SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 JavaScript SQL Projects
-
I'm working on https://github.com/drawdb-io/drawdb trying to optimize the editor and have it lag less when the number of tables increases. Also have some highly requested features I'd like to implement before launching on Product Hunt.
Then I wanted a change of pace and started on something so ambitious that it's stupid... I'm trying to make a web browser from scratch I guess. So far tokenizing the html is going fine but I'm not sure how far I'll be able to get.
-
InfluxDB
Purpose built for real-time analytics at any scale. InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
Project mention: Low-code drag-and-drop tool for building RESTful APIs with in minutes. | dev.to | 2024-07-04Knex: SQL query builder used in the application to manage sql databases queries in a easier way by letting knex handel all the hassle for us.
-
I once tried to use sql.js [1] on a static site for full text search. It worked, but the resulting database size for that site was too large for the web, even with things like detail=none and content='' applied, and requiring the user to download a database each time was just no go. (I guess things should work better for sites with less content or those not requiring a trigram tokenizer.)
I switched to Pagefind [2] afterwards before finding out a sql.js-httpvfs [3] fork of sql.js that removes exactly the need to fully download a database (with HTTP range requests). I haven't got the chance to test sql.js-httpvfs out though, but it looks pretty sound and could be much more flexible than Pagefind. (Previously discussed at https://news.ycombinator.com/item?id=27016630 .)
[1] https://github.com/sql-js/sql.js/
[2] https://pagefind.app/
[3] https://github.com/phiresky/sql.js-httpvfs
-
evidence
Business intelligence as code: build fast, interactive data visualizations in pure SQL and markdown
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-08
GraphQL 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 :)
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
-
-
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.
-
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...
-
orange-orm
Javascript and Typescript ORM with full intellisense, no-code generations. Works over http as well.
Project mention: Flyweight: A Node.js ORM Specifically for SQLite | news.ycombinator.com | 2024-04-07You should try https://github.com/alfateam/rdb
It is database agnostic. It works with sqlite, mssql, mysql, postgres, oracle, and sapase.
It gives you full intellisense without code generation - even when running pure javascript.
You can run it from the browser in a secure manner, as you can host it in express js via adapter.
I am the author.
-
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
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 discussion
JavaScript SQL related posts
-
Parchment Style - FAV0 Weekly #014
-
Postgres.new: In-browser Postgres with an AI interface
-
Show HN: PGLite – PostgreSQL in the Browser
-
At 50 Years Old, Is SQL Becoming a Niche Skill?
-
What Happens When You Put a Database in the Browser?
-
3 Insanely Powerful Software Tools to Boost Your Productivity and Avoid Overtime
-
Build a type-safe and event-driven Uptime Monitor in TypeScript
-
A note from our sponsor - SaaSHub
www.saashub.com | 16 Sep 2024
Index
What are some of the best open-source SQL projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | drawdb | 19,782 |
| 2 | Knex | 19,166 |
| 3 | sql.js | 12,546 |
| 4 | evidence | 4,125 |
| 5 | franchise | 4,004 |
| 6 | join-monster | 2,670 |
| 7 | sqliteviz | 2,117 |
| 8 | react-awesome-query-builder | 1,958 |
| 9 | jQuery-QueryBuilder | 1,676 |
| 10 | ElectroCRUD | 1,537 |
| 11 | generator-starhackit | 1,278 |
| 12 | xhgui-branch | 894 |
| 13 | sqlime | 892 |
| 14 | orange-orm | 669 |
| 15 | Stackoverflow-Clone-Frontend | 548 |
| 16 | gnorm | 487 |
| 17 | dataframe-js | 460 |
| 18 | Codecademy-Exercise-Answers | 293 |
| 19 | cuelake | 283 |
| 20 | sqliterally | 263 |
| 21 | analytics-toolbox-core | 188 |
| 22 | Sutando | 162 |
| 23 | tree-sitter-sql | 148 |
Sponsored
Purpose built for real-time analytics at any scale.
InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.
www.influxdata.com