4 ms·
Woaw. HN, the place created by pg, who advocated trying to "beat the average" and have "frighteningly ambitious startup ideas", etc. Yet HN has become the pla
by martinced 14y ago
Woaw. HN, the place created by pg, who advocated trying to "beat the average" and have "frighteningly ambitious startup ideas", etc.
Yet HN has become the place for the status-quo. Where people are going to vote everything encouraging the status-quo (like articles about the benefits of C# and SQL) as if it was the holy gospel...
"Immediately, a SQL relational database is proposed as the solution."
For a start you're probably not trying to solve a problem involving big-data ; )
Ask the big data players who are using fast and gigantic key/value stores how did SQL work for them...
For smaller needs, then SQL offers, basically: ACID. Most companies do not care about what SQL can really do: they'll wrap everything into ORMs and perform business logic outside of SQL and in crazy models that aren't relational at all and then store back everything into SQL.
What most business care about is ACID, not being truly relational (which SQL DBs ain't anyway), not set theory.
The most saddening thing about traditional SQL DBs is that there's no basis for queries: the same query shall return different results depending on when the query is made (because most SQL DBs are "update in place" DBs / value-oriented DBs).
In the Real-World [TM] this is very problematic because when you can't reproduce a problem you have to try to reproduce the state the DB was in at a particular time and query from there. It is a gigantic time waster.
In my view for really big data needs SQL simply doesn't cut it while for smaller needs I still want ACID but I want something CRA ("create read append-only"), not CRUD.
I have nothing against using something like Datomic (which is CRA) backed with a SQL datastore.
But the "traditional" SQL DB that the herd --bent on never creating anything disruptive-- is using? Not for me.
CRUD is dead baby. CRUD is dead.
There are, today, people who've read and understood pg's writings who are using Lisp dialects (like Clojure) and CRA DBs (like Datomic, backed or not by SQL) to gain a competitive edge.
This kind of stuff is the reason why I come to HN. Not to read why the status-quo is acceptable (even if it's all most of the HN crowd knows).