Top 17 sqlite-extension Open-Source Projects

• sqlite-plus

  29 3,420 7.1 C

  The ultimate set of SQLite extensions

Project mention: I'm writing a new vector search SQLite Extension | news.ycombinator.com | 2024-05-02

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

• sqlite-vss

  17 1,537 6.8 C++

  A SQLite extension for efficient vector search, based on Faiss!

Project mention: I'm writing a new vector search SQLite Extension | news.ycombinator.com | 2024-05-02

I guess this is an answer to the GitHub issue I opened against SQLite-vss a couple of months ago?

https://github.com/asg017/sqlite-vss/issues/124

• InfluxDB

  www.influxdata.com featured

  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.

  

• xlite

  16 1,230 0.9 Rust

  Query Excel spredsheets (.xlsx, .xls, .ods) using SQLite

Project mention: Show HN: Query Your Sheets with SheetSQL | news.ycombinator.com | 2024-03-13

There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)

• stanchion

  3 626 8.9 C

  A SQLite extension that brings column-oriented tables to SQLite

Project mention: Show HN: Stanchion – Column-oriented tables in SQLite | news.ycombinator.com | 2024-01-31

The "Data Storage Internals" section[1] of the README sounds to me like it has its own column-oriented format for these tables, at least that's how I'm reading the part about segments. Is that the case? If so, have you tried using Apache Arrow or Parquet to see how they compare?

[1] https://github.com/dgllghr/stanchion#data-storage-internals

• libgsqlite

  10 507 0.0 Rust

  A SQLite extension which loads a Google Sheet as a virtual table.

Project mention: Show HN: Query Your Sheets with SheetSQL | news.ycombinator.com | 2024-03-13

There is similar open-source project for Google Sheets: https://github.com/0x6b/libgsqlite (SQLite extension), which is a fork of https://github.com/x2bool/xlite (same idea but for Microsoft Excel spreadsheets)

• sqlite-lines

  7 384 6.8 C

  A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.)

• sqlite-html

  4 362 6.9 Go

  A SQLite extension for querying, manipulating, and creating HTML elements.

• SaaSHub

  www.saashub.com featured

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

  

• sqlite-loadable-rs

  2 320 6.2 Rust

  A framework for writing fast and performant SQLite extensions in Rust

• sqlite-http

  3 215 6.9 Go

  A SQLite extension for making HTTP requests purely in SQL

• sqlpkg-cli

  1 178 8.2 Go

  SQLite package manager

Project mention: SQLite Package Manager | news.ycombinator.com | 2023-07-25

• sqlite-regex

  1 157 5.5 Rust

  A fast regular expression SQLite extension, written in Rust

• sqlite-xsv

  1 115 6.2 Rust

  the fastest CSV SQLite extension, written in Rust

• sqlite-ulid

  1 117 8.3 Python

  A SQLite extension for generating and working with ULIDs

• sqlite-jsonschema

  2 36 6.1 TypeScript

  A SQLite extension for validating JSON objects with JSON Schema

Project mention: JSON Canvas – An open file format for infinite canvas data | news.ycombinator.com | 2024-03-11

Exactly so. SQLite also has a rich collection of CHECK constraints which can raise errors if data is not to your liking in some fashion, this includes validating JSON. Not a JSON schema, admittedly, although (just like for Postgres) this is available as an extension. https://github.com/asg017/sqlite-jsonschema

Saying that SQLite doesn't have "real types" is simply false. If one doesn't want to learn how to use a tool, blaming it for that failure is poor form.

• sqlite-url

  1 30 5.6 C

  A SQLite extension for parsing, generating, and querying URLs and query strings

• sqlite-path

  1 25 6.1 C

  A SQLite extension for parsing, generating, and querying paths

• sqlite-fastrand

  1 19 6.0 Rust

  A SQLite extension for quickly generating random numbers, booleans, characters, and blobs

• SaaSHub

  www.saashub.com featured

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

  

sqlite-extension related posts

• I'm writing a new vector search SQLite Extension

  13 projects | news.ycombinator.com | 2 May 2024

• Embeddings are a good starting point for the AI curious app developer

  7 projects | news.ycombinator.com | 17 Apr 2024

• SQLite vs. Chroma: A Comparative Analysis for Managing Vector Embeddings

  2 projects | dev.to | 7 Oct 2023

• Vector database is not a separate database category

  3 projects | news.ycombinator.com | 2 Oct 2023

• SQLite-Vss: A SQLite Extension for Vector Search

  1 project | news.ycombinator.com | 18 Sep 2023

• Introduction to Vector Search and Embeddings

  2 projects | dev.to | 13 Aug 2023

• Sqlite3 and electron in production

  1 project | /r/electronjs | 2 Jul 2023
• A note from our sponsor - SaaSHub
  www.saashub.com | 7 Jun 2024

  SaaSHub helps you find the best software and product alternatives Learn more →

Index

Sponsored

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.

www.influxdata.com