Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

We use RethinkDB

blog.workshape.io

Post reply on HN
Print view View original

71–78 of 78 posts

Re: We use RethinkDB

#71

Post by dkersten »

z3t4 wrote: post #68

I'm also working on a noSQL database. What I'm struggling with is the abstraction for searches/filters. For example, if you want to get all books with "beginner" in the title, in SQL it would look something like: "SELECT * FROM books WHERE title LIKE %beginner%" Where in no-SQL it would look like book.filter({title: ["like", "beginner"]}); Any ideas on how to abstract the filtering in a more clear way?

In RethinkDB the query looks like this:

    r.table('books').filter(function(doc){
        return doc('title').match("beginner")
    })
Or like this:

    r.table('books').filter(r.doc('title').match("beginner"))
Or if you have a secondary index setup correctly, this could work:

    r.table('books').getAll("beginner", {index: "title"})

Re: We use RethinkDB

#72

Post by lucian1900 »

felipesabino wrote: post #44
lucian1900 wrote: post #40

Earlier quoted context omitted.

No database can be fast without indexes. If the queries you get are defined by your users, you can still create indexes for the common ones.

The way business logic in the system is currently designed , there are no 'common ones', except for some ids (already indexed) used in other process rather than this dynamic filter. Based on that we also evaluated the approach of using something else like druid [1] [2] that is built for reading performance, but I am still studying possibilities and have no idea about the impact and problems a change like that would i…

Another thing to note is that Mongo is simply very slow. Without indexes, something like Postgres is much more likely to be fast.

Re: We use RethinkDB

#75

Post by findjashua »

baq wrote: post #69
findjashua wrote: post #63

Earlier quoted context omitted.

re: Elasticsearch Rethink's 'ungroup' method lets you chain multiple reductions, which is incredibly powerful for building aggregation queries. Elasticsearch doesn't have that capability, and hence its aggregation capabilities are severely limited. For example, with Rethink, it's very easy to compute a metric from metrics computed in a previous reduction. You can't do that with Elasticsearch, since its dsl allows met…

splunk has eventstats command which computes metrics and assigns them to fields of documents so you can process them. is that something similar? (except the fact that splunk's invoices are know to cause cardiac arrest?)

besides the price, it's an extra moving part in the system. Also, can it add the fields to the aggregated result or just the raw documents?

Re: We use RethinkDB

#76

Post by krunaldo »

davyjones wrote: post #66
krunaldo wrote: post #59

Earlier quoted context omitted.

An r720 from dell or similar model from dell with 600GB*2 SSD intel s3500DC model, 20 cores & 256GB of RAM will go for 5k-7k. You can bump this to 386GB of ram without going above 10k.

When I changed the country to Japan, the sticker price jumped from 2000 USD to 15,000 USD eq. for a very basic system. I am just at a loss as to what can explain this disparity. Guess I will have to call up my vendor to get a comparable quote.

My tip is always to try to get in contact with a couple of reseller and play them out against each other in the price department.

If you are looking for larger purchases 50k+ USD than you should talk directly with Dell, HP or comparable vendor and put them into the play off for who you choose :)

Re: We use RethinkDB

#77

Post by davyjones »

krunaldo wrote: post #76
davyjones wrote: post #66

Earlier quoted context omitted.

When I changed the country to Japan, the sticker price jumped from 2000 USD to 15,000 USD eq. for a very basic system. I am just at a loss as to what can explain this disparity. Guess I will have to call up my vendor to get a comparable quote.

My tip is always to try to get in contact with a couple of reseller and play them out against each other in the price department. If you are looking for larger purchases 50k+ USD than you should talk directly with Dell, HP or comparable vendor and put them into the play off for who you choose :)

I always do that. I have worked with Strategic Sourcing for a while...so... ;-)

Re: We use RethinkDB

#78

Post by baq »

findjashua wrote: post #75
baq wrote: post #69

Earlier quoted context omitted.

splunk has eventstats command which computes metrics and assigns them to fields of documents so you can process them. is that something similar? (except the fact that splunk's invoices are know to cause cardiac arrest?)

besides the price, it's an extra moving part in the system. Also, can it add the fields to the aggregated result or just the raw documents?

splunk can do both: stats aggregates, eventstats adds aggregate fields to raw documents.
Post reply on HN