#storedprocedures — Public Fediverse posts

Interesting blog post "Supercharge #SQLite with #Ruby Functions" by @julik

https://blog.julik.nl/2025/01/supercharge-sqlite-with-ruby-functions

Instead of #storedprocedures you can use user defined procedures (#udf).

#rubylang #database

I'm planning on writing a book. I've developed a #halfDAO, a #software #architecture #pattern for the #java #programming #language.

I find #JPA too broad: most of my apps just need to read. Writing back to the data store happens rarely. When it does, I use #storedProcedures. I don't need a JPA cache: my apps read into local memory objects, execute, and stop.

My solution is #DomainDriven, uses #Builders and #Generators. And in active use in 20 applications.

I need a publisher.