Sure, i think its just sql has not had any breaking version changes in like… ever?
- 0 Posts
- 88 Comments
It has though
Window functions were an addition, but more recently struct, json, and array fields with native support. Pipe syntax is getting multiple implementations.
Match recognize is a whole new standard abstraction of window functions.
Union by name is being added (fuck union by position).
Ah, the SQLite approach!
panda_abyss@lemmy.cato Programmer Humor@programming.dev•i love ai in my offline foss softwares that are still in beta5·2 days agoI traded crypto to pay for my AI machine.
I feel like I’m stacking bubbles.
I have not deployed Garage S3, but it has a static pages feature you could use — just buid your static files with jekyl or something, create a bucket and set the permissions.
panda_abyss@lemmy.cato Fuck AI@lemmy.world•"I Hate This Viscerally": People Are REALLY Mad at These AI Glasses That Record Everything Constantly0·5 days agoAcceptable for the blind only
Caviar mukbang.
You want to be so full of roe that if an alien sliced you open your stomach would look like a pregnant salmon.
panda_abyss@lemmy.cato Selfhosted@lemmy.world•18% of people running Nextcloud don't know what database they are usingEnglish12·7 days agoSQLite is a proper database. Realistically you’ll never exhaust its 278tb storage limits, it’s thoroughly battle tested, and it’s dead easy to backup.
I doubt nextcloud is running enough parallel db writes for this to actually matter — and if it is WAL mode is still probably good enough.
Once you have multiple software clients running then you will need a client server dbms like Postgres. For most home or group installations, this should not be an issue.
panda_abyss@lemmy.cato Selfhosted@lemmy.world•18% of people running Nextcloud don't know what database they are usingEnglish9·7 days agoThat kid is never going to figure out if they downloaded the assignment pdf to “Downloads (iPad)” or “Downloads (iCloud)”
panda_abyss@lemmy.cato linuxmemes@lemmy.world•Discovering GNOME extensions may have been a mistake.0·8 days agoI can play radio from my desktop?
Neovim*
I don’t like that an adversary could modify that link or its contents without much detection or any logging.
When you compare it to package managers that have immutable versioning that’s a big downfall. If someone were modifying pypi or npm packages I would be surprised if it went undetected.
Realistically is that an issue, probably not. But I do try and reduce my exposure when I can.
Maybe it’s marble patterned laminate
panda_abyss@lemmy.cato Fuck AI@lemmy.world•Connecticut Man's Case Believed to Be First Murder-Suicide Associated With AI Psychosis0·10 days agoReason 24435 why you did not train AI on Reddit.
Grub is timeless design
panda_abyss@lemmy.cato Selfhosted@lemmy.world•I'm "use NFS forfilesharing" old. what's the current optimal solution for shared drives if I have like 3 linux machines in the house?English4·13 days agoI hear good things about seaweedfs instead of minio these days
This is why I run discord in the browser only.
I think it’s important if you’re successful (in whatever it is you’re trying to succeed at) to help at least one other person become successful.
I never really minded the shenanigans, after reading the docs once it all mostly made sense