3 ms·
DOGE doesnt need sudo, just a READ-only access to the the most recent (read: last month's) database backup is enough. when I was a data analyst, I rarely conne
by slt2021 2y ago
DOGE doesnt need sudo, just a READ-only access to the the most recent (read: last month's) database backup is enough.
when I was a data analyst, I rarely connected to live production DB to do Exploratory data analysis (this is what DOGE is doing). Because running OLAP queries on live OLTP system is problematic.
But having my own instance of DB with a restored backup of data was more than enough for analysis:
1. I could modify schema, create indexes to speed up my queries
2. Could create materialized view to join bunch of dimension tables
3. Could create temp tables for intermediary analysis steps, sumamries, etc etc.
If I were DOGE, I would just ask for a a yesterday's Backup database restored on a single server (isolated from PROD environment completely) and just would do all my analysis there
- ggm 2y agoThat's smart. A lot of places do cold or nearline storage offsite so i guess if it wasn't superenciphered (or, if you were given the key) it's lowish impact to clone from that.
- slt2021 2y agothey are supposed to have a protocol to restore DB from a backup, so just execute that standard procedure on a dedicated isolated server