Awesome GitHub RepositoriesSQLite Extensions

Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.

Beekeeper Studio is a cross-platform desktop application designed for database management and SQL development. It provides a unified graphical interface to connect to, query, and modify data across a wide range of relational and NoSQL database systems. The application functions as a comprehensive workspace, integrating tools for schema design, record editing, and data visualization. The project distinguishes itself through a focus on secure, flexible connectivity and AI-assisted workflows. It supports advanced authentication methods, including enterprise single sign-on, multi-factor authentic

Koel is a self-hosted music streaming server designed for hosting, managing, and streaming personal digital music collections via web and mobile applications. It functions as a personal audio streaming platform that allows users to organize local and cloud-based audio libraries with integrated user accounts and playlist management. The system distinguishes itself by acting as a cloud-integrated media server, enabling the connection of remote storage providers to serve music files without requiring local disk space. It provides a cross-platform playback experience, ensuring consistent access t

Darktable is a professional photography post-production suite and digital asset management system designed for the end-to-end processing of raw sensor data. It provides a comprehensive environment for photographers to perform color correction, exposure adjustment, and image retouching while maintaining a non-destructive workflow that keeps original source files unchanged. The software utilizes a modular plugin architecture and a pixelpipe processing pipeline to execute image manipulations, allowing for custom editing workflows. It incorporates a color-managed display pipeline that uses intern

SQLite.swift is a type-safe Swift wrapper and object-relational mapping layer that provides a bridge for interacting with SQLite databases. It functions as a database driver that allows for embedded database management and local data persistence within Swift applications. The project distinguishes itself through a type-safe expression builder that verifies SQL statement syntax and intent at compile time. It includes specialized support for high-performance text matching via full-text search integration and provides mechanisms for securing sensitive data through database encryption. The libra

Shadow is an Android plugin framework designed to dynamically load and execute Android components and native libraries from external modules into a host application. It functions as a dynamic component loader that integrates activities, services, and broadcast receivers without requiring modifications to the host application code. The system includes a native library loader to execute C/C++ binary files from plugin modules directly within the host process. It also features a module dependency manager that supports segmented loading and explicit dependency chains across multiple plugin package

Steampipe is a cloud infrastructure query engine and API-to-SQL mapper that translates REST and GraphQL API responses into relational rows and columns. It allows for the retrieval and joining of real-time data from multiple cloud service providers using a relational database interface. The project functions as a PostgreSQL foreign data wrapper and an SQLite API extension, mapping external API endpoints to virtual tables. This enables the use of standard SQL to query live cloud services and aggregate data from different providers and service accounts into a single unified dataset. The system

SQLCipher is an encrypted SQLite database engine and secure relational database that provides transparent AES-256 encryption for database files and stored data. It functions as a cryptographic storage engine that requires a passphrase or binary key to unlock and access content. The engine ensures data confidentiality through page-level encryption and protects data integrity using cryptographic hashes to detect unauthorized modifications. It includes capabilities for encryption key rotation to update passphrases and secure memory locking to prevent sensitive keys from being swapped from RAM to

sqlite-vec is a C-based vector library and SQLite extension that adds virtual tables for storing and querying high-dimensional embeddings. It functions as a database plugin for performing nearest neighbor searches using distance metrics such as L2, cosine, and Hamming distance. The project provides a portable embedding store that supports deployment across Android, iOS, desktop environments, and web browsers via WebAssembly. It distinguishes itself by converting numerical arrays into compact binary formats and utilizing quantization to reduce the memory footprint and storage size of vector in

Skim is a cross-platform interactive fuzzy finder that runs as a terminal application, a Rust library, a Vim and Neovim plugin, and a shell integration tool. It provides real-time filtering and selection from lists of items, supporting keyboard and mouse navigation, live preview panes, and multi-select functionality across Linux, macOS, and Windows. The tool distinguishes itself through a composable query expression tree that supports fuzzy, exact, inverse, prefix, suffix, and logical AND/OR operators, combined with a Smith-Waterman scoring engine that penalizes typos and gaps for natural rel

node-sqlite3 is a relational database client and a set of native bindings that allow Node.js applications to interact with SQLite databases. It functions as a C++ native addon, linking JavaScript to the SQLite C library to manage data stored in local files or in-memory stores. The project includes optional support for SQLCipher, enabling page-level encryption to secure local database files. The driver covers a wide range of database management capabilities, including executing SQL queries with parameter binding, managing connections to database files, and preparing statements for repeated ex

SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted data

