Search Articles — Sudonull

Search Results

In this project

gnata: JSONata on Go with AI for $400

https://sudonull.com/gnata-jsonata-on-go-with-ai-for-400

Engineer Reco ported JSONata to Go with Cursor: 1000x speedup, $500k savings. Process details, tests, shadow deployment. For Go developers.

Structured JSON Logs: A Guide for Developers

https://sudonull.com/structured-json-logs-a-guide-for-developers

Practical guide to implementing effective logging in distributed systems. Learn about MDC, entrypoints and error/warning separation.

Dialog management in Python via JSON config

https://sudonull.com/dialog-management-in-python-via-json-config

Declarative approach to wizards in Python. Configuring steps, conditional visibility and integration with aiogram 3 without nested if. Read the guide.

Notation for SQL conditions in JSON strings

https://sudonull.com/notation-for-sql-conditions-in-json-strings

Compact string notation for generating SQL expressions from JSON. Support for sets, intervals, MIN/MAX. Regular validation and examples for developers. Study and implement in preprocessor.

Grid Inventory GameMaker: Code and JSON

https://sudonull.com/grid-inventory-gamemaker-code-and-json

Create a flexible grid inventory system in GameMaker with ds_grid, JSON database, and drag-and-drop. Step-by-step code for middle developers. Implement now.

From other projects

From the web

PostgreSQL: Documentation: 18: 8.14. JSON Types

https://www.postgresql.org/docs/current/datatype-json.html

Notably, jsonb will reject numbers that are outside the range of the PostgreSQL numeric data type, while json will not. Such implementation-defined restrictions are permitted by RFC 7159.

What is JSONB in PostgreSQL? - GeeksforGeeks

https://www.geeksforgeeks.org/postgresql/what-is-jsonb-in-postgresql/

Jul 23, 2025 · In this article, we will explain JSONB in detail, explain how to manipulate it, and explain why JSONB is important in PostgreSQL with the help of practical examples.

JSON vs JSONB - A complete comparison - DbVisualizer

https://www.dbvis.com/thetable/json-vs-jsonb-in-postgresql-a-complete-comparison/

Dec 2, 2022 · Learn everything you need to know about the difference between JSON and JSONB, and why most often JSONB is the recommended option.

Explanation of JSONB introduced by PostgreSQL - Stack Overflow

https://stackoverflow.com/questions/22654170/explanation-of-jsonb-introduced-by-postgresql

Mar 26, 2014 · JSONB objects are stored as a decompressed binary as opposed to "raw data" in JSON, where no reparsing of data is required during retrieval. JSONB also supports indexing, which can be …

PostgreSQL: Documentation: 18: 9.16. JSON Functions and Operators

https://www.postgresql.org/docs/current/functions-json.html

In addition, the usual comparison operators shown in Table 9.1 are available for jsonb, though not for json. The comparison operators follow the ordering rules for B-tree operations outlined in Section …

How to Query JSONB in PostgreSQL | Tiger Data

https://www.tigerdata.com/learn/how-to-query-jsonb-in-postgresql

Feb 17, 2025 · Learn how to query JSON in PostgreSQL using various operators along with JSONB functions. A practical guide for PostgreSQL and TimescaleDB developers.

The SQLite JSONB Format

https://sqlite.org/draft/jsonb.html

Dec 5, 2023 · Beginning with version 3.45.0 (pending), SQLite supports an alternative binary encoding of JSON which we call "JSONB". JSONB is a binary format that stored as a BLOB.

JSON vs JSONB — What Are They, How Do They Differ, and When to …

https://www.grandlinux.com/en/blogs/json-jsonb.html

Mar 26, 2026 · What Is JSONB? JSONB (JSON Binary) stores JSON data in a decomposed binary format — the same data as JSON, but stored in a way that enables much faster searching and …

JSONB: PostgreSQL’s Secret Weapon for Flexible Data Modeling

https://medium.com/@richardhightower/jsonb-postgresqls-secret-weapon-for-flexible-data-modeling-cf2f5087168f

May 4, 2025 · JSONB: Stores data in a binary format, removing whitespace, sorting keys, and enabling fast queries and indexing. Think of it as a searchable library rather than a locked box.

JSON Binding (JSON-B) - Home - GitHub Pages

https://javaee.github.io/jsonb-spec/

JSON-B is a standard binding layer for converting Java objects to/from JSON messages. It defines a default mapping algorithm for converting existing Java classes to JSON, while enabling developers to …

Trending Now