Viewing profile — iccananea

Signs that you are old: I saw "in 4k" and thought that it was in 4 kilobytes, not 4k resolution

I've written about a storage layer for sqlite before in my http://workdad.dev blog and had been using and improving it over time. The result has been sqlflow, which at its core wra…

Yeah, the 4-year forward projection was what got me hooked on moneywell in 2009, when I bought a "forever" license for them. I have since wanted a budgeting app that would have tha…

I am researching providers to be able to add account sync to trackm.net I haven't done it at first because (1) they all have monthly / yearly costs and I wanted a flat fee; (2) I c…

That's actually a fair point, regarding the implications of a one time fee. Personally, I don't like subscription-based apps so didn't want to create yet another one. And I built t…

Hadn't heard of it before, though looks similar in intent. My inspiration for trackm was actually moneywell.app which i bought a license for in 2009. The "look X years" into the fu…

I built this as a personal finance app that allows me to see how my recurring incomes and expenses will affect my network over the years. So trackm can show up to 4 years in the fu…

I'm working on ripbox, a prototype cd player / ripper that than rip your CDs while you listen to them, back them up and then make them available for streaming anywhere. My cousin h…

This is a simple web app that I made to search for public information on Brazilian companies. The site is in Portuguese and in order to see most of the info you have to create an a…

Agreed, but tools like https://sqlc.dev , which I mention in the article, are a good trade-off that allows you to have verified, testable, SQL in your code.

Ironically I started drafting this article in 2021, when I had to deal with a Django codebase littered with nested N+1 queries due to using the ORM in the most pythonic way.

Drizzle does exactly what I described in the article: it re-implements SQL in the target language (in this case TypeScript).

Native sql with sqlc.dev

Not exactly what you want, but I've been using https://sqlc.dev to generate hydration code from SQL queries and loving it!

I really like this pattern and have been using it both at work and my hobby projects. For the database abstraction, you can use sqlc.dev Next version will have beta support for sql…

I have no problem with my manager being more technical than me or being better at what I do, as long as they don't try to do my job instead of theirs. If they are actively trying t…