website-thomas-astro VS Prisma

Since Drizzle abstracts away the differences between Postgres & LibSQL behind the scenes, I didn't have to change much to my queries. This made the migration very easy. Having the type-safety of Drizzle, I could just do the changes and do a quick type-check to see if any TS errors popped up, if there weren't any, I was done. Now the migration's done, I don't have to worry about hitting the limits of the free tier anywhere soon, and the DX got even better, double win! If you want to see the changes I had to do to move from Vercel Postgres to Astro DB in code, you can check this compare. You'll see a lot of the changed files are from moving my pages/page-views route to a static route, and handling all the data fetching for it on the client side. This was mainly done to avoid seeing an empty page for too long while server rendering the dataset.

Full code can be found on GitHub, live data can be seen on my website.

Hope this was helpful! Source code can be found on my Github as always.

I must say I really enjoy working with Astro for writing Markdown/MDX, especially when they make it this easy! Source code can be found on Github. An example of a tag page can be found here.

Hopefully this helps other people wanting to use serverless/edge API functions in their Astro projects. Source code can be found here.

To make my code run locally too, I needed to change the DATABASE_URL environment variable to make it point directly to PlanetScale instead of going through Prisma Proxy. Go check it out on my blog, and add a comment ;-). Source code can be found on my Github.

In the world of software development, there are two kinds of developers: those who have never had to complain about ORMs and those who have actually used them. Whether it’s Django ORM for Python, Active Record for Ruby, GORM for Golang, Doctrine for PHP, or Prisma for TypeScript, a common issue persists: writing simple queries is straightforward, but constructing complex or optimized queries can take hours, if not days.

Support for a Union type #2505

generator client { provider = "prisma-client-js" binaryTargets = ["native", "rhel-openssl-1.0.x"] } datasource db { provider = "postgresql" // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below // Further reading: // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string url = env("DATABASE_URL") } model Post { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt createdBy User @relation(fields: [createdById], references: [id]) createdById String @@index([name]) } // ... rest of the schema

Unfortunately Prisma hasn’t supported polymorphism yet. As such, you can't use inheritance to model the entity in the same way as in your programming language, as depicted in the above class diagram. The good news is that we could intimate it using table inheritance to imitate it.

In this project I am manually declaring the data types. For better type-safety, use Prisma, which automatically generates types based on your database schema.

When you're creating a full-stack application, you'll also need to write logic to interact with your database. For relational databases like Postgres, you can do this with SQL, or an ORM like Prisma.

Prisma is a modern TypeScript-first ORM that allows you to manage database schemas easily, make queries and mutations with great flexibility, and ensure excellent type safety.

Prisma

There have been multiple feature requests to add native support for AsyncLocalStorage to Prisma, but they haven't been met with much enthusiasm from the maintainers. Some people solved it by extending and overriding the client (which is arguably prone to breaking with updates).