In the last few days I’m experimenting with substituting CRUD API code with Stored Procedures which directly produce the endpoints JSON as a single-row scalar value. API is then just a wrapper that authenticates, validates input and streams the DB’s JSON directly to the client.
No ORMs, no SQL generators etc.
All SQL is where it should belong: in the database
API does only single „CALL myfunc(…)“ db calls
A simple centralised error handler can accurately report errors from the database
No weird mixed row/json columns scanning into structs and re-marshalling everything to JSON
Codebase is collapsing to 20% (by LOCs)
Stored Procedures can use wonderfully declarative SQL code
Response times in the microseconds, even for multiple queries, all happens inside the DB
More side effects:
the data model can change and evolve without touching the API at all
Zero deploys mean zero downtime
the API application is so tiny, I could easily switch it to any programming language I want (yes, even Common Lisp) without worrying about available databases libraries, type mapping and rewriting tens of thousands of lines of intermixed language/SQL-code.
The general direction of the dev industry is heading in the opposite direction. More ORMs, more layers, more database abstraction. More weird proprietary cloud databases with each their own limited capabilities and query language.
So you tell me: Is it crazy? Is it wrong? Why do I have doubts despite everything working out beautifully?
We are pleased to announce that we have now added PSSPred to #NMROnline – ELECTRO, to provide the secondary structure predictions required for Mars assignment.
I love Mastodon's solution, just including the @ in the URL solves Twitter's problem of "oops, we can't have a twitter.com/ music because we let a user be @music"
The Hugo static site generator is making this a breeze! 👍
Not only is it relatively simple to add new functionality, but also we don't need to worry about web service security. Hosting is done by our supplier and there is no CMS that needs updates or has security flaws introduced by badly maintained plugins 💪
Static site generators are not for every use case - but they are just perfect for small sites that are updated irregularly. Most Wordpress-based small business websites could also be a static website generated by a tool like Hugo.