Need advice about which tool to choose?Ask the StackShare community!

Oracle PL/SQL

Stacks675

Followers526

+ 1

Votes8

Prisma

Stacks753

Followers813

+ 1

Votes52

Add tool

Oracle PL/SQL vs Prisma: What are the differences?

Oracle PL/SQL: It is a combination of SQL along with the procedural features of programming languages. It is available in Oracle Database, TimesTen in-memory database, and IBM DB2. Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database; Prisma: Prisma makes working with databases easy. Prisma is a powerful database tool used for data access, migrations and visual data management. It replaces traditional ORMs and removes friction from complicated database workflows.

Oracle PL/SQL and Prisma can be categorized as "Query Languages" tools.

Prisma is an open source tool with 15.2K GitHub stars and 886 GitHub forks. Here's a link to Prisma's open source repository on GitHub.

Powersports Auction, Seistreinta, and AnkaWorld are some of the popular companies that use Prisma, whereas Oracle PL/SQL is used by Matrix Absence Management Inc, Pre2000, and CUBE. Prisma has a broader approval, being mentioned in 21 company stacks & 73 developers stacks; compared to Oracle PL/SQL, which is listed in 12 company stacks and 31 developer stacks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.

Learn More

Pros of Oracle PL/SQL

Pros of Prisma

2
Multiple ways to accomplish the same end
2
Powerful
1
Not mysql
1
Massive, continuous investment by Oracle Corp
1
Extensible to external langiages
1
Pl/sql

11
Type-safe database access
10
Open Source
8
Auto-generated query builder
6
Supports multible database systems
6
Increases confidence during development
4
Productive application development
4
Built specifically for Postgres and TypeScript
2
Supports multible RDBMSs
1
Robust migrations system

Sign up to add or upvote prosMake informed product decisions

Cons of Oracle PL/SQL

Cons of Prisma

2
High commercial license cost

2
Doesn't support downward/back migrations
1
Doesn't support JSONB
1
Do not support JSONB
1
Mutation of JSON is really confusing
1
Do not support JSONB
0
Jjj

Sign up to add or upvote consMake informed product decisions

- No public GitHub repository available -

What is Oracle PL/SQL?

It is a powerful, yet straightforward database programming language. It is easy to both write and read, and comes packed with lots of out-of-the-box optimizations and security features.

What is Prisma?

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.

Need advice about which tool to choose?Ask the StackShare community!

Jobs that mention Oracle PL/SQL and Prisma as a desired skillset

Software Engineer

Warsaw, POL

View Job Details

Backend Engineer, Search Product

San Francisco, CA, US; , CA, US

View Job Details

Full Stack Sr Software Engineer

CBRE

United States of America Texas Richardson

View Job Details

+20

Software Engineer II, (Backend) Runtime

Postman

, India

View Job Details

See jobs for Oracle PL/SQL

See jobs for Prisma

What companies use Oracle PL/SQL?

What companies use Prisma?

See which teams inside your own company are using Oracle PL/SQL or Prisma.

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Oracle PL/SQL?

What tools integrate with Prisma?

Sign up to get full access to all the tool integrationsMake informed product decisions

What are some alternatives to Oracle PL/SQL and Prisma?

PostgreSQL

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

Oracle

Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.

MySQL

The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

MongoDB

MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.

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.

See all alternatives

Oracle PL/SQL vs Prisma

Need advice about which tool to choose?Ask the StackShare community!

Pros of Oracle PL/SQL

Pros of Prisma

Sign up to add or upvote prosMake informed product decisions

Cons of Oracle PL/SQL

Cons of Prisma

Sign up to add or upvote consMake informed product decisions

What is Oracle PL/SQL?

What is Prisma?

Need advice about which tool to choose?Ask the StackShare community!

What companies use Oracle PL/SQL?

What companies use Prisma?

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Oracle PL/SQL?

What tools integrate with Prisma?

Sign up to get full access to all the tool integrationsMake informed product decisions

Related Comparisons

Trending Comparisons

Top Comparisons