sql-workbench
sqlite-plus
sql-workbench | sqlite-plus | |
---|---|---|
5 | 29 | |
14 | 3,420 | |
- | - | |
2.6 | 7.1 | |
4 months ago | 2 days ago | |
C | ||
- | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sql-workbench
-
Using DuckDB-WASM for In-Browser Data Engineering
Author here, thanks for posting! The blog post explains how https://sql-workbench.com can be used for in-browser data engineering and analytics. Let me know if you have questions!
-
Show HN: Privacy-first analytics in natural language in the browser
The new feature of https://sql-workbench.com uses DuckDB WASM, Langchain & Ollama as well as the DuckDB-NSQL Text-to-SQL model running on the user's local machine to enable querying local and remote data via natural language.
Demo video: https://www.youtube.com/watch?v=rTuCec_fhlk
-
Sqlime: Online SQLite Playground
here's a duckdb-wasm version[0] (not open-source, but author said they were working towards that in another thread)
0 - https://sql-workbench.com/
-
Show HN: WhatTheDuck – open-source, in-browser SQL on CSV files
Thanks you, https://sql-workbench.com author here :-) Let me know if you have some feature requests / bug reports etc. at https://github.com/tobilg/sql-workbench/issues Thanks!
sqlite-plus
-
I'm writing a new vector search SQLite Extension
I definitely plan to! I have a much larger list of SQLite extensions I've built here: https://github.com/asg017/sqlite-ecosystem
Here's a few other references you may enjoy if you wanna learn more about SQLite extensions:
- The single source file for sqlite-vec: https://github.com/asg017/sqlite-vec/blob/main/sqlite-vec.c
- sqlean, a project from Anton Zhiyanov which is good base of great SQLite extensions: https://github.com/nalgeon/sqlean
- The official SQLite docs: https://www.sqlite.org/loadext.html
- The "hello world" SQLite extension example: https://www.sqlite.org/src/file/ext/misc/rot13.c
-
Sqlime: Online SQLite Playground
People should check out Nalgeon's work on SQLite extensions: https://github.com/nalgeon/sqlean.
-
Sqlite3 and electron in production
Extra - Not sure what you are doing with the database but I came across this repo of extensions that seem pretty solid - https://github.com/nalgeon/sqlean
-
Sqlpkg – SQLite Package Registry
The simplicity of tree-navigation in "closure" is pretty amazing for how simple it is: https://github.com/nalgeon/sqlean/issues/27
Given that SQLite supports huge sizes for text, you could almost use the above as a way to create an outliner, with everything stored in the database itself ...
- The ultimate set of SQLite extensions
- sqlean: A set of SQLite extensions
-
The Set of SQLite Extensions
https://github.com/nalgeon/sqlean/blob/main/docs/define.md
I've been considering using that. Anyone have any experience with it?
-
Making SQLite extensions pip install-able
Author here, happy to answer questions!
Simon already gave a great intro to my SQLite extensions, and I just want to point folks to Anton Zhiyanov's sqlean project, for pure-C extensions: https://github.com/nalgeon/sqlean
Also, some of these extensions are also packaged as Datasette plugins, so you can also run `datasette install datasette-sqlite-regex` or `datasette install datasette-sqlite-ulid` to add these extension to your Datasette instances! https://docs.datasette.io/en/stable/plugins.html
What are some alternatives?
datasette-lite - Datasette running in your browser using WebAssembly and Pyodide
sqliteviz - Instant offline SQL-powered data visualisation in your browser
mergestat-lite - Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊
go-sqlite3-stdlib - A standard library for mattn/go-sqlite3 including best-effort date parsing, url parsing, math/string functions, and stats aggregation functions
json2csv - Convert json to csv with column titles
sqlite_protobuf - A SQLite extension for extracting values from serialized Protobuf messages
indie-stack - The Remix Stack for deploying to Fly with SQLite, authentication, testing, linting, formatting, etc.
sqlite_ora_functions
dflat - Structured Data Store for Mobile
sqlite-past-present-future - Performance evaluation and optimization of SQLite
sqlite-viewer - View SQLite file online
sqlite-lines - A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.)