SaaSHub helps you find the best software and product alternatives 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
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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
https://opensource.com/article/20/4/plot-data-python gives some common options. What kind of plots are you trying to achieve? Interactive? Jupyter notebooks? Reporting? SVG or HTML output? You might also like to look at things like https://evidence.dev
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.
JavaScript SQL related posts
-
Show HN: Open-Source BI as Code
-
When to Use Bun Instead of Node.js
-
SQLite Auto Migrator VS node-sqlite - a user suggested alternative
2 projects | 14 May 2024 -
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
-
A note from our sponsor - SaaSHub
www.saashub.com | 1 Jun 2024
Index
What are some of the best open-source SQL projects in JavaScript? This list will help you:
Project | Stars | |
---|---|---|
1 | Knex | 18,855 |
2 | sql.js | 12,293 |
3 | drawdb | 11,387 |
4 | falcon | 5,132 |
5 | franchise | 3,988 |
6 | evidence | 3,483 |
7 | join-monster | 2,658 |
8 | sqliteviz | 2,044 |
9 | react-awesome-query-builder | 1,848 |
10 | jQuery-QueryBuilder | 1,665 |
11 | ElectroCRUD | 1,531 |
12 | generator-starhackit | 1,278 |
13 | xhgui-branch | 893 |
14 | sqlime | 855 |
15 | Stackoverflow-Clone-Frontend | 537 |
16 | gnorm | 482 |
17 | dataframe-js | 457 |
18 | Codecademy-Exercise-Answers | 293 |
19 | cuelake | 283 |
20 | sqliterally | 260 |
21 | analytics-toolbox-core | 185 |
22 | tree-sitter-sql | 139 |
23 | firenze | 131 |
Sponsored