MikroORM is a TypeScript ORM for Node.js implementing the Data Mapper, Unit of Work, and Identity Map patterns. It provides database abstraction across MongoDB, MySQL, MariaDB, PostgreSQL (including CockroachDB/PGlite), SQLite (including libSQL/Turso), MSSQL, and Oracle. The library features entity management via decorators or EntitySchema, relationship handling, schema generation, migrations, seeding, query building, caching, filters, custom types, embeddables, lifecycle hooks, and transaction management. Structured as a monorepo with separate packages for core functionality, database drivers, CLI, migrations, seeding, entity generation, and reflection, it emphasizes modularity and extensibility through patterns like strategy (naming strategies), decorator-based metadata, and proxy-wrapped entities for helper methods.
OpenCode-Mem is a plugin for OpenCode, an AI coding assistant, that provides persistent memory using vector embeddings and Turso/libSQL. It stores project-level technical memories (decisions, code facts, patterns) and learns user preferences/configs across sessions. The system uses local ONNX embeddings (or remote API) and supports multiple LLM providers (Anthropic, OpenAI, Google Gemini, MiniMax). It features auto-capture of session content, user profile learning with confidence decay, deduplication, and migration services. A full React web UI allows browsing, editing, and managing memories and user profiles. The architecture is modular: plugin entry, AI provider abstraction, Turso shard management, embedding service, web server, and shared API schemas. While primarily an application, it includes robust data pipeline patterns for vector search, ETL (migration), and user modeling.