If you happened to miss this tweet than it turns out you *can* use hash indexes in PostgreSQL to enforce uniqueness using an exclusion constraint!

This is not very intuitive and not explicitly documented (that I know of) which makes you think if there are any caveats to it...

Had a great time meeting Charles (Charles Max Wood | [email protected]), Valentino (@thecodenamev), and Dave (@kobaltz) at Ruby Rogues! We discussed PostgreSQL with Ruby on Rails. We chatted about the writing process, and how it's aimed at 'Application DBAs' (credit: Haki). 👉
twitter.com/rubyrogues/sta…

#TIL interval expressions in PostgreSQL can accept both positive and negative values in a single expression.

For example, given the first day of the month - calculate the last day of the month:

SELECT '2024-01-01'::date + INTERVAL '1 month - 1 day';

👌Nice

One of my favorite patterns since Python 10 is assert_never(ever), I like how it reads 🤪

Did you know there is a surprising performance drop in #Postgres performance when using medium size values and TOAST? In today's episode we look at why this drop is happening and describe two ways to mitigate it. We feature Haki: hubs.li/Q027wxNM0

How do you implement 'get or create' in #PostgreSQL ?

My best effort (that don't cause unnecessary bloat) includes 3 CTEs and ~25 lines... ON CONFLICT and MERGE are useless.

Any better ideas?

'Lesser Known PostgreSQL Features' (2021)

Nice one, by Haki. TIL about tablefunc() and \crosstabview for creating pivot tables in #Postgres /psql 🤓.

What's your favourite PG secret feature more folks should know about?

hakibenita.com/postgresql-unk…

Is anybody using PREPARE TRANSACTION in PostgreSQL to conduct a distributed transaction over multiple different data stores? Curious about *actual* use cases. (For example, enqueue to some external queue inside a transaction...)

Great recap 👏

Thanks pganalyze for doing this 😉

Here's a little #SQL snippet for all the people whose week *does not* start on Monday

I'm giving a talk this Thursday on PyCon Sri Lanka about concurrency in web application

I'm going to show how to keep your data consistent and your system running smoothly w/o compromising (too much) performance🚀

It's free, online and interactive!

👇👇👇
pycon.lk

Excellent article highlighting some techniques for utilizing typing in Python to write safer code 👌

Also TIL about NewType (I've used TypeAlias so far but NewType is better).

If you write Python read it now, seriously 👇