Hacker GitHub

← All repos

nalgeon/sqlean

View on GitHub ↗ ★ 4,385 C

The ultimate set of SQLite extensions

27 mentions on Hacker News by 21 people: 7 stories, 20 comments · first 2021-04-03 · latest 2026-01-12

Mentions per year 27 mentions · busiest year 2022 (9)
20082026
AllStoriesComments NewestTopOldest
  1. If that's the case how would the sqlite package (also part of sqlean)'s fileio work out https://github.com/nalgeon/sqlean/blob/main/docs/fileio.md fileio_read - Read file contents as a blob. fileio_scan - Read a file line by line.…
    comment by Imustaskforhelp · 2026-01-12 · in FUSE is All You Need – Giving agents access to anything via filesystems
  2. …the help of a virtual table: https://github.com/0x09/sqlite-statement-vtab Available in sqlean: https://github.com/nalgeon/sqlean/blob/main/docs/define.md#t... And my Go driver: https://pkg.go.dev/github.com/ncruces/go-sqlite3/ext/stateme..…
    comment by ncruces · 2025-01-29 · in Composable SQL
  3. There are also some good libs for SQLite. This is the standard set that I use. https://github.com/nalgeon/sqlean
    comment by steve_gh · 2025-01-27 · in Supercharge SQLite with Ruby Functions
  4. …deal with "missing features" from SQLite (e.g. stored procedures)? Do you use extensions like https://github.com/nalgeon/sqlean in production?
    comment by qazxcvbnm · 2024-07-11 · in First Contact with SQLite
  5. …- 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:…
    comment by alexgarcia-xyz · 2024-05-03 · in I’m writing a new vector search SQLite Extension
  6. People should check out Nalgeon's work on SQLite extensions: https://github.com/nalgeon/sqlean . It's a worthy effort.
    comment by fforflo · 2024-04-09 · in Sqlime: Online SQLite Playground
  7. sqlean or sqlpkg perhaps? https://github.com/nalgeon/sqlean https://sqlpkg.org/
    comment by toomuchtodo · 2024-03-23 · in Pack: A new container format for compressed files
  8. …what kind of support time scale you're wanting? Popular curated extension collections like sqlean ( https://github.com/nalgeon/sqlean ) seem like they'll have a shelf life of many years.
    comment by justinclift · 2024-02-02 · in Show HN: Stanchion – Column-oriented tables in SQLite
  9. The simplicity of tree-navigation in "closure" is pretty amazing: 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…
    comment by shrubble · 2023-07-01 · in Sqlpkg – SQLite Package Registry
  10. …too, which itself can be turned off. :) There's a fair amount of 3rd party extensions too. eg: https://github.com/nalgeon/sqlean GIS stuff, encryption support (several varieties), Excel/ODS support, and tonnes of other things
    comment by justinclift · 2023-04-28 · in Exciting SQLite Improvements Since 2020
  11. https://github.com/nalgeon/sqlean/blob/main/docs/define.md I've been considering using that: define Anyone have any experience with it?
    comment by tarkin2 · 2023-02-28 · in sqlean: A set of SQLite extensions
  12. …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…
    comment by alexgarcia-xyz · 2023-02-06 · in Making SQLite extensions pip install-able
  13. …[1]: https://github.com/multiprocessio/go-sqlite3-stdlib [2]: https://github.com/nalgeon/sqlean
    comment by polyrand · 2022-09-01 · in SQLite: Past, Present, and Future
  14. see https://github.com/nalgeon/sqlean for 'All the missing SQLite functions'
    comment by efdb · 2022-08-21 · in SQLite has pretty limited builtin functions
  15. …- sqlite-lines: https://github.com/asg017/sqlite-lines - various other extensions: https://github.com/nalgeon/sqlean And past HN threads: - https://news.ycombinator.com/item?id=32335295 - https://news.ycombinator.com/item?id=32288165
    comment by alexgarcia-xyz · 2022-08-10 · in SQLite-HTTP: A SQLite extension for making HTTP requests
  16. …https://github.com/riyaz-ali/sqlite - sqlean, a ton of other helpful SQLite extensions (in C): https://github.com/nalgeon/sqlean
    comment by alexgarcia-xyz · 2022-08-03 · in SQLite-HTML: A SQLite extension for querying, manipulating, and creating HTML
  17. …Excel files, in Rust https://github.com/x2bool/xlite - sqlean, several small SQLite extensions in C https://github.com/nalgeon/sqlean - mergestat, several SQLite extensions for developers (mainly Github's API) in Go…
    comment by alexgarcia-xyz · 2022-07-30 · in A SQLite extension for reading large files line-by-line
  18. …- https://github.com/adamlouis/squirrelbyte - https://github.com/chunky/sqlite3todot - https://github.com/nalgeon/sqlite-plus/ - https://www.sqlite.org/json1.html#jsonpath
    comment by hardwaresofton · 2021-04-15 · in SQLite the only database you will ever need in most cases
  19. The VSV extension has additional arguments that may be useful in some situations: https://github.com/nalgeon/sqlite-plus/blob/main/docs/vsv.md
    comment by smitty1e · 2021-04-03 · in SQLite Plus: Missing SQLite functions
  20. …sense. GGP is probably meaning exactly that, specifically vsv from the OP that I missed initially. https://github.com/nalgeon/sqlite-plus/blob/main/docs/vsv.md
    comment by foepys · 2021-04-03 · in SQLite Plus: Missing SQLite functions