Top 23 JavaScript Database 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.
-
awesome-cheatsheets
👩💻👨💻 Awesome cheatsheets for popular programming languages, frameworks and development tools. They include everything you should know in one single file.
Expected to see Pyhthon there, but didn't. Then I looked in the repo, and there it was, just not linked on the front? https://github.com/LeCoupa/awesome-cheatsheets/blob/master/l...
-
-
Project mention: What is the consensus about using ORM in node js applications? | reddit.com/r/node | 2021-11-28
-
Never used it personally. But just having a quick look at their github project...
-
Project mention: Workflow for putting a lot of data into a database | reddit.com/r/mysql | 2021-11-14
I've written out a long .sql document (~1,000 lines) with CREATE TABLE statements for all the tables that I'd need (entities and relationships alike). The way the Node mysql package seems to work is that I give it information (hostname, password, etc.) to connect to my database, and then I can write code which will query the database, e.g. For a bulk insert, I'd use a query function which takes in an SQL INSERT statement (as a String), as well as the data (e.g. as an array), and then it would perform that operation on my database with the array that I feed in.
-
Project mention: I want to make a complete "note" taking app but i'm still a beginner and only know up to vanilla js. What should I learn so I can make this project? | reddit.com/r/webdev | 2021-09-28
Maybe you could take this project as a reference? It is a chrome extension built by Vue3 & Vite2. It aksi combines lowdb with chrome.storage to store the notes.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
Knex.js works better than node-postgres at least in the cases where you need to dynamically build a SQL query based on (URL) arguments. For example:
-
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.
-
-
Thankfully the community helped me figure this out. You can read about detail on the issue here at github .
-
ArangoDB
🥑 ArangoDB is a native multi-model database with flexible data models for documents, graphs, and key-values. Build high performance applications using a convenient SQL-like query language or JavaScript extensions.
Project mention: I'm building a smart and automated lead capture/enriching system - and I'd like your ideas | reddit.com/r/Entrepreneur | 2021-10-06Database, I'm on the bridge between Elasticsearch or ArangoDB (https://www.arangodb.com/). I considered PostgreSQL and MongoDB, but this system feels like a limbo between needing a schema - and not. This I'm still not 100% settled on though.
-
I'm trying to get JavaScript to read/write to a PostgreSQL database. I found this project on GitHub. I was able to get the following sample code to run in Node.
-
react-native-firebase
🔥 A well-tested feature-rich modular Firebase implementation for React Native. Supports both iOS & Android platforms for all Firebase services.
The other tool I use is firebase analytics, you can get it with the RN firebase package (https://rnfirebase.io)
-
Project mention: DuckDB-WASM: Efficient Analytical SQL in the Browser | news.ycombinator.com | 2021-10-29
-
To communicate with MongoDB database we will need Node driver mongodb. So install it.
-
-
Using XMLHttpRequests, I can download any file from the internet without needing to prompt the user. Once it's downloaded, I can store it in the user's IndexedDB, which is a local storage solution on a per-website basis, intended for storing large amounts of structured data. That's perfect for storing video and audio files. As per usual, I wanted a wrapper for IndexedDB to keep things extra simple, so I opted to use Dexie.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:
-
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:
-
I want to build a decentralized social media web app for a personal project, and I'm thinking on using IPFS. What tool, API, or library can get me set up without writing smart contracts or using blockchain solutions? I've heard that GunDB or OrbitDB are useful libraries- is that true? What are your thoughts and suggestions?
-
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
JavaScript Database related posts
- What is the consensus about using ORM in node js applications?
- What is this JavaScript "require"?
- What database should i use with node.
- 🔰🦸 Production-ready template for backends created with Node.js, Typescript and Express
- Going serverless with MongoDB Realm - React.js Version
- Any suggestions to build a decentralized web app?
- How to create an Axe API from scratch?
Index
What are some of the best open-source Database projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | SheetJS js-xlsx | 28,178 |
| 2 | awesome-cheatsheets | 25,722 |
| 3 | Sequelize | 25,299 |
| 4 | Mongoose | 23,508 |
| 5 | MySQL | 16,831 |
| 6 | Lowdb | 16,747 |
| 7 | Knex | 14,957 |
| 8 | gun | 14,873 |
| 9 | PouchDB | 14,566 |
| 10 | ArangoDB | 11,824 |
| 11 | PostgreSQL | 10,015 |
| 12 | react-native-firebase | 9,622 |
| 13 | sql.js | 9,524 |
| 14 | MongoDB | 9,237 |
| 15 | WatermelonDB | 7,960 |
| 16 | Dexie.js | 7,240 |
| 17 | Objection.js | 6,416 |
| 18 | Bookshelf | 6,242 |
| 19 | orbit-db | 6,195 |
| 20 | Waterline | 5,322 |
| 21 | LevelUP | 3,956 |
| 22 | orm2 | 3,062 |
| 23 | pg-promise | 3,051 |
Are you hiring? Post a new remote job listing for free.
