{"repo":"coregx/relica","free":true,"listed":false,"github":"https://github.com/coregx/relica","clone":"git clone https://github.com/coregx/relica.git","description":"Lightweight, type-safe database query builder for Go with zero production dependencies. Advanced SQL features (JOINs, subqueries, CTEs, window functions), batch operations (3x faster), LRU statement cache (<60ns). Professional API documentation. PostgreSQL, MySQL, SQLite support.","language":"Go","stars":22,"topics":["database","database-abstraction","go","golang","lru-cache","mysql","orm","performance","postgresql","query-builder"],"license":"MIT","category":"databases-storage","readme_excerpt":"Relica Relica is a lightweight, type-safe database query builder for Go with zero production dependencies. 🤖 AI Agents : Before generating code, read AGENTS.md for correct API patterns. Use Model() API for CRUD, Expression API for WHERE conditions. Avoid map[string]interface{} . ✨ Features - Zero Production Dependencies - Uses only Go standard library - High Performance - LRU statement cache, batch operations (3.3x faster) - Type-Safe - Generic One[T] / All[T] / Scalar[T] + reflection-based struct scanning - Model() API - ORM-style CRUD with auto-populated IDs (int + UUID via autoincrement tag), composite PKs - NullStringMap - Dynamic scanning without predefined structs - Named Placeholders - {:name} syntax with Bind(Params{}) for readable queries - Functional Expressions - CASE, COALESCE, NULLIF, GREATEST, LEAST, CONCAT - Transactional() - Auto commit/rollback helper with panic recovery - Dynamic WHERE - AndWhere() / OrWhere() for conditional query building - Row() / Column() - Convenient scalar and single-column queries - Prepare() / Close() - Manual statement control for batch operations - Transaction Support - Full ACID with all isolation levels - Enterprise Security - SQL injection prevention, audit logging, compliance - Batch Operations - Efficient multi-row INSERT and UPDATE - JOIN Operations - INNER, LEFT, RIGHT, FULL, CROSS JOIN support - Sorting & Pagination - ORDER BY, LIMIT, OFFSET, DISTINCT - Aggregate Functions - COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING - Su","default_branch":null,"files":null,"tree":[],"storefront":"/r/coregx","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/coregx/relica/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}