News for hackers. Stuff that matters.
Re:SQL Databases Are An Overapplied Solution (And What To Us... by viraptor on Thursday February 18, 2010 @09:30AM (#1134167)
"... but I'll show a trivial example, because methods of orders processing and querying could take a whole blog post."

The key to such query is using the correct data representation, and the query itself is no different to the previous one: condition and condition and [...] You can solve the date + payment being processed by first getting a list of orders satisfying those conditions and then checking which of them have the widget you need. That's still only 2 queries (if the db can handle multi-key get). It's not slow/complicated/whatever and it's more or less what your typical RDBMS will do. How often do you write complicated new queries IRL?

Stopping document stores from clobbering each other? Reader/writer locks if you're working on a local store. Or setting up an arbitrating db access manager if you're working on a remote one. Exactly the same as SQL servers (SQLite and any RDBMS respectively)

There are no comments on this comment yet.