Joining CSV and JSON data with an in-memory SQLite database
19th June 2021 The new sqlite-utils memory command can import CSV and JSON data directly into an in-memory SQLite database, combine and query it using SQL and output the results as CSV, JSON or various other formats of plain text tables. sqlite-utils memory The new feature is part of sqlite-utils 3.10, which I released this morning. You can install it using brew install sqlite-utils or pip install
Bashing JSON into Shape with SQLite
Published on 2022-01-04, 1640 words, 6 minutes to read It is clear that most of the world has decided that they want to use JSON for their public-facing API endpoints. However, most of the time you will need to deal with storage engines that don't deal with JSON very well. This can be confusing to deal with because you need to fit a square peg into a round hole. However, SQLite added JSON function
The JSON1 Extension | SQLite
1. Overview By default, SQLite supports thirty functions and two operators for dealing with JSON values. There are also two table-valued functions that can be used to decompose a JSON string. There are twenty-six scalar functions and operators: json(json) jsonb(json) json_array(value1,value2,...) jsonb_array(value1,value2,...) json_array_length(json) json_array_length(json,path) json_error_positio
GitHub - pikkr/pikkr: JSON parser which picks up values directly without performing tokenization in Rust
Pikkr is a JSON parser which picks up values directly without performing tokenization in Rust. This JSON parser is implemented based on Y. Li, N. R. Katsipoulakis, B. Chandramouli, J. Goldstein, and D. Kossmann. Mison: a fast JSON parser for data analytics. In VLDB, 2017. This JSON parser extracts values from a JSON record without using finite state machines (FSMs) and performing tokenization. It
CBOR — Concise Binary Object Representation | Overview
RFC 8949 Concise Binary Object Representation “The Concise Binary Object Representation (CBOR) is a data format whose design goals include the possibility of extremely small code size, fairly small message size, and extensibility without the need for version negotiation.†JSON data model CBOR is based on the wildly successful JSON data model: numbers, strings, arrays, maps (called objects in JSON)
demjson‒A Python JSON module
NEWS: (December 2015) Version 2.2.4 was released! Read about all the changes. (Notes for downstream package maintainers.) About demjson and jsonlint The demjson package is a comprehensive Python language library to read and write JSON; the popular language-independent data format standard. It includes a command tool, jsonlint, that allows you to easily check and validate any JSON document, and spo
GitHub - cognitect/transit-format: A data interchange format.
Transit provides a set of basic elements and a set of extension elements for representing typed values. The extension mechanism is open, allowing programs using Transit to add new elements specific to their needs. Users of data formats without such facilities must rely on either schemas, convention, or context to convey elements not included in the base set, making application code much more compl
jq
jq is a lightweight and flexible command-line JSON processor. jq is like sed for JSON data - you can use it to slice and filter and map and transform structured data with the same ease that sed, awk, grep and friends let you play with text. jq is written in portable C, and it has zero runtime dependencies. You can download a single binary, scp it to a far away machine of the same type, and expect
ランã‚ング
ランã‚ング
メンテナンス
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - TomWright/dasel: Select, put and delete data from JSON, TOML, YAML, XML and CSV files with a single tool. Supports conversion between formats and can be used as a Go package.
GitHub - multiprocessio/dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
GitHub - wader/fq: jq for binary formats - tool, language and decoders for working with binary and text formats
GitHub - jqlang/jq: Command-line JSON processor
GitHub - kellyjonbrazil/jc: CLI tool and python library that converts the output of popular command-line tools, file-types, and common strings to JSON, YAML, or Dictionaries. This allows piping of output to tools like jq and simplifying automation scripts
https://webdatarender.com/
GitHub - simonw/datasette: An open source multi-tool for exploring and publishing data
http://seriot.ch/parsing_json.html
GitHub - miloyip/nativejson-benchmark: C/C++ JSON parser/generator benchmark
GitHub - tomnomnom/gron: Make JSON greppable!
GitHub - WebReflection/JSONH: Homogeneous Collection Compressor
eBay
{{#tags}}- {{label}}
{{/tags}}