Data Feed #6: JSON {}

Articles, diagrams, and news about data systems for the engineers
data-feed
Author

Elias Nema

Published

March 17, 2023

Weekly Focus: JSON {}

PostgreSQL can deal with JSON for a very long time (and here is a great history1 of it), but now is also able to write the server log in JSON format.2

  • 1 JSONB in PostgreSQL today and tomorrow

  • 2 JSON logs in PostgreSQL 15

    • A deep dive into the potential performance issues when parsing JSON.3

  • 3 High-performance JSON parsing in Go

    • The MySQL JSON data type.

    In SQLite, JSON functions are built-in and on by default since 3.38, along with -> and ->> operators, compatible with MySQL and PostgreSQL.4

  • 4 SQLite Release 3.38.0

    • DuckDB:

    • DuckDB can read JSON files as tables, and here is an example of querying GH Archive data.5
    • JSON support was a big part of a DuckDB 0.7.0 release.6

  • 5 Shredding Deeply Nested JSON, One Vector at a Time

  • 6 Announcing DuckDB 0.7.0

    • Learning

    What is a UUID, and what is it used for?

    Data migrations are still of the hardest problems in engineering, and AWS has written a couple of recent articles about that:

    Easy PostgreSQL time bins.

    Announcing Data API Builder (preview) for PostgreSQL.

    What is advertised Kafka address?

    PASS Data Community Summit is in Seattle on November 14-17 with a call for speakers still open.

    Getting started: Stream processing using Apache Flink and Redpanda.

    Deep Dive

    An AMAZING, more than 600 pages book focusing on PostgreSQL internals.7 A must-read!

  • 7 PostgreSQL 14 Internals

    • Enabling Linux Huge Pages for Postgres and MySQL.8

  • 8 Huge pages with Postgres & InnoDB: better perf, but a bit more work.

    • Performance comparison of the major PostgreSQL versions.

    Overview of machine learning-based automatic database tuning techniques at OtterTune.9

  • 9 OtterTune 1.5 to 2.0: Where We Are and Where We’re Going

    • Breaking your PostgreSQL database with bad CHECK constraints.

    Business

    The top five global data and AI trends in 2023 from Google Cloud.

    A new whitepaper from AWS on Data Lakes cost modeling best practices.10

  • 10 Cost modeling Data Lakes for beginners

    • Community and open source: the secret to PostgreSQL’s success.

    Prioritizing security, stability, and client satisfaction: insight from Fiserv’s VP and fellow architect.

    Get Data Feed posts by ✉️ | 🐦 | 🐘