所谓“多租户（Multi-Tenancy）”，本质上就是：一套系统，同时服务多个客户，并且每个客户的数据互相隔离。 很多团队第一次做 SaaS 系统时，对“多租户”这件事的理解都非常粗暴。 数据库实例爆炸、连接池失控、迁移困难、资源利用率极低。 更致命的是 ...

这几年后端圈有个现象挺明显的： 一聊数据库，越来越多人开始夸 PostgreSQL。 夸它 JSONB 强、扩展生态丰富、SQL 更标准、向量和时序场景更顺手，甚至不少人会直接给出一句很武断的话： “PostgreSQL 才是未来，MySQL 早该退场了。” 但如果你真的去看公司里的生产 ...

Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...

Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

Multiversion concurrency control (MVCC) is a database optimization technique. MVCC creates duplicate copies of records so that data can be safely read and updated at the same time. With MVCC, database ...

“The Oracle stack was getting harder to maintain, and scaling it meant significant investment every time. We saw Azure Database for PostgreSQL as the right foundation for the future. It’s open, ...

PostgreSQL with the pgvector extension allows tables to be used as storage for vectors, each of which is saved as a row. It also allows any number of metadata columns to be added. In an enterprise ...

This is a foreign data wrapper (FDW) to connect PostgreSQL to any Java DataBase Connectivity (JDBC) data source. The existing JDBC FDWs are only read-only, this version provides the write capability.

Abstract: Working with different DBMS for programmers in their daily work represents a significant challenge in terms of choosing the appropriate way of connecting to the DBMS for the appropriate ...