3 个仓库
Defining database tables, indexes, and constraints using SQL statements in schema files that are verified at compile time.
Distinct from Database Schema Definitions: Distinct from Database Schema Definitions: focuses on SQL-based schema definition with compile-time verification, not general collection structure definitions.
Explore 3 awesome GitHub repositories matching data & databases · SQL Schema Definitions. Refine with filters or upvote what's useful.
SQLDelight is a Kotlin database library that validates SQL schema, statements, and migrations at compile time, generating type-safe Kotlin query functions from labeled SQL files. It treats SQL as the source of truth for database definitions, catching schema errors during the build process before they reach production. The library supports multiple database dialects including SQLite, MySQL, PostgreSQL, HSQL, and H2, and generates platform-specific code for Android, iOS, JVM, and JavaScript targets. It provides a platform-specific driver abstraction that handles database connectivity difference
Defines database schemas using SQL statements that are verified at compile time and generate matching Kotlin types.
ihp 是一个为 PostgreSQL 设计的类型安全 Web 框架和全栈应用编排器。它作为一个服务端渲染框架和类型安全 ORM,能自动从 SQL 模式生成记录类型,以确保编译时的查询验证。 该平台的特色在于在编译时验证路由、数据库查询和模板,以防止运行时崩溃。它使用 WebSocket 实现实时 Web 界面以进行即时数据同步,并采用服务器驱动的超媒体进行部分 DOM 修补。 该框架涵盖了广泛的集成功能,包括支持 Passkey 和 OAuth 的用户身份管理、具有自动迁移功能的完整数据存储层,以及具有类型安全 HTML 模板的综合 UI 渲染系统。它还提供了用于 JSON API 开发、异步后台任务执行以及支付网关金融集成的内置工具。 生产环境通过声明式 NixOS 部署进行管理,以实现可复现的基础设施。
Maintains a canonical SQL file that serves as the declarative definition of the database state.
Standalone Migrations is a Ruby-based utility that provides database schema management and migration capabilities outside of a full web framework. It enables developers to track, version, and apply structural changes to relational databases using standard migration scripts in custom or non-framework environments. The tool distinguishes itself by offering multi-database isolation, allowing for the management of independent data stores within a single project through separate configuration sets and migration paths. It supports dynamic environment-aware configuration, which allows connection set
Captures database structure by exporting raw SQL definitions for version control.