With over 300 databases on the market, how do you determine which is right for your specific use case or skill set? We continue to see the common debate of SQL vs. NoSQL and other database comparisons all over social media and blogging platforms. In ...
Markdown supported · ⌘↵ to post
What do you think about prepared statements? Does HarperDB support that?
MongoDB query language does not support prepared statements, and sometimes fails with strings that starts with $. I tried to wrap in { $literal: "$CONTENT" }, but it is confusing when I can or cannot wrap in $literal.
Also, you probably also realize that NoSQL is somewhat a misnomer, but actually "non-relational". It may use a query language that may or may not resemble SQL. Sometimes, both SQL-like and SQL-unlike syntaxes are allowed.
You didn't even mention much about NewSQL.
Daniel Ziltener
Clojure developer
Time series databases don't necessarily suffer in write speeds. A good example for that is Datomic, it can easily parallelize reads almost arbitrarily. And that is possible exactly because the database is append-only (and transactions are also supported). Since it is append-only, the whole database can be seen as an atomic value, and thus no locking or anything has to be done.