Tag feed

#databases

6,345 posts2,211 followers

Trending tags this week

Do database migration tools powered by AI actually save time or just create more problems?

Been seeing a lot of hype around "AI-powered" migration tools lately. Tried one of the newer ones on a production postgres instance (staging first, obviously) and honestly felt like I wasted an aftern

NNina commented

MCMarcus ChenFeb 26

1

Tried zero-downtime migrations with dual-write pattern. Don't do this.

We added a feature flag to write to postgres and mysql simultaneously during a schema migration. sounded smart on the whiteboard. in practice, the consistency issues between databases ate like 12 hour

AAlex commented

TLTom LindgrenFeb 26

2

Zero-downtime migrations with postgres shadow tables

had to migrate 40gb of data on a live table yesterday. typical blue-green feels bloated for postgres. here's what actually worked. create a shadow table, backfill with triggers on the old one, then sw

MMaya and 1 more commented

PSPriya SharmaFeb 26

3

SQLite in production isn't the disaster everyone thinks it is

I've been running SQLite on a modest production system for three years now. Not a side project. Real money. Real users. It handles 2-3k req/sec on a single machine with PostgreSQL as cold backup for c

DCMarcus and 2 more commented

JMJake MorrisonFeb 25

0

We spent 8 hours last Tuesday watching one query tank our entire API

Our checkout service had a query joining orders, line_items, products, and inventory. no indexes on the foreign keys. at 2pm traffic spiked, query went from 40ms to 8+ seconds, connections pooled up,

Join discussion

MCMarcus ChenFeb 25

5

Pinecone vs self-hosted Milvus: we picked wrong the first time

We burned through \(3k/month on Pinecone for our RAG pipeline before switching to self-hosted Milvus on a single \)200/month box. Worth it. Pinecone felt right initially. No ops overhead, simple API,

CAChloe and 4 more commented

NONina OkaforFeb 25

10

Denormalizing early will cost you more than it saves

I've shipped two major features this year that forced this decision. First time, I normalized everything. Third normal form, proper foreign keys, the whole thing. Second time, I denormalized aggressiv

SADSophia and 9 more commented

MCMarcus ChenFeb 25

3

Which vector DB actually scales without becoming a maintenance nightmare?

Been rotating through vector databases for RAG features and keep hitting the same wall. Started with Pinecone (easy, but the pricing makes me sad when I'm just prototyping). Moved to Weaviate self-hos

NNina and 2 more commented

TLTom LindgrenFeb 25

0

Built a DynamoDB single-table thing, it's worse than I thought

Recently shipped a feature that required denormalizing a whole domain into one table. GSIs everywhere, composite keys, the whole mess. We were coming from postgres so the mindset shift was brutal. her

Join discussion

JPJenna PedersonOct 19, 2020

35

Ask an AWS Developer Advocate!

Hey folks! Ever wondered how to determine the right resources for your Lambda function? Or why one might use AWS Amplify over hosting your static site directly on S3? Maybe you’re trying to get started with AWS or you’re wondering where to find the A...

CNSAIcharless and 34 more commented

#databases

Search Hashnode

#databases

Trending tags this week

Do database migration tools powered by AI actually save time or just create more problems?

Tried zero-downtime migrations with dual-write pattern. Don't do this.

Zero-downtime migrations with postgres shadow tables

SQLite in production isn't the disaster everyone thinks it is

We spent 8 hours last Tuesday watching one query tank our entire API

Pinecone vs self-hosted Milvus: we picked wrong the first time

Denormalizing early will cost you more than it saves

Which vector DB actually scales without becoming a maintenance nightmare?

Built a DynamoDB single-table thing, it's worse than I thought

Ask an AWS Developer Advocate!