#drizzle Development Tutorials & Tips | Roast Dev

Create a fullstack Next.js 15 app with Drizzle ORM, Postgresql, Docker

In modern web development, integrating a robust backend with a responsive frontend is crucial for building powerful and scalable applications. With Next.js, creating dynamic full stack applications ha...

15.03.2025 0 Read More

Simplifying Test Data Generation with Drizzle ORM

Introduction At our company, we run tests using an actual database with Testcontainers instead of mocking the database during test execution. To conduct such tests, we need to prepare test da...

16.03.2025 0 Read More

Placegoose: Seeding and deployment with HONC

In the first article of this series, we walked through building Placegoose, a simple mock data API using the HONC stack. My goals were pretty simple: Showcase solutions for common Hono project require...

24.03.2025 0 Read More

Fastify API with Postgres and Drizzle ORM

Before we start, we will need Node.js installed. General Setup Let's create a new directory for our API first: ⛶mkdir fastify-api cd fastify-apiNow, we need to initialize a new project: ⛶n...

31.03.2025 0 Read More

Type-safe ORM for Atlassian Forge SQL: forge-sql-orm with Drizzle support

💡 forge-sql-orm: Type-safe ORM for @forge/sql based on Drizzle Are you working with @forge/sql and tired of writing raw SQL with manual typings? forge-sql-orm brings a structured, type-s...

05.04.2025 0 Read More

Pagination with COUNT(*) OVER() in Atlassian Forge SQL: How to avoid double queries — and stay secure in TypeScript

Are you working with @forge/sql and struggling with pagination + total count? Here's a more efficient and safer way to do it using window functions. 💡 The problem In typical pagination, we ...

06.04.2025 0 Read More