@nanostores/sql

Nano Stores SQL

Nano Stores wrapper around SQLite or PGLite to generate reactive stores from SQL queries. This wrapper us useful if you moved logic from UI components to smart stores.

• Support multiple databases drivers: SQLocal, Expo, PGLite, or your custom driver.
• Can be used in browser with OPFS ot with React Native.
• Can be used with Drizzle to have type-safe query generation or with plain SQL strings to be very small in JS bundle.

import { openDb } from '@nanostores/sql'
// Or import { expoDriver } from '@nanostores/sql/expo'
import { sqlocalDriver } from '@nanostores/sql/sqlocal'

const db = openDb(sqlocalDriver('app.sqlite'))

const User = ({ id }) => {
  const $users = db.store<User>
    `SELECT * FROM users WHERE id = ${id}`
  // or const $users = db.store(drizzleDb.select().from(usersTable)
  //   .where(eq(usersTable.id, id)))
  const users = useStore($users)
  if (users.status === 'loading') {
    return <Loader>
  } else {
    return {users.value[0].name}
  }
}

  Nano Stores SQL is built by Evil Martians, an American design and engineering consultancy for developer tools, AI, and cybersecurity startups.

Docs

Read full docs here.