Paul Ramsey
@pwramsey
Please find me at @[email protected] @pwramsey.bsky.social
PostGIS is the beating heart of so many @felt 🖤ers stack, so we built an integration. Take a tour with @michalmigurski ✨
Our friends from @felt will be at PostGIS Day talking about their new mapping integration with PostGIS tools. Join us for this talk and a whole day of open source geospatial use cases and applications. Free, virtual event on Thursday the 21st. crunchydata.com/community/even…
Paul Ramsey (@pwramsey): Running an Async Web Query Queue with Procedures and pg_cron postgr.es/p/710
Do you use BRIN indexes on Geometry? Let me know, we are thinking of removing them.
A RAG AI system doesn’t have to be super complicated. You might just want to add custom information to your project without touching other parts of the LLM. @pwramsey has a super simple solution. In today’s blog he shows you how to add a table of data to be used with the…
Did you attend FOSS4G 2007? Did you meet a middle aged blond woman? Maybe you can help solve a 20 year old mystery. interpol.int/en/What-you-ca…
Postgres Data Platform Postgres has never been “just a database.” It’s best to think of it as a query-engine that sits on top of data stores. This modularity has always been in the architecture of Postgres. Most people use Postgres as an application database (OLTP) — if you…
Last reminder: PostGIS Day is tomorrow! Please register! It's free and it helps us size the webinar account. crunchydata.com/community/even…
For five years now I've been running my own private server with a world map data set, as a benchmark workload. The whole Planet imports and indexes in 4 hours now. That represents a build rate of 200GB/hour using a single database disk. crunchydata.com/blog/loading-t…
PostGIS day is coming to a screen near you on Thursday the 21st. We have so many great speakers from electric cars, to AI, to Danish cities, and of course fancy maps! Drop in for some of the talks. crunchydata.com/community/even…
Elizabeth Christensen @sqlliz will be at PostGIS day talking about the basics of pg_featureserv and pg_tileserv. A couple other folks have related talks building on this topic. If you're curious about PostGIS API options, you're definitely in luck this year. Join us on Thursday…
I was recently on the Geospatial Index podcast talking about @crunchydata, @PostgreSQL, and @postgis youtube.com/watch?v=Bsz8lW….
Frank Warmerdam has already filled in his GDAL survey. Please help us by filling out yours.
The first ever GDAL Users Survey is now open for feedback at docs.google.com/forms/d/e/1FAI… The survey is an attempt to provide structured guidance for the maintenance program to focus its efforts in the coming year. Please contribute and help us circulate it!
A point I haven’t seen made: If Trump wins, his policies are almost certain to drive inflation higher. Then what? The answer is obvious: a purge of “disloyal” staff at the Bureau of Labor Statistics. And the reported numbers will miraculously improve.
The amount of effort @louisemeta put into this talk was 🤯, she told me there is probably 10 deep dive blog posts she could extract from this talk and I don't think thats an exaggeration. Definitely a can't miss if you're at @pgconfeu x.com/crunchydata/st…
We're excited to be sponsoring @pgconfeu this week. Make sure you catch the talks by our team: * @Karenhjex on Wednesday at 3pm - Crunchy Postgres for Kubernetes: Your Virtual DBA * @louisemeta on Thursday at 11:50am - A Deep Dive into Postgres Statistics We also have several…
🎉🌐 The @postgis day 2024 schedule is ready 🌐🎉 We have an exciting lineup of talks about #OpenSource solutions for #Geospatial. This is the day after @gisday, November 21st. This is free, online on Zoom, and runs the whole day from afternoon in Europe to afternoon in…
Excited to announce the release of pg_parquet: A Postgres extension that makes it simple to connect Postgres and parquet files Learn more - crunchydata.com/blog/pg_parque…
#PGConfdev 2025 Call for Proposals is now open! 2025.pgconf.dev/cfp.html We are accepting proposals for 25-minute talks, 50-minute talks, and alternative content (like panels, summits, and any other creative ideas)! We can't wait to read your #PGConfdev2025 proposal! #PostgreSQL
Did you know that a former #NACIS president is the brain behind our beautiful maps and visualizations? Learn how @mamataakella uses her cartography skills to make magic happen in the browser ✨
if you want to learn more about @felt i'll be giving a talk @NACIS on thursday morning in the Tools and Visualization track showing all our new features - if you can't make it, be sure to find me in the halls - i'm loaded with demos! look forward to another great year! #nacis2024
Paul Ramsey (@pwramsey): Convert JSON into Columns and Rows with JSON_TABLE postgr.es/p/6EA
This is the last day to submit PostGIS Day talks! ErP! Quick! crunchydata.com/community/even…
