{"_id":"@0stv0/databases","name":"@0stv0/databases","dist-tags":{"latest":"1.0.0"},"versions":{"1.0.0":{"name":"@0stv0/databases","version":"1.0.0","description":"```bash npm install @0stv0/databases ```","main":"./dist/index.js","types":"./dist/index.d.ts","exports":{".":{"types":"./dist/index.d.ts","import":"./dist/index.js"}},"author":{"name":"stevku"},"license":"MIT","type":"module","dependencies":{"@0stv0/toolkit":"^1.0.1","@toon-format/toon":"^2.1.0","mongodb":"^7.1.0","mysql2":"^3.19.0","pg":"^8.20.0","redis":"^5.11.0"},"devDependencies":{"@types/node":"^25.3.5","@types/pg":"^8.18.0","@types/redis":"^4.0.10"},"repository":{"type":"git","url":"git+https://github.com/0stv0/databases.git"},"homepage":"https://github.com/0stv0/databases#readme","gitHead":"14f3bb28c5bf26236d8c3658d5b1229d471e2b19","_id":"@0stv0/databases@1.0.0","bugs":{"url":"https://github.com/0stv0/databases/issues"},"_nodeVersion":"25.6.1","_npmVersion":"11.9.0","dist":{"integrity":"sha512-4fgVhu1bNfIWs6IRg4K4YahjmdPa1AtrWm2uT7DfWbo+SYMbailmOpx/iaFstCfrVApX0/tHd4LLF5GdIHmHSw==","shasum":"4e1ceea10d7d44edc9f2296bc2a5f928966a736a","tarball":"https://registry.npmjs.org/@0stv0/databases/-/databases-1.0.0.tgz","fileCount":23,"unpackedSize":27662,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIHu+/aKj3tYDvq3i1/W86RgxLwzpHxTu3tBptVjrDf4ZAiBeOMNGk5Gwf9p+6k5mq9zQzHEVmW2YM8TZAzzWFtoOCQ=="}]},"_npmUser":{"name":"0stv0","email":"stevku.mejster@gmail.com"},"directories":{},"maintainers":[{"name":"0stv0","email":"stevku.mejster@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/databases_1.0.0_1772832996326_0.8880318131207483"},"_hasShrinkwrap":false}},"time":{"created":"2026-03-06T21:36:36.164Z","1.0.0":"2026-03-06T21:36:36.469Z","modified":"2026-03-06T21:36:36.792Z"},"maintainers":[{"name":"0stv0","email":"stevku.mejster@gmail.com"}],"description":"```bash npm install @0stv0/databases ```","homepage":"https://github.com/0stv0/databases#readme","repository":{"type":"git","url":"git+https://github.com/0stv0/databases.git"},"author":{"name":"stevku"},"bugs":{"url":"https://github.com/0stv0/databases/issues"},"license":"MIT","readme":"### Installation\n```bash\nnpm install @0stv0/databases\n```\n\n### MySQL\n```ts\nimport { MySQL } from \"@0stv0/databases\";\n\ntype TestUser = {\n    id: number;\n    name: string;\n    lastname: string;\n};\n\nawait MySQL.connect({\n    host: 'localhost',\n    port: 3306, // Optional, default 3306\n    user: 'root',\n    password: '', // Optional, default empty\n    database: 'database',\n    keepAlive: true // Optional, default false\n});\nlet users: TestUser[] | null = await MySQL.query<TestUser[]>(\"SELECT * FROM users WHERE id > ?\", [10]);\n\nawait MySQL.execute(\"INSERT INTO users (id) VALUES (?)\", [123]);\n\nawait MySQL.transaction(async(con) =>\n{\n    await con.execute(\"somesql\", [1, 2, 3]);\n    await con.execute(\"somesql2\", [3, 2, 1]);\n    // You can return something here if needed\n});\n\nawait MySQL.close();\n```\n\n### PostgreSQL\n```ts\nimport { Postgres } from \"@0stv0/databases\";\n\ntype TestUser = {\n    id: number;\n    name: string;\n    lastname: string;\n};\n\nawait Postgres.connect({\n    host: 'localhost',\n    port: 5432, // Optional, default 5432\n    user: 'root',\n    password: '', // Optional, default empty\n    database: 'database',\n    keepAlive: true, // Optional, default false\n    ssl: true // Optional, default false\n});\n\nlet data: TestUser[] | null = await Postgres.query<TestUser[]>(\"SELECT * FROM users WHERE id > $1\", [10]);\n\nawait Postgres.query(\"INSERT INTO users (id) VALUES ($1)\", [123]);\n\nawait Postgres.transaction(async(con) => \n{\n    await con.query(\"somesql\", [1, 2, 3]);\n    await con.query(\"somesql2\", [3, 2, 1]);\n    // You can return something here if needed\n});\n\nawait Postgres.close();\n```\n\n### MongoDB\n```ts\nimport { Collection } from \"mongodb\";\nimport { Mongo } from \"@0stv0/databases\";\n\ntype TestUser = {\n    id: number;\n    name: string;\n    lastname: string;\n};\n\nawait Mongo.connect({\n    uri: 'your-db-uri',\n    db: 'your-db'\n});\n\nlet col: Collection<TestUser> | null = Mongo.getCollection<TestUser>('users');\n\nawait Mongo.transaction(async(session, db) =>\n{\n    db.collection(\"somecoll\").insertOne({somekey: 'someval'}, { session });\n    db.collection(\"somecoll\").deleteOne({somekey2: 'someval2'}, { session });\n    // YOu can return something here if needed\n});\n\nawait Mongo.close();\n```\n\n### Redis\n```ts\nimport { Redis } from \"@0stv0/databases\";\n\nawait Redis.connect({\n    url: 'your-db-url'\n});\n\nawait Redis.set('somekey', 'someval');\nlet val: string | null = await Redis.get('somekey');\nlet exists: boolean    = await Redis.exists('somekey');\nawait Redis.del('somekey');\n\nawait Redis.close();\n```","readmeFilename":"README.md","_rev":"1-fd16ad0233ab03bcf5718e06c18e33bd"}