dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
Introducing dsq, a command-line tool for running SQL queries against JSON, CSV, Excel, Parquet, and other data file formats.
Introducing dsq, a command-line tool for running SQL queries against JSON, CSV, Excel, Parquet, and other data file formats.
Explains how to analyze large JSON files that exceed memory limits using partial JSON parsing techniques in Node.js.
A Swift developer explores using Codable to encode/decode references between types, solving data duplication in JSON-based document models.
Explains how to integrate ASP.NET Core Minimal APIs with Razor Pages for efficient JSON data handling in web applications.
Explains how to import JSON files directly into ES modules using the JSON modules proposal and import assertions in JavaScript.
A technical exploration of performance differences between row-oriented and column-oriented data structures for in-memory data processing.
A personal explanation of serialization and deserialization, using analogies and examples from Go and Wikipedia to clarify the concepts.
A Django tutorial explaining user session data, how it works, its storage engines, and how to access it via request.session.
Explains how Swift 5.5's Codable API automatically synthesizes encoding/decoding for enums, including those with associated values.
A walkthrough of building a basic JSON parsing library from scratch using modern C++ features like move semantics and smart pointers.
A tutorial on using the JavaScript fetch() API to make GET and POST requests with JSON data, including setting headers and parsing responses.
A technical guide on building a performant object previewer in JavaScript to avoid UI freezes when handling large data structures.
Explains how to customize JSON encoding/decoding for external Swift types like TimeZone using wrapper types and Codable.
A beginner's tutorial on building a basic JSON API using the Python Flask web framework, covering setup, routing, and CRUD operations.
Explores the surprising flexibility of YAML keys, including spaces and special characters, with examples from Home Assistant config.
A critique of Signal's centralization and a proposal for a federated, protocol-based chat app with end-to-end encryption.
A tutorial on building a full CRUD REST API using only Django's core features, without the Django Rest Framework.
A step-by-step React tutorial for building a simple blog application using JSON data, covering components, state, props, and deployment.
A tutorial on using static JSON files with Netlify to serve data in a JAMStack architecture, avoiding database costs.
Explains why Go's json.Unmarshal behaves differently when passed a pointer variable vs. the address of a pointer, clarifying pointer mechanics.