Lightnews — Scholar-powered news

Elizabeth Garrett Christensen @sqlliz.bsky.social · 28d

@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

5 7

Elizabeth Garrett Christensen @sqlliz.bsky.social · Jul 8

Postgres Meetup for All tomorrow www.meetup.com/postgres-mee...

1 3

Elizabeth Garrett Christensen @sqlliz.bsky.social · Jun 10

Postgres performance mistakes ... and how to fix them 💪 @andyatkinson.com

www.meetup.com/postgres-mee...

10 Costly Database Performance Mistakes (and How to Fix Them), Wed, Jun 18, 2025, 12:00 PM | Meetup

Andrew Atkinson works hands on with Ruby on Rails and Postgres performance. He even wrote[ a book ](https://pragprog.com/titles/aapsql/high-performance-postgresql-for-rails

www.meetup.com

1 4

Elizabeth Garrett Christensen @sqlliz.bsky.social · May 29

link?

1 2

Elizabeth Garrett Christensen @sqlliz.bsky.social · May 27

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.

2 9

Reposted by Elizabeth Garrett Christensen

@pgconfnyc @pgconfnyc.bsky.social · May 5

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

3 2

Elizabeth Garrett Christensen @sqlliz.bsky.social · Apr 9

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

1 2

Elizabeth Garrett Christensen @sqlliz.bsky.social · Mar 12

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

1

Elizabeth Garrett Christensen @sqlliz.bsky.social · Mar 1

Postgres people starter pack! go.bsky.app/Acp7hmk

1 4 8

Elizabeth Garrett Christensen @sqlliz.bsky.social · Feb 14

haha "Streamholm Syndrome" that's great 😂

1

Elizabeth Garrett Christensen @sqlliz.bsky.social · Feb 13

Thank you!

1 1

Elizabeth Garrett Christensen @sqlliz.bsky.social · Feb 11

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...

3

Elizabeth Garrett Christensen @sqlliz.bsky.social · Feb 6

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
💥

2 10

Reposted by Elizabeth Garrett Christensen

Scott Ball @scottballesri.bsky.social · Jan 28

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

1 4

Elizabeth Garrett Christensen @sqlliz.bsky.social · Jan 27

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

14

Elizabeth Garrett Christensen @sqlliz.bsky.social · Jan 9

1997 called and they want their mocha back

2

Elizabeth Garrett Christensen @sqlliz.bsky.social · Jan 6

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...

2

Elizabeth Garrett Christensen @sqlliz.bsky.social · Dec 26

I have a new blog today out on vectors and their many uses. www.crunchydata.com/blog/name-co...

1 1

Elizabeth Garrett Christensen @sqlliz.bsky.social · Dec 19

Sometimes I talk hex to myself in my head if colors aren't right. Just give that a little FFFFFFFF 😂

2

Elizabeth Garrett Christensen @sqlliz.bsky.social · Dec 16

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.

1 6

Elizabeth Garrett Christensen @sqlliz.bsky.social · Dec 6

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...

6

Elizabeth Garrett Christensen @sqlliz.bsky.social · Dec 5

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" 😋🤣🫠

1 10

Elizabeth Garrett Christensen @sqlliz.bsky.social · Dec 4

nailed it

1

Elizabeth Garrett Christensen @sqlliz.bsky.social · Dec 4

Headed straight for Apache Iceberg ⛴️

2 2

Reposted by Elizabeth Garrett Christensen

Crunchy Data @crunchydata.com · Dec 3

>> 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.

1 7