JSPM

  • ESM via JSPM
  • ES Module Entrypoint
  • Export Map
  • Keywords
  • License
  • Repository URL
  • TypeScript Types
  • README
  • Created
  • Published
  • Downloads 4
  • Score
    100M100P100Q42605F
  • License MIT

Run SQL quries on your Mongodb database.

Package Exports

  • sql-to-nosql
  • sql-to-nosql/dist/index.mjs

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (sql-to-nosql) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

SQL-to-NOSQL

As the name suggests, sql-to-nosql lets you run SQL scripts on your NoSQL database.

Status

The project is under active development and is not yet ready to use in production. I'm aiming to launch v-1.0 by November 2023 with some of the most common sql operations. 🤞

Installation

npm insall sql-to-nosql

# or

yarn add sql-to-nosql

# or

pnpm add sql-to-nosql

Usage

import { SqlToNoSql } from "sql-to-nosql";

const runner = new SqlToNoSql({
  srcDBtype: "postgresql",
  destDBtype: "mongodb",
  connection: "YOUR_DEST_DB_CONNECTION_STRING",
});

const resp = await runner.run(
  "select * from users where email = devarifhossain@gmail.com",
);

console.log(resp);
/** ☝️ [{
    _id: new ObjectId("622f07d56852c662cb8b953b"),
    role: 'admin',
    name: 'Arif Hossain',
    email: 'devarifhossain@gmail.com',
    __v: 0
  }]*/

Roadmap

  • Database
    • MongoDB
  • Commands
    • SELECT
    • INSERT
    • DELETE
    • UPDATE
  • Clauses
    • WHERE
    • ORDER BY
    • LIMIT
    • OFFSET
    • GROUP BY
    • HAVING
    • JOIN
    • UNION
    • INTERSECT
    • EXCEPT
  • Functions
    • COUNT
    • SUM
    • AVG
    • MIN
    • MAX
  • Operators
    • =
    • !=
    • <

    • =

    • <=
    • AND
    • OR
    • NOT
    • IN
    • BETWEEN
    • LIKE
    • IS NULL
    • IS NOT NULL
  • Typescript Support

Contributing

Read the contributing guide to learn how you can contribute to this project.