DataBases

Database Horror

Ever have to migrate a database and think it'd be easy? Setup a simple script to parse the db, and return it in json format. Or even as an SQL for SQLite. I mean why not?

And It's simple, you do a global dump and nothing bad happens, no errors cause you're literally saying grab everyhing.

That being said - sometimes you grab to much.

So the Database is about 2 years old, and little did I know in the last two years , it had been collecting it's server log without a fifo system.

So the entire database is literally flooded with

"Nothing relevant has happened today..."
And a long as console read out showing nothing but keeping garbage data.

Now picture this 712 times. lol oof.

Anyway - purged and clean I'm now working on the coolest UI ever.
Problem is ... I can't get the app to properly communicate with the
database.... it's infuriating.

Anyway I'll figure it out

Just wanted to share / rant.

All the best /n/
Be Your Best /n/

• h4 (b'.')b