Discussion on "Database Architectures & Use Cases - Explained"

Margo McCabe · 2020-09-15T17:18:02.841Z

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 ...

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.

Thank you for your feedback! In our teams experience, we've seen that time series databases are incredibly fast at writing data, because, like you said, everything is linear. We have found that read speeds for specific queries tend to suffer relative to write speeds. Our team has not worked with Datomic, so that may very well be the exception in this case.

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.

HarperDB does not support prepared statements at this time. We are discussing new functionality which would enable users to expose custom functions as an API. This could encompass the concept of prepared statements along with additional functionality.

We actually have a NewSQL blog here that you should check out! The term NewSQL is used to describe databases that offer ACID guarantees and SQL syntax combined with the scalability of NoSQL database system.

Discussion

Database Architectures & Use Cases - Explained

Responses(2)

Recent in Forum

Search Hashnode

Database Architectures & Use Cases - Explained

Responses(2)

Recent in Forum