Awesome GitHub RepositoriesSQLite Storage Adapters

Mastodon is a decentralized microblogging platform and federated social network. It allows users to publish short text updates, media, and links to a chronological feed across a distributed architecture that removes reliance on a single central authority. The software enables the creation of self-hosted social servers, giving administrators local control over user accounts and content. These independent instances synchronize user profiles and interactions across a global network of servers using the ActivityPub protocol for cross-platform social networking. The platform includes community co

Winston is a versatile logging library for Node.js designed to record system events and metadata. It functions as a multi-transport log manager that routes data to various destinations and a structured log formatter that transforms entries into JSON or plain text. The project is distinguished by its pluggable transport architecture, which decouples the logging interface from delivery mechanisms. This allows for the creation of custom transport extensions and the use of hierarchical logger instances to inherit configurations while attaching persistent metadata to downstream messages. The libr

This project is a reactive, offline-first NoSQL database engine designed for JavaScript applications. It provides a robust framework for managing application state by synchronizing data across browsers, mobile devices, and server-side runtimes. By treating local storage as the primary source of truth, it enables applications to remain functional without network connectivity, automatically reconciling changes with remote backends once a connection is restored. The database distinguishes itself through a modular architecture that supports cross-environment synchronization and high-performance d

DataX is a distributed data integration framework and plugin-based ETL tool designed for synchronizing large datasets between heterogeneous sources and destinations. It functions as a JDBC data migration engine and offline synchronization tool, enabling the movement of data between relational databases, NoSQL stores, and object storage. The system utilizes a plugin-based connector architecture that decouples reader and writer logic, allowing it to map and transform data types across different storage engines using a standardized internal representation. This design supports heterogeneous data

YYeTsBot is a self-hosted Telegram bot that enables searching, browsing, and sharing media resources from the YYeTs subtitled media archive. It operates as an interactive bot within Telegram, allowing users to search for subtitled media content and manage resource links directly through chat commands. The application indexes YYeTs media resources and user-submitted links, building a searchable database stored in a local SQLite database. It supports community curation through features that let users flag unavailable resources and submit new media links for inclusion. The bot maintains per-user

sql.js is a serverless, in-memory SQL database engine that ports SQLite to WebAssembly for use within a web browser. It provides a JavaScript interface to initialize relational databases, execute SQL queries, and manage structured data without requiring a backend server. The project enables the import and export of database states using typed arrays, allowing in-memory data to be persisted as files. It supports high-precision integer retrieval via BigInt and utilizes prepared statements to increase execution speed and security. The engine includes capabilities for client-side data management

Sonarr is an automated media management tool that functions as a personal video recorder for television series. It monitors RSS feeds and indexers to track, download, and organize television episodes for personal media libraries. The application integrates with Usenet and BitTorrent clients to automate the acquisition of content. It maintains library integrity by identifying missing episodes and searching for higher-quality versions of existing files, such as 1080p or 4K, based on user-defined criteria. Beyond acquisition, the software handles the organization of media by renaming and sortin

Luanti is an open-source sandbox game engine designed for the creation and exploration of interactive three-dimensional voxel environments. It functions as a platform for building persistent digital spaces where users can modify block-based worlds and share custom content. The engine provides a framework for multiplayer interaction, utilizing a client-server architecture to synchronize world states across connected participants. It incorporates a scripting interface that allows for the integration of user-created modifications, alongside a centralized distribution system for managing and inst

greenDAO is an object-relational mapping library for Android that maps Java objects to SQLite databases. It provides infrastructure for high-performance data persistence by translating data objects into database records and vice versa. The library implements a type-safe query builder for retrieving records across multiple entities using joins and relationship chaining. It also includes a security layer that provides full-disk encryption for the SQLite database to prevent unauthorized access to stored information. The system utilizes compile-time code generation to create mapping classes, avo

WatermelonDB is an offline-first data synchronization engine and reactive database library designed for mobile and web applications. It provides a persistent storage layer backed by SQLite, enabling applications to maintain full functionality and data consistency while operating without an internet connection. The framework distinguishes itself through a reactive data binding system that automatically updates user interface components whenever underlying database records change. It utilizes schema-driven model mapping to generate type-safe interfaces and employs lazy object materialization to

Grist is a relational spreadsheet platform that combines the flexibility of a spreadsheet with the power of a relational database. At its core, it manages structured data across multiple linked tables, using a relational database engine to organize information while providing a familiar grid interface. The platform supports Python-based formulas for complex calculations and data transformations, with automatic recalculation when referenced cells change. The system is designed for self-hosted deployment, storing data in either portable SQLite files or enterprise-grade PostgreSQL databases. It

Dex is an OpenID Connect provider and identity federation proxy that translates authentication signals from various upstream sources into a unified OpenID Connect interface. It functions as a multi-protocol identity broker, enabling client applications to implement a single standard while delegating user verification to external identity providers. The project distinguishes itself through a pluggable connector architecture that bridges disparate protocols including LDAP, SAML, and OAuth2. It provides specific integrations for services such as GitHub, Google, GitLab, and Microsoft, while offer

EmDash is an open-source content management system built on Astro that combines a visual admin panel with a plugin-driven architecture and server-side rendering. It provides a complete content management system with structured content modeling, a rich text editor using Portable Text format, and a TypeScript API for type-safe content queries. The system supports authentication through passkeys, OAuth 2.1, and external providers, with role-based access control and fine-grained permission scopes. What distinguishes EmDash is its plugin development framework, which supports both native plugins ru

崩坏：星穹铁道全自动 三月七小助手

AzurLaneAutoScript is a mobile game automation system designed to perform repetitive gameplay tasks unattended. It functions as a screenshot-driven bot that controls Android devices, emulators, and cloud phones via ADB and uiautomator2, using computer vision to make interaction decisions instead of fixed timers. The project distinguishes itself through an advanced computer vision suite that includes local optical character recognition and perspective-aware grid detection. These tools allow the bot to parse 3D game maps, compute vanishing points, and normalize grid-centered objects for precise

go-admin is a framework for generating administrative interfaces and data visualization dashboards using the Go programming language. It functions as a low-code dashboard builder and a web-based interface for performing create, read, update, and delete operations across multiple SQL database dialects. The project features a deployment model that compiles backend logic and frontend assets into a single executable binary for simplified distribution. It includes a role-based access control system to manage user permissions and restrict administrative functions based on assigned roles. The frame

ai-goofish-monitor is an AI-driven marketplace monitor and containerized web scraper designed to track online listings. It uses multimodal large language models and natural language prompts to analyze product text and images, determining if items meet specific requirements. The system employs an anti-detection workflow that rotates network proxies and authenticated accounts to bypass rate limits. It captures browser cookies and session states to mimic real user behavior during automated requests. The project includes a task scheduler using cron expressions and an embedded SQLite database for

Mapscii is a terminal-based geographic interface and vector map renderer. It allows users to view and explore geographic map data and points of interest directly within an xterm-compatible console using ASCII and Braille characters. The project functions as a vector tile map client capable of fetching and styling geographic layers from public or private sources. It also serves as an MBTiles map viewer, enabling the exploration of geographic data stored in local files for offline use. The tool provides keyboard-driven navigation for zooming and panning across coordinates, along with the abili

Clipy is a clipboard manager and productivity utility for macOS. It functions as a text snippet manager and a tool for archiving clipboard history, allowing users to retrieve previously copied text and images. The application enables the storage of frequently used boilerplate text as snippets to avoid repetitive manual typing. These snippets and historical clipboard entries can be accessed and inserted into other applications via keyboard shortcuts.

GRDB.swift is a comprehensive SQLite toolkit and object-relational mapper for Swift. It provides a database wrapper that handles local data persistence, connection management, and encrypted file storage for Apple platforms. The library features a dedicated observation framework that tracks database changes to automatically synchronize the application state and user interface in real time. It distinguishes itself with a type-safe query builder and a protocol-based mapping system that converts database rows into structured Swift objects. The toolkit covers a broad range of administrative and o