JavaScript Database

Open-source JavaScript projects categorized as Database | Edit details

Top 23 JavaScript Database 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 awesome-cheatsheets

    👩‍💻👨‍💻 Awesome cheatsheets for popular programming languages, frameworks and development tools. They include everything you should know in one single file.

    Project mention: Cheatsheets | news.ycombinator.com | 2021-11-18

    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...

  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • GitHub repo Sequelize

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

    Project mention: What is the consensus about using ORM in node js applications? | reddit.com/r/node | 2021-11-28
  • 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 MySQL

    A pure node.js JavaScript Client implementing the MySQL protocol.

    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.

  • GitHub repo Lowdb

    Simple to use local JSON database (supports Node, Electron and the browser)

    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.

  • GitHub repo Knex

    A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

    Project mention: What database should i use with node. | reddit.com/r/node | 2021-11-26

    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.

  • GitHub repo gun

    An open source cybersecurity protocol for syncing decentralized graph data.

    Project mention: gun: NEW Data - star count:14909.0 | reddit.com/r/algoprojects | 2021-11-28
  • GitHub repo PouchDB

    :koala: - PouchDB is a pocket-sized database.

    Project mention: PouchDB.find is not a function | dev.to | 2021-05-30

    Thankfully the community helped me figure this out. You can read about detail on the issue here at github .

  • GitHub repo 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-06

    Database, 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.

  • GitHub repo PostgreSQL

    PostgreSQL client for node.js.

    Project mention: What is this JavaScript "require"? | reddit.com/r/codehunter | 2021-11-26

    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.

  • GitHub repo 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: App Store Analytics Tool | reddit.com/r/reactnative | 2021-11-14

    The other tool I use is firebase analytics, you can get it with the RN firebase package (https://rnfirebase.io)

  • GitHub repo sql.js

    A javascript library to run SQLite on the web.

    Project mention: DuckDB-WASM: Efficient Analytical SQL in the Browser | news.ycombinator.com | 2021-10-29
  • GitHub repo MongoDB

    The Official MongoDB Node.js Driver

    Project mention: Connect to MongoDB Atlas from SvelteKit | dev.to | 2021-11-01

    To communicate with MongoDB database we will need Node driver mongodb. So install it.

  • GitHub repo WatermelonDB

    🍉 Reactive & asynchronous database for powerful React and React Native apps ⚡️

    Project mention: About Offline First | news.ycombinator.com | 2021-09-29
  • GitHub repo Dexie.js

    A Minimalistic Wrapper for IndexedDB

    Project mention: Building More Than Just a YouTube Video Downloader | dev.to | 2021-11-07

    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.

  • 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 orbit-db

    Peer-to-Peer Databases for the Decentralized Web

    Project mention: Any suggestions to build a decentralized web app? | reddit.com/r/ipfs | 2021-11-22

    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?

  • 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 LevelUP

    A wrapper for abstract-leveldown compliant stores, for Node.js and browsers.

  • GitHub repo orm2

    Object Relational Mapping

  • 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

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-11-28.

JavaScript Database related posts

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
Find remote jobs at our new job board 99remotejobs.com. There are 34 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