Warning: Work in progress! Leave feedback on Zulip or Github if you'd like this doc to be updated.

Tables, Object, and Documents - Notation, Query, Creation, Schema

This is part of maximal YSH!

Table of Contents
Tables
Note: SQL Databases Support all three models!
Related

Tables

Data Type Notation Query Creation Schema
Table TSV, CSV csvkit, xsv, awk-ish, etc.
SQL, Data Frames
? ?
Object JSON jq
JSONPath: MySQL/Postgres/sqlite support it?
jq JSON Schema
Document HTML5, XML DOM API like getElementById()
CSS selectors
XPath?
JSX Templates XML Schema?
Existing

 

Data Type Notation Query Creation Schema In-Memory
Table TSV8 (is valid TSV) dplyr-like Data Frames
Maybe some SQL-pipe subset thing?
table { } ? By column: dict of "arrays"
By row: list of dicts
Object JSON8 (superset) JSONPath?
jq as a reshaping language
Hay? Package { } JSON Schema? List and Dict
Document HTM8 (subset) CSS selectors Markaby Style div { }
"sed" style
? DocFrag - a span within a doc
DocTree - an Obj representation
?
Oils

Note: SQL Databases Support all three models!

Related

Generated on Thu, 09 Jan 2025 17:42:22 +0000