{"library":"sqlite-cache-for-google-sheets","type":"library","category":null,"description":"Opinionated SQLite cache layer for Google Sheets data, designed for local development workflow where schema changes frequently. Version 9.0.0 is stable, actively maintained on GitHub. Ships TypeScript types. Provides a one-time load from Google Sheets into a local SQLite database, then allows querying via better-sqlite3. Unlike direct API queries, it avoids runtime dependency on Google Sheets and enables fast iteration. Requires API key, doc ID, and sheet ID. Uses a configurable map function to transform rows. Returns a better-sqlite3 database object for querying.","language":"javascript","status":"active","version":"9.0.0","tags":["javascript","typescript"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install sqlite-cache-for-google-sheets","imports":["import { createDatabase } from 'sqlite-cache-for-google-sheets'","import type { DatabaseConfig } from 'sqlite-cache-for-google-sheets'","import type { SheetRow } from 'sqlite-cache-for-google-sheets'","const { createDatabase } = require('sqlite-cache-for-google-sheets')"]},{"cmd":"yarn add sqlite-cache-for-google-sheets","imports":[]},{"cmd":"pnpm add sqlite-cache-for-google-sheets","imports":[]}],"homepage":"https://github.com/joropeza/sqlite-cache-for-google-sheets#readme","github":"https://github.com/joropeza/sqlite-cache-for-google-sheets","docs":null,"changelog":null,"pypi":null,"npm":"sqlite-cache-for-google-sheets","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}