- Designing Pokémon Database in SQL - How to Show Multiple Route Locations?
Hello! I'm taking my first database design course in grad school and our final project is to make our own databook on any topic we want. I chose to make a database of all the Pokémon, moves,...
15 points13 comments4 d ago
- [RAG / pgvector] How do you handle vector chunks when a document is soft-deleted?
Hi everyone, I'm building an ingestion pipeline for a RAG system. My tech stack relies on PostgreSQL for relational data and pgvectore for storing text chunks and performing similarity searches....
4 points5 comments2 d ago
- Database Indexing Isn't Magic. Understand It From Scratch
3 points0 comments2 d ago
- Is data transfer speed still a major bottleneck when migrating from on-premise to Snowflake?
1 points1 comment3 d ago
- Does anyone test how easy/hard it is to leave a managed database before committing?
I was going through a checklist for evaluating managed Postgres and one section was about getting out of the DB again. The questions are whether you can move data out with standard Postgres...
1 points0 comments9 h ago
- New In-Memory Database Purpose-Built for AI Agents by Neo4J
1 points0 comments11 h ago
- Building a key-value store as an experiment in AI-assisted research and development
I used AI to explore approaches, discuss tradeoffs, and work through implementation. It helped me finish the project much faster. But it also reinforced something for me: trusting generated code...
1 points0 comments13 h ago
- Superstore Dataset
1 points0 comments18 h ago
- Things I learned while investigating slow MySQL queries in production
I've been spending some time investigating slow MySQL queries in production recently. Thought I'd put together some notes on the approach I followed and a few things I found useful along the way....
1 points0 comments1 d ago
- What could our tools do to make working with Oracle Database, easier?
1 points0 comments1 d ago