postgresql Tag Posts Index

#postgresql ...

...

PostgreSQL Backup System for Docker with S3 and Slack

At 2:23 AM last Tuesday, something went wrong with our database. Backups were a few days old, and so recovery took longer. That’s when I realized our backup system

Announcing pg_conn2 - a #Postgresql extension that creates a new database ...

... connection directly from sql code, lol.

Do you tune #postgresql to lower the value of random_page_cost?

Naming things is hard #postgresql

There is Postgres and there's Postgrest. For maximum confusion there should also ...

... be a rust rewrite called Postgrs. #postgresql

#PostgreSQL 18 introduces async IO

Have you ever had the need for a JOIN on expression other than = ? #sql ...

... #postgresql

Announcing pg_snowflake, a #sql #postgresql extension for creating customisable ...

... snowflake ID types.

Doing simple comparison of #postgresql procedural languages. Return 42 is ...

... function returning hardcoded value 42. Select row selects a single row from table having 10k rows. plpgsql being faster than sql is surprising for the second

Really #postgresql ? I can insert text value into an integer column?

Writing query creating #sql function that is run inside plpython function created ...

... in sql file is next level sql skill. #postgresql

I added triggers to automatically add/remove embeddings for new/removed entries ...

... in the table #postgresql #ai #python

I'm working on a #postgresql extension that runs huggingface sentence transformer ...

... model directly in Postgres process. #python #ai

Activate #python virtual environment right from #postgresql procedure/function.

What if you could just do this? #postgresql #python #ai

pg_worker_pool now supports ...

... pg_stat_activity #postgresql

I'm doing a #postgresql extension that creates a pool of named background ...

... workers.

#postgresql

Awesome, compiling a #postgresql extension with -Wextra raises warnings from ...

... Postgres include files.