3 ms·

Every time I read these MongoDB articles, I question why RethinkDB didn't rise up.

by overcast 10y ago

ecares 10y ago
So do I
hashkb 10y ago
We all ran back to Postgres and realized life wasn't so bad?
- overcast 10y ago
  Meh, MySQL is by far the dominant in that sector. RethinkDB is exactly what I need for most of my projects, relational, real time, document storage.
  - untog 10y ago
    By "that sector" you mean SQL databases as opposed to NoSQL? I'm finding Postgres' JSON column types to be very useful in working with NoSQL-y document structures.
    - overcast 10y ago
      I mean free "open source", SQL databases.
      - cygned 10y ago
        At least Postgres has proper SQL support and can handle CHECK constraints.
      - untog 10y ago
        I'd argue that Postgres doesn't belong just in that sector, then, given that it can be used for many of the roles Mongo/Rethink are used in.
    - williamstein 10y ago
      I'm rewriting all of my large amount of RethinkDB client code using PostgreSQL right now (including using their JSONB and LISTEN/NOTIFY functionality), and loving it.
raverbashing 10y ago
Well, do PostgreSQL magically prevents SQL Injection attacks if you pass unsanitized data to it? It's the same thing here
- ralfn 10y ago
  Yes both have query languages that are not native to your application (i.e. to your application it is data, such as a string or a json). But that is design flaw of SQL and MongoDB and does not apply to all databases.
starptech 10y ago
That kind of issue has nothing to do with Mongodb. He could even use RethinkDb.
- ralfn 10y ago
  That is wildly inaccurate. RethinkDB provides client drivers that model the rethinkdb queries in Javascript, so data and query are not combined into some horrible JSON query language (MongoDB) or horrible string based language (SQL). Input data is treated as is. No part of it will ever be interpreted as a query unless you decide to eval() your input data. Get informed: http://rethinkdb.com http://rethinkdb.com
  - starptech 10y ago
    Yes, but you can also pass the payload to the filter function and allow injecting custom conditions. r.table('users').filter(<here>).run(conn, callback); of course if you use the chainable syntax r.table('users').filter(r.row("age").eq(30)).run(conn, callback); you can prevent it but that's not the point. It has nothing to do with Mongodb.

Every time I read these MongoDB articles, I question why RethinkDB didn't rise up.

ecares 10y ago

So do I

hashkb 10y ago

We all ran back to Postgres and realized life wasn't so bad?

overcast 10y ago
Meh, MySQL is by far the dominant in that sector. RethinkDB is exactly what I need for most of my projects, relational, real time, document storage.
- untog 10y ago
  By "that sector" you mean SQL databases as opposed to NoSQL? I'm finding Postgres' JSON column types to be very useful in working with NoSQL-y document structures.
  - overcast 10y ago
    I mean free "open source", SQL databases.
    - cygned 10y ago
      At least Postgres has proper SQL support and can handle CHECK constraints.
    - untog 10y ago
      I'd argue that Postgres doesn't belong just in that sector, then, given that it can be used for many of the roles Mongo/Rethink are used in.
  - williamstein 10y ago
    I'm rewriting all of my large amount of RethinkDB client code using PostgreSQL right now (including using their JSONB and LISTEN/NOTIFY functionality), and loving it.

raverbashing 10y ago

Well, do PostgreSQL magically prevents SQL Injection attacks if you pass unsanitized data to it? It's the same thing here

ralfn 10y ago
Yes both have query languages that are not native to your application (i.e. to your application it is data, such as a string or a json). But that is design flaw of SQL and MongoDB and does not apply to all databases.

starptech 10y ago

That kind of issue has nothing to do with Mongodb. He could even use RethinkDb.

ralfn 10y ago
That is wildly inaccurate. RethinkDB provides client drivers that model the rethinkdb queries in Javascript, so data and query are not combined into some horrible JSON query language (MongoDB) or horrible string based language (SQL). Input data is treated as is. No part of it will ever be interpreted as a query unless you decide to eval() your input data. Get informed: http://rethinkdb.com http://rethinkdb.com
- starptech 10y ago
  Yes, but you can also pass the payload to the filter function and allow injecting custom conditions. r.table('users').filter(<here>).run(conn, callback); of course if you use the chainable syntax r.table('users').filter(r.row("age").eq(30)).run(conn, callback); you can prevent it but that's not the point. It has nothing to do with Mongodb.