Posts about Fun with Postgres
Rolling the Dice with the PostgreSQL Random Functions
Paul shows examples of generating random numbers, random integers, random text values, and random groups. He also shows off the new random_normal function which just came out with Postgres 16.
6 min read
XKCD Bad Map Projection with PostGIS
In honor of the beloved XKCD comic, Paul recreates some bad maps using PostGIS functions. Check out these funky cartographic contortions and learn a little spatial sql along the way.
4 min readHoly Sheet! Remote Access CSV Files from Postgres
Want to get CSV data into your database? Paul has some great tools to help you use CSV and Google Sheets. Like remote copy, http access, using Python for materialized views, and ogr_fdw. You heard that right, there's a foreign data wrapper for CSV to Postgres!
7 min readPractical AI with Postgres
Use some of the newest AI tools for Postgres! Craig shows you how to use ChatGPT for schema creation, data creation, query writing, indexing and more.
9 min readFun with Letters in PostGIS 3.3!
Check out the new PostGIS function, ST_Letters. We're making words, putting words on a map, increasing convexity with ST_ConcaveHull, and making letters from polygons with ST_TriangulatePolygon.
4 min readReal-time Database Events with pg_eventserv
Introducing our newest open-source project, pg_eventserv! pg_eventserv takes events generated by the PostgreSQL NOTIFY command and passes the payload along to waiting WebSockets clients.
5 min readFun With Postgres Functions
Craig has pulled out some of his favorite functions from the Postgres toybox. He shows off date functions, aggregations, text functions, and math.
5 min read
