bk99.de entertain the web since 1997

bk99.de
HN · DatabasesCurated

PostgreSQL 9.4 introduces JSONB

Summary

PostgreSQL 9.4 adds binary-stored JSON, new replication options and better tools for analytical and operational workloads. PostgreSQL 9.4 was released in December 2014. JSONB supports indexing.

Ideas

  • JSONB stores documents in a decomposed binary representation.
  • GIN indexes speed up searches within JSON documents.
  • Materialised views can be refreshed without long read locks.
  • Replication slots prevent WAL data that is still needed from being removed too early.

Insights

  • Relational and document-oriented models can coexist in the same database.
  • A flexible schema does not replace deliberately chosen integrity rules.
  • Operational features determine the value of a database as much as query syntax.

Facts

  • The version added logical decoding as a foundation.

Recommendations

  • Only use JSONB for structures that are actually variable.
  • Monitor replication slots for retained WAL volumes.

References

Read the original article

Search the Web Archive

HN · 2012

RethinkDB as a distributed open source database

After three years of development, the RethinkDB team releases a distributed database with manageable replication and an expressive query language. RethinkDB was released publicly in November 2012. The project is developed as free software.

HN · 2015

PostgreSQL gets atomic UPSERT

Peter Geoghegan implements INSERT ON CONFLICT, combining insertion and conflict handling in one concurrency-safe statement. UPSERT arrived with PostgreSQL 9.5. The syntax is INSERT ON CONFLICT.

HN · 2026

Asahi Linux 7.2: progress on Apple Silicon

James Calligeros describes how Asahi Linux brings together power-saving features, new Apple generations and direct video output. M3 devices now support the webcam, microphones, USB 3.0 and Thunderbolt. M4 and M5 systems reach working NVMe and initial PCIe device detection.