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 SQL Projects
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
-
-
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.
-
-
-
-
evidence
Business intelligence as code: build fast, interactive data visualizations in pure SQL and markdown
-
-
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.
-
generator-starhackit
StarHackIt: React/Native/Node fullstack starter kit with authentication and authorisation, data backed by SQL, the infrastructure deployed with GruCloud
-
xhgui-branch
uprofiler UI,xhprof UI,tideways UI , PHP Non-intrusive performance monitoring platform.
-
Stackoverflow-Clone-Frontend
Clone project of a famous Q/A website for developers built using MySQL, Express, React, Node, Sequelize :globe_with_meridians:
-
-
-
analytics-toolbox-core
A set of UDFs and Procedures to extend BigQuery, Snowflake, Redshift, Postgres and Databricks with Spatial Analytics capabilities
-
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.
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
Regarding visualization tools, sqliteviz has proven to be the best I've found so far. Their web app runs locally but has some trackers, so I run it locally via a simple, static HTTP server. Falcon and Redash seem like overkill for my needs.
Project mention: SQLPage – Building a full web application with nothing but SQL queries [video] | news.ycombinator.com | 2024-03-11It’s interesting to me how far you have pushed the SQL language in this framework, such that it truly is “SQL only”.
The challenge as I see it with enabling analysts to build websites is that you need to build abstractions to get from familiar (SQL, yaml) - the language of analytics, to new (HTML, CSS, JS) - the language of the web browser
As one of the maintainers of Evidence (https://evidence.dev), one of the things I’ve often considered is how accessible our syntax is to analysts. Our syntax combines SQL and Markdown, with MDX style components e.g.
The are inherently webdev-ey, and I do think they put off potential users.
On the flip-side, by adhering to web standards, you get extensibility out of the box, and working out what to do is just a Google search away.
Anyway, thanks for the thought provoking piece.
Project mention: Understanding TTFB Latency in DJango - Seems absurdly slow after DB optimizations even locally | /r/django | 2023-12-08GraphQL could be efficiently translated into SQL and things certainly try, but the only thing close to a "bulletproof" implementation I found was Join Monster (https://github.com/join-monster/join-monster) in NodeJS-land and even that I think is now mostly abandoned. GraphQL as a system was built assuming random-access to data stores is ~free because that's what Facebook has, but the rest of us don't :)
xhgui：https://github.com/laynefyc/xhgui-branch
This is incredible work.
However, the project doesn't follow best practices in the JavaScript ecosystem. The included WebAssembly (wasm) file should be fetched from npm, instead of being uploaded to the project.
https://github.com/nalgeon/sqlime/blob/0bb684c/js/sqlite/sql...
Project mention: How to extend treesitter SQL highlighting with custom keywords? | /r/neovim | 2023-06-28Which grammar are you using? https://github.com/DerekStride/tree-sitter-sql supports backticks. This is the one that is used by nvim-treesitter.
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).
JavaScript SQL related posts
- RDS Database Migration Series - A horror story of using AWS DMS with a happy ending
- SQLPage – Building a full web application with nothing but SQL queries [video]
- Show HN: Appendable – Index JSONL data and query via CDN
- Observable 2.0, a static site generator for data apps
- Evidence, a static site generator for data apps
- PRQL as a DuckDB Extension
- Shouldn't FROM come before SELECT in SQL?
-
A note from our sponsor - SurveyJS
surveyjs.io | 23 Apr 2024
Index
What are some of the best open-source SQL projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Knex | 18,720 |
| 2 | sql.js | 12,191 |
| 3 | drawdb | 6,154 |
| 4 | falcon | 5,132 |
| 5 | franchise | 3,988 |
| 6 | evidence | 3,276 |
| 7 | join-monster | 2,652 |
| 8 | sqliteviz | 1,856 |
| 9 | react-awesome-query-builder | 1,773 |
| 10 | jQuery-QueryBuilder | 1,661 |
| 11 | ElectroCRUD | 1,522 |
| 12 | generator-starhackit | 1,279 |
| 13 | xhgui-branch | 893 |
| 14 | sqlime | 829 |
| 15 | Stackoverflow-Clone-Frontend | 534 |
| 16 | gnorm | 482 |
| 17 | dataframe-js | 457 |
| 18 | Codecademy-Exercise-Answers | 293 |
| 19 | cuelake | 284 |
| 20 | sqliterally | 260 |
| 21 | analytics-toolbox-core | 185 |
| 22 | tree-sitter-sql | 131 |
| 23 | firenze | 131 |
Sponsored
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.
workos.com