Menu

#Sql

314 posts

Feed·
20 of 314 posts
How do you keep yourself from running the wrong UPDATE on production? Here's what I built into my client
📰
0Read More

How do you keep yourself from running the wrong UPDATE on production? Here's what I built into my client

#sql#redditsql#nicedb#without#connection

Everyone has a story about an UPDATE without a WHERE, or the right query in the wrong tab. I built NiceDB, an open-source database client, around that problem: a production connection is marked everywhere it appears (tree, tab, title bar, status line) and…

15s
0Read More

My churn query showed 0 churn every month. It was a missing-row problem

#sql#redditsql#month#prev#customer

was doing a simple MRR breakdown (new / expansion / churn per month) and churn came out as 0 every single month. looked great for about a minute small version of the data: ``` customer | month | mrr A | 2025-01 | 100 A | 2025-02 | 100 A | 2025-03 | 100 B…

15s
0Read More

How to connect Oracle Database 19c from host machine to VirtualBox guest machine ?

#sql#redditsql#machine#oracle#database

Hi everyone, i want to access the oracle database on my guest machine (on VirtualBox) using my host machine (both machines are on windows 11) , i have already set up oracle client on my host machine but i couldn’t figure out how to connect it to the…

15s
Designing Pokémon Database in SQL - How to Show Multiple Route Locations?
📰
0Read More

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

#sql#redditsql#know#reposting#violates

Let me know if reposting this violates the "no solicitation for others to do your homework" rule, I'm just genuinely asking if there is a better way to do this than what my beginner mind has imagined lol submitted by /u/publicherstorian [link] [comments]

15s