--- title: "How to corrupt your database (so you won't)" publication: "Postgres Weekly" issue: 468 published_at: "2022-08-24" canonical_url: "https://postgresweekly.com/issues/468" --- Plus PostgREST 10.0, new interactive Postgres tutorials, and the rise of the 'anti join'. | #​468 — August 24, 2022 [Web Version](https://postgresweekly.com/issues/468) In case you missed my note two weeks ago, we took a week off, so you _didn't_ miss an issue last week :-) We're back now until the end of the year – 123 days until Christmas, by the way.. 😆 __ _Peter Cooper, your editor._ Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_50/wljdiwyatrfsws8qxgxf.jpg)](https://www.crunchydata.com/blog/learn-postgres-at-the-playground) [Learn Postgres at the Playground](https://www.crunchydata.com/blog/learn-postgres-at-the-playground) — You might be familiar with online tutorial ‘playgrounds’ (such as [Ruby’s](https://try.ruby-lang.org/)) – now Craig Kerstiens and CrunchyData have unveiled a set of interactive [online tutorials for Postgres](https://www.crunchydata.com/developers/tutorials) coupled with a fresh collection of [Postgres tips.](https://www.crunchydata.com/postgres-tips) There's [some more background here.](https://news.ycombinator.com/item?id=32498722) Craig Kerstiens [How to Corrupt Your PostgreSQL Database](https://www.cybertec-postgresql.com/en/how-to-corrupt-your-postgresql-database/) — You know sometimes when you’re trying to _avoid_ something so you look at it and then inadvertently crash into it anyway? Laurenz shows us how to really mess up our databases so that, hopefully, you can, well, _not_ do that.. :-) Laurenz Albe [![\](https://copm.s3.amazonaws.com/338699d4.png)](https://tsdb.co/pgw-13-postgresql-tools-that-arent-psql) [13 Postgres Tools That Aren't psql](https://tsdb.co/pgw-13-postgresql-tools-that-arent-psql) — We asked the PostgreSQL community: psql is by far the most popular tool for interacting with PostgreSQL, but it definitely isn't the only one. In this blog post, we look at which other tools PostgreSQL users love most. Timescale sponsor **QUICK BITS:** - [postgres.email](https://postgres.email/) is an interesting proof of concept of a new way to read Postgres mailing lists (such as pgsql-hackers, as seen here). Here's more on [how it was built](https://news.ycombinator.com/item?id=32542648). - Part II of the fantastic [Postgres 14 Internals](https://postgrespro.com/blog/pgsql/5969682) book is now available to read. [Rise of the 'Anti-Join'](https://www.crunchydata.com/blog/rise-of-the-anti-join) — “Find me all the things in set _A_ that are _not_ in set _B_,” asks Paul. He compares a few ways to do this before settling on the ‘anti join’ approach (basically a subquery feeding a `WHERE NOT EXISTS` clause). Paul Ramsey [Postgres to Make Aliases Optional for Sub-`SELECT`S in `FROM` Clause](https://www.cybertec-postgresql.com/en/aliases-for-sub-selects-in-from-clause/) — The SQL _standard_ makes aliases mandatory for subqueries, but not all databases adhere to this. Could Postgres, too, make them optional? [Seems so.](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bcedd8f5fce0b69970cf0cee7bca560833d05869) Pavlo Golub [How to Migrate Scheduled Jobs to pg_timetable from pgAgent](https://www.cybertec-postgresql.com/en/migrate-scheduled-jobs-to-pg_timetable-from-pgagent/) — [pg_timetable](https://www.cybertec-postgresql.com/en/products/pg_timetable/) is an increasingly popular scheduled job extension for Postgres and while Pavlo recently wrote about [migrating from pg_cron to pg_timetable](https://www.cybertec-postgresql.com/en/migrate-scheduled-jobs-to-pg_timetable-from-pg_cron/), it’s now pgAgent’s turn! Pavlo Golub [Build a Full Stack 'AMA' App with Remix, Prisma, and PostgreSQL](https://foysal.it/posts/fullstack-remix-app/) — Given the recent redefining of Jamstack, it seems Remix - though SSR only - qualifies. Remix has a ton of interesting characteristics. If you’d like to learn it, this is an in-depth tutorial using it to build an ‘Ask Me Anything’-type site. Foysal Ahamed 🛠 Code and Tools [PostgREST 10.0: Serve a RESTful API from a Postgres Database](https://postgrest.org/en/stable/) — We’ve covered this popular tool many times over the years. [10.0](https://github.com/PostgREST/postgrest/releases/tag/v10.0.0) isn’t a _particularly_ big release but introduces a health check endpoint, the ability to run without config, GeoJSON output support, and lots of smaller [bits and pieces.](https://github.com/PostgREST/postgrest/releases/tag/v10.0.0) Nelson and Chavez [Fully Managed Postgres. One Less Thing to Worry About](https://resources.enterprisedb.com/elephant-in-the-room/?utm_source=postgresweekly&utm_medium=newsletter&utm_campaign=BigAnimalpgweeklynewsletter) EDB BigAnimal sponsor [AWS RDS Postgres Deployment with pgAdmin 4](https://www.enterprisedb.com/blog/aws-rds-postgresql-deployment-pgadmin-4) — How to use the pgAdmin AWS RDS deployment wizard for deploying a fresh Postgres database on AWS. Yogesh Mahajan (EDB) **RELEASES:** [PostgresML 1.0.1](https://github.com/postgresml/postgresml) – Train models and make predictions from Postgres. [ActiveRecordExtended 3.0](https://github.com/GeorgeKaraszi/ActiveRecordExtended) – Extra Postgres functionality for Rails apps. [PGLoader 3.6.7](https://github.com/dimitri/pgloader) – Continuous migration tool. [pg_timetable 4.9](https://github.com/cybertec-postgresql/pg_timetable) – Advanced scheduling extension. [pgsodium 3.0.4](https://github.com/michelp/pgsodium) – Modern cryptography with libsodium. [PLV8 3.1.4](https://github.com/plv8/plv8) – The V8 JS engine for Postgres. [django-pgtrigger 4.3.2](https://github.com/Opus10/django-pgtrigger) – Write Postgres triggers for Django models. [PostGIS 3.3.0rc2](http://www.postgis.net/2022/08/22/postgis-3.3.0rc2/) [Pgpool-II 4.3.3, 4.2.10, 4.1.13, 4.0.20 and 3.7.25](https://www.postgresql.org/about/news/pgpool-ii-433-4210-4113-4020-and-3725-released-2498/) [CloudNativePG 1.16.1 and 1.15.3](https://www.postgresql.org/about/news/cloudnativepg-1161-and-1153-released-2497/) **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)