JavaScript ODM / ORM

Open-source JavaScript projects categorized as ODM / ORM | Edit details

Top 12 JavaScript ODM / ORM Projects

  • GitHub repo SheetJS js-xlsx

    :green_book: SheetJS Community Edition -- Spreadsheet Data Toolkit

    Project mention: Tips for Making a Popular Open-Source Project in 2021 [Ultimate Guide] | news.ycombinator.com | 2021-11-12

    Maybe a story from a maintainer would help. To contextualize, the main SheetJS open source project https://github.com/SheetJS/sheetjs has over 28K stars.

    tl;dr: the project involves "crowdsourced research" which benefits from popularity.

    The main social goal with the project is data preservation and integrity. Large-scale economic and political decisions are made from data and analyses in spreadsheets. For example, last year in the UK, COVID cases were underreported thanks to Excel minutiae https://www.bbc.com/news/technology-54423988

    Due to various corporate stratagems, the older data representations were intentionally obfuscated. To support Excel, many developers poked around at Excel files and guessed at the structures.

    In this environment, the biggest challenge is finding worksheets with random corner cases. These types of files are not easy to create and fuzzing has limited effectiveness. This is where open source and popularity come into play. The open source and JS nature of the project helps reduce testing friction (https://oss.sheetjs.com/ runs in the web browser, no need to install anything) and encourage bug reports with test cases.

    There will always be "entitled users" and "low quality bug reports" but that comes with the territory. There are also meaningful issues and code contributions. Efforts at trying to prevent the low quality contributions also discourage higher quality contributions.

  • GitHub repo Sequelize

    An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js

    Project mention: How do you track the fanfics you read? | reddit.com/r/HPfanfiction | 2021-12-05

    Sequelize to interact with an Sqlite database.

  • Scout APM

    Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.

  • GitHub repo Mongoose

    MongoDB object modeling designed to work in an asynchronous environment.

    Project mention: Why is mongoose typed so loosely? | reddit.com/r/typescript | 2021-11-20

    Never used it personally. But just having a quick look at their github project...

  • GitHub repo Objection.js

    An SQL-friendly ORM for Node.js

    Project mention: I used Typeorm in one of our projects and I have nothing but regrets | reddit.com/r/node | 2021-10-02

    And if you want an ORM, you can add Objection which uses knex:

  • GitHub repo Bookshelf

    A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

    Project mention: How to get randomly sorted recordsets in Strapi | dev.to | 2021-11-12

    First, we need to get all recordsets randomly sorted. To achieve this, we will need to build a query. Strapi is using Bookshelf as an ORM. So we can start by getting our Partnership model, so we can run a query on it. Inside the query, we get a knex (this is the query builder that Bookshelf uses under the hood) query builder instance. On this query builder instance, we can there ask to order recordsets randomly. Let's try this:

  • GitHub repo Waterline

    An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more

    Project mention: Best Node.js ORM? | reddit.com/r/node | 2021-06-30
  • GitHub repo orm2

    Object Relational Mapping

  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • GitHub repo pg-promise

    PostgreSQL interface for Node.js

    Project mention: Help seeding a database with PG | reddit.com/r/learnjavascript | 2021-08-17

    Yes. You can also take at the pg-promise library. https://github.com/vitaly-t/pg-promise

  • GitHub repo node-mssql

    Microsoft SQL Server client for Node.js

    Project mention: Need some guidance - Web browser based apps with MS SQL | reddit.com/r/learnprogramming | 2021-11-10

    What you can do is use Node.js along with the mssql library to build your site. You can either use templates and render pages on the server, or you can build out an API and write your browser client in a framework like React or Angular.

  • GitHub repo Mongorito

    🍹 MongoDB ODM for Node.js apps based on Redux

  • GitHub repo firenze

    Adapter based JavaScript ORM for Node.js and the browser

  • GitHub repo uuid-mongodb

    📇 Generates and parses MongoDB BSON UUIDs

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-12-05.

JavaScript ODM / ORM related posts

Index

What are some of the best open-source ODM / ORM projects in JavaScript? This list will help you:

Project Stars
1 SheetJS js-xlsx 28,334
2 Sequelize 25,332
3 Mongoose 23,531
4 Objection.js 6,440
5 Bookshelf 6,245
6 Waterline 5,323
7 orm2 3,063
8 pg-promise 3,054
9 node-mssql 1,947
10 Mongorito 1,411
11 firenze 131
12 uuid-mongodb 85
Find remote jobs at our new job board 99remotejobs.com. There are 32 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com