SQLite JavaScript: Extend your database with JavaScript

1. sqlite-js

   1 3 559 8.4 C

   Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript.

   

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. plv8

   2 16 2,052 7.0 C++

   V8 Engine Javascript Procedural Language add-on for PostgreSQL

   

4. quickjs

   3 84 10,671 9.3 C

   Public repository of the QuickJS Javascript Engine.

   

   This is a fantastic approach.

   BTW, it looks like the js engine is "QuickJS" [0]. (I'm not familiar with it myself.)

   I like it because sqlite by itself lacks a host language. (e.g., Oracle's plsql, Postgreses pgplsql, Sqlserver's t-sql, etc). That is: code that runs on compute that is local to your storage.

   That's a nice flexible design -- you can choose whatever language you want. But quite typically you have to bring one, and there are various complications to that.

   It's quite powerful, BTW, to have the app-level code that acts on the app data live with the data. You can present cohesive app-level abstraction to the client (some examples people will hopefully recognize: applyResetCode(theCode) or authenticateSessionToken(), or whatever), which can be refined/changed without affecting clients. (Of course you still have to full power and flexibility of SQL and relational data for the parts of your app that need it.)

   [0] https://bellard.org/quickjs/

5. CG-SQL-author

   4 5 35 9.0 C

   CG-SQL Author's Cut: CG/SQL is a compiler that converts a SQL Stored Procedure like language into C for SQLite. SQLite has no stored procedures of its own. CG/CQL can also generate other useful artifacts for testing and schema maintenance.

   

   There is also https://github.com/ricomariani/CG-SQL-author that has a powerful stored procedure capabilities that can be transpiled to C/Lua/..., you can try it in your browser here https://mingodad.github.io/CG-SQL-Lua-playground .

6. query

   5 8 105 9.0 Rust

   Query is an all-in-one web development solution eliminating the need for external servers, runtimes, frameworks, caching, storage, and admin tools. (by gc-victor)

   

7. sqlite-vec

   6 27 7,688 9.5 C

   A vector search SQLite extension that runs anywhere!

   

   How does it compare to https://github.com/asg017/sqlite-vec ? Already using this in a big project.

8. sql.js

   7 51 13,619 4.0 JavaScript

   A javascript library to run SQLite on the web.

   

   You can already do this ... https://sql.js.org/#/?id=api-documentation:~:text=//%20You%2...

Suggest a related project