Recent Posts

(TIL) PSQL: Types By Category

less than 1 minute read

Postgres has many types, each of which fall into a particular category. These categories include Array, Boolean, String, Numeric, Composite, etc. Each of the...

(TIL) PSQL: Truncate All Rows

less than 1 minute read

Given a postgres database, if you want to delete all rows in a table, you can use the DELETE query without any conditions.

(TIL) PSQL: Turn Timing On

less than 1 minute read

When digging around your database and running queries, it is helpful to have an eye on the speed of those queries. This can give insight into where there are...