{"id":46247,"library":"requery-sqlite","title":"Requery SQLite","description":"Requery SQLite is the SQLite dialect and backend for Requery, a typed SQL query builder for Python. Version 0.21.0 provides a synchronous SQLite interface with connection management, query execution, and type-safe row mapping. It integrates tightly with Requery's expression system, enabling composable queries compiled to SQLite-specific SQL. Released regularly alongside Requery core, it differentiates by offering compile-time type checking without an ORM overhead, targeting developers who want SQLite access with Python type safety.","status":"active","version":"0.21.0","language":"javascript","source_language":"en","source_url":"https://github.com/adnelson/requery","tags":["javascript"],"install":[{"cmd":"npm install requery-sqlite","lang":"bash","label":"npm"},{"cmd":"yarn add requery-sqlite","lang":"bash","label":"yarn"},{"cmd":"pnpm add requery-sqlite","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Core library providing the query builder and expression system","package":"requery","optional":false}],"imports":[{"note":"The main entry point to create a database connection","wrong":"import requery_sqlite","symbol":"connect","correct":"from requery_sqlite import connect"},{"note":"Class representing a SQLite database connection","symbol":"Database","correct":"from requery_sqlite import Database"},{"note":"Requery SQLite exposes the underlying sqlite3 module as a public attribute; but typical usage uses the `connect` function","wrong":"from requery_sqlite import sqlite3","symbol":"sqlite3","correct":"import sqlite3 as db"}],"quickstart":{"code":"from requery_sqlite import connect\ndb = connect(':memory:')\n\nfrom requery import (\n    Table,\n    Column,\n    Integer,\n    Text,\n    select,\n)\n\nusers = Table('users',\n    Column('id', Integer, primary_key=True),\n    Column('name', Text),\n    Column('email', Text),\n)\ndb.execute(users.create())\n\nquery = select(users.c.name, users.c.email).where(users.c.id == 1)\nresult = db.execute(query)\nrow = result.one()\nprint(row.name, row.email)","lang":"python","description":"Shows how to create an in-memory database, define a table, insert data, and run a typed SELECT query with Requery SQLite."},"warnings":[{"fix":"Upgrade Python to 3.8+.","message":"Requery SQLite requires Python 3.8 or higher.","severity":"breaking","affected_versions":">=0.21.0"},{"fix":"Use a connection pool or ensure single-threaded access.","message":"Database connections are not thread-safe by default.","severity":"breaking","affected_versions":">=0.1.0"},{"fix":"Use requery-sqlite only in synchronous contexts.","message":"The connect() function returns a synchronous connection; asynchronous usage is not supported yet.","severity":"gotcha","affected_versions":">=0.21.0"},{"fix":"Replace 'from requery.sqlite import ...' with 'from requery_sqlite import ...'.","message":"The old requery.sqlite module is deprecated; use requery_sqlite package instead.","severity":"deprecated","affected_versions":">=0.20.0"}],"env_vars":null,"search_vec":"'0.21.0':21 'access':78 'alongsid':57 'backend':10 'builder':17 'check':68 'compil':49,65 'compile-tim':64 'compos':47 'connect':28 'core':59 'develop':74 'dialect':8 'differenti':61 'enabl':46 'execut':31 'express':44 'integr':39 'interfac':26 'javascript':83 'manag':29 'map':37 'offer':63 'orm':71 'overhead':72 'provid':22 'python':19,80 'queri':16,30,48 'regular':56 'releas':55 'requeri':1,3,12,42,58 'row':36 'safe':35 'safeti':82 'specif':53 'sql':15,54 'sqlite':2,4,7,25,52,77 'sqlite-specif':51 'synchron':24 'system':45 'target':73 'tight':40 'time':66 'type':14,34,67,81 'type-saf':33 'version':20 'want':76 'without':69","created_at":"2026-06-07T12:59:00.293988+00:00","updated_at":"2026-06-07T12:59:00.293988+00:00","problems":[{"fix":"Install the package: pip install requery-sqlite","cause":"Package not installed or installed under different name.","error":"ModuleNotFoundError: No module named 'requery_sqlite'"},{"fix":"Use connect() to create a database instance.","cause":"Using Database class directly instead of connect function.","error":"TypeError: 'Database' object is not callable"},{"fix":"Use db.execute() for DDL without expecting a row result; for queries, ensure SELECT statements are used.","cause":"Executing a DDL statement (e.g., CREATE TABLE) and trying to fetch results.","error":"AttributeError: 'NoneType' object has no attribute 'fetchall'"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/adnelson/requery#readme","github":"https://github.com/adnelson/requery","docs":null,"changelog":null,"pypi":null,"npm":"requery-sqlite","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-07","next_check":"2026-09-05","install_tag":null}}