Published onAugust 17, 2024How to add comment on table and column in PostgresdevpostgresI was just wondering if it's possible and it turns out it is
Published onAugust 15, 2024Quickly generate Postgres database in a single commandubuntuclicoolifypostgresHow I thought I could let AI do all the work but it turns out it can only do so much
Published onJuly 29, 2024How to generate fake data in Postgres with faker_fdwdevdockerpostgresMake your staging or development database look like production
Published onJuly 18, 2024How to install and run pg-boss via CoolifyubuntucoolifypostgresBackground jobs with Postgres?!
Published onJuly 17, 2024How to install and run PgBouncer via CoolifyubuntuclicoolifypostgresYou have to have PgBouncer if you are using PostgreSQL
Published onJune 14, 2024Blocking External Access to PostgreSQL in Docker with UFW on UbuntudatabasepostgresSetting up firewall is not always easy even when the tool said it's uncomplicated
Published onMarch 20, 2024Populate Postgres database with fake datadevpostgresDirectly from the database itself
Published onJanuary 22, 2024Cron job in PostgreSQLdevdatabasepostgresWhen you need to periodically update your database