@rdub/react-sql.js-httpvfs

React wrapper for sql.js-httpvfs (for querying SQLite databases from a web browser).

API

• query.ts: React hooks for querying SQLite databases
  • useSqlQuery
  • useSqlQueryLazy
  • useSqlResult
  • useSqlQueryCallback
• sql.ts: lower-level bindings to sql.js-httpvfs
  • getDb
  • useDb

Examples

crashes.hudcostreets.org

Paginated table backed by SQLite file in S3:

demo, source, data (s3://nj-crashes/njsp/crashes.db)