Clojurians Log v2
humbleui
I finally finished watching the talk - all very cool 🙂 On the packaging and distribution front I suspect there could a good amount of practical overlap with what Mike Hearn's been building with Kotlin lately: https://conveyor.hydraulic.dev/ He describes Conveyor in this talk alongside some rather interesting DB integration ideas https://www.youtube.com/watch?v=jKeHKe9ttas - and he has also written about the ~web3/decentralization motivations behind here https://blog.plan99.net/re-moxie-on-web3-b0cfccd68067 > Step 1 for building a decentralized system: get code onto the powerful, high bandwidth devices users actually plug into AC power today, keep it up to date and for political reasons do it outside of app stores. Ethereum has totally failed at this and Moxie is right to point that out. But the reason they failed is obvious once you actually try to do it: it’s a universe of pain. Awkward, hacked together and frequently abandoned tools, poor software update systems, numerous package and installer formats, and even needing to render icons at lots of different sizes all slows you down. > I spent most of 2021 working on software that addresses all these problems. It lets you make self-updating desktop and server apps with only a small config file and a single command.
Lots of DBs in finance, all a long time ago now. Mostly not SPs post 2014 dealing with Oracle/MySQL/H2. I remember writing a SP serialiser, SVN differ and cron job, a form of contiguous integration for a large investment bank in South Africa in ~2008 because report SPs were being edited directly on the UAT DB for MS SQL Server, and nobody knew who was making what edits 🤣 . Previous workflow which the team wanted making live edits, and catching changes close in time was the best hack we could come up with.
...oh no 🙈
within the XTDB team we've certainly debated the idea of a git push endpoint before (no running arbitrary DDL) - I suspect that would really help for more mutable DBs too :)
A questioner asks the point about security, and he's correct that views and SPs solve this... but then he should retitle the talk: "How to write a distributed app using only stored procedures for your business logic" ... because that's where this design will ultimately land up. I do concede the simplicity of starting on this approach and then migrating off it. I wouldn't relish writing lots of stored procedures.
yeah SPs in SQL / SQL databases are traditionally really hard to work with at high complexity scale (or so I hear) - but what if that wasn't the case
which DBs have you had most experience with in this regard?
for XTDB in the long term, I'm hoping that between wasm and ideas like we see in https://db.in.tum.de/~jungmair/papers/p2799-jungmair.pdf that more sensible approaches to SPs can emerge