๐ Prisma Accelerate now offers Static IP!
๐ You can secure your database by enabling IP allowlisting and only allow access to it from Accelerate and other trusted IP addresses.
๐๐ฝ Learn how to enable static IP in Accelerate.
๐ฅณย Add this event to your calendar: Prisma &
@MongoDB
Launch Week!
๐๏ธย Dates: April 25th - 29th
๐ Five days of celebration with exciting tutorials, talks, events, and giveaways!
โฌ๏ธย Use this link to access more details and sign up!
๐ฌ Utility of the week: Prisma Editor
Prisma Editor is a tool that provides real-time visualization and editing for your Prisma schema.
Try it out and give it a ๐ on GitHub
๐ฆ Prisma 5 is live
Preview features moved to General Availability:
๐ jsonProtocol: making Prisma faster by default
๐ fieldReference: for comparing columns in the same table
๐ extendedWhereUnique: for using non-unique fields inside where clauses
๐ง Community highlight of the week: Prisma Pagination extension
The extension provides cursor-based and page-number-based pagination methods for your models for retrieving pagination metadata.
๐
๐ฅณย Prisma has raised a Series B financing round!
With this funding, we will continue to invest in developing and adding new features to the open-source ORM while building the Application Data Platform.
๐ Learn more about our vision and plans!
๐ Today, we're thrilled to announce Pulse in Early Access
Pulse is the easiest way to subscribe to database change events and build real-time applications using Prisma Client.
โก๏ธ Join the waitlist now
#PrismaPulse
๐บ๏ธ Package of the week: Prisma DBML Generator
Prisma DBML generator is a great utility for generating entity relationship diagrams using the DBML (Database Markup ) schema, which you can visualize using
๐
๐๏ธ Exciting news! With the 5.0 release, Prisma is now significantly faster.
Read our blog post to understand the performance improvements, how we did it, and the expected benefits of upgrading.
๐ Today's appreciation tweet goes out to
@ridafkih
.
Rida built Schemix, which allows you to compose your Prisma schema using TypeScript.
๐ Give Schemix a try and a star while you're at it on GitHub.
We've been hard at work speeding up cold starts in
#serverless
applications using Prisma!
We're excited to say we've sped up cold start times by ~9xโก๏ธ
Check out this blog post to see how we did it and get real insights into what affected those times:
๐ 5.8.0 is live!
In our first release of the year, we've improved the `relationJoins` Preview feature.
You can now specify what strategy to use when fetching relation data on the query level.
๐ Community highlight of the week: prisma-paginate
prisma-paginate provides utility methods that make it easy and convenient to query paginated data in Prisma Client.
Try it out and give the project a ๐
๐งฐ Prisma utility of the week: prisma-json-types-generator
prisma-json-types-generator converts Prisma Clientโs JSON type to a strongly typed JSON field, enforcing type safety.
โก๏ธ
๐ Another day, another launch!
๐ Edge functions have been reshaping development โ and we're thrilled to announce that you can finally use them with Prisma ORM!
๐ฅณ You can now access your DB from
@vercel
Edge Functions and
@cloudflare
Workers.
5.4.0 is live, and it is ๐ฅ๐ฅ
๐ Preview support for
@planetscaledata
and
@neondatabase
serverless database drivers
๐ Early Access support for
@tursodatabase
๐คฏ (A LOT OF) Query performance improvements
Try it out now!
โ๏ธ Prisma ORM 5.7.0 is out!
It's our last release of the year, and we added two new Preview features for PostgreSQL & CockroachDB:
๐ JOINs on relation queries
๐ Native distinct: the distinct option now using SQL queries
Dive into the details โฌ๏ธ
๐ We hit 30,000 stars on GitHub! ๐ฅณ
๐ A huge thank you to our amazing community for their support and to our team for their hard work.
๐ Stay tuned for the exciting features we have in store.
๐ Today's
#DeveloperFavourite
is
@remix_run
!
It's a full stack web framework that lets you focus on the UI and work back through web fundamentals to deliver a fast, slick, and resilient UX.
Prisma + Remix = ๐
Check it out in their docs:
๐ Prisma ORM 5.10.0 is out
๐๏ธ Optimized relation queries in MySQL
โ๏ธ Configure transaction options in the `PrismaClient` constructor
๐น๏ธ Access the Prisma Data Platform via Prisma CLI
Check out the release notes for more details!
๐ย Prisma ORM v5.11.0 just dropped!
Here's what's new:
๐๏ธ Performance improvements in nested `create` operations
๐ย Edge deployment support in Preview (stay tuned for the official announcement ... ๐)
๐งย Weโre excited to announce that Prisma Client extensions are production-ready!
Using Prisma Client extensions, you can customize Prisma Client to your heartโs desire without losing type-safety. ๐ช
๐ Prisma 4.5.0 is here!
Here are the new features & improvements you can expect.
๐น Filter for non-unique properties (Preview)
You can now add non-unique properties inside the โwhereโ statement for queries that operate on a unique record
๐ New in Preview: Prisma ORM support for serverless database drivers!
You can use HTTP and WebSockets to connect to your database using db drivers by
@neondatabase
and
@planetscale
instead of long-running TCP connections.
More on how to get started ๐
๐ย Prisma now natively supports Embedded Documents for
@MongoDB
!
Generate a type-safe Prisma Client that reads and writes Embedded Documents.
๐ย Learn how to get started in this thread... ๐งตย (1/5)
โICYMI: omitting fields returned by Prisma Client is now in Preview. When returning results, remove sensitive fields with `omit`.
๐ย Learn more in our documentation
๐ค Extension of the week: prisma-gpt by
@AliYeysides
prisma-gpt is a client extension that lets you query your database with natural language using GPT.
Check it out and give it a ๐ on GitHub.
๐ Prisma is now on Discord, and we cannot wait to hang out, chat in real-time, and share ideas with you there.
๐ Huge thanks to the existing community discord for allowing us to adopt it officially.
Read on for more details and how you can join
Friendly competition and debates are part of our dynamic, but supporting Ukraine is one area where we wholeheartedly agree with team
@DrizzleORM
-
Please attend, learn and donate!
Don't forget to join us tomorrow!
We'll be discussing a lot of great ideas about
@DrizzleORM
relations API improvements and checking out many fantastic features from
@arktypeio
๐ We're big fans of
@nextauthjs
, which offers authentication for Next.js:
๐ It's open source
๐ Full of new great features since their recent 3.0.0 release
๐ Comes with support for Prisma
๐
Prisma 4.2.0 is here!
๐ Preview support for tracing in Prisma Client.
With tracing, you can now see how long Prisma takes and what queries are issued in each operation.
๐ Need a hosted PostgreSQL database for your Prisma project?
โ Learn how to setup one for free on
@supabase_io
in this article by
@thisismahmoud_
!
๐ฆ Today's v5.1.0 release focuses on some smaller issues to make the experience of Prisma ORM even smoother!
โก๏ธ Weโve also improved query performance on PostgreSQL & CockroachDB by reducing the number of SQL statements that are sent to the DB.
๐ Todayโs appreciation tweet goes to prisma-console by
@kinjal2209
prisma-console provides a REPL-style allowing you to run Prisma Client queries on your console with full auto-completion support.
Try it out and give it a โญ on GitHub!
๐ Our 4.0.0 release is packed with features that are now Generally Available:
โ๏ธ Improved index configuration with `extendedIndexes`
๐ JSON filtering with `filterJson`
๐ฅ Raw query support with `improvedQueryRaw` and more
๐ย Read the release notes ๐
๐ฅย Prisma 4.3.0
Here are the new features & improvements you can expect in this release.
Field reference support on query filters (Preview) - you can now compare one column with another.
๐ก Type-safe raw SQL queries
Did you know you can improve the DX of writing raw queries using
#SafeQL
to make them type-safe? You can also combine it with features Prisma ORM doesnโt support, e.g. PostGIS.
โฌ๏ธ Learn how to in our guide
๐ Extension feature: prisma-extension-kysely
๐ค The prisma-extension-kysely by
@realEoinOBrien
enables you to combine Prisma and
@kysely_
together to write type-safe raw SQL queries using Prisma Client.
Try it out and give it a ๐ on GitHub
๐ฆ In 4.16.0, we shipped 3 features to General Availability:
๐ Prisma Client extensions
๐ Order by nulls first and last
๐ Filter relation count
Check out the release notes ๐
๐ Unleash real-time power with Pulse: our latest product, soon in Early Access
Pulse allows you to subscribe to real-time data changes in your database, making implementing real-time features in your app effortless.
Secure your waitlist spot at
๐ Prisma ORM 5.9.0 is out
โจ Optimized result set in Prisma Client queries
โ Proper error returned for unreachable DBs (SQL Server)
Stay tuned for more news about performance & edge support in the coming weeks ๐
๐ข Prisma 5.2.0 is live
๐ Query performance improvements
๐ Simplified connection string override in Prisma Client
๐ Improved Prisma Client experience for Prisma Accelerate and Data Proxy
๐ Prisma 5.3.0 is out!
We shipped improvements to Prisma Client, Prisma Migrate & the VS Code extension. We're working on a few bigger projects TBA โ hint, hint, roadmap. ๐
๐ This week's
#FridayFavorite
is Postwoman, a free, fast and beautiful API request builder created by
@liyasthomas
.
It's an in-browser Postman alternative that can be also be installed as a PWA and supports GraphQL!
๐ฝ
๐ We have reached 20,000+ stars on GitHub ๐
We're thankful to our community for all their support and super stoked about everything we have in store ๐
๐Help us reach 30k!
โจ Prisma v4.9.0 is live!
Here are some of the highlights:
โ Multi-schema support for SQL Server (Preview)
โ Database views support (Early Preview)
โ Improved Prisma Client Extensions support (Preview)
โ MongoDB WriteConflict bug fix
๐ข Prisma ORM v5.5.0 is out!
Today, we shipped:
๐ Improvements to the serverless database drivers (Preview)
๐ 3 new flags for the prisma init CLI command
Upgrade and let us know what you think.
โNull vs. Undefined
- What are they?
- How are they different?
- How does Prisma Client differentiate between the two?
Letโs dig into these controversial primitives and how Prisma treats them differently. ๐
๐ย Prisma ORM support for Turso is now in Early Access
@tursodatabase
is an edge-hosted distributed database based on libSQL that brings data closer to your users and minimizes query latency.
Give it a try, and let us know what you think!
๐กDid you know you can compare fields in the same model in Prisma Client?
This feature was introduced in v4.3.0 to enable the use of Prisma Clientโs query API instead of raw queries to compare columns.
๐
๐คฉ Today's highlight: prisma-cursor-stream
It enables you to stream query responses from Prisma Client, making it suitable for working with large data from your DB.
Additionally, it allows you to configure the batching behavior of your queries.
๐
๐ชฉ Community highlight: Bridg
Bridg enables you to query your database using Prisma Client from the frontend, like Firebase or Supabase.
๐ Give it a try and star bridg on GitHub.
๐โจ Our documentation just got a makeover โ say hello to DARK MODE! ๐๐
Dark/Light mode automatically matches your system preferences. While it's a minimal version with no toggle switch at this time, stay tuned for future updates!
#DarkMode
๐๏ธ Did you know you can use read replicas in Prisma Client?
Read replicas enable you to distribute reads across database replicas for high-traffic workloads.
Try it out using the
@prisma
/extension-read-replicas extension.
๐ฅ Community highlight of the week: prisma-kysely
prisma-kysely generates TypeScript types based on your Prisma schema you can use to write type-safe SQL queries in Kysely
๐
๐ย Prisma ORM now lets you choose the best join strategy:
๐ฅ Join data in the DB or on the application-level!
๐ Learn how to use both and the underlying technical details about lateral JOINs with JSON aggregation in PostgreSQL for DB-level data joins.
๐ Ready to level up your skills? Check out our tutorial on building a REST API with
#NestJS
, PostgreSQL, and Prisma!
In this series, we cover:
๐ Data modeling
๐ CRUD operations
๐ REST API
โ Validation
โ Error Handling
๐ Complex Relations