Frew Schmidt writes about Perl, Go, Unix tooling, AWS debugging, and plain-text workflows from a working engineer's perspective.
HN links it for practical how-tos, like Go and Zig cross-compilation, MS ODBC driver setup on Debian, and doing passwords right with DBIx::Class.
Well the problem is, if you don't use an ORM, you'll invent one yourself...only poorly. And new hires will end up taking a ton of time to learn this "custom" orm framework of yours.
And there are many bad, or simply, "too simple" ORMs out there that really don't help you much. I haven't really found one better than Perl's DBIx::Class (though outside of Java, Python, Ruby, I have haven't really looked).
Case in point, I recently found this little gem[0] allowing easy correlated subqueries. I basically took a webpage that was loading in over 2 minutes, and reduced it to about 100ms and the outputted SQL was about 2 pages long (from about half a page of custom resultset orm code). I used several correlated subqueries to sort of pivot part of a table (well several tables actually). The original author of the code I was working on was fetching entire tables of data, with each row fetching (joining) to another entire table (it did this in several levels really) just to sum some values. This was all valid ORM code (even with handy 'if' statements checking every row id to do in ORM join (yes he didn't even use a dang where clause!)) but it showed a true lack of knowledge of the ORM at hand and even SQL in general. Nonetheless, I saved the day :)
[0] https://blog.afoolishmanifesto.com/posts/introducing-dbix-class-helper-resultset-correlaterelationship/
My use cases similar to this https://blog.afoolishmanifesto.com/posts/golang-zig-cross-compilation/
need to bundle a lot of C libraries, some using dynamic linking and some using static linking, and I need to deploy them on different operating systems, including some that are difficult to work with like RHEL. Right now the builds are slow because I use a separate Dockerfile for each platform and then copy the binary back to the host. With Zig CC I could build binaries for different platforms and architectures without using Docker.
You might also enjoy these:
* https://blog.darknedgy.net/technology/2015/10/11/0/
* https://blog.darknedgy.net/technology/2015/09/05/0/
* https://blog.darknedgy.net/technology/2016/01/01/0/
* https://blog.afoolishmanifesto.com/tags/supervisors/
ODBC+FreeTDS is not generally a good idea. Microsoft's ODBC driver works fine though.
https://blog.afoolishmanifesto.com/posts/install-and-configure-the-ms-odbc-driver-on-debian/ explains how to get it going on debian.
And with DBIx::Class it is almost easier to do it right[1] than wrong.
[1] https://blog.afoolishmanifesto.com/posts/do-passwords-right/