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

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

Postgres performance mistakes ... and how to fix them 💪 @andyatkinson.com www.meetup.com/postgres-mee...

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.

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

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 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 people starter pack! go.bsky.app/Acp7hmk

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

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 💥

Interesting & timely discussion from the OSM community regarding what goes into place naming. community.openstreetmap.org/t/gulf-of-am...

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

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

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

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.

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

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

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

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

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

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

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

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

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'm having one of those days where my job is super dreamy. Next up, interview with ARIN about Postgres and Crunchy Data. Yeah, that ARIN, the people that run the internet.

In this latest #GISchat @sqlliz.bsky.social of @crunchydata.com walks us through how to use open source tooling to avoid paying the vendor tax: youtu.be/Bsz8lWFPAH8?...