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.
zombiezen/go-sqlite is a Go library providing low-level bindings to SQLite 3 using the CGo-free modernc.org/sqlite implementation. It offers direct access to SQLite features including connection management, statement execution, blob I/O streaming, online backup API, user-defined functions (scalar and aggregate), session API for changesets, virtual table support, and schema migration tools. The architecture follows a modular design with core sqlite package for basic operations, sqlitex for extended utilities (connection pooling, execution helpers), sqlitefile for blob-backed buffers, and sqlitemigration for schema migrations. The library is safe for concurrent use through connection pooling and proper error handling, with comprehensive test coverage demonstrating its reliability.
Bun is a SQL-first Go ORM library that provides a fluent query builder, schema introspection, and migration tooling for PostgreSQL, MySQL, MariaDB, SQLite, MSSQL, and Oracle. It wraps the standard database/sql interface and offers a rich set of features including model-based CRUD with struct tags, relation loading (belongs-to, has-one, has-many, many-to-many), soft deletes, CTEs, upserts, and bulk operations. The library is designed for production use with built-in support for OpenTelemetry, structured logging, and New Relic instrumentation via optional extension packages. Architecturally, Bun separates SQL generation into dialect-specific packages (pgdialect, mysqldialect, etc.) and provides its own PostgreSQL wire protocol driver (pgdriver) for low-latency connections. The core query builders (SelectQuery, InsertQuery, etc.) compose reusable query parts (WHERE, ORDER, RETURNING) and use a feature flag bitmask to conditionally emit dialect-specific SQL. The migration system supports both SQL-file migrations and automatic schema diffing, comparing model definitions against live database catalogs to generate ALTER TABLE statements. Key entry points include the DB type (NewDB, NewSelect, etc.), the schema package for table/field metadata, and the migrate package for versioned migrations. The library is extensively tested across multiple database backends using Docker containers and snapshot-based golden file testing. While the codebase is large and dialect-specific branches add complexity, the overall architecture is clean, well-factored, and follows Go idioms consistently.
This repository is a Go library that implements a database/sql driver for SQLite3, using cgo to bind to the SQLite C library (either the bundled amalgamation or a system-installed libsqlite3). It provides a full-featured driver supporting transactions, prepared statements, custom functions, aggregators, collations, hooks, virtual tables, backup, serialization, and many SQLite extensions via build tags. The architecture is a single-package driver with a large cgo file (sqlite3.go) and numerous optional feature files selected by build constraints. Key entry points are the SQLiteDriver, SQLiteConn, SQLiteStmt, and SQLiteRows types, which implement the standard database/sql interfaces. The codebase is mature, widely used, and actively maintained, with extensive tests and CI across platforms. It is not a standalone application but a reusable library consumed by Go programs.
Gogs is a self-hosted Git service written in Go, providing a full-featured platform for hosting Git repositories with issue tracking, pull requests, wiki, webhooks, and Git LFS support. The backend is a monolithic Go application using a dual web framework (Macaron and Flamego) and dual ORM (XORM and GORM) during an ongoing migration. The frontend is a hybrid of legacy server-rendered templates and a modern React SPA built with TanStack Router, Radix UI, and Tailwind CSS. The system supports multiple authentication backends (LDAP, SMTP, PAM, GitHub OAuth), SSH and HTTP Git protocols, and extensive REST API. It is deployed via Docker with s6 supervisor and backup rotation scripts. The codebase demonstrates strong engineering practices with well-structured utility packages, security-conscious input validation, and comprehensive test coverage using golden files and mock stores. However, it carries technical debt from the framework migration, vendored outdated frontend plugins (CodeMirror 5.17.0), and a monolithic legacy JavaScript file.