sql
@webda/sql
@webda/sql
Engine-neutral "one JSON document per row" store for Webda: a uuid key column and a data JSON column per
table, CRUD and conditional writes, WebdaQL translated to SQL, class filtering through the stored __type,
bulk deleteMany / updateMany, native aggregations and the raw access used by the migration commands.
The package carries no database driver. An engine provides a SQLDialect (the syntax of every JSON fragment:
placeholders, JSON paths, type tests, merges, DDL) and a SQLStore subclass holding the connection:
see @webda/postgres (PostgresDialect, JSONB) and @webda/sqlite (SQLiteDialect, JSON1 on node:sqlite).