https://blog.gslin.org/archives/2025/06/14/12463/%e5%a5%87%e6%80%aa%e7%9a%84-postgresql-benchmark-%e7%9c%8b%e8%b5%b7%e4%be%86%e9%82%84%e6%b2%92%e8%a7%a3%ef%bc%9f/

奇怪的 PostgreSQL benchmark (看起來還沒解？)

#benchmark #database #db #performance #pgbench #pgsql #postgresql #rdbms #speed #sql

https://blog.gslin.org/archives/2025/06/11/12450/supabase-%e6%89%93%e7%ae%97%e8%a6%81%e9%96%8b%e7%99%bc-postgresql-%e4%b8%8a%e7%9a%84-vitess%ef%bc%9amultigres/

Supabase 打算要開發 PostgreSQL 上的 Vitess：Multigres

#database #db #multigres #postgresql #proxy #rdbms #supabase #vitess

Does anyone use PL/SQL?

#Databases #RDBMS #SQL #SoftwareEngineering

MariaDB 11.8 LTS open-source RDBMS is out, featuring full MariaDB Vector support, faster backups, improved replication, and more.
https://linuxiac.com/mariadb-11-8-lts-rdbms-lands-with-vector-search/

#mariadb #mysql #opensource #rdbms

https://blog.gslin.org/archives/2025/06/09/12444/mariadb-11-8-lts/

MariaDB 11.8 LTS

#2038 #2106 #database #embedding #hnsw #mariadb #mysql #problem #rdbms #signed #timestamp #unsigned #vector #year

https://blog.gslin.org/archives/2025/05/28/12418/mariadb-%e8%b2%b7-galera-cluster%ef%bc%9f%ef%bc%81/

MariaDB 買 Galera Cluster？！

#cluster #database #db #galera #mariadb #mysql #rdbms

Eventually, I came with my own solution to handle `MIN` and `MAX` in #PostgreSQL with UUID columns (with UUID v7).

https://darkghosthunter.medium.com/postgresql-using-min-max-on-uuid-columns-51e52927e6a0

#Programming #Coding #Code #SQL #UUID #Postgres #Database #DB #Databases #RDBMS #SoftwareDevelopment #WebDevelopment #WebDev #DatabaseDevelopment #DBDevelopment #Tutorial #Blog

I'm literally just two fucking clicks away from swapping PostgreSQL to Microsoft SQL Server for a client.

Why? It supports `MAX(uuid)`.

Fuck it. I'm choosing the dark side on this one.

#Programming #SQL #Database #DB #RDBMS #Databases #WebDevelopment #SoftwareDevelopment #WebDev #PostgreSQL #Postgres

How difficult can be creating an hypertable in TimescaleDB?

It seems that pretty much of a fucking lot.

#PostgreSQL #TimescaleDB #Hypertable #Hypertables #SQL #RDBMS #RelationalDatabase #Database #Databases #Programming #SoftwareDevelopment #DatabaseDevelopment

Stop by and see our CEO @c2main present on using #Linux container groups to improve #PostgreSQL system performance and automation at #PGConfDev in #Montreal tomorrow, May 14th. He'd be happy to chat with you about questions and thoughts relating to #Postgres development, research, and projects!

#opensource #foss #oss #canada #tech #techevent #database #data #rdbms #sql #datascientist #analytics #dev