BestHub
Sign in
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
21CTO
21CTO
Mar 14, 2026 · Databases

Why SQL Is Making a Comeback: From Browsers to Backend

The article explores how three emerging trends—lightweight client‑side databases, schema‑less JSONB support, and modern synchronization engines—are reviving SQL, making it a first‑class data language for browsers, edge computing, and traditional back‑ends while preserving strong consistency and developer productivity.

JSONBSQLdatabases
0 likes · 10 min read
Why SQL Is Making a Comeback: From Browsers to Backend
Efficient Ops
Efficient Ops
Jan 6, 2026 · Databases

Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained

This article compiles a detailed comparison of PostgreSQL and MySQL, highlighting PostgreSQL's lack of text‑size limits, better NULL handling, native array and JSON support, built‑in optimistic locking, superior GIS types, MVCC, flexible indexing, robust replication, and overall stability, while also noting the few areas where MySQL still holds an edge.

Database comparisonGISJSONB
0 likes · 9 min read
Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained
DevOps Coach
DevOps Coach
Dec 15, 2025 · Databases

Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming

The article explains how PostgreSQL has evolved from a simple relational store into a versatile platform that supports full‑text search, vector similarity, geospatial queries, JSONB, message queues, and analytical workloads, allowing developers to replace multiple specialized tools with a single unified system.

Database ExtensionsEvent StreamingFull-text search
0 likes · 6 min read
Why PostgreSQL Is Becoming the Backend OS: From Search to Event Streaming
JakartaEE China Community
JakartaEE China Community
Jul 28, 2025 · Backend Development

How to Store JSON Data Using JPA and Hibernate

This tutorial shows how to store, query, and manipulate JSON data in PostgreSQL using JPA and Hibernate, covering native JSON/JSONB types, the Hypersistence JsonType, entity mapping, service and REST layers, WildFly configuration, and curl‑based testing.

HibernateHypersistenceJSON
0 likes · 11 min read
How to Store JSON Data Using JPA and Hibernate
21CTO
21CTO
Jul 1, 2024 · Databases

MongoDB vs PostgreSQL: Which Handles GenAI Workloads Better?

This article compares MongoDB’s document‑oriented storage with PostgreSQL’s relational model for generative AI workloads, detailing how JSON, JSONB, and BSON affect insert and read performance across a series of benchmarks on identical hardware.

BSONDatabase PerformanceGenAI
0 likes · 11 min read
MongoDB vs PostgreSQL: Which Handles GenAI Workloads Better?
ITPUB
ITPUB
May 5, 2024 · Databases

What GitLab’s 34k‑Line Postgres Schema Reveals About Scalable Database Design

This article examines GitLab’s extensive PostgreSQL schema, explaining why the project uses a pure‑SQL structure file, how primary‑key choices, internal versus external IDs, naming conventions, timestamps, text types, partitioning, GIN indexes, JSONB columns, foreign‑key strategies and other data‑type decisions impact performance, maintainability, and scalability.

IndexesJSONBPartitioning
0 likes · 25 min read
What GitLab’s 34k‑Line Postgres Schema Reveals About Scalable Database Design
ITPUB
ITPUB
Jan 5, 2018 · Databases

Why PostgreSQL Stands Out: Essential Features and Extensions Explained

This article outlines the most compelling reasons to choose PostgreSQL, covering its advanced data types like JSONB and Range, powerful extensions such as Citus, HyperLogLog and PostGIS, logical replication, rich indexing options, upsert support, foreign data wrappers, and a host of legacy capabilities.

ExtensionsIndexesJSONB
0 likes · 10 min read
Why PostgreSQL Stands Out: Essential Features and Extensions Explained
ITPUB
ITPUB
Jan 8, 2016 · Databases

Unlock PostgreSQL 9.5: Faster Sorting, Grouping Sets, Upserts & JSONB Tips

PostgreSQL 9.5 brings dramatic performance gains, new OLAP capabilities like GROUPING SETS, CUBE, ROLLUP, convenient pg_rewind for HA, flexible upsert handling, and enhanced JSONB output, all illustrated with practical examples and import techniques.

9.5Grouping SetsJSONB
0 likes · 4 min read
Unlock PostgreSQL 9.5: Faster Sorting, Grouping Sets, Upserts & JSONB Tips
ITPUB
ITPUB
Jan 1, 2016 · Databases

10 Essential PostgreSQL Tips to Boost Your Productivity

Discover ten practical PostgreSQL techniques—including CTEs, custom .psqlrc settings, pg_stat_statements, FDWs, array handling, materialized views, window functions, pivot shortcuts, PostGIS, and JSONB—to write cleaner queries, improve performance, and leverage advanced database features.

CTEFDWJSONB
0 likes · 9 min read
10 Essential PostgreSQL Tips to Boost Your Productivity