News for hackers. Stuff that matters.
Re:S/Sed/Ed by dextercd on Thursday November 14, 2024 @07:24PM (#42142771)
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.

Re:S/Sed/Ed by snthpy on Friday November 15, 2024 @12:31AM (#42144199)
Do 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?

Re:S/Sed/Ed by dextercd on Friday November 15, 2024 @02:20PM (#42149962)
I 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.