Prisma vs Trino

Overview

Prisma

Stacks1.3K

Followers974

Votes55

GitHub Stars44.2K

Forks1.9K

Trino

Stacks35

Followers35

Votes0

GitHub Stars12.1K

Forks3.4K

🔥 Trending in Languages on StackShare

JavaScript Languages

Lightweight, interpreted, object-oriented language with first-class functions

Try it View Docs Alternatives

Try

499

284k

Detailed Comparison

Prisma	Trino
Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.	It is a fast distributed SQL query engine for big data analytics that helps you explore your data universe. It is designed to query large data sets distributed over one or more heterogeneous data sources.
Auto-generated and type-safe query builder for Node.js & TypeScript; Declarative data modeling & migration system; GUI to view and edit data in your database; Single source of truth for database and application models; Auto-completion in code editors instead of needing to look up documentation; Less boilerplate so developers can focus on the important parts of their app; Queries not classes to avoid complex model objects;	Highly parallel and distributed query engine; Simplicity; Versatile; In-place analysis
Statistics
GitHub Stars 44.2K	GitHub Stars 12.1K
GitHub Forks 1.9K	GitHub Forks 3.4K
Stacks 1.3K	Stacks 35
Followers 974	Followers 35
Votes 55	Votes 0
Pros & Cons
Pros 12 Type-safe database access 10 Open Source 8 Auto-generated query builder 6 Supports multible database systems 6 Increases confidence during development Cons 2 Doesn't support downward/back migrations 1 Mutation of JSON is really confusing 1 Do not support JSONB 1 Doesn't support JSONB 1 Do not support JSONB	No community feedback yet
Integrations
TypeScript Node.js Microsoft SQL Server PostgreSQL Serverless Apollo SQLite MongoDB GraphQL MariaDB	Kafka Prometheus Druid MySQL Elasticsearch MongoDB PostgreSQL Superset Amazon S3 Clickhouse

What are some alternatives to Prisma, Trino?

GraphQL

GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012.

Sequelize

Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.

Apache Spark

Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.

Presto

Distributed SQL Query Engine for Big Data

Amazon Athena

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

PostGraphile

Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database

Apache Flink

Apache Flink is an open source system for fast and versatile data analytics in clusters. Flink supports batch and streaming analytics, in one system. Analytical programs can be written in concise and elegant APIs in Java and Scala.

lakeFS

It is an open-source data version control system for data lakes. It provides a “Git for data” platform enabling you to implement best practices from software engineering on your data lake, including branching and merging, CI/CD, and production-like dev/test environments.

OData

It is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. It helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc.