3 ms·
> Maybe graph databases are what some folks are looking for. Beware. These sometimes sell themselves as great for everything ("Look, if you squint, all your da
by wharvle 3y ago
> Maybe graph databases are what some folks are looking for.
Beware. These sometimes sell themselves as great for everything ("Look, if you squint, all your data's a graph! Clearly RDBMS is the wrong fit, use our graph database for all of it [and pay us money]!" — the general tone of marketing for at least one major graph database vendor) but tend to have to make interesting performance trade-offs to achieve the kind of quick graph-operation performance they like to showcase.
Step outside the narrow set of things they're good at (sometimes not even including all there reasonable "graphy" sorts of things one might want to do!) and performance may drop to the Earth's core.
They also may be way behind your typical mature RDBMS at things like constraints and transactions, or support far fewer datatypes, which can lead to some real pain.
(this basic pattern actually seems to hold for most attempted RDBMS "killers"—they get hyped as a replacement, but actually their best fit in a sane stack is as a supplement to RDBMS for specific purposes for very particular workloads, if you really, really need them. See also: the wild "NoSQL"/MongoDB hype of some years back)
- j45 3y agoFair points. The graph extension for Postgres is interesting. As for a pure graph db options like TypeDB seem to be a bit different than the historical alternatives.