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 est un ORM (Object-Relational Mapper) léger et une couche d'accès aux données pour SQLite. Il fournit des outils pour traduire les classes d'application en tables de base de données, gérer les enregistrements via un mappeur d'entités et implémenter la persistance locale des données. La bibliothèque inclut un wrapper chiffré qui sécurise les fichiers de base de données en utilisant des clés de connexion et des configurations de chiffrement natives. Elle dispose également d'une couche d'accès aux données qui prend en charge les opérations synchrones et asynchrones pour maintenir la réactivité de l'application lors des accès disque. Le projet couvre une gamme de capacités de gestion de base de données, y compris la génération automatique de tables à partir de définitions de classes, les opérations CRUD basées sur les entités et les requêtes basées sur des prédicats. Il permet également l'exécution de SQL brut en utilisant des instructions paramétrées.

RavenDB is a multi-model NoSQL document database designed for high-performance, ACID-compliant data storage. It persists structured information as schema-flexible JSON documents and utilizes a unit-of-work session pattern to track entity changes and batch modifications into atomic transactions. The platform is built on a distributed architecture that supports horizontal scaling through sharding and ensures high availability via multi-node, master-to-master cluster replication. The database distinguishes itself through a self-optimizing query engine that automatically creates and maintains ind

Rotki est une suite de gestion financière locale conçue pour le suivi de portefeuille de cryptomonnaies, la comptabilité fiscale et l'analyse de la finance décentralisée (DeFi). Il fonctionne comme une application auto-hébergée qui sécurise tous les dossiers financiers, l'historique des transactions et les identifiants des utilisateurs au sein d'une base de données locale chiffrée, garantissant que les données sensibles restent entièrement sous le contrôle de l'utilisateur. La plateforme se distingue par une architecture préservant la confidentialité qui élimine la dépendance au stockage cloud centralisé ou aux fournisseurs de données tiers. Les utilisateurs conservent un contrôle total sur leur connectivité en configurant des endpoints RPC distants personnalisés pour les requêtes blockchain et en utilisant des intégrations API en lecture seule pour la synchronisation des données d'échange. De plus, l'application emploie une approche zero-knowledge pour la synchronisation des données, permettant aux utilisateurs de sauvegarder et d'accéder en toute sécurité à leurs dossiers financiers sur plusieurs appareils sans exposer d'informations privées. Au-delà de son modèle de stockage et de connectivité de base, le logiciel dispose d'un moteur comptable modulaire qui calcule les profits, les pertes et les mesures fiscales en appliquant des méthodes de coût de revient sélectionnées par l'utilisateur aux données agrégées. Il inclut une logique d'analyse spécialisée pour traduire l'activité blockchain brute en événements lisibles par l'homme, couvrant des interactions DeFi complexes telles que la fourniture de liquidités, les positions de prêt et le yield farming. Le système fournit également des outils de visualisation complets pour rendre les tendances historiques, les allocations d'actifs et l'évolution de la valeur nette.

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