BestHub
Sign in
Tagged articles
9 articles
Page 1 of 1
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 22, 2026 · Databases

Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice

PostgreSQL’s extensible architecture lets it evolve from a relational DB into a true multi‑model system supporting graphs, vectors, full‑text, time‑series, GIS and key‑value data, with detailed architecture explanations, practical code demos, cross‑model queries, extension selection, and production‑grade best‑practice tips.

Apache AGEFull‑Text SearchJSONB
0 likes · 39 min read
Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice
JavaGuide
JavaGuide
Oct 8, 2025 · Databases

Is MySQL Now the Runner‑Up to PostgreSQL in the AI Era?

While MySQL has long dominated relational databases with its open‑source stability and massive user base, the rise of AI and PostgreSQL’s extensible ecosystem—highlighted by extensions like pgvector, pg_bm25, TimescaleDB and PostGIS—are shifting developer preference, as shown by the 2025 Stack Overflow survey.

AIDatabase ExtensibilityPostgreSQL
0 likes · 6 min read
Is MySQL Now the Runner‑Up to PostgreSQL in the AI Era?
DataFunSummit
DataFunSummit
Aug 28, 2022 · Databases

Practical Implementation of TimescaleDB and PostgreSQL at Hytera: Concepts, Deployment, and Performance

This article presents an in‑depth overview of time‑series data concepts and the practical adoption of TimescaleDB built on PostgreSQL at Hytera, covering requirements, core features, hypertable architecture, deployment models, compression, data retention, backup strategies, and performance benchmarks.

DistributedPostgreSQLTime-series
0 likes · 14 min read
Practical Implementation of TimescaleDB and PostgreSQL at Hytera: Concepts, Deployment, and Performance
ITPUB
ITPUB
Mar 10, 2022 · Databases

How to Speed Up Latest‑Record Queries in Large PostgreSQL Time‑Series Tables

This article explains why querying the most recent record for a specific device in massive time‑series tables can be painfully slow in PostgreSQL, demonstrates the impact of using only a timestamp index, and presents several indexing and query‑design strategies—including composite indexes, lateral joins, SkipScan, recursive CTEs, and logging tables with triggers—to dramatically improve performance.

PostgreSQLSQLTime-Series
0 likes · 22 min read
How to Speed Up Latest‑Record Queries in Large PostgreSQL Time‑Series Tables
MaGe Linux Operations
MaGe Linux Operations
Jul 11, 2020 · Databases

Unlocking Time‑Series Power: A Deep Dive into TimescaleDB

This article introduces TimescaleDB—a PostgreSQL extension for time‑series data—explaining its core concepts, data‑model choices, architecture, native compression, and provides step‑by‑step installation instructions on a CentOS 7 environment.

PostgreSQLTime SeriesTimescaleDB
0 likes · 15 min read
Unlocking Time‑Series Power: A Deep Dive into TimescaleDB