☀️ If you don't receive Postgres Weekly next week (August 17), don't panic. Your email is (probably) still working – we're just taking a week off for summer vacation :-) We'll be back, complete with sun tan wind burn, on August 24.
__
Peter Cooper, your editor. |
| Pagila 3.0: A Sample Database for Postgres — Originally a port of the 'Sakila' example database for MySQL, Pagila provides a complete and realistic schema and data that could be used in tutorials, demos, for learning SQL, or testing. The DVD rental store metaphor from Sakila stays, but numerous extra features have been brought into play, including JSONB columns, foreign keys, and triggers. There are full instructions on spinning it up too. Devrim Gündüz |
 Build Internal Tools with PostgreSQL — Connect Retool to Postgres in a few minutes, and quickly build internal tools on top of your Postgres data. Retool connects directly to your PostgreSQL DB and lets you use SQL to manage the data in your PostgreSQL tables. Start building with PostgresSQL. Retool sponsor |
| HAVING: A Less Understood SQL Clause? — HAVING provides WHERE-like predicate-based filtering of results but of aggregations or groups and most commonly following a GROUP BY clause (something WHERE cannot do). In Hacker News's discussion of this item, more people were curious to learn about the use of GROUP BY CUBE in the article though!
Small Things SQL |
⬆️ Editor's note: I hate breaking the editorial wall, but this YouTube channel is fantastic as it essentially focuses on one small topic or blog post at a time. If you get bored next week and miss Postgres Weekly, it'll give you something to watch! :-) |
| DbGate: Another Database Desktop Client App — Built as an Electron app using Svelte as the underlying framework, this is a pretty elegant cross platform (and open source!) client for Postgres, MySQL, and others. Jan Prochazka |
|  | |
