Issue 445 - Now we're even using SQL to cheat at Wordle (11)

'How We Optimized Our Postgres Queries 100x' — When it comes to optimizing Postgres queries “the rabbit hole is deep”, says Vadim who ran into some very specific pain points. This is a good look at how he tackled some performance problems and got some reasonably easy wins.

Awesome Postgres: A Curated List of 200+ Libraries, Tools, and Resources — It’s been four years since we’ve linked to this handy resource but it continues to get updates. It covers all areas from backups to GUI clients, managed services to Docker images, blogs, and more. You can also contribute your own suggestions via the repo.

5 Mins of Postgres - A Weekly Video Series by pganalyze — Every Thursday, we publish a short, bite-sized video on YouTube to walk you through noteworthy Postgres updates and content that we came across in the previous 7 days. Check out the first 7 episodes and feel free to subscribe to our YouTube channel.

How to Cheat at WORDLE with Postgres — I’m glad to see someone admitting that using code to help you play Wordle is cheating, but nonetheless it’s also neat to see Postgres getting a piece of the action. You might pick up a handy SQL technique or two from this too, so we’re all winners really.

Creating Checksums for Tables — A look at an approach to hashing table data in aggregate in order to create a checksum for comparing the equality of different groups of data (e.g. tables).

Automating RDS and Aurora Postgres Log Exports to Amazon S3 using Extensions — A walkthrough of using the pg_cron extension (now supported on AWS’s Postgres services) to automatically run exports of logs to S3 using log_fdw and aws_s3.

Pl/Perl Recursion — PL/Perl enables you to write Postgres functions in Perl (which opens up a lot of succinct string manipulation options).

SQL Notebook 1.1: A Windows App for Casual Data Exploration with SQL — Import your data from CSV, Excel, SQL Server, Postgres or MySQL and then use a lightweight Jupyter-style notebook interface for exploratory queries.

SQLreduce: Reduces Verbose Breaking SQL Queries to Minimal Examples — SQLsmith is a tool for generating random SQL queries with an aim at finding bugs in database systems, but its ‘successful’ (i.e. ones that break Postgres!) queries can often be more verbose than they need to be. SQLreduce resolves this. GitHub repo. Alas, this will not be of immediate use if you merely want...

Bun 1.1: A Simple Go(lang) SQL Database Client for Postgres and More — A client library that provides an ‘ORM-like’ experience with Postgres, MySQL, SQL Server, and SQLite. The querying approach is quite idiosyncratic but very fluent.