{"id":45482,"library":"most-data-sqlite","title":"MOST Web Framework SQLite Adapter","description":"SQLite adapter for the MOST Web Framework, providing database connectivity for MVC applications. Version 0.1.16 is current with no stable release cadence. Requires manual compilation of a regex extension (C source) for SQLite. Adapter is configured via app.json with adapter types and instances. Suitable for Node.js projects using the MOST framework with local SQLite databases. No alternative adapter comparisons available due to limited ecosystem.","status":"active","version":"0.1.16","language":"javascript","source_language":"en","source_url":"https://github.com/kbarbounakis/most-data-sqlite","tags":["javascript","web","mvc","most","most-web","framework","model","view","controller"],"install":[{"cmd":"npm install most-data-sqlite","lang":"bash","label":"npm"},{"cmd":"yarn add most-data-sqlite","lang":"bash","label":"yarn"},{"cmd":"pnpm add most-data-sqlite","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Peer framework dependency for MOST Web Framework","package":"most-web","optional":true}],"imports":[{"note":"Adapter is not imported directly; registered as a plugin via framework configuration","wrong":"Using require('most-data-sqlite') directly","symbol":"SQLite Data Adapter","correct":"Define in app.json: { \"name\":\"SQLite Data Adapter\", \"invariantName\": \"sqlite\", \"type\":\"most-data-sqlite\" }"},{"note":"sqlite3 is a transitive dependency managed by the adapter","wrong":"Attempting to import sqlite3 module separately","symbol":"sqlite3","correct":"No direct import needed; sqlite3 is used internally"},{"note":"Required for regex support; must be compiled per platform","wrong":"Ignoring compilation or using pre-built binary","symbol":"regexp.c","correct":"Compile with gcc as shown in README"}],"quickstart":{"code":"// app.json configuration\n{\n  \"adapterTypes\": [\n    { \"name\":\"SQLite Data Adapter\", \"invariantName\": \"sqlite\", \"type\":\"most-data-sqlite\" }\n  ],\n  \"adapters\": [\n    { \n      \"name\":\"local-db\", \"invariantName\":\"sqlite\", \"default\":true,\n      \"options\": {\n        \"database\":\"db/local.db\"\n      }\n    }\n  ]\n}","lang":"javascript","description":"Configures the SQLite adapter in MOST Web Framework app.json, setting it as the default database adapter with a local SQLite file."},"warnings":[{"fix":"Compile regexp.c with gcc as per platform-specific instructions in README","message":"Requires manual compilation of regex extension (regexp.c) for SQLite","severity":"breaking","affected_versions":">=0.1.0"},{"fix":"Follow the app.json adapter registration pattern; do not use require('most-data-sqlite')","message":"Adapter is configured via JSON config, not imported directly as a module","severity":"gotcha","affected_versions":">=0.1.0"},{"fix":"Pin version and test updates; no official deprecation policy","message":"No versioning or breaking change policy documented; assume internal changes","severity":"deprecated","affected_versions":">=0.1.0"}],"env_vars":null,"search_vec":"'0.1.16':20 'adapt':5,7,39,45,63 'altern':62 'app.json':43 'applic':18 'avail':65 'c':35 'cadenc':27 'comparison':64 'compil':30 'configur':41 'connect':15 'control':80 'current':22 'databas':14,60 'due':66 'ecosystem':69 'extens':34 'framework':3,12,56,77 'instanc':48 'javascript':70 'limit':68 'local':58 'manual':29 'model':78 'most-web':74 'mvc':17,72 'node.js':51 'project':52 'provid':13 'regex':33 'releas':26 'requir':28 'sourc':36 'sqlite':4,6,38,59 'stabl':25 'suitabl':49 'type':46 'use':53 'version':19 'via':42 'view':79 'web':2,11,71,76","created_at":"2026-06-07T12:55:13.666367+00:00","updated_at":"2026-06-07T12:55:13.666367+00:00","problems":[{"fix":"Run npm install most-data-sqlite","cause":"Package not installed or missing","error":"Error: Cannot find module 'most-data-sqlite'"},{"fix":"Add adapter type entry to adapterTypes array in app.json","cause":"Adapter not registered in app.json adapterTypes","error":"SQLite adapter not found"},{"fix":"Compile regexp.c with gcc -shared -fPIC -o regexp.0.dylib regexp.c (adjust for platform)","cause":"regexp.c not compiled or loaded","error":"regexp extension not loaded"}],"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/kbarbounakis/most-data-sqlite","github":"https://github.com/kbarbounakis/most-data-sqlite","docs":null,"changelog":null,"pypi":null,"npm":"most-data-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}}