Awesome GitHub RepositoriesLocal Database Security

This is a mobile object database and NoSQL local data store that replaces relational tables with a schema-based model. It functions as a reactive data store, using live object observations and change notifications to trigger automatic user interface refreshes. The system provides built-in mobile cloud data synchronization to keep local datasets consistent with a remote server across multiple devices. It also includes security features for encrypted local storage, protecting sensitive on-disk data using at-rest encryption keys and fine-grained access control. Broad capabilities include object

fmdb is an object-oriented SQLite database library and persistence layer for native macOS and iOS environments. It provides an Objective-C wrapper that encapsulates the low-level C API, allowing applications to manage local relational data storage and embedded database connections through a high-level interface. The library focuses on thread-safe database access by synchronizing operations across multiple threads using serialized queues to prevent data corruption and race conditions. It includes specialized capabilities for secure local storage, such as database encryption and the management

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

LiteDB is a serverless, embedded NoSQL document database for .NET applications. It persists data into a single portable file, functioning as a BSON data store that resides within the application process rather than running as a separate server. The system is ACID compliant, utilizing write-ahead logging to ensure atomic, consistent, isolated, and durable transactions. It includes built-in encryption to provide secure local data storage and protect files on disk from unauthorized access. The project covers object-document mapping to convert classes into document formats, indexed search capabi

LiteDB is a serverless NoSQL document store and embedded database engine for .NET applications. It persists unstructured documents and binary data into a single standalone disk file, allowing the database to run within the application process rather than as a separate server. The system supports strongly typed queries through Language Integrated Query and allows the execution of standard SQL commands for data retrieval and transformation. It provides native mapping of plain classes into document formats and secures stored information via symmetric-key file encryption. The engine includes cap

This project is a cross-platform messaging SDK and client development library used to build custom Telegram applications. It functions as a comprehensive framework that manages network encryption, local data storage, and API communication, providing a C-compatible JSON interface that allows integration with any programming language. The library distinguishes itself by providing a full database manager for encrypted local caching and synchronized state, alongside a dedicated bot framework for creating interactive bots with business account integration. It enables the implementation of speciali

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

OmniRoute is a unified LLM API gateway that connects multiple AI providers to a single endpoint. Its primary purpose is to simplify the integration of various AI models into tools and agents by translating different provider formats into a standardized API. The project distinguishes itself through a multi-strategy request routing system that optimizes for cost, speed, and availability, including automatic model fallbacks and a circuit-breaker resilience model to isolate provider failures. It employs a local-first security posture, using AES-256-GCM encryption to store API keys and conversatio

sqlite-net ist ein leichtgewichtiger Object-Relational Mapper (ORM) und Datenzugriffsschicht für SQLite. Es bietet Tools zum Übersetzen von Anwendungsklassen in Datenbanktabellen, zum Verwalten von Datensätzen über einen Entity-Mapper und zur Implementierung lokaler Datenpersistenz. Die Bibliothek enthält einen verschlüsselten Wrapper, der Datenbankdateien mittels Verbindungsschlüsseln und nativen Verschlüsselungskonfigurationen sichert. Sie verfügt zudem über eine Datenzugriffsschicht, die sowohl synchrone als auch asynchrone Operationen unterstützt, um die Anwendungsreaktionsfähigkeit während des Festplattenzugriffs aufrechtzuerhalten. Das Projekt deckt eine Reihe von Datenbankmanagement-Funktionen ab, einschließlich automatischer Tabellengenerierung aus Klassendefinitionen, entity-basierten CRUD-Operationen und prädikatbasierten Abfragen. Es ermöglicht zudem die Ausführung von rohem SQL mittels parametrisierter Statements.

Rotki ist eine Local-First-Finanzmanagement-Suite für Kryptowährungs-Portfolio-Tracking, Steuerbuchhaltung und DeFi-Analysen (Decentralized Finance). Es fungiert als selbstgehostete Anwendung, die alle Finanzunterlagen, Transaktionshistorien und Benutzerdaten in einer verschlüsselten lokalen Datenbank sichert und so sicherstellt, dass sensible Daten vollständig unter der Kontrolle des Benutzers bleiben. Die Plattform zeichnet sich durch eine privatsphärenschonende Architektur aus, die die Abhängigkeit von zentralisiertem Cloud-Speicher oder Drittanbietern eliminiert. Benutzer behalten die volle Kontrolle über ihre Konnektivität, indem sie benutzerdefinierte RPC-Endpunkte (Remote Procedure Call) für Blockchain-Abfragen konfigurieren und Read-Only-API-Integrationen für die Synchronisation von Börsendaten nutzen. Darüber hinaus verwendet die Anwendung einen Zero-Knowledge-Ansatz für die Datensynchronisation, der es Benutzern ermöglicht, ihre Finanzunterlagen sicher über mehrere Geräte hinweg zu sichern und darauf zuzugreifen, ohne private Informationen preiszugeben. Über das Kernmodell für Speicherung und Konnektivität hinaus bietet die Software eine modulare Buchhaltungs-Engine, die Gewinn, Verlust und Steuerkennzahlen berechnet, indem sie vom Benutzer gewählte Kostenbasis-Methoden auf aggregierte Daten anwendet. Sie enthält spezialisierte Parsing-Logik, um rohe Blockchain-Aktivitäten in menschenlesbare Ereignisse zu übersetzen, und deckt komplexe DeFi-Interaktionen wie Liquiditätsbereitstellung, Lending-Positionen und Yield Farming ab. Das System bietet zudem umfassende Visualisierungstools zur Darstellung historischer Trends, Vermögensallokationen und der Entwicklung des Nettovermögens.

MIRIX is an AI agent state orchestrator and long-term memory system designed to provide persistent context for large language models. It functions as a multi-modal AI memory pipeline that processes text, voice, and screen captures into structured knowledge stores, including a dedicated screen activity knowledge base. The project distinguishes itself by integrating a multi-modal observation pipeline that monitors desktop activity in real-time to build a searchable history of user actions. It utilizes a multi-tiered memory hierarchy—separating episodic, semantic, procedural, and core stores—and

Molly is a privacy-focused Android messenger and a client for the Matrix open standard. It functions as a decentralized, end-to-end encrypted communication tool that allows users to interact across federated networks without a central authority. The application implements several security-centric features, including binary integrity verification to ensure the authenticity of the installed build and RAM-overwrite memory sanitization to prevent sensitive data leakage. It provides local database encryption secured by user-defined passphrases and supports routing network traffic through proxies o