csvs

Database

plain-text relational database

Product

competes: recutils, SQL, mongodb

interacts: file system, clients, text editors

constitutes: a set of CSV files

includes: config, schema, data

resembles: recutils

patterns:

stakeholders: fetsorn

Technical

宣 胞 闹

• user must view dataset in a text editor

  众 脱 幻

• user must version control the dataset

  叔 纹 岩

• user must query with grep

  在 赏 顶

• user must deduplicate values

  朗 归 娘

• user without a client should figure out the dataset structure

  波 精 祸

• developer without a client should figure out how to restore data

  据 叫 妻

• developer must implement searches

  关 障 讯

• user must specify relations between entities

  裂 捞 红

• user must store arrays, lists

  奥 虚 昌

• user must store records, sets

  良 送 辖

• user must store identical data in efficient space

  碱 碱 烷

• user should specify foreign keys as sha256sum hashes of values

  复 究 臂

• user should specify foreign keys as multiformats hashes of values

  卖 践 杀

• user should store relative values

  泡 辟 止

• user should store escaped string

  模 桂 红

• user should store without duplication

  据 归 改

• user must store values

  亦 龙 皱

• developer must extend csvs format

  敌 爬 鬼

• user must read plain text

  磁 西 催

• user must read dataset files

  差 纳 父

• user must write dataset files

  税 七 汽

• developer must easily reverse engineer the dataset structure without documentation

  决 胀 我

• developer must easily support and maintain the dataset

Library

library for interacting with csvs datasets

Product

competes: libraries for SQL, MongoDB,

interacts: with arbitrary dataset storage that implements FS

constitutes: a library, a WASM reactor module

includes: a façade interface, query controller, record update controller, record delete controller, schema controller, dataset cache

patterns: façade

resembles:

stakeholders: fetsorn

Technical

龄 摸 律

• user must search records in a csvs dataset

  馏 温 佛

• user must specify custom read method

  邻 津 二

• user must specify custom write method

  大 冶 横

• user must specify custom grep method

  巡 尾 造

• user must edit record in a csvs dataset

  沸 油 诚

• user must delete record from a csvs dataset

  理 双 景

• user must add record to a csvs dataset

  绝 项 额

• user can optimize csvs dataset files

  糊 变 审

• user must stream query results

  迹 黄 虽

• user should find 100k records in under 1 second

  巩 必 扎

• user must add records in bulk

  津 飞 妹

• user must edit records in bulk

  阻 愿 夫

• user must delete records in bulk

  黄 苯 层

• user must search all keys

  铅 射 写

• user must build a record from key

  核 舒 骨

• user must search dataset with multiple trunks

  似 脚 放

• user must consistently reproduce dataset contents

CLI

command-line utility for interacting with csvs datasets

Product

competes: prsql, sqlite

interacts: filesystem

constitutes: a cli utility

includes:

patterns:

resembles:

stakeholders: fetsorn

Technical

北 翻 蚀

• user can create an empty csvs dataset

  玩 矿 仓

• user must create an empty csvs dataset

  薄 刺 内

• user must edit an empty csvs dataset

  夹 轨 检

• user must edit schema of a csvs dataset

  升 辨 良

• user must delete schema entry dataset

  氯 弃 检

• user must query entry dataset