Let's Talk About Database Performance

TL;DR

Database.js and Prisma offer a better developer experience for working with databases, but Prisma comes with performance drawbacks, while Database.js provides faster performance without sacrificing developer experience.

Transcript

databases love them hate them you probably still need them sequel no sequel graphql sequel whatever you're using it's not easy to work with and the few things that are easy to work with like Prisma come with their own gotchas it feels like when new tools are introduced that improve the developer experience with databases they often come at performa... Read More

Key Insights

• 😍 Prisma provides an incredible developer experience by allowing developers to write SQL as autocompleting TypeScript and have type-safe responses. However, it comes with some technical debt from V1.
• 🚀 Database.js by PlanetScale is a promising technology that offers a library and an HTTP-based SQL endpoint. It allows developers to query and mutate data from a database without connecting via SQL, resulting in faster performance and smaller bundle sizes.
• 😱 Using Prisma on Lambda can lead to significant performance penalties, with cold start times reaching up to 3 seconds. Running Prisma on the edge is nearly impossible due to its dependence on node and Rust native code.
• 💪 Database.js offers a better performance solution by eliminating the need for a connection to be made, resulting in faster response times and a smaller bundle size for deployment to the edge.
• 😎 Keisley, a query builder by Sammy, enhances the developer experience by making querying databases in TypeScript type-safe. It provides autocomplete and type-safe responses, although it requires writing type definitions.
• 💻 Jacob has created Keasley PlanetScale, a binding that allows developers to use Keasley with Database.js and connect to the PlanetScale service. This integration simplifies the process of querying the database and leveraging the benefits of type safety.
• ✅ With the combination of Keasley and Database.js, developers have the potential to create a Best in Class developer and user experience by sharing a schema between these tools and improving the overall performance and developer experience of working with databases.
• 🌍 Deploying applications on the edge with Database.js can significantly improve performance by reducing the total distance traveled and speeding up server startup times. However, deciding whether to put the server close to the user or the database depends on the nature of the requests and the number of queries made.

Questions & Answers

Q: How does Prisma improve the developer experience for working with databases?

Prisma provides a single-schema approach, where developers write SQL queries in TypeScript, benefiting from autocompletion and type-safe responses.

Q: What are the performance drawbacks of using Prisma, especially in serverless environments?

Prisma's large bundle size and the need to establish a database connection result in slow response times, which can be exponentially worse when multiple queries are involved.

Q: How does Database.js address the performance issues of Prisma?

Database.js eliminates the need to establish a SQL connection, which significantly improves performance, especially in serverless and edge environments where there are no cold start delays.

Q: How does Database.js work with Keasly to provide a type-safe querying experience?

Keasly is a query builder that, when combined with Database.js and appropriate type definitions, enables efficient and type-safe SQL querying in TypeScript projects.

Summary & Key Takeaways

• Prisma offers a great developer experience with autocompleting TypeScript and type-safe responses, but it has performance issues, especially in serverless and edge environments.

• Database.js by Planet Scale is a promising technology that provides a library and an HTTP-based SQL endpoint for querying and mutating data without the need for a SQL connection, resulting in faster performance.

• The combination of Database.js and Keasly, a query builder, allows for type-safe and efficient querying in TypeScript, although there are still challenges with generating type definitions.