Ent is a statically typed entity framework for Go that models database structures as a graph of nodes and edges. It functions as a code generation engine that transforms schema definitions into type-safe database clients, query builders, and migration scripts. By representing data as interconnected entities, the framework enables intuitive traversal of complex relationships and ensures that database interactions remain consistent with the application model at compile time. The framework distinguishes itself through its graph-based approach to data modeling and its reliance on compile-time cod
sqlboiler is a database-first ORM generator for Go that analyzes an existing database schema to produce strongly typed structures and query helpers. It functions as a schema-driven code generator, transforming database tables and relationships into executable Go source code. The project distinguishes itself through a type-safe query builder that uses chainable modifiers to construct SQL statements, eliminating the need for raw string concatenation. It utilizes customizable text templates to generate source code, allowing for the aliasing of schema entities and the creation of custom templates
Kysely is a TypeScript SQL query builder that provides a type-safe interface for constructing and executing database queries. It functions as a database layer that ensures schema compliance and prevents runtime errors by using a fluent interface and a programmable way to build complex SQL statements. The project features a type-safe database layer capable of inferring return types and aliases from SQL selections and joins. It also includes a SQL migration manager to track and apply schema changes across different environments to keep database versions synchronized. The toolkit covers relatio
Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database tables to classes and execute SQL queries with build-time validation. It functions as a type-safe query builder and a wrapper for SQLite and PostgreSQL, eliminating manual result set parsing by binding query outputs to native objects. The project distinguishes itself through a build-time code generation system that produces type-safe APIs and validates raw SQL statements against database versions before execution. It features reactive query streaming, which transforms SQL queries
Prisma Client is a database client for Node.js and TypeScript applications that provides a type-safe interface for interacting with relational databases. It functions as an object-relational mapper that translates declarative schema definitions into strongly typed query interfaces, ensuring that database operations align with the underlying data structure.
The main features of prisma/prisma-client-js are: Node.js Database Integration, Database ORMs, Type-Safe Database Clients, Type-Safe Query Builders, Compile-Time Schema Integrations, Database Agnostic Generators, Fluent Query Builders, Query Engine Binaries.
Open-source alternatives to prisma/prisma-client-js include: ent/ent — Ent is a statically typed entity framework for Go that models database structures as a graph of nodes and edges. It… aarondl/sqlboiler — sqlboiler is a database-first ORM generator for Go that analyzes an existing database schema to produce strongly typed… kysely-org/kysely — Kysely is a TypeScript SQL query builder that provides a type-safe interface for constructing and executing database… simolus3/drift — Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database… alibaba/alisql — AliSQL is a fork of MySQL by Alibaba that extends the relational database management system with enhancements for high… prismagraphql/prisma — Prisma is a type-safe database object-relational mapper that uses a declarative schema to map data models to…