One might think that Excel is a decent CSV editor as it is, but it's not. It is a very capable CSV reader, I do not dispute that. When it comes to writing though, Excel does not match what you'd expect from a mature application: It might change...
Disclaimer: I am not a professional software developer, and my opinion might not be as authoritative as yours. My native language is not English and since my first encounter with computers I have used multiple localized and non-localized computer...
As your code base gets bigger, test automation becomes more and more important. This applies to any development platform, including Power Query / PowerBI. If you reuse your code and improve some low level function later, test automation allows...
This is a step by step guide to getting started with LibPQ, an illustrated version of "Installation and usage" section of the official documentation. Installation LibPQ source code The source code of the library has to be present in each workbook...
This week I have stumbled upon a very thorough review of existing problems and hidden costs of sustaining modern (open source) digital infrastructure. Here it is: Roads and Bridges - The Unseen Labor Behind Our Digital Infrastructure by Nadia...