Expo SQLite Query Helper (v1.2.0) is a lightweight, zero-config query builder for expo-sqlite in React Native apps. It provides a simple async API for common SQL operations (createTable, insert, search, update, delete) with automatic promise handling and result objects (row, insertId, lastQuery). Unlike raw SQLite, it abstracts away SQL syntax while still exposing the last executed query for debugging. Compatible with Expo SDK 46+ and expo-sqlite 10.3+. Ships TypeScript types. Alternative to Knex.js or TypeORM for Expo projects. Release cadence: monthly minor updates.
npm install expo-sendylo-sqlite-helperNo compatibility data collected yet for this library.
Verified import paths — ran on the pinned version, not inferred.
Initializes database, creates table, inserts multiple rows, and searches by condition.
Call Database only once (e.g., in App component or a singleton).
Use `result.row._array` to get array of objects.
Always pass a database name to Database() (e.g., Database('myApp.db')).Use array syntax: insert('table', [{...}]) for single or multiple rows.Ensure Database('name.db') is called at app startup.Use `import { createTable } from 'expo-sqlite-query-helper'`.Restructure code to call Database() before any other import functions.