3 ms·
> There are also a lot of queries that SQL is awful at, like most things involving graphs. That's why things like graph- and time-series databases have market n
by bob1029 3y ago
> There are also a lot of queries that SQL is awful at, like most things involving graphs. That's why things like graph- and time-series databases have market niches.
I don't really understand the graph database argument. "Graph" == "Joins" in my brain. I've also seen "Graph" used in place of "we aren't sure of our schema or generally what the business is even doing yet".
Time series is definitely a fair argument depending on the specifics, but I've never needed Cassandra & friends to get the job done.
- hwayne 3y agoYou can mimic graph data with joins in SQL but it's not a good fit for querying properties of a graph. Think of something like "find all the distinct cliques (sets of elements where every element is connected to every other element in the set) that contain this element."