{"id":43827,"library":"shared-orm-library","title":"shared-orm-library","description":"A generic Sequelize ORM wrapper for relational databases (MySQL, PostgreSQL, MariaDB, etc.), defaulting to PostgreSQL. Current stable version is 1.0.17. Provides a simple interface to initialize Sequelize with environment-based configuration. Not actively maintained after initial release; lacks common ORM features like migrations, seeders, or built-in model definitions, making it less suitable for production compared to direct Sequelize usage or mature libraries like TypeORM/Prisma.","status":"maintenance","version":"1.0.17","language":"javascript","source_language":"en","source_url":null,"tags":["javascript"],"install":[{"cmd":"npm install shared-orm-library","lang":"bash","label":"npm"},{"cmd":"yarn add shared-orm-library","lang":"bash","label":"yarn"},{"cmd":"pnpm add shared-orm-library","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Core ORM library; shared-orm-library is a thin wrapper around Sequelize","package":"sequelize","optional":false}],"imports":[{"note":"Package exports a default export; using require with .default is not needed if using CommonJS, but if using ESM, use the import above. For CJS, const db = require('shared-orm-library') works.","wrong":"const db = require('shared-orm-library').default","symbol":"default","correct":"import db from 'shared-orm-library'"}],"quickstart":{"code":"import db from 'shared-orm-library';\n\n// db is a configured Sequelize instance (defaults to PostgreSQL)\n// To use MySQL or MariaDB, set environment variables DB_DIALECT=mysql\n// Example: query all users\nconst users = await db.query('SELECT * FROM users', { type: db.QueryTypes.SELECT });\nconsole.log(users);","lang":"typescript","description":"Shows how to import the default export and run a raw query using the Sequelize instance."},"warnings":[{"fix":"Set environment variables before using the library, or fork the package to accept a config object.","message":"Package expects environment variables (DB_DIALECT, DB_HOST, etc.) to be set; no configuration object can be passed directly.","severity":"gotcha","affected_versions":"<=1.0.17"}],"env_vars":null,"search_vec":"'1.0.17':24 'activ':38 'base':35 'built':52 'built-in':51 'common':44 'compar':62 'configur':36 'current':20 'databas':12 'default':17 'definit':55 'direct':64 'environ':34 'environment-bas':33 'etc':16 'featur':46 'generic':6 'initi':30,41 'interfac':28 'javascript':72 'lack':43 'less':58 'librari':4,69 'like':47,70 'maintain':39 'make':56 'mariadb':15 'matur':68 'migrat':48 'model':54 'mysql':13 'orm':3,8,45 'postgresql':14,19 'product':61 'provid':25 'relat':11 'releas':42 'seeder':49 'sequel':7,31,65 'share':2 'shared-orm-librari':1 'simpl':27 'stabl':21 'suitabl':59 'typeorm/prisma':71 'usag':66 'version':22 'wrapper':9","created_at":"2026-06-05T17:01:40.256701+00:00","updated_at":"2026-06-05T17:01:40.256701+00:00","problems":[{"fix":"Ensure DB_DIALECT, DB_NAME, DB_USER, DB_PASSWORD, DB_HOST, DB_PORT are set in environment.","cause":"Attempting to access db.QueryTypes before initialization; db is not initialized if environment variables are missing.","error":"Cannot read properties of undefined (reading 'QueryTypes')"}],"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":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"shared-orm-library","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-05","next_check":"2026-09-03","install_tag":null}}