ToroDB Stampede

Data

database replication

SHOW HN2016

ToroDB Stampede

Automagical MongoDB to PostgreSQL, 100x Faster Queries

torodb.com

#mongodb#postgresql#replication#etl#sql

43points
17comments
#817of 2,264 in 2016
Top 37%of 2016 by points

How HN took it

CuriousMostly questions and neutral comments

4 positive, 5 neutral or asking, 0 mixed, 1 critical, out of 10 comments about the project. Thread score +0.13.

Performance: 2 for, 0 againstIdea: 1 for, 1 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Impressive performance gains over MongoDB

    From 1 comment
    • Impressive performance, even compared against a Mongo shard with 3 nodes!
      3manuek on HN
  • Relational approach to document data is a sensible idea

    From 1 comment
    • It's so funny to hear sometimes that noSQL is better that SQL databases and see how much more powerful tools can be built using old good relational engines. Also, this story a…
      postila on HN

Objections

  • 'Automatic' and 'magic' naming suggests loss of control

    From 1 comment
    • FYI: myself (and I believe a reasonable number of other software developers) treat the word "Automatic" as a red flag. Magic means you don't understand how something works.…
      stephenr on HN
  • Benchmark methodology and hardware specs were unclear

    From 1 comment
    • Hi there! Stampede looks nice, congrats! Quick question about the 100x performance claim and the benchmarks in https://www.8kdata.com/blog/announcing-torodb-stampede-1-0-beta/: -…
      javiermaestro on HN

Requests

  • Benchmark with dataset fitting in RAM on a single MongoDB instance

    From 2 comments
    • Hi there! Stampede looks nice, congrats! Quick question about the 100x performance claim and the benchmarks in https://www.8kdata.com/blog/announcing-torodb-stampede-1-0-beta/: -…
      javiermaestro on HN
    • LOL I re-read the article and found the specs. I really read it but somehow managed to skip the paragraph or something :-? Anyway, my point stands. I'd use a single instance in…
      javiermaestro on HN

Questions

  • How optional fields and sparse tables are handled

    From 1 comment
    • How do you deal with optional fields in documents? do you modify the table schema on the run? If there's a larg-ish number of optional fields, but each document has only or a few…
      davidpardo on HN
  • Whether it can run on an existing database and schema

    From 1 comment
    • One of our engineer's recently floated up the idea of using ToroDB Stampede for replacing our MongoDB -> PostgreSQL ETL, since it's merely a set of Python scripts parsing JSON…
      kasano on HN

Alternatives named

  • MongoDB BI Connector

    From 3 comments
    • It's so funny to hear sometimes that noSQL is better that SQL databases and see how much more powerful tools can be built using old good relational engines. Also, this story a…
      postila on HN
    • Indeed, MongoDB BI connector v1 was based on PostgreSQL. However, they used 9.4's foreign data wrappers and since those could not push down query clauses, the connector itself…
      ahachete on HN
    • I've tried that connector and decided against using it. The problem was you had to define your schema by hand and in mongo sometimes you have legacy data records with different…
      eb0la on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/13072039)