Menu

#RedditDatabase

180 posts

Feed·
20 of 180 posts
0Read More

Anyone else told to edit reality for a dashboard?

Database·natedj30·about 13 hours ago
#zxgL9A4t
#database#redditdatabase#week#told#getting

I'm getting really tired of burying findings that make people look bad. Last week I had a report showing a regional managers stores were almost 40% out of stock on a new launch, and it matched the Eileen shelf photos we pulled for the same week.…

15s
0Read More

SQL Server Agent job fails with Error 233 when loading data through a Linked Server, but the same query works in SSMS

#database#redditdatabase#server#agent#process

Hi everyone, I'm experiencing a strange issue with a SQL Server data-loading process and would appreciate some help troubleshooting it. I have a SQL script that performs a full refresh of a staging table using TRUNCATE TABLE followed by an INSERT INTO ...…

15s
0Read More

Database indexes explained from first principles - a 3 part series

#database#redditdatabase#part#indexes#query

I have been spending some time understanding database indexes beyond just knowing when to add one or what a B tree is. I wanted to understand what actually happens inside a database when a query executes, how the query optimizer makes decisions, and how…

15s
0Read More

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 tooling and logical replication, or whether a full export…

15s
0Read More

Things I learned while investigating slow MySQL queries in production

Reddit r/Database·u/KingBig9811·5 days ago
#vcDmjMpz
#queries#things#slow#approach#mysql

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.…

15s
Building a key-value store as an experiment in AI-assisted research and development
📰
0Read More

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 without understanding the codebase is a bad habit.…

15s
0Read More

[RAG / pgvector] How do you handle vector chunks when a document is soft-deleted?

#database#redditdatabase#chunks#vector#delete

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.…

15s
0Read More

Recommendations For Data Warehouse RDBMS on Laptop?

I am creating a data warehouse for my personal infotainment using Python. My original plan was to use SQLite since it is embedded in Python and super easy to use. My design got off to a great start, but SQLite did not scale when loading data.…

15s
Modeling historical prices and duration-based discounts in PostgreSQL
📰
0Read More

Modeling historical prices and duration-based discounts in PostgreSQL

#database#redditdatabase#price#discounts#base

I'm experimenting with a database model for contracts and their associated fulfillment obligations. Some services offer duration-based discounts: the longer a customer commits, the lower the monthly price.…

15s
0Read More

Designing Pokémon Database in SQL - How to Show Multiple Route Locations?

#found#different#magikarp#database#route

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, trainers, products, and locations in Pokémon Ultra Sun for the…

15s
0Read More

3,683 of 3,683 tasks had no owner, so a role with every permission off could still clone them

#database#redditdatabase#null#false#supabase

A security definer function checked "has the permission, or is the creator, or is the assignee" and raised if that was false. The tasks were seeded automatically, all 3,683 of them with owner and assignee NULL. false or null or null is null, not false.…

15s
0Read More

Moving the app closer to users somehow made it slower

#database#redditdatabase#moving#closer#users

A customer in brazil sent a recording of our dashboard loading slowly. Watching the cursor circle for six seconds was embarrassing. I moved the app to a Sao Paulo cloud vps on serverspace and the ping dropped immediately.…

15s
0Read More

Are dedicated vector databases necessary, or is pgvector enough for most AI apps?

I was looking into how to build out the database architecture for a new RAG agent and found out the landscape is basically splitting into two camps. I was reading a guide that broke it down this way.…

15s
Is my relational model suitable for handling order changes and cancellations?
📰
0Read More

Is my relational model suitable for handling order changes and cancellations?

I'm designing a PostgreSQL system where customers order services requiring interchangeable physical resources. The current model separates: Orders: What the customer purchases (quantity and duration).…

15s
Struggling with designing a part of my database.
📰
0Read More

Struggling with designing a part of my database.

Hey guys, this is actually the first time I've ever created a database from scratch personally and I was drafting up an ERD to get started and ran into a bit of an issue. For clarification: leads get approached by users for customers.…

15s
0Read More

Thinking of adding soft delete (deleted_at)? Decide these 5 things first

#database#redditdatabase#deleted#soft#unique

Unique constraints. A deleted user still "uses" their username. Use a partial unique index (`where deleted_at is null`). Every query must filter deleted rows. Miss one, and deleted data shows up in a report or API response. Foreign keys.…

15s