The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 JavaScript Sqlite Projects
-
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.
-
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.
-
rdb
Javascript and Typescript ORM with full intellisense, no-code generations. Works over http as well.
-
authcompanion2
An admin-friendly, User Management Server (with Passkeys & JWTs) - for seamless and secure integration of user authentication
-
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.
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
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: Tuql: Automatically create a GraphQL server from a SQLite database | /r/patient_hackernews | 2023-04-26
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: Google will disable all but OAuth for IMAP, SMTP and POP starting Sept. 30 | news.ycombinator.com | 2024-01-18Thanks for your feedback. We've updated our home page at https://forwardemail.net and added a dedicated link/section in our FAQ for "What is Forward Email" at https://forwardemail.net/faq#what-is-forward-email.
Commit: https://github.com/forwardemail/forwardemail.net/commit/5942...
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?
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.
Project mention: Flyweight: A Node.js ORM Specifically for SQLite | news.ycombinator.com | 2024-04-07
Project mention: SpatiaLite (SQLite extension) for browser and node | news.ycombinator.com | 2023-09-20
Project mention: Show HN: An Admin-Friendly, User Management Server (With Passkeys and JWTs) | news.ycombinator.com | 2023-09-25
JavaScript Sqlite related posts
- Flyweight: A Node.js ORM Specifically for SQLite
- Ask HN: Wa-SQLite vs. Dexie, 2024
- Show HN: Quietone – search audio and video by transcript
- Soul RESTful and realtime server for SQLite, now with Authentication!
- JSON Canvas – An open file format for infinite canvas data
- SQLite Db Admin in the Browser
- Loro Now Open Source: Reimagine State Management with CRDTs
-
A note from our sponsor - WorkOS
workos.com | 19 Apr 2024
Index
What are some of the best open-source Sqlite projects in JavaScript? This list will help you:
Project | Stars | |
---|---|---|
1 | sql.js | 12,191 |
2 | Bookshelf | 6,338 |
3 | webhook.site | 4,861 |
4 | drawdb | 4,517 |
5 | orm2 | 3,074 |
6 | sqliteviz | 1,853 |
7 | ElectroCRUD | 1,522 |
8 | soul | 1,408 |
9 | tuql | 1,035 |
10 | todos-express-password | 846 |
11 | sqlime | 829 |
12 | forwardemail.net | 751 |
13 | wa-sqlite | 643 |
14 | rdb | 552 |
15 | flyweight | 489 |
16 | node-gtfs | 424 |
17 | lolisafe | 309 |
18 | spl.js | 158 |
19 | db-samples | 119 |
20 | authcompanion2 | 76 |
21 | database-js | 74 |
22 | puresql | 50 |
23 | acsys | 49 |