---
title: "Discussion on \"Database Architectures & Use Cases - Explained\" | Hashnode"
description: "Discussion on \"Database Architectures & Use Cases - Explained\". With over 300 databases on the market, how do you determine which is right for your specific use case or skill set?\nWe continue to see the common debate of SQL vs. NoSQL and other database comparisons all over social media and blogging platforms. In ..."
url: "https://hashnode.com/posts/database-architectures-and-use-cases-explained/5f60f74ac417c20b18b72286"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Database Architectures & Use Cases - Explained](https://margomccabe.hashnode.dev/database-architectures-and-use-cases-explained?utm_source=hashnode&utm_medium=feed)

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

Sep 15, 2020 · 9 min read · margomccabe.hashnode.dev  
Read the article

-   [#databases](https://hashnode.com/tag/databases)
-   [#software-architecture](https://hashnode.com/tag/software-architecture)
-   [#sql](https://hashnode.com/tag/sql)
-   [#nosql](https://hashnode.com/tag/nosql)

## Written by

[Margo McCabe](https://hashnode.com/@MargoHDB)

@MargoHDB · Denver, CO

  
[View profile](https://hashnode.com/@MargoHDB)

On the innovative team @ HarperDB

Women in Tech | DevRel | Databases | Tech Blogger | Podcast Host

## Responses 2

Markdown supported · ⌘↵ to post

[Daniel Ziltener](https://hashnode.com/@zilti)

[Sep 16, 2020](https://hashnode.com/posts/database-architectures-and-use-cases-explained/5f60f74ac417c20b18b72286/comment/5f622983456ff01582e81184)

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.

[Margo McCabe](https://hashnode.com/@MargoHDB)

[Sep 16, 2020](https://hashnode.com/posts/database-architectures-and-use-cases-explained/5f60f74ac417c20b18b72286/comment/5f622983456ff01582e81184#reply-5f62302d018bef1561b429ed)

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.

[Pacharapol Withayasakpunt](https://hashnode.com/@polv)

[Sep 16, 2020](https://hashnode.com/posts/database-architectures-and-use-cases-explained/5f60f74ac417c20b18b72286/comment/5f61f053c08f260dbcebe911)

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.

[Margo McCabe](https://hashnode.com/@MargoHDB)

[Sep 16, 2020](https://hashnode.com/posts/database-architectures-and-use-cases-explained/5f60f74ac417c20b18b72286/comment/5f61f053c08f260dbcebe911#reply-5f6232ab456ff01582e811db)

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](https://dev.to/harperdb/deep-dive-newsql-databases-255l) 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.