Musikcube 是一个跨平台音乐播放器和高性能 C++ 音频引擎，专为管理本地音乐库而设计。它既是一个基于终端的音乐播放器，也是一个能够索引元数据并在不同操作系统上播放音频的无头音频服务器。 该项目采用客户端-服务器架构，将核心音频引擎和元数据索引器与用户界面分离。这种设计使其能够充当自托管音频流服务器，通过 WebSocket 和 HTTP 向远程客户端传输音乐和元数据，并支持实时转码和基于密码的身份验证。 系统包含通过目录扫描和增量元数据更新进行本地音乐库索引的功能。它提供了播放列表管理、元数据查询以及通过系统级热键进行全局播放控制的工具。音频引擎支持多段均衡器、前置放大器增益配置和多种声音驱动选择。 该软件可作为后台守护进程部署，以确保在系统启动过程中保持持续可用。

REFramework is a runtime modding framework for games built on the RE Engine, providing a C# plugin system with typed proxy code generation, a Lua scripting interface, an ImGui-based UI system, a runtime debugging toolkit, and a VR integration layer. At its core, it intercepts and modifies internal game engine functions and state at runtime through hooking and scripting APIs, enabling deep inspection and manipulation of live game objects. The framework distinguishes itself through typed proxy code generation that auto-creates C# interfaces from the game's type database, giving compile-time saf

sqlean 是一个实现为 C 语言共享库的 SQLite 扩展库合集。它提供了一套额外的标量和表值函数，扩展了 SQLite 数据库引擎的原生功能。 该项目为密码学、高等数学、网络和文件系统访问提供了专门的工具集。这些包括二进制哈希和编码、统计分析、IP 地址验证，以及将 CSV 文件或文件系统路径映射为虚拟表的能力。 该库还包括全面的文本处理工具，如正则表达式、模糊匹配和 Unicode 感知字符串操作。其他功能涵盖高精度日期和时间管理以及唯一标识符的生成。

Rusqlite is an embedded database interface and relational database driver that provides a client library for interacting with SQLite. It functions as an SQL query wrapper, enabling the management of local file-based or in-memory databases through a safe interface. The library allows for the extension of native database capabilities by implementing custom scalar functions, collations, and virtual tables. It also supports the embedding of the database engine directly into the application binary to remove external library dependencies. The project covers a broad range of capabilities including

GodotSteam is a game engine plugin and API wrapper that integrates the Steamworks SDK into the Godot engine. It serves as a bridge between the engine's scripting layer and platform services, allowing applications to access social features and platform-specific connectivity. The project utilizes a C++ wrapper and a C-compatible foreign function interface to bind the Steamworks SDK. It includes a session manager that handles application ID initialization and enforces that the application is launched through the Steam client to validate ownership and session integrity. The integration covers se

TShock is a server management tool and plugin framework for dedicated Terraria servers. It functions as an administrative suite and anti-cheat tool designed to control player permissions, monitor game integrity, and extend server functionality. The project provides a framework for creating custom plugins that modify the game world and implement new commands. It enables internal state modification through bytecode injection, packet interception, and memory manipulation to bypass engine restrictions and alter live game environments. Administrative capabilities include a hierarchical role-based

OwnTone 是一个自托管的音乐库管理器和多房间音频流媒体服务器，设计为 Unix 原生守护进程运行。它作为一个集中式枢纽，将本地音频文件、网络电台、播客和云端音乐服务聚合到一个统一的库中，以实现全网访问。 该服务器通过为 AirPlay 和 Chromecast 设备提供同步的多房间音频广播，以及对 DAAP 和 MPD 等标准网络协议的支持而脱颖而出。它通过一个多协议管道管理这些流，处理转码和中继，确保在各种硬件和软件播放器之间的兼容性。 该系统包括全面的库管理功能，利用关系数据库索引实现快速导航和智能播放列表生成。它支持通过移动和 Web 界面进行远程控制，允许用户从网络上的任何连接设备管理播放和库导航。 该软件专为在类 Unix 操作系统上部署而设计，可通过原生包管理器、容器镜像或手动编译进行安装。

This project is a music information retrieval library and research dataset designed for audio feature extraction and music genre classification. It provides a framework for training and evaluating machine learning models that categorize audio tracks into hierarchical genre structures, supported by a collection of open-licensed MP3 tracks and pre-computed features. The project includes a music metadata API client to fetch structured track, album, and artist information from external data sources. It utilizes these external integrations to map parent-child relationships between genres and organ