Mastodawn

Regina Obe: PostGIS Tiger Geocoder 2025.1

PostGIS Tiger Geocoder 2025.1

The PostGIS development team is pleased to provide postgis_tiger_geocoder extension. This is the very first release since the break from the PostGIS core. This version requires PostgreSQL 16 and above and should work with any supported PostGIS version. PostGIS 3.6 series is the last series to include postgis_tiger_geocoder. PostGIS 3.7 will be shipped without postgis_tiger_geocoder. Moving forward postgis_tiger_geocoder has its own dedicated repo at OSGeo Gitea postgis_tiger_geocoder under the PostGIS org. The versioning model has also changed to be versioned based on the year of the Census US Tiger dataset that is current at time of it’s release.

PostGIS

pgEdge Postgres 3h ago

In SF for Deep Tech Week? We're co-hosting Build Night: The Data Layer for Agentic Apps tomorrow evening.
Tuesday, June 23 | 5:30 - 8:30 PM | AngelList Founders Cafe.

Engineers, founders, architects, and CTOs spending an evening on MCP-native database access, hybrid RAG, distributed #PostgreSQL, and production backends that hold up when agents are writing to them.

A few seats left. Register: 👉 https://luma.com/frontier-e9k5

#AgenticAI #DeepTechWeek #SanFrancisco #OpenSource #SF #BayArea #TechEvent

GripNews 3h ago

🌘 不列顛哥倫比亞省、時區與 PostgreSQL
➤ 當「時區」不再穩定：如何確保您的預約系統不受時區規則變更的影響
✤ https://www.crunchydata.com/blog/british-columbia-and-time-zone-changes
本文探討了當政府改變時區規則（如不列顛哥倫比亞省改為全年夏令時間）時，資料庫中儲存的時戳資料會如何失效。作者指出，PostgreSQL 的 `timestamptz` 型別儲存的是 UTC 時間，在轉換時會依賴系統的 `tzdata` 規則。若 `tzdata` 更新，未來日期的計算將產生誤差。為瞭解決此問題，作者建議對於涉及「人類預期時間」的場景（如預約、法定期限），應採用「雙欄位模式」：分別儲存本地時間與時區名稱，並透過觸發器（Trigger）計算 UTC 時間，以確保在時區規則變更時，資料仍能正確重新計算。
+ 這篇文章點出了許多開發者忽略的技術債。時區規則是政治決策，而非恆定物理定律，將兩者混為一談確實非常危險。
+ 很有啟發性的方案。雖然雙欄位模式
#資料庫管理 #PostgreSQL #時區處理 #軟體工程

British Columbia, Time Zones, and Postgres | Crunchy Data Blog

This year, British Column has moved to year-round Pacific Time. How does that affect date data?

Crunchy Data

POSETTE: An Event for Postgres 4h ago

What makes the cut before a Postgres feature freeze? In this POSETTE 2026 keynote panel, hear PostgreSQL committers & hackers Álvaro Herrera (@alvherre), Heikki Linnakangas, @melanieplageman & Thomas Munro (@tmunro) unpack what made it into Postgres 19—and what didn’t.

Enjoy: https://www.youtube.com/watch?v=Vw4WKeoxKq4&list=PLOBORF8Y_l8g

#PosetteConf #PostgreSQL #databases #OpenSource #conference

Mason Loring Bliss 5h ago

Nice article about my favourite database, PostgreSQL.

https://www.theregister.com/databases/2026/06/22/the-database-that-refused-to-die-how-postgres-survived-its-own-creators/5259716

#postgresql

The database that refused to die: How Postgres survived its own creators

From academic toss-aside to cloud substrate

theregister

Postgres Summit US 5h ago

Interested in volunteering for PG Summit US? We have multiple volunteer opportunities available. Fill out the form below and we’ll be in touch!

https://bit.ly/pgusvolunteer

#PostgreSQL #postgres #conference

pgEdge Postgres 6h ago

Prototyping AI with #PostgreSQL is easy. Production is where teams get stuck.

Mike Josephson (pgEdge) covers the full open source stack - MCP Server, RAG Server, AI DBA Workbench - and the Q&A goes deep: why a dedicated MCP server vs. direct LLM access? - enterprise controls, TSV optimization, semantic caching.

Live demo runs fully local on Ollama + Gemma 4 31B. No data leaving the machine.

Watch the on-demand replay: 🎙️ https://pages.pgedge.com/postgresworld-webinar-postgres-series-ai-dba-workbench-for-postgresql-a-technical-walkthrough-02efc371-9c20-4ba0-86f4-faea117d7a2f

#OpenSource #AI #MCP #DataEngineering #tech #llm

pgEdge Postgres 6h ago

Cold data is read-only - that's the assumption baked into basically every tiering solution on the market. ColdFront breaks it.

UPDATE & DELETE on archived rows work through standard SQL. A GDPR deletion on five-year-old events is a single DELETE statement. No restore cycle.

DuckDB in-process, Apache Iceberg on any S3. Stock unpatched #PostgreSQL 16/17/18. Beta now, PostgreSQL License. Led by Jimmy Angelakos.

📖 https://github.com/pgEdge/coldfront

#OpenSource #DataEngineering #ApacheIceberg #DuckDB

Thomas Strömberg 6h ago

TFW when you need to quadruple the storage on your machines because your open-source project is finally successful.

On that note, https://lab.atomdrift.org/ will be down for the next couple of hours so I can upgrade our #OmniOS #PostGreSQL master & #FreeBSD frontend replica to 4TB of NVME so that the drive doesn't fill while I go on vacation.

atomdrift lab - Fallout

PgUS 6h ago

The London PostgreSQL Meetup Group will be hosting its next in person event tomorrow! Join them at The Star of Kings for “Stopping Collations Going Wrong” with Andreas Karlsson and a recap of PGConf DEV with Alastair Turner and Valeria Kaplan.

https://www.meetup.com/london-postgresql-meetup-group/events/315092418/?eventOrigin=network_page

#PostgreSQL #postgres