Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more! Learn more →
Top 23 JavaScript Database Projects
-
awesome-cheatsheets
👩💻👨💻 Awesome cheatsheets for popular programming languages, frameworks and development tools. They include everything you should know in one single file.
-
SheetJS js-xlsx
📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
xlsx.
-
Appwrite
Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!
-
Sequelize
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
Project mention: Using a MySQL database to serve multiple guilds | reddit.com/r/Discord_Bots | 2023-01-21If you like the OOP paradigm and you don't know a lot of the SQL syntax i also suggest looking for an ORM, which abstracts query language the language you're using like https://sequelize.org/
-
A custom NodeJS OpenFaaS template that uses MongoDB and Mongoose to manage the data models
-
Lowdb
Simple to use local JSON database. Use native JavaScript API to query. Written in TypeScript. (supports Node, Electron and the browser)
Project mention: go-store: Lightweight embedded database in pure Go inspired by Lowdb | reddit.com/r/golang | 2022-12-14I just finished the first stable version of go-store, a lightweight embeeded database written in pure Go. It was heavily inspired by lowdb. The motivation was that I needed something simple to store information for another project and that I wanted to try out Go's generics.
-
Project mention: I made the most customizable 2048 game you have ever played. | reddit.com/r/2048 | 2022-11-24
Hmm... I'm not sure why you get a "Loading..." I don't even remember adding a "Loading..." so I'm not sure what that's from. Yes, I do have a account system in place using a database. I am using Node.js and have a mysql backed account system. It requires a bit of setup to get MySQL running on your machine (depending on your operating system), but it's super easy to use on your local system if you have the environment setup. It's a bit more challenging once you take it online; I have a digital ocean droplet that's running this service and a couple more personal projects as well, which does come with a cost to have online. But at least using locally you can build something for free and then when you want you can take it online.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
How does HN receive SQL builders in general? I feel like most of us agree ORMs are typically a bad idea. I feel like that almost instantly leaves the need for "something" to take its place. In my experience, it's typically been a query builder like this.
I've also tried:
https://www.npmjs.com/package/sql-template-strings ("out of date" since like 2016? https://www.npmjs.com/package/sql-template-tag might be better)
Are query builders an anti pattern? People who are doing serious/logic heavy stuff with SQL, how do you avoid a query builder (if at all?)
-
Sonar
Write Clean JavaScript Code. Always.. Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
-
Project mention: Meet OctoBase - AFFiNE's local-first, collaborative open-source database! | reddit.com/r/rust | 2023-01-31
-
Project mention: Recommend an embedded database for use in Electron app | reddit.com/r/electronjs | 2022-12-28
I have used pouchdb as an embedded db for electron - API and performance were not the best, but that was the price to pay for the requirements.
-
Project mention: How to build interactive way to learn SQL using Next.js and database? | reddit.com/r/reactjs | 2023-01-04
Maybe you can try to use some SQL database compiled as Web Assembly Modules? Like this one for example: https://github.com/sql-js/sql.js
-
node-postgres (raw sql, without ORM)
-
react-native-firebase
🔥 A well-tested feature-rich modular Firebase implementation for React Native. Supports both iOS & Android platforms for all Firebase services.
Project mention: Im in a HUGE pinch for a group project thats due in a week, please help (advice desperately needed). | reddit.com/r/reactnative | 2023-01-15If you have to fetch and persist out of the app, then use firebase firestore with https://rnfirebase.io/.
-
Watermelon DB.
-
Dexie works swell with SvelteKit. https://dexie.org
-
dejavu
The Missing Web UI for Elasticsearch: Import, browse and edit data with rich filters and query views, create search UIs visually.
However, if you prefer a graphical interface, you can take a look at Dejavu. You can easily install it via the Dejavu Chrome Extension.
-
Project mention: orbit-db VS db3 - a user suggested alternative | libhunt.com/r/orbit-db | 2023-01-15
-
If you aren't using TypeScript I'd very much recommend Objection.js, I've used it multiple times and no complaints so far. You can pass raw SQL queries to it as well so I'm sure it would be a good fit for your project!
-
Project mention: Is there a 'batteries included' backend framework like Django, but written in JS? | reddit.com/r/learnjavascript | 2022-03-06
If you're set on JS (using only one language on a team/project can be very nice) common choices for backend often involve using Express or hapi with some ORM (like Prisma or Bookshelf).
-
Waterline
An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more
-
Project mention: e2e testing setup and thoughts on Playwright | reddit.com/r/ExperiencedDevs | 2022-12-16
during development we use mirage JS to spin up an in-browser mock server which returns mock data for any API endpoints not currently implemented by the real backend. during integration testing we configure this server to return mock data for all API endpoints in the system, giving us a fixed environment against which our tests can run. test suites can be run in parallel since each time a playwright page is opened a new copy of the webapp, and thus a new copy of the mock server, is launched. these integration tests run whenever a frontend PR is opened or updated.
-
postgres
Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno (by porsager)
Project mention: Well, shit. Objection.js has been sunset, which ORM/querybuilder did you move to? | reddit.com/r/node | 2022-12-03About a year ago I moved to raw SQL using Postgres.js. Honestly I thought it would be traumatic but it's been great so far.
-
-
Project mention: What is the best web-based PostgreSQL for Workshop | reddit.com/r/PostgreSQL | 2022-10-05
Would https://franchise.cloud be any use?
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
JavaScript Database related posts
- Is it recommended that a backend for React be written in Javascript? Or is another language like Python Ok
- Adding real-time full-text search to a Next.js app with Tigris
- Data Store with Nucleoid (Low-code Backend)
- D&D 5th Edition SRD as JSON objects
- Ask HN: Why are so many PHP projects moving to Node?
- Which ORM do you prefer with nodejs/Typescript project and why ?
- Promises, Thenables, & Lazy-evaluation: What, Why, How
-
A note from our sponsor - Appwrite
appwrite.io | 5 Feb 2023
Index
What are some of the best open-source Database projects in JavaScript? This list will help you:
Project | Stars | |
---|---|---|
1 | awesome-cheatsheets | 32,210 |
2 | SheetJS js-xlsx | 32,141 |
3 | Sequelize | 27,388 |
4 | Mongoose | 25,266 |
5 | Lowdb | 18,997 |
6 | MySQL | 17,649 |
7 | Knex | 17,061 |
8 | gun | 16,858 |
9 | PouchDB | 15,487 |
10 | sql.js | 11,094 |
11 | PostgreSQL | 10,939 |
12 | react-native-firebase | 10,595 |
13 | WatermelonDB | 8,902 |
14 | Dexie.js | 8,836 |
15 | dejavu | 8,023 |
16 | orbit-db | 7,437 |
17 | Objection.js | 6,918 |
18 | Bookshelf | 6,306 |
19 | Waterline | 5,387 |
20 | miragejs | 4,928 |
21 | postgres | 4,367 |
22 | LevelUP | 4,035 |
23 | franchise | 3,941 |