Top 23 JavaScript SQL Projects
-
Sequelize
An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js | Postgres, MySQL, MariaDB, SQLite, MSSQL, Snowflake & DB2
Introduced around 2014, Sequelize is an easy-to-use and Promise-based ORM for Node.js.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
For using SQL with JavaScript check out knex.js
-
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!
-
Project mention: Show HN: CSVFiddle – Query CSV files with DuckDB in the browser | news.ycombinator.com | 2022-07-01
Does it work with really large files? Like, >100mb or so. I was considering making something similar but with sqlite.js [1], but the problem with it is that it loads everything in memory, so I wasn't entirely sure how it will deal with larger workloads.
-
Or maybe Falcon as a desktop tool.
-
Project mention: Show HN: DataStation – App to easily query, script, and visualize data | news.ycombinator.com | 2022-05-31
I love the idea of a data notebook. Have you seen Franchise? It's a lovely design for something similar, though its implementation (which stopped in 2019) didn't go beyond querying and visualization, rather than manipulation. But the stying and component design are lovely, and it may be possible to pull that from their code. https://github.com/HVF/franchise
-
-
Project mention: Creating a condition/rule builder for users to save rules - unsure how to model this in Django | reddit.com/r/django | 2022-05-05
https://querybuilder.js.org look this up to get an idea ;)
-
SonarLint
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
-
sqliteviz - Instant offline SQL-powered data visualisation in your browser
-
generator-starhackit
StarHackIt: React/Native/Node fullstack starter kit with authentication and authorisation, data backed by SQL, the infrastructure deployed with GruCloud
-
Project mention: Recommendations for exposing / publishing business rules | reddit.com/r/SoftwareEngineering | 2022-02-04
I'm using JsonLogic quite a bit. If your just after true/false I've found this is great: https://github.com/ukrbublik/react-awesome-query-builder
-
Project mention: Is it just me who doesn't agree with db first ORM model? | reddit.com/r/golang | 2022-04-09
I've used gnorm for that in the past for some code generation, and I had absolute control. Gnorm took care of the database inspection side of things, and I created the templates it used to generate the code. I had full control over generated models and code.
-
Stackoverflow-Clone-Frontend
Clone project of a famous Q/A website for developers built using MySQL, Express, React, Node, Sequelize :globe_with_meridians:
Project mention: Stack Overflow CLONE (MySQL + Sequelize + Node + React) | reddit.com/r/todayilearned | 2022-03-13 -
-
-
-
-
-
You might look at SQLToy which is a DB and blog I wrote to teach how SQL processing works internally: https://github.com/weinberg/SQLToy
-
lexiQL
lexiQL is a GraphQL prototyping tool and SQL database visualizer built for developers looking to optimize their queries and transition away from RESTful APIs
-
Stackoverflow-Clone-Backend
Backend code of the Stackoverflow Clone project. Built using Express, Node, MySQL, and Sequelize
Project mention: Stackoverflow CLONE (MySQL + Express + React + Node) | reddit.com/r/reactjs | 2021-09-14Frontend: https://github.com/Mayank0255/Stackoverflow-Clone-Frontend Backend: https://github.com/Mayank0255/Stackoverflow-Clone-Backend
-
worker-template-postgres
Reference demo and modified PostgreSQL driver to connect Cloudflare Workers to a relational database.
Couldn't find any good Postgres client for Cloudflare Workers, so I decided to bundle the Postgres template into a single module. I hope it is useful for some of you!
-
-
JavaScript SQL related posts
- Show HN: CSVFiddle – Query CSV files with DuckDB in the browser
- Tech stack for this?
- Decode input data in bigquery
- Extending SQLite with Rust
- Do Open Source programs have supervisors?
- Ask HN: Is there a way to emulate a SQL database in the browser?
- docker-compose.yaml to start YugabyteDB with POSTGRES_USER POSTGRES_PASSWORD POSTGRES_DB env
Index
What are some of the best open-source SQL projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Sequelize | 26,362 |
| 2 | Knex | 16,014 |
| 3 | sql.js | 10,244 |
| 4 | falcon | 4,930 |
| 5 | franchise | 3,880 |
| 6 | join-monster | 2,485 |
| 7 | jQuery-QueryBuilder | 1,546 |
| 8 | sqliteviz | 1,534 |
| 9 | generator-starhackit | 1,270 |
| 10 | react-awesome-query-builder | 1,195 |
| 11 | gnorm | 456 |
| 12 | Stackoverflow-Clone-Frontend | 405 |
| 13 | mlcraft | 338 |
| 14 | Codecademy-Exercise-Answers | 290 |
| 15 | cuelake | 267 |
| 16 | sqliterally | 251 |
| 17 | dekart | 114 |
| 18 | SQLToy | 106 |
| 19 | lexiQL | 77 |
| 20 | Stackoverflow-Clone-Backend | 58 |
| 21 | worker-template-postgres | 57 |
| 22 | database-js | 51 |
| 23 | tree-sitter-sql | 49 |
Are you hiring? Post a new remote job listing for free.
