{"library":"better-sqlite3-schema","type":"library","category":null,"description":"A library for migrating nested and multi-dimensional JSON data to/from SQLite databases using better-sqlite3-helper. Version 3.1.10 is stable, with active maintenance. It supports both runtime composition and code generation for ~50% speed improvement. Key differentiators: schema-driven normalization, bulk inserts with transactions, and caching of normalized values to reduce duplication. Suitable for large datasets (e.g., 8GiB proxy logs) with significant storage savings (e.g., 11% of plain text size). Includes TypeScript types via shipped definitions.","language":"javascript","status":"active","version":"3.1.10","tags":["javascript","helper","schema","migrate","import","export","better-sqlite3-helper","better-sqlite3","sqlite3","typescript"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install better-sqlite3-schema","imports":["import { TableSchema } from 'better-sqlite3-schema'","import { makeSchemaScanner } from 'better-sqlite3-schema'","import { makeInsertRowFnFromSchema } from 'better-sqlite3-schema'","import { makeDeduplicatedInsertRowFnFromSchema } from 'better-sqlite3-schema'","import { makeSelectRowFnFromSchema } from 'better-sqlite3-schema'","import { makeSelectRefFieldArray } from 'better-sqlite3-schema'","import { makeGetRefValueFnFromSchema } from 'better-sqlite3-schema'"]},{"cmd":"yarn add better-sqlite3-schema","imports":[]},{"cmd":"pnpm add better-sqlite3-schema","imports":[]}],"homepage":"https://github.com/beenotung/better-sqlite3-schema#readme","github":"https://github.com/beenotung/better-sqlite3-schema","docs":null,"changelog":null,"pypi":null,"npm":"better-sqlite3-schema","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}