4 ms·
One time I used Power BI/Power query language to generate an Ed script that contained all versions of all XML documents in a database and turn them into a Git r
by dextercd 2y ago
One time I used Power BI/Power query language to generate an Ed script that contained all versions of all XML documents in a database and turn them into a Git repo.
I still like writing scripts that generate Git repos but I don't use Ed much.
- snthpy 2y agoDo you have anything public on this or similar to this? I'm also a fan of Power Query and M-lang and think it's underappreciated by the dev community. Why did you use PQ in that instance?
- dextercd 2y agoI don't have anything public, unfortunately. It wasn't super complicated. It just generated a long string of all the files with Ed commands around it to change the current file name (f) and invoke Git (!git). I don't remember why I decided to do it this way. I probably couldn't easily connect to the database any other way. Getting the right tools installed might've involved some bureaucracy. Nowadays, I probably would've just dealt with that, but I didn't know at the time how important that janky solution would be to my work. Power BI is not something I miss working with but Power Query is really nice. The fact that the UI generates code that you can tweak afterwards is a great learning tool. I still use it in Excel sometimes.