The article explains why developers should move beyond MySQL to PostgreSQL, illustrating the productivity gains of native window functions, MVCC concurrency, rich indexing, JSONB support, and extensive extensions through detailed examples, installation guides, performance comparisons, and real‑world use cases.
The article explains why many developers stuck with MySQL should consider PostgreSQL, highlighting its superior SQL standards support, MVCC concurrency, rich indexing, JSONB performance, full‑text search, extensive extensions, and practical installation and Java integration steps, while also comparing pros, cons, and ideal use cases.
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.
This article analyzes Multica’s open‑source hosted‑agent platform, detailing how it orchestrates multiple AI agents, manages task memory through a six‑table relational schema, avoids vector embeddings, and balances human‑in‑the‑loop collaboration with scalable workspace isolation.
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.
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.
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.
The article shares a seasoned DBA’s firsthand comparison of MySQL and PostgreSQL, covering their histories, performance quirks, real‑world case studies, lock mechanisms, backup strategies, and practical selection guidelines to help developers decide which database best fits their workload.
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.
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.
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.
This article explains PostgreSQL's jsonb type, its performance advantages over plain json, outlines its pros and cons, and demonstrates common operations such as inserting, querying, filtering, array expansion, containment checks, and indexing with practical book‑entry examples.
This article explores PostgreSQL’s NoSQL capabilities by comparing JSON and JSONB data types, demonstrating their storage differences, read/write performance tests on millions of rows, index strategies, and the new full‑text search support for JSON/JSONB introduced in version 10.
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.
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.
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.
