{"id":41563,"library":"mythix-orm-sqlite","title":"Mythix ORM SQLite Driver","description":"SQLite database driver for Mythix ORM, version 3.1.0 released with TypeScript support and a moderate release cadence. It provides SQLite-specific features such as in-memory database, BIGINT auto-increment emulation, and foreign key constraint management. Designed to work seamlessly with the Mythix ORM ecosystem, it requires peer dependencies mythix-orm and mythix-orm-sql-base. Differs from other SQLite drivers by integrating with Mythix ORM's model binding and query generation.","status":"active","version":"3.1.0","language":"javascript","source_language":"en","source_url":"https://github.com/th317erd/mythix-orm-sqlite","tags":["javascript","orm","mysql","postgres","postgresql","mssql","mongo","snowflake","database","typescript"],"install":[{"cmd":"npm install mythix-orm-sqlite","lang":"bash","label":"npm"},{"cmd":"yarn add mythix-orm-sqlite","lang":"bash","label":"yarn"},{"cmd":"pnpm add mythix-orm-sqlite","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Peer dependency required for ORM functionality","package":"mythix-orm","optional":false},{"reason":"Peer dependency providing SQL base classes","package":"mythix-orm-sql-base","optional":false}],"imports":[{"note":"ESM import is recommended; CommonJS require returns the constructor but named exports are standard. Works in both ESM and CJS environments.","wrong":"const SQLiteConnection = require('mythix-orm-sqlite');","symbol":"SQLiteConnection","correct":"import { SQLiteConnection } from 'mythix-orm-sqlite'"},{"note":"Named export, not default.","wrong":"import SQLiteQueryGenerator from 'mythix-orm-sqlite'","symbol":"SQLiteQueryGenerator","correct":"import { SQLiteQueryGenerator } from 'mythix-orm-sqlite'"},{"note":"Default export is also the SQLiteConnection constructor for compatibility with older CommonJS patterns, but named imports are preferred.","wrong":"const { SQLiteConnection } = require('mythix-orm-sqlite')","symbol":"default","correct":"import SQLiteConnection from 'mythix-orm-sqlite'"}],"quickstart":{"code":"import { SQLiteConnection } from 'mythix-orm-sqlite';\n\nasync function main() {\n  const connection = new SQLiteConnection({\n    bindModels: true,\n    models: [], // Add your models\n    filename: ':memory:',\n    foreignConstraints: true,\n    logger: console\n  });\n\n  await connection.start();\n  console.log('SQLite connection established');\n  await connection.stop();\n}\n\nmain().catch(console.error);","lang":"typescript","description":"Demonstrates creating an in-memory SQLite connection with Mythix ORM, binding models, and enabling foreign key constraints."},"warnings":[{"fix":"Avoid using BIGINT auto-increment in production; use emulation only for testing.","message":"SQLite does not natively support BIGINT auto-increment; enabling `emulateBigIntAutoIncrement` may lead to edge-case failures.","severity":"gotcha","affected_versions":">=3.0.0"},{"fix":"Leave `foreignConstraints: true` unless you have a specific reason to disable them.","message":"Foreign key constraints are disabled by default in SQLite. Setting `foreignConstraints: true` (the default) enables them via PRAGMA, but this may affect performance.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Use `bindModels: true` instead of `boundModels`.","message":"Option `boundModels` is misspelled as `boundModels` in option table; the correct option is `bindModels` (with an 'i')","severity":"deprecated","affected_versions":">=3.0.0"},{"fix":"Provide a file path for persistent storage if needed.","message":"If `filename` is not specified, defaults to `:memory:` which creates a volatile in-memory database.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'3.1.0':12 'auto':36 'auto-incr':35 'base':65 'bigint':34 'bind':78 'cadenc':21 'constraint':42 'databas':6,33,90 'depend':56 'design':44 'differ':66 'driver':4,7,70 'ecosystem':52 'emul':38 'featur':27 'foreign':40 'generat':81 'in-memori':30 'increment':37 'integr':72 'javascript':82 'key':41 'manag':43 'memori':32 'model':77 'moder':19 'mongo':88 'mssql':87 'mysql':84 'mythix':1,9,50,58,62,74 'mythix-orm':57 'mythix-orm-sql-bas':61 'orm':2,10,51,59,63,75,83 'peer':55 'postgr':85 'postgresql':86 'provid':23 'queri':80 'releas':13,20 'requir':54 'seamless':47 'snowflak':89 'specif':26 'sql':64 'sqlite':3,5,25,69 'sqlite-specif':24 'support':16 'typescript':15,91 'version':11 'work':46","created_at":"2026-06-04T18:53:01.151871+00:00","updated_at":"2026-06-04T18:53:01.151871+00:00","problems":[{"fix":"npm install mythix-orm mythix-orm-sql-base mythix-orm-sqlite","cause":"Missing peer dependency or incorrect installation","error":"Error: Cannot find module 'mythix-orm-sqlite'"},{"fix":"Use `const SQLiteConnection = require('mythix-orm-sqlite').SQLiteConnection` or switch to ESM import","cause":"Using default import with CommonJS require","error":"TypeError: Cannot read properties of undefined (reading 'SQLiteConnection')"},{"fix":"Ensure `bindModels: true` and models are provided in the `models` array with proper schema definitions","cause":"Models not bound or table not created","error":"Error: SQLITE_ERROR: no such table: ..."}],"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/th317erd/mythix-orm-sqlite#readme","github":"https://github.com/th317erd/mythix-orm-sqlite","docs":null,"changelog":null,"pypi":null,"npm":"mythix-orm-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-04","next_check":"2026-09-02","install_tag":null}}