#postgres Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Clerk integrates with a Next.js application using Supabase

Supabase is one of the most popular backend platforms on the web, but it breaks from traditional architecture patterns when accessing data.Full-stack applications typically have distinct frontend and ...

01.04.2025 0 Read More

Implementing multi-tenancy into a Supabase app with Clerk

Collaborative software is on track to become a nearly $53 billion* industry by 2032. Needless to say, adding collaborative, multitenant features into your application will position you to capture a pi...

01.04.2025 0 Read More

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

This post is maintained by Bytebase, an open-source database DevSecOps tool that can manage both Postgres and SQL Server. We update the post every year. Update History Comment 2025/03/26 Initi...

01.04.2025 0 Read More

10M IoT Data Points Daily at 50% Lower Storage Costs Using PostgreSQL

TL;DR: Trebellar manages 10M daily IoT sensor readings from commercial buildings while cutting storage costs by half. Their engineering team accomplished this with just "five lines of code" by impleme...

02.04.2025 0 Read More

How Real-Time Analytics in Oil & Gas Prevents Million-Dollar Failures

Industrial IoT deployments present some of the most challenging data engineering problems in production environments today. When you're dealing with critical infrastructure where failures cost million...

02.04.2025 0 Read More

Writing an LLM Eval with Vercel's AI SDK and Vitest

The Xata Agent Recently we launched Xata Agent, an open-source AI agent which helps diagnose issues and suggest optimizations for PostgreSQL databases.To make sure that Xata Agent still works...

03.04.2025 0 Read More

Foreign Keys: A must in SQL, but not in a Document Database?

In relational SQL databases, foreign keys are essential for guaranteeing referential integrity. There are two main reasons to declare them, particularly regarding their cascading behavior: Enforcing S...

03.04.2025 0 Read More

Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

TL;DR Ever built something where two users tried to update the same record at the same time, and everything broke? Or maybe you ran into those weird bugs where a user sees stale data or, wors...

04.04.2025 0 Read More

Optimizing UPDATE of millions of rows easily

The other day, we received a file containing buildings with their number of dwelling and a matching identifier important to us, weighted by a score indicating the quality of the matching. The idea is ...

05.04.2025 0 Read More

Connecting Database with NestJS Using Prisma ORM

Hello Backend devs...Time to connect NestJS application with a database. There are many databases can be connected with NestJS, including Sql or NoSql types. Choosing a right database is another cruci...

06.04.2025 0 Read More

Clerk integrates with a Next.js application using Supabase

Implementing multi-tenancy into a Supabase app with Clerk

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

10M IoT Data Points Daily at 50% Lower Storage Costs Using PostgreSQL

How Real-Time Analytics in Oil & Gas Prevents Million-Dollar Failures

Writing an LLM Eval with Vercel's AI SDK and Vitest

Foreign Keys: A must in SQL, but not in a Document Database?

Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

Optimizing UPDATE of millions of rows easily

Connecting Database with NestJS Using Prisma ORM

#reading

#popular