Prisma

Prisma is a type-safe database object-relational mapper that uses a declarative schema to map data models to relational and document databases. It provides a unified toolkit for data access, combining a database driver with tools for schema management and record manipulation.

The project features a multi-database driver that standardizes interactions across PostgreSQL, MySQL, and MongoDB. It includes a system for tracking and applying structural schema migrations across different environments and a graphical user interface for browsing and editing database records.

The system ensures data integrity through static type generation and a type-safe client, allowing for query execution with automatic type checking. It translates high-level data modeling into physical database tables or collections via a declarative schema definition.

Features

Type-Safe Object-Relational Mappers - Provides a complete type-safe ORM that maps declarative schemas to relational and document databases.
Database Mapping - Implements a translation layer that maps declarative schema definitions into relational and document database structures.
Data Abstraction Layers - Provides an abstraction layer that decouples application logic from raw database queries via a programmable interface.
Database Dialect Adapters - Standardizes interaction across different SQL and NoSQL engines by translating internal representations into specific database dialects.
Database Drivers - Provides a unified programmatic interface for interacting with multiple database management systems like PostgreSQL, MySQL, and MongoDB.
Database Schema Migrations - Automates the application of versioned updates to database schemas to maintain structural compatibility with application code.
Database Migration Tools - Manages and automates schema versioning and structural updates to keep different database environments consistent.
Declarative Physical Mapping - Translates high-level data modeling definitions into physical database tables or collections across different storage engines.
Declarative Schema Managers - Uses a declarative data modeling system to reconcile the database state with a desired configuration defined in code.
Multi-Database Connectors - Provides a unified interface for connecting a single application to different database engines like PostgreSQL, MySQL, and MongoDB.
SQL Data Modeling - Defines database tables and relationships using a high-level declarative schema instead of manual SQL commands.
Type-Safe Client Generators - Generates a type-safe database client from schema definitions to ensure compile-time safety during data access.
Type-Safe Database Clients - Ensures compile-time safety for database operations through the generation of strongly-typed interfaces from schemas.
Type-Safe Query Builders - Provides a programmatic interface for retrieving and manipulating records with automatic type checking and compile-time validation.
Type Definition Generators - Automatically synthesizes language-specific type definitions based on the database schema for compile-time validation.
Database Management Interfaces - Offers graphical tools for browsing, editing, and visualizing database records and structures.
Database GUIs - Provides a web-based graphical user interface for the visual management of database structures and records.
Query Engine Binaries - Executes database operations using a compiled low-level binary to ensure high performance and strict type safety.
Visual Database Browsers - Provides a graphical user interface for browsing and manipulating database records to simplify data management.
API Generation - Converts database schemas into real-time GraphQL APIs.

Star 历史

prismagraphqlprismaArchived

Name: prismagraphql/prisma
Author: prismagraphql

View on GitHub

16,393 星标840 分支ScalaApache-2.012 次浏览v1.prisma.io/docs

Prisma

Features

Type-Safe Object-Relational Mappers - Provides a complete type-safe ORM that maps declarative schemas to relational and document databases.
Database Mapping - Implements a translation layer that maps declarative schema definitions into relational and document database structures.
Data Abstraction Layers - Provides an abstraction layer that decouples application logic from raw database queries via a programmable interface.
Database Dialect Adapters - Standardizes interaction across different SQL and NoSQL engines by translating internal representations into specific database dialects.
Database Drivers - Provides a unified programmatic interface for interacting with multiple database management systems like PostgreSQL, MySQL, and MongoDB.
Database Schema Migrations - Automates the application of versioned updates to database schemas to maintain structural compatibility with application code.
Database Migration Tools - Manages and automates schema versioning and structural updates to keep different database environments consistent.
Declarative Physical Mapping - Translates high-level data modeling definitions into physical database tables or collections across different storage engines.
Declarative Schema Managers - Uses a declarative data modeling system to reconcile the database state with a desired configuration defined in code.
Multi-Database Connectors - Provides a unified interface for connecting a single application to different database engines like PostgreSQL, MySQL, and MongoDB.
SQL Data Modeling - Defines database tables and relationships using a high-level declarative schema instead of manual SQL commands.
Type-Safe Client Generators - Generates a type-safe database client from schema definitions to ensure compile-time safety during data access.
Type-Safe Database Clients - Ensures compile-time safety for database operations through the generation of strongly-typed interfaces from schemas.
Type-Safe Query Builders - Provides a programmatic interface for retrieving and manipulating records with automatic type checking and compile-time validation.
Type Definition Generators - Automatically synthesizes language-specific type definitions based on the database schema for compile-time validation.
Database Management Interfaces - Offers graphical tools for browsing, editing, and visualizing database records and structures.
Database GUIs - Provides a web-based graphical user interface for the visual management of database structures and records.
Query Engine Binaries - Executes database operations using a compiled low-level binary to ensure high performance and strict type safety.
Visual Database Browsers - Provides a graphical user interface for browsing and manipulating database records to simplify data management.
API Generation - Converts database schemas into real-time GraphQL APIs.

Prisma 的开源替代方案

相似的开源项目，按与 Prisma 的功能重合度排序。

prisma/prisma
prisma/prisma
46,366在 GitHub 上查看
Prisma is a database toolkit that provides a unified access layer for interacting with relational and document databases. It centers on a declarative schema modeling approach, where developers define their data structures in a human-readable language. This schema serves as the single source of truth, from which the toolkit automatically generates type-safe database clients that provide compile-time validation and editor autocomplete for all data operations. The project distinguishes itself through a high-performance, Rust-based query engine that handles query planning and connection pooling o
TypeScriptcockroachdbdatabasejavascript
在 GitHub 上查看46,366
prisma/prisma1
prisma/prisma1
16,393在 GitHub 上查看
Prisma1 is a TypeScript object-relational mapper and type-safe database client designed for interacting with relational databases. It functions as a system for declarative schema modeling, where database structures are defined in a single schema file that automatically synchronizes with the underlying database. The project provides a type-safe query builder that generates a custom client to ensure database queries match defined schema types at compile time. It also includes a database GUI administrator, providing a visual web interface for browsing, editing, and managing relational database r
Scala
在 GitHub 上查看16,393
drizzle-team/drizzle-orm
drizzle-team/drizzle-orm
34,835在 GitHub 上查看
Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.
TypeScriptormtypescriptsql
在 GitHub 上查看34,835
simolus3/drift
simolus3/drift
3,231在 GitHub 上查看
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
Dartdartdart-build-systemflutter
在 GitHub 上查看3,231

查看 Prisma 的所有 30 个替代方案

常见问题解答

prismagraphql/prisma 是做什么的？

prismagraphql/prisma 的主要功能有哪些？

prismagraphql/prisma 的主要功能包括：Type-Safe Object-Relational Mappers, Database Mapping, Data Abstraction Layers, Database Dialect Adapters, Database Drivers, Database Schema Migrations, Database Migration Tools, Declarative Physical Mapping。

prismagraphql/prisma 有哪些开源替代品？

prismagraphql/prisma 的开源替代品包括： prisma/prisma — Prisma is a database toolkit that provides a unified access layer for interacting with relational and document… prisma/prisma1 — Prisma1 is a TypeScript object-relational mapper and type-safe database client designed for interacting with… drizzle-team/drizzle-orm — Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and… simolus3/drift — Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database… geldata/gel — Gel is an object-relational database system that models data as a graph of interconnected objects. By utilizing a… mikro-orm/mikro-orm — Mikro-ORM is a TypeScript-based object-relational mapping system that provides a unified persistence layer for Node.js…