Majestic Southern Taihang

Standing on the hills of Manchuria, on the grasslands of Hulunbuir.

Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution — Pigsty

Databases are the core component of information systems, relational databases are the absolute backbone of databases, and PostgreSQL is the world’s most advanced open source relational database. With such favorable timing and positioning, how can it not achieve great success?

How to implement relatively complex fuzzy search logic in PostgreSQL?

What? Don’t know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!

Replica identity is important - it determines the success or failure of logical replication