4 ms·

Odd to refer to Redis as a general-purpose database: "Hive is not meant to become a general-purpose database, like Redis" Assume that is an error and they mea

Odd to refer to Redis as a general-purpose database: "Hive is not meant to become a general-purpose database, like Redis" Assume that is an error and they meant to say MySQL (or similar)? Or I'm seriously misunderstanding something.

bityard 5y ago
Redis _is_ a general-purpose database. So is MySQL. They just accept and store data in different ways.
- rmbyrro 5y ago
  I guess the thing is it's not actually used/viewed a lot of times as a general-purpose DB, but rather just an in-memory cache. There are better examples they could've used in this context, like MySQL - as mentioned -, Postgres, Mongo, etc.
  - maxbond 5y ago
    Redis is a featurful key-value store. Values can be hash maps, streams, sets, etc. Many people do not _use_ these features, and their mental model of Redis is as an in-memory cache - that's fine, but we're looking at this from the perspective of an _implementer_, not a _user_. So regardless if no one uses streams, if we decide to provide them, we own that complexity. Hive is declaring their intention not to be as featurful a key-value store as Redis. None of those other examples are key-value stores. Mongo is the most similar, but really has more in common with MySQL and Postgres than Redis/Hive. Key value stores view their values as opaque, modulo things like providing embedded hash maps. Queries in key-value stores are pretty simple, and are focused on the _keys_. Eg, iterate over these keys in sorted order and give me the values. All of these other databases provide advanced querying capabilities by having type systems and the ability to introspect their objects and make decisions based on their values.
    - rmbyrro 5y ago
      Got it. You wanted an example for a key-value store database. The article is yours, so who am I to opinion on which example to use... This is just noise...
      - maxbond 5y ago
        Hey I apologize if there's been a confusion, I have nothing to do with this article, I was just trying to point out a distinction I thought was being missed.
    - avereveard 5y ago
      Redis is more of a datastore than a database. Sure it will persist data if you coherce it forcefully to, but works best as a transient store, with data residing somewhere else.
      - aaomidi 5y ago
        Not really? This is exactly what the comment before you is calling out. Using the word "forcefully" to mean "configure it to", is weird, and is just setting the tone of the discussion without adding anything meaningful to it. > but works best as a transient store "best". It's odd to see such a strong determination of what a tool should be used for. It works fine as a "transient store", and it also works fine as a database.
        avereveard 5y ago
        sure, as you can use a monkey wrench for all your nuts. it's not going to be as pleasant, and it's going to ruin the nuts eventually.
        aaomidi 5y ago
        If you say so. This way of thinking about redis holds so many organizations back. Seriously, go try it again as a database.
- deleted 5y ago
  [deleted]

bityard 5y ago

Redis _is_ a general-purpose database. So is MySQL. They just accept and store data in different ways.

rmbyrro 5y ago
I guess the thing is it's not actually used/viewed a lot of times as a general-purpose DB, but rather just an in-memory cache. There are better examples they could've used in this context, like MySQL - as mentioned -, Postgres, Mongo, etc.
- maxbond 5y ago
  Redis is a featurful key-value store. Values can be hash maps, streams, sets, etc. Many people do not _use_ these features, and their mental model of Redis is as an in-memory cache - that's fine, but we're looking at this from the perspective of an _implementer_, not a _user_. So regardless if no one uses streams, if we decide to provide them, we own that complexity. Hive is declaring their intention not to be as featurful a key-value store as Redis. None of those other examples are key-value stores. Mongo is the most similar, but really has more in common with MySQL and Postgres than Redis/Hive. Key value stores view their values as opaque, modulo things like providing embedded hash maps. Queries in key-value stores are pretty simple, and are focused on the _keys_. Eg, iterate over these keys in sorted order and give me the values. All of these other databases provide advanced querying capabilities by having type systems and the ability to introspect their objects and make decisions based on their values.
  - rmbyrro 5y ago
    Got it. You wanted an example for a key-value store database. The article is yours, so who am I to opinion on which example to use... This is just noise...
    - maxbond 5y ago
      Hey I apologize if there's been a confusion, I have nothing to do with this article, I was just trying to point out a distinction I thought was being missed.
  - avereveard 5y ago
    Redis is more of a datastore than a database. Sure it will persist data if you coherce it forcefully to, but works best as a transient store, with data residing somewhere else.
    - aaomidi 5y ago
      Not really? This is exactly what the comment before you is calling out. Using the word "forcefully" to mean "configure it to", is weird, and is just setting the tone of the discussion without adding anything meaningful to it. > but works best as a transient store "best". It's odd to see such a strong determination of what a tool should be used for. It works fine as a "transient store", and it also works fine as a database.
      - avereveard 5y ago
        sure, as you can use a monkey wrench for all your nuts. it's not going to be as pleasant, and it's going to ruin the nuts eventually.
        aaomidi 5y ago
        If you say so. This way of thinking about redis holds so many organizations back. Seriously, go try it again as a database.
deleted 5y ago
[deleted]