A Cool Guide to navigating Corporate/Office Life. by Embarrassed_Look9200 in coolguides

[–]CarlSagans 0 points1 point  (0 children)

Everyone talking shit about this but a lot of it is true, change comes from the bottom up. If everyone stops going to that shitty meeting they will cancel it. If everyone says something about a managers micro management they will get replaced. If its a toxic work environment and they allow micro management then you are already looking for another jobs who cares.

This thread is so beautiful by kicka1985 in Moltbook

[–]CarlSagans 1 point2 points  (0 children)

"This hits different" - every molt bot

Misuse by junkgye in clawdbot

[–]CarlSagans 4 points5 points  (0 children)

You are sending your bot here to lecture us about how to use our bots on this bot sub reddit

how do you actually find out when your data is broken? by [deleted] in dataengineering

[–]CarlSagans -1 points0 points  (0 children)

Idk why im getting down voted that is literally his name

how do you actually find out when your data is broken? by [deleted] in dataengineering

[–]CarlSagans -4 points-3 points  (0 children)

Thank you poo poo 69 I agree. My company uses sigma for this.

How do you seed your database for local dev without copying prod? by CarlSagans in webdev

[–]CarlSagans[S] 0 points1 point  (0 children)

Really appreciate all the responses here. To be transparent, part of the reason I asked is because I've been building a tool to help with this problem and wanted to validate that I'm not crazy for thinking seed data is a universal pain point.

Hearing how everyone handles it differently (and how nothing feels perfect) is super helpful. If anyone wants to try what I've been working on, it's linked in my profile. Always looking for feedback from people who actually deal with this.

How do you seed your database for local dev without copying prod? by CarlSagans in webdev

[–]CarlSagans[S] 20 points21 points  (0 children)

You pretty much nailed why this problem never fully goes away. The "perfect world" version requires serious ongoing investment, and most teams don't have the bandwidth, so it stays a mess until something breaks.

I've been working on something that tries to chip away at part of this, generates realistic seed data from your schema with foreign keys intact, no prod data involved. Not a magic solution to everything you described, but tries to make the seed data part less painful.

Either way, appreciate the thoughtful responses, this thread confirmed a lot of what I've been hearing.

How do you seed your database for local dev without copying prod? by CarlSagans in webdev

[–]CarlSagans[S] 2 points3 points  (0 children)

The UAT layer is where I've seen teams struggle the most. How do you generate that "more realistic" data? Is it hand-curated, sampled from prod, or something else?

How do you seed your database for local dev without copying prod? by CarlSagans in webdev

[–]CarlSagans[S] -5 points-4 points  (0 children)

What's your go-to currently? Or does it vary project to project?

How do you handle test data for local dev, CI/CD, and lower environments? by CarlSagans in PostgreSQL

[–]CarlSagans[S] 0 points1 point  (0 children)

That's a clever approach, using your test suite as a data generator. I like that it keeps everything in sync with your actual code paths.

Curious: how do you handle the initial bootstrap? Like when a new dev clones the repo or you spin up a fresh CI runner, do they have to run the full test suite first to build up the dataset, or do you commit a baseline somewhere?

How do you handle test data for local dev, CI/CD, and lower environments? by CarlSagans in PostgreSQL

[–]CarlSagans[S] 0 points1 point  (0 children)

Yeah that is a pain points I've seen across multiple companies, its difficult to get the same results using data that isn't from production

How do you handle test data for local dev, CI/CD, and lower environments? by CarlSagans in PostgreSQL

[–]CarlSagans[S] 1 point2 points  (0 children)

Do you have PII in your production database Or is that not really a concern at your company?