Elizabeth Garrett Christensen
banner
sqlliz.bsky.social
Elizabeth Garrett Christensen
@sqlliz.bsky.social
#Postgres @snowflake via @crunchydata.com. Board member @pgus.bsky.social. Co-host of #PostGIS day.
@pwramsey.bsky.social and I are hosting PostGIS Day again this year! The call for papers and registration is open now. Join us!

www.snowflake.com/postgis-day-...
PostGIS Day | November 20
Learn how others are making use of PostGIS, pick up some tips and tricks, and share stories about bringing this excellent tool into your organizations.
www.snowflake.com
September 17, 2025 at 2:07 PM
Postgres Meetup for All tomorrow www.meetup.com/postgres-mee...
July 8, 2025 at 3:58 PM
PostGIS tip: Get faster spatial queries and maps with st_simplfy. ⚡ When you don't need exact topology and want to make things faster and simpler, look at the ST_Simplify and ST_SimplifyPreserveTopology functions. Example in the video.
May 27, 2025 at 8:55 PM
Reposted by Elizabeth Garrett Christensen
We have a new venue for PGConf NYC 2025 and a new hotel to go with it! Check it out and book now:

2025.pgconf.nyc/venue/

@PostgreSQL #postgres #conference
PGConf NYC 2025 | PostgreSQL Conference
PGConf NYC 2025 will be held from on September 29th - October 1st in New York City, NY at Convene 117 West 46th Street.
2025.pgconf.nyc
May 5, 2025 at 7:14 PM
Postgres Meetup for All in a few hours will be meeting up to chat about connection pooling/failover with the new pgDog project (and pgCat). Join us! www.meetup.com/postgres-mee...
Postgres Connection Pooling with PgDog & PgCat, Wed, Apr 9, 2025, 1:00 PM | Meetup
Lev Kokotov will be at the April meetup to talk about his work with the connection pooler [PgCat ](https://github.com/postgresml/pgcat)and its new successor project [PgDog]
www.meetup.com
April 9, 2025 at 2:34 PM
Postgres Meetup for All topic today is schema migrations March 12th at 10 central (an hour from now). There aren't a lot of opportunities to compare open source tools side by side like this - join us! www.meetup.com/postgres-mee.... @ryanbooz.bsky.social @apatheticmagpie.bsky.social @theory.fyi
Postgres Schema Migrations, Wed, Mar 12, 2025, 11:00 AM | Meetup
This month’s meetup will focus on schema migrations with a panel discussion from 3 different industry experts. * Ryan Booz will join us from Red Gate to talk about the Fly
www.meetup.com
March 12, 2025 at 1:59 PM
Postgres people starter pack! go.bsky.app/Acp7hmk
March 1, 2025 at 12:35 AM
Tomorrow the Postgres Meetup for All will be hosting Philippe Noël (@philippemnoel.bsky.social) from ParadeDB. Phil will present for about 30 minutes and we'll have the rest of the time for discussion about Postgres and search. Join us! www.meetup.com/postgres-mee...
February 11, 2025 at 3:19 PM
Today I got to play around with @crunchydata.com's new data warehouse.
- connected to the entire world's building footprint data in
@overturemaps.bsky.social
- made a local table of tornado path data from FEMA
- joined them together
- set up a web browser to view the join with pg_tileserv
💥
February 6, 2025 at 11:56 PM
Reposted by Elizabeth Garrett Christensen
Interesting & timely discussion from the OSM community regarding what goes into place naming.
community.openstreetmap.org/t/gulf-of-am...
Gulf of America - Gulf of Mexico
President Donald Trump just said during his inauguration that he wants to rename the Gulf of Mexico to the Gulf of America. Aside from the political aspects, how does that even work? How does OSM cho...
community.openstreetmap.org
January 28, 2025 at 6:26 PM
I was very touched to see I was just included on the contributors list for PostgreSQL. I just adore the Postgres community - they've made it very easy to contribute and have been more than welcoming. Congrats and thank you to all the new Postgres contributors too. www.postgresql.org/about/news/n...
New PostgreSQL Contributors
The [PostgreSQL Contributors Page](https://www.postgresql.org/community/contributors/) includes people who have made substantial, long-term contributions of time and effort to the PostgreSQL project. ...
www.postgresql.org
January 27, 2025 at 3:38 PM
Postgres Meetup for All topic this Wednesday is DuckDB. There's a lot happening with #PostgreSQL & @duckdb.org. This meetup is open to all levels from just curious to experienced users. We'll have a 30 minute talk with plenty of discussion time. Join us!

www.meetup.com/postgres-mee...
January 6, 2025 at 6:07 PM
I have a new blog today out on vectors and their many uses. www.crunchydata.com/blog/name-co...
December 26, 2024 at 4:38 PM
PSA to people who write code and instructions. Your commented code blocks are not instructions. Sure, add some comments, but that's not a replacement for actual technical writing and explanation.
December 16, 2024 at 7:21 PM
I help host a monthly group Postgres Meetup for All. Next week we'll have Claire from Microsoft (clairegiordano.bsky.social) talking about blogging. If you're writing more or want your writing have more impact, join us. We leave lots of time for discussion too. www.meetup.com/postgres-mee...
December 6, 2024 at 10:55 PM
I just spoke at a 'girls who code' after school club in my town. They were looking for women with actual tech jobs to talk about what they do. I was full of hope for this experience but it was a tiny disaster. They mostly just asked me "what does crunchy data taste like" 😋🤣🫠
December 5, 2024 at 11:24 PM
Reposted by Elizabeth Garrett Christensen
>> This combination leverages the simplicity of flat files, the scalability and transactional capabilities of Iceberg, and the structured query efficiency of Postgres to create a robust, flexible medallion architecture.
December 3, 2024 at 7:39 PM
Reposted by Elizabeth Garrett Christensen
Announcing Crunchy Data Warehouse! A next-generation Postgres-native data warehouse that provides full Iceberg support for fast analytical queries and transactions.Read more in our announcement. www.crunchydata.com/blog/crunchy...
Crunchy Data Warehouse: Postgres with Iceberg for High Performance Analytics | Crunchy Data Blog
We are excited to release Crunchy Data Warehouse, a modern data warehouse for Postgres. Crunchy Data Warehouse combines Postgres with Iceberg, Parquet, and data lake formats for fast analytics queries...
www.crunchydata.com
November 20, 2024 at 2:45 PM
I published a new blog post today on two sql features, ROLLUP and CUBE. These are pretty handy if you're rollup up data by date and another attribute. www.crunchydata.com/blog/easy-to...
Easy Totals and Subtotals in Postgres with Rollup and Cube | Crunchy Data Blog
Learn about easy subtotals with the GROUP BY ROLLUP and CUBE to get totals and subtotals across categories and date bins.
www.crunchydata.com
November 18, 2024 at 5:17 PM
I am speaking at this year's PostGIS Day. My talk is about how to get from #PostGIS to #maps really easily. @crunchydata.com supports a couple little #opensource #Go projects that expose data as an api. Lots of other great #foss4g talks on Thursday too. www.crunchydata.com/community/ev...
November 16, 2024 at 4:40 PM
I host a monthly Postgres meetup called Postgres Meetup for All. This Thursday we've have Arka from Notion. Notion has a HUGE Postgres database. He'll be talking about how they use connection pooling in their failover set up. Join us! www.meetup.com/postgres-mee...
November 12, 2024 at 10:54 PM
Hey new bluesky friends! I'm co-hosting a #geospatial event for open source called #PostGIS day with @pwramsey.bsky.social. We have a ton of great talks. Check out the schedule and plan to join us for this free virtual day of learning on Nov 21. www.crunchydata.com/community/ev...
PostGIS Day 2024
Join us Thursday, Nov 21st for a free online event for PostGIS and open-source geospatial.
www.crunchydata.com
November 4, 2024 at 3:08 PM
I was just thinking to myself this morning ... wow bluesky has a lot more maps and databases in my feed and virtually no trash. I think I'm going to like it here. 💙
I like that there's more DuckDB than US elections in my feed here.
November 1, 2024 at 3:09 PM