Top 12 JavaScript ODM / ORM Projects
-
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.
-
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.
-
Never used it personally. But just having a quick look at their github project...
-
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:
-
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:
-
Waterline
An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more
-
-
-
Yes. You can also take at the pg-promise library. https://github.com/vitaly-t/pg-promise
-
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.
-
-
-
JavaScript ODM / ORM related posts
- Need some guidance - Web browser based apps with MS SQL
- looking for package which can copy values from excel -> html p, h2,h3 etc
- SheetJS - Missing data after modifying xlsm then using sheet_to_txt
- Which nodejs ORM is closest to Django?
- Installing from NPM on Existing Project
- Transitioning from MySQL to MongoDB
- Looking for a mentor who can teach me backend using node js.
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 |
Are you hiring? Post a new remote job listing for free.
