PostgreSQL
Vector is the New JSON
August 06, 2023 in PostgreSQL
Vectors will become a key element in building applications, just like JSON historically. PostgreSQL leads the AI era with vector extensions.
Vectors will become a key element in building applications, just like JSON historically. PostgreSQL leads the AI era with vector extensions.
PostgreSQL, The most successful database
June 28, 2023 in PostgreSQL
StackOverflow 2023 Survey shows PostgreSQL is the most popular, loved, and wanted database, solidifying its status as the 'Linux of Database'.
StackOverflow 2023 Survey shows PostgreSQL is the most popular, loved, and wanted database, solidifying its status as the 'Linux of Database'.
AI Large Models and Vector Database PGVector
May 10, 2023 in PostgreSQL
This article focuses on vector databases hyped by AI, introduces the basic principles of AI embeddings and vector storage/retrieval, and demonstrates the functionality, performance, acquisition, and application of the vector database extension PGVECTOR through a concrete knowledge base retrieval case study.
This article focuses on vector databases hyped by AI, introduces the basic principles of AI embeddings and vector storage/retrieval, and demonstrates the functionality, performance, acquisition, and application of the vector database extension PGVECTOR through a concrete knowledge base retrieval case study.
How Powerful is PostgreSQL Really?
August 22, 2022 in PostgreSQL
Let performance data speak: Why PostgreSQL is the world's most advanced open-source relational database, aka the world's most successful database. MySQL vs PostgreSQL performance showdown and distributed database reality check.
Let performance data speak: Why PostgreSQL is the world's most advanced open-source relational database, aka the world's most successful database. MySQL vs PostgreSQL performance showdown and distributed database reality check.
Why PostgreSQL is the Most Successful Database?
July 12, 2022 in PostgreSQL
Database users are developers, but what about developers' preferences, likes, and choices? Looking at StackOverflow survey results over the past six years, it's clear that in 2022, PostgreSQL has won all three categories, becoming literally the "most successful database"
Database users are developers, but what about developers' preferences, likes, and choices? Looking at StackOverflow survey results over the past six years, it's clear that in 2022, PostgreSQL has won all three categories, becoming literally the "most successful database"
Ready-to-Use PostgreSQL Distribution: Pigsty
May 24, 2021 in PostgreSQL
Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution: Pigsty.
Yesterday I gave a live presentation in the PostgreSQL Chinese community, introducing the open-source PostgreSQL full-stack solution: Pigsty.
Why Does PostgreSQL Have a Bright Future?
May 08, 2021 in PostgreSQL
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?
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?
Localization and Collation Rules in PostgreSQL
March 05, 2021 in PostgreSQL
What? Don't know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!
What? Don't know what COLLATION is? Remember one thing: using C COLLATE is always the right choice!
Implementing Advanced Fuzzy Search
March 05, 2021 in PostgreSQL
How to implement relatively complex fuzzy search logic in PostgreSQL?
How to implement relatively complex fuzzy search logic in PostgreSQL?
PostgreSQL Logical Replication Deep Dive
March 03, 2021 in PostgreSQL
This article introduces the principles and best practices of logical replication in PostgreSQL 13.
This article introduces the principles and best practices of logical replication in PostgreSQL 13.