With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js. 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
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
react-native-firebase
🔥 A well-tested feature-rich modular Firebase implementation for React Native. Supports both iOS & Android platforms for all Firebase services.
-
dejavu
The Missing Web UI for Elasticsearch: Import, browse and edit data with rich filters and query views, create search UIs visually.
-
postgres
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)
-
Waterline
An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
Awesome Cheat Sheets: This curated list of cheat sheets covers a wide range of topics, including programming languages, frameworks, databases, and more, making it a valuable resource for developers of all levels.
ExcelJS and XLSX (SheetJS) are great libraries to work with XLSX files. The former I've found a bit easier to work with but less efficient in general.
To manage user auth we need to create a user account - identification. So, let's install mongoose and jsonwebtoken to handle JWT authentication - an alternative to creating a user session when a user logs in
https://github.com/typicode/lowdb is a cool option.
Project mention: JavaScript Libraries for Implementing Trendy Technologies in Web Apps in 2024 | dev.to | 2024-04-09Knex.js
Project mention: Show HN: Appendable – Index JSONL data and query via CDN | news.ycombinator.com | 2024-03-05Hi HN! A friend and I were inspired by projects like https://github.com/sql-js/sql.js and the idea of querying files served over CDN with HTTP range requests. We started thinking: what would a database that was specifically designed for this type of use case look like? So we started building one, and we landed on a functional prototype that we're pretty proud of!
With our prototype, Appendable, we're able to serve and query large (GB+) datasets by hosting them on a static file host like Amazon S3 or Cloudflare R2 without running a separate server and worrying about things like tail latency, replication, and connection pooling -- all that is handled for us by the file hoster.
Additionally, one tenet that we have been following is Appendable won't touch your underlying data, so your jsonl file is preserved and we point at that data instead of consuming it into an Appendable-specific file format. This keeps your data yours and makes it easy to introspect the data: just open it up with your favorite editor aka vim.
We're curious what you think, we're excited to build this out further to get the performance even better and add features like pubsub. Everything is open source at https://github.com/kevmo314/appendable.
Kevin and Matthew
Project mention: Neon Is Generally Available: Serverless Postgres | news.ycombinator.com | 2024-04-15pg doesn't do too well with serverless, dead connections are left in the pool (or something)
Project mention: [Demystifying Firebase (Part-1)] How to setup Firebase in React Native CLI App. | dev.to | 2024-04-05We'll be utilizing React Native Firebase for this.
The word on the street is that https://github.com/rhashimoto/wa-sqlite is nearly production ready, closing in on the neat 1.0.0 release, with its IDBBatchAtomic engine highly recommended at https://www.powersync.com/blog/sqlite-persistence-on-the-web. You can try out the benchmark https://rhashimoto.github.io/wa-sqlite/demo/benchmarks.html.
And the other contestant is Dexie, stable https://dexie.org/.
If you were to branch into a new venture today, which one would you pick? And why?
Storing the notes: For storing the notes, we will use the amazing WatermelonDB package which is a popular sqlite wrapper for react-native. Instead of using the default package we will use a fork of this that uses sqlcipher instead of the regular sqlite, allowing us to encrypt the database by passing a secret key.
Project mention: OrbitDB reaches version 1.0 after 8 years of development | news.ycombinator.com | 2023-09-19
Objection.js is a SQL-friendly ORM for Node.js that supports various relational databases, including PostgreSQL, MySQL, and SQLite. It provides a flexible and expressive query builder. Objection.js is known for its expressive syntax, allowing developers to build complex queries easily. It supports eager loading, transactions, and migrations.
Project mention: Neon Is Generally Available: Serverless Postgres | news.ycombinator.com | 2024-04-15I want to use this as a chance to bring attention to a GitHub issue that I think would help reduce friction for Neon:
https://github.com/neondatabase/neon/issues/4989
If the Neon driver were to allow us to easily pass in a localhost connection, the development and test experience would be easier. Perhaps Neon could swap to something like this internally: https://github.com/porsager/postgres.
Having run a local dev environment connected to Neon and tests connected to Neon got in our way of adoption. We'd prefer to develop and run tests against a regular Postgres localhost database.
To the PMs of Neon, put yourself in the shoes of a new developer thinking of giving Neon a try. What changes will I have to make to my code and my development workflow?
Bookshelf.js is an uncomplicated and lightweight ORM designed for Node.js, constructed atop the Knex.js query builder. Its primary aim is to support SQL databases, such as PostgreSQL, MySQL, and SQLite. Bookshelf.js focuses on simplicity and user-friendliness, offering a direct method for defining models and relationships through JavaScript classes and prototypal inheritance.
Project mention: Exploring Mirage JS: Simplifying API Mocking in React Development | dev.to | 2023-08-07Mirage JS GitHub Repository
Personally with more time I would also use JavaScript so I can improve it. Last time I wrote something with Express and a database connection is a long time ago and not for work, only for my personal testing. But for JavaScript database connection to PostgreSQL I recommend pg-promise. That works like a charm.
JavaScript Database related posts
- Neon Is Generally Available: Serverless Postgres
- [Demystifying Firebase (Part-1)] How to setup Firebase in React Native CLI App.
- OAuth 2.0 implementation in Node.js
- SQLPage – Building a full web application with nothing but SQL queries [video]
- Build Your Own Uptime Monitor with MeteorJS + Fetch + Plotly.js ☄️🔭
- Show HN: Appendable – Index JSONL data and query via CDN
- querySrv errors when connecting to MongoDB Atlas
-
A note from our sponsor - SurveyJS
surveyjs.io | 19 Apr 2024
Index
What are some of the best open-source Database projects in JavaScript? This list will help you:
Project | Stars | |
---|---|---|
1 | awesome-cheatsheets | 37,460 |
2 | SheetJS js-xlsx | 34,449 |
3 | Mongoose | 26,598 |
4 | Lowdb | 20,843 |
5 | Knex | 18,720 |
6 | MySQL | 18,156 |
7 | gun | 17,763 |
8 | PouchDB | 16,257 |
9 | sql.js | 12,191 |
10 | PostgreSQL | 11,891 |
11 | react-native-firebase | 11,410 |
12 | Dexie.js | 10,729 |
13 | WatermelonDB | 10,074 |
14 | dejavu | 8,323 |
15 | orbitdb | 8,103 |
16 | Objection.js | 7,198 |
17 | postgres | 6,678 |
18 | Bookshelf | 6,338 |
19 | Waterline | 5,415 |
20 | miragejs | 5,279 |
21 | LevelUP | 4,069 |
22 | franchise | 3,988 |
23 | pg-promise | 3,414 |