PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.
A technical walkthrough of loading and exploring UK Environment Agency flood data using DuckDB and Rill for a streaming pipeline project.
Explores JWCC, a JSON extension adding comments and trailing commas, comparing it to JSON5, HuJSON, JSONC, and Hjson.
Explains the ECMAScript 'Import Attributes' feature for importing non-JavaScript artifacts like JSON and WebAssembly, now at Stage 4.
The article critiques JORM-style APIs, explaining why they are not true REST and how hypermedia-driven design solves coupling and evolvability issues.
Explains how to emulate SQL's FILTER clause for JSON aggregate functions in Oracle, addressing NULL value handling in JSON arrays and objects.
Using GitHub Actions to automate parsing Azure sustainability PDFs into a public JSON file for programmatic use.
Specification and development status of valarmd, a paused daemon project for showing desktop notifications from calendar alarms.
A developer's technical build log for creating Jumblie, a daily word puzzle game, covering concept, word list generation, and prototyping.
Explores OpenAI's new JSON mode for GPT-4 Turbo, demonstrating how to reliably generate valid JSON output with a Ruby code example.
A guide to jq, a powerful command-line JSON processor for developers, covering installation, basic usage, and productivity tips.
A step-by-step tutorial on building a JSON API using Java Spring Boot, Maven, and PostgreSQL.
A tutorial on using the fileCache utility from Splendid UI to easily implement local file system caching in Node.js applications.
A tutorial on using pipes and the .[] filter in jq, a command-line JSON processor, for data iteration and transformation.
Part III of a tutorial series on jq, focusing on core filter concepts for selecting and processing JSON data, including the dot filter and JSON syntax.
A guide on copying specific elements like queries, metrics, or groups between Azure Workbooks using the Advanced Editor and JSON.
Explains how to handle JSON arrays in Kusto Query Language (KQL) using mv-expand and mv-apply, focusing on Azure AD Conditional Access policy data.
A guide to solving common JSON deserialization issues in .NET, focusing on JsonSerializerOptions and property name casing.
jOOQ 3.18.0 release adds enhanced SQL diagnostics, SQL/JSON support, Oracle/PostgreSQL array features, and R2DBC 1.0 integration.
A tutorial on creating custom VS Code snippets to automate repetitive coding tasks and speed up development workflow.
