{"library":"ormso","title":"ORMSO","description":"ORMSO is a JavaScript object-relational mapper for SQLite (with extensibility to other databases) supporting object-to-database mapping, cross-database synchronization, and client data publishing. Current stable version is 0.0.151, released with pre-1.0 cadence meaning frequent breaking changes. Key differentiators: built-in sync between databases, and a publish layer for clients (with basic OData planned). Early-stage library, documentation sparse; not recommended for production without thorough vetting.","language":"javascript","status":"active","last_verified":"Sat May 09","install":{"commands":["npm install ormso"],"cli":null},"imports":["import ormso from 'ormso'","import { ORM } from 'ormso'","import { Model } from 'ormso'"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import ormso, { ORM, Model } from 'ormso';\nimport Database from 'better-sqlite3';\n\nconst db = new Database(':memory:');\nconst orm = new ORM(db);\n\nclass User extends Model {\n  static tableName = 'users';\n  static fields = {\n    id: { type: Number, primaryKey: true },\n    name: { type: String },\n    email: { type: String }\n  };\n}\n\norm.register(User);\nawait orm.sync({ force: true });\n\nconst user = new User({ name: 'John', email: 'john@example.com' });\nawait user.save();\n\nconst found = await User.findOne({ where: { name: 'John' } });\nconsole.log(found);","lang":"typescript","description":"Shows how to create a SQLite database, define a model with ORMSO, sync schema, create and query records.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}