I am a big SQL fan but not all data has to be relational.
Let’s say I want the GPS coordinates of ten million vehicles every 5 seconds. I have a vehicle id, a timestamp, and coordinates. I do not care if a few writes get lost. Why does this have to be relational?
And perhaps I also record other info that may change from vehicle to vehicle. Perhaps just values that are true if present. DoorOpen, BrakeApplied, LightsOn, LightBarOn, EngineOn, etc. I may only be displaying this data in a UI. I may get different values from every vehicle or even every write. There is no “schema”. I mean, I can have a JSON field or something in my relational table? But this is not exactly relational anymore.
Correct not all data has to be relational but it will always eventually become relational. You will at one point want to pair that vehicle id to a vehicle and then again to something else.
Based on what? It’s top notch for immutability, zero trust, proof of existence, accountability, transparency, uptime, decentralization, network resilience…
What about throughput, latency, schema modeling, query load balancing/routing, confidentiality, regulatory compliance, operational tooling? How easily can I write a CRUD or line of business service using it?
Confidentiality, regulatory compliance, schema modeling (IDLs?), query load balancing (rpc infra) and operational tooling pretty good in my world now (Solana).
Throughout and latency decent now (400ms conf, couple second finality, 4k tps) but obviously the type of system that needs a trustless immutable database has tradeoffs.
How easily can you write a crud system? No clue that’s on you.
A line of business service? Why the hell would that need a trustless immutable ledger. You’re barking up the wrong tree.
Low level financial systems are pretty much the only thing that benefits. Small niche for proof of existence perhaps. And maybe other immutable use case things.
We usually only find out years after the fact when the information is declassified. Also, secrecy is only necessary to the extent that it helps reach objectives. Knowing the CIA infiltrates leftist movements undercuts hope and increases distrust between leftists.
You can start the server again manually right?
Because i am about to go for Oracle free forever server (
It is a Analytics server so i dont mind them deleting the entire server sometimes. And me manually starting it back up as soon as they do that.
Also we have auto backup
I just want a free server
My recommendation is to use it as a reverse proxy to expose services but ultimately host from another device.
It's 1 gb of ram anyway (the free 24 gb of ram arm vps' are scarce and hard to get).
Another tip is that they monitor cpu and ram and are more likely to delete it if is idling. There exist programs on github that do nothing but waste cpu in order to try to keep the oracle vps up.
The DoD funded a lot of the early development of relational databases, along with internet protocol. Working for the cia was probably the least of ellisons sins. Really bad company, but solid DB.
44 Comments
drolex@sopuli.xyz · 80 pts · 202d
Hahaha this is cartoonishly evil, surely it can't be true!
Next you'll tell me Ellison invests in creepy life extension projects and gives an insane amount of money to post-fascist politicians!
technocrit@lemmy.dbzer0.com · 18 pts · 202d
Don't forget the support for genocide.
VibeSurgeon@piefed.social · 69 pts · 202d
I think we all know it actually stands for One Rich Asshole Called Larry Ellison
toynbee@lemmy.world · 7 pts · 202d
To be honest, until now I always thought it was because of Oracles.
ghostahh@lemmy.world · 11 pts · 202d
Wind gusts are crazy today the way jokes are flying over heads
hemko@lemmy.dbzer0.com · 33 pts · 202d
Ah, that answers the question "when did oracle become so evil?"
skarn@discuss.tchncs.de · 23 pts · 202d
"Become"?
hemko@lemmy.dbzer0.com · 18 pts · 202d
Yeah, from the beginning
xep@discuss.online · 30 pts · 202d
The worst DB in existence, not to defend Oracle, is blockchain.
Pat_Riot@lemmy.today · 18 pts · 202d
Blockchain isn't a Database, and the worst one is AS400.
Rooster326@programming.dev · 12 pts · 202d
A400 is at least relational.
MongoDB on the other hand...
LeFantome@programming.dev · 2 pts · 201d
I am a big SQL fan but not all data has to be relational.
Let’s say I want the GPS coordinates of ten million vehicles every 5 seconds. I have a vehicle id, a timestamp, and coordinates. I do not care if a few writes get lost. Why does this have to be relational?
And perhaps I also record other info that may change from vehicle to vehicle. Perhaps just values that are true if present. DoorOpen, BrakeApplied, LightsOn, LightBarOn, EngineOn, etc. I may only be displaying this data in a UI. I may get different values from every vehicle or even every write. There is no “schema”. I mean, I can have a JSON field or something in my relational table? But this is not exactly relational anymore.
Rooster326@programming.dev · 4 pts · 201d
Correct not all data has to be relational but it will always eventually become relational. You will at one point want to pair that vehicle id to a vehicle and then again to something else.
IAmNorRealTakeYourMeds@lemmy.world · 3 pts · 201d
y'all wrong, the worst database in existence is wherever I keep my notes. because every time I write notes I forget where the fuck I wrote them.
pressanykeynow@lemmy.world · 2 pts · 201d
Isn't it how all the databases work? Or maybe you should just enable cache for yours.
IAmNorRealTakeYourMeds@lemmy.world · 1 pts · 201d
can't cache my notes because I forgot where I put my notebook
locuester@lemmy.zip · 3 pts · 201d
Based on what? It’s top notch for immutability, zero trust, proof of existence, accountability, transparency, uptime, decentralization, network resilience…
chaospatterns@lemmy.world · 9 pts · 201d
What about throughput, latency, schema modeling, query load balancing/routing, confidentiality, regulatory compliance, operational tooling? How easily can I write a CRUD or line of business service using it?
bestboyfriendintheworld@sh.itjust.works · 3 pts · 196d
Also blockchain is append only. So no deletions.
locuester@lemmy.zip · -1 pts · 201d
Confidentiality, regulatory compliance, schema modeling (IDLs?), query load balancing (rpc infra) and operational tooling pretty good in my world now (Solana). Throughout and latency decent now (400ms conf, couple second finality, 4k tps) but obviously the type of system that needs a trustless immutable database has tradeoffs.
How easily can you write a crud system? No clue that’s on you. A line of business service? Why the hell would that need a trustless immutable ledger. You’re barking up the wrong tree. Low level financial systems are pretty much the only thing that benefits. Small niche for proof of existence perhaps. And maybe other immutable use case things.
bss03@infosec.pub · 26 pts · 202d
Oracle is not the worse DB in existence. They are a worse company than MS, but I'd much rather be talking to Oracle than MSSQL.
(My go-to is PostgreSQL, tho.)
bort@sopuli.xyz · 4 pts · 202d
MSSQLMS is goat tho
edinbruh@feddit.it · 19 pts · 202d
mongodb is webscale
ikidd@lemmy.world · 1 pts · 201d
Had to know Kai was going to show up.
irelephant@lemmy.dbzer0.com · 18 pts · 201d
W3dd1e@lemmy.zip · 13 pts · 201d
I am forced to use Oracle at work. It is, in fact, hot garbage.
pressanykeynow@lemmy.world · 4 pts · 201d
What makes it garbage? Compared to postgres
W3dd1e@lemmy.zip · 4 pts · 200d
Oh, just getting to the interface where I can run SQL is a pain in the ass. It’s hidden behind Oracle’s terrible UI.
leftzero@lemmy.dbzer0.com · 4 pts · 200d
Nonsense, everyone knows Oracle is an acronym: One Rich Asshole Called Larry Ellison.
technocrit@lemmy.dbzer0.com · 4 pts · 202d
"intelligence" <---> incompetence
Tinidril@midwest.social · 2 pts · 201d
I dunno about that. The CIA has at least been competent at undermining leftist movements.
ZomieChicken@sh.itjust.works · 1 pts · 198d
Are they? It's a known fact that they do that kind of thing. If they were good, wouldn't their involvement not appear, or would be, at best, a rumor?
Tinidril@midwest.social · 1 pts · 198d
We usually only find out years after the fact when the information is declassified. Also, secrecy is only necessary to the extent that it helps reach objectives. Knowing the CIA infiltrates leftist movements undercuts hope and increases distrust between leftists.
xcaliber47@europe.pub · 4 pts · 202d
Hate to be the Devils advocate here, but Oracle is the only one (as far as i know) which provides a FREE usable server. FOREVER. Via OracleCloud
qaz@lemmy.world · 13 pts · 202d
Until it randomly gets removed without warning
JasonDJ@lemmy.zip · 12 pts · 202d
FOREVER*
xcaliber47@europe.pub · 9 pts · 202d
As far as i know, yes. Forever. Only 1 cloud provider that gives free usable server FOREVER (until they eventually change their policy or something)
LeFantome@programming.dev · 9 pts · 201d
Promise free cloud forever. Randomly delete it without recourse once people come to depend on it.
Check: sounds pretty evil.
moonpiedumplings@programming.dev · 6 pts · 202d
They like to randomly delete them. It happened to me and a friend.
xcaliber47@europe.pub · 1 pts · 200d
You can start the server again manually right? Because i am about to go for Oracle free forever server ( It is a Analytics server so i dont mind them deleting the entire server sometimes. And me manually starting it back up as soon as they do that. Also we have auto backup I just want a free server
Will it work?
moonpiedumplings@programming.dev · 1 pts · 200d
Unfortunately deleted means deleted. Data gone.
My recommendation is to use it as a reverse proxy to expose services but ultimately host from another device.
It's 1 gb of ram anyway (the free 24 gb of ram arm vps' are scarce and hard to get).
Another tip is that they monitor cpu and ram and are more likely to delete it if is idling. There exist programs on github that do nothing but waste cpu in order to try to keep the oracle vps up.
ikidd@lemmy.world · 4 pts · 201d
And as usual from Oracle, it isn't worth free. You better have a good backup, because they'll shut that shit off on you without warning.
olenkoVD@lemmy.dbzer0.com · 2 pts · 195d
I think MSSQL is worse than MySQL (or at least MariaDB)
Simulation6@sopuli.xyz · 1 pts · 201d
The DoD funded a lot of the early development of relational databases, along with internet protocol. Working for the cia was probably the least of ellisons sins. Really bad company, but solid DB.