Hacker News Reader

assfaceon Time-travel queries in CockroachDB

> It would be interesting to see a list of features from major database management systems that have been removed over the years.

The only other thing I can think of right now are in-memory optimized indexes (e.g., T-Trees) from the 1980s. These were later removed and replaced with B+trees (or skip lists if you're MemSQL) because CPU caches (SRAM) got much faster than memory (DRAM).

assfaceon Time-travel queries in CockroachDB

This is an old idea. It was in the original version of Postgres from Berkeley in the 1980s. They ended up taking it out in 1998 because systems kept running out of disk space:

https://www.postgresql.org/docs/6.3/static/c0503.htm

It's actually very easy to implement if you use the "append" version of MVCC (which Postgres does). All you need to do is just disable garbage collection (e.g., the vacuum).

assfaceon Scaling nodes in a Dgraph cluster

> Not the entire point. Relational databases have schemas that are not well suited to graph structures, and SQL is also a barrier.

The latest research disagrees with your statement:

http://cidrdb.org/cidr2015/Papers/CIDR15_Paper20.pdf

assfaceon Uber Turns to Saudi Arabia for $3.5B Cash Infusion

I can't go into details, but it wasn't that much. The public number for "buying" CMU's NREC is $5.5 million.

http://www.nytimes.com/2015/09/13/magazine/uber-would-like-t...

assfaceon Time Series, the new shiny?

> I think Datomic which has been doing time series data for years now answers the "what’s the big deal" question for me:

This is known as "time travel queries". Postgres supported this back in the original version from the 1980s but then they took it out in 1997 because it takes up too much disk space.

It's trivial to do in an MVCC system. You just turn off garbage collection (vacuuming in PSQL parlance).

assfaceon CockroachDB Skitters into Beta

> This is one of the most exciting DB's coming into the world, and I've had a lot of fun watching progress from the sidelines!

I'm going to have to disagree. The German HyPer DBMS has a lot more interesting ideas. Cockroach is just distributed MVCC from the 1980s on top of a key/value store.

MemSQL also has a new LLVM architecture written by the HipHop VM inventor that they poached from Facebook.

assfaceon Announcing SQL Server on Linux

You are actually not far off. Sybase was founded by Bob Epstein, who was Stonebraker's student at Berkeley and helped build the original INGRES system.

assfaceon Secondary shops flooded with unicorn sellers

> Not really. The Iraq and Afghanistan wars together cost something on the order of $750 billion, which was less than one year of stimulus spending at the beginning of the current administration.

Ignore this person. They don't know what they are talking about.

The estimate cost of the Afghan + Iraq War is estimated to be $4-6 trillion when you account for long-term medical care and disability compensation for service members, veterans and families, military replenishment and social and economic costs.

Source: http://www.hks.harvard.edu/news-events/news/articles/bilmes-...

assfaceon SQLGraph: An Efficient Relational-Based Property Graph Store (2015) [pdf]

The conference was in June 2015. The paper would have been submitted for peer review in Summer/Fall 2014. Which means that it could have been written in Winter/Spring 2014.

SIGMOD is not like a dev conference where you can change the paper the day before your talk.

assfaceon Using Graph Databases to Stop E-commerce Fraud in Real Time

Why can't you do this in a relational DBMS? Recent research says it that would probably be faster.

The Case Against Specialized Graph Analytics Engines

http://www.cidrdb.org/cidr2015/Papers/CIDR15_Paper20.pdf

assfaceon Postgres 9.5 feature rundown

Internal development or just usage/administration?

assfaceon Literate SQL

> The same query when ran on DB2 took 12 hours, on postgres (5x more data) it took 24 hours.

You're doing it wrong. These type of queries should be run on a column store (e.g., Vertica).

assfaceon Pg_paxos: High Availability Data Replication for PostgreSQL

Does anybody actually use any of CitusData's stuff in production? I've heard that their free extensions are mostly junk and then when they don't work they try to get you to buy their proprietary components.

assfaceon RethinkDB 2.2: atomic changefeeds, parallel scans, improved runtime

Because it's 2015.

assfaceon American Apparel Files for Bankruptcy

> Not many 30 year olds have both the body and the mentality to wear the American Apparel clothes that they bought when they were in university.

Speak for yourself.

http://i.imgur.com/C4C9Llb.jpg

I'm going to grave with these on. These colors don't run!

assfaceon New Perl 6 Homepage

This ship sailed 10 years ago. It's too little too late.

The real question is whether python3 can avoid the same fate...

assfaceon Drug Goes from $13.50 a Tablet to $750, Overnight

> I've yet to see any one industry that has been nationalised as is performing better (in every sense) than the private sector.

The nationalized health care programs seem to be performing better in other countries than ours.

assfaceon More efficient memory-management could enable chips with thousands of cores

Lamport clocks are logical. You can think of these as physiological.

assfaceon 3D Xpoint memory: Faster-than-flash storage unveiled

> Dear Micron, brace for a mother of all patent lawsuits from HP.

Ignore this person. They don't know what they are talking about.

This is phase-change memory. It's been on everyone's radar for the last decade. HP is pushing their titanium oxide memristors. That's a completely different technology.

assfaceon To Be Continuous

All of the academic stream systems from the early 2000s are long over. The students have all graduated.

Truviso got bought by Cisco and disappeared into their internal projects.

StreamBase got bought by TIBCO and is still available today.

assfaceon New in Cassandra 3.0: Materialized Views

Awesome. Welcome to 1998.

assfaceon The town that banned Wi-Fi

> "People come here because they say they can hear the electrics"

That phrase is straight out of a Deliverance-like horror film.

assfaceon Self-Adjusting Computation

There is a significant storage overhead due to all of the data that is collected about the computation (the "dynamic dependency graph").

The storage overhead is massive. It's a non-starter with this approach. Our experiments with self-adjusting computation were in the range of 30-100x for simple algorithms. That means if you have a 1TB data set, you need 30TB just to store the intermediate results.

A relational database with materialized views or the special purpose systems that you cite (DBToaster, LINVIEW) are better approaches.

assfaceon Creating multi-game highscore lists in ArangoDB

> It’s left to the operating system to determine the working set and to transfer pages between main memory and secondary storage

Sigh. Good ol' mmap. They should ask MongoDB how they went for them. Then they should read Stonebraker's 1981 paper:

http://db.cs.berkeley.edu/cs286/papers/os-cacm1981.pdf

People never learn.

assfaceon Michael Stonebraker wins Turing Award

Fun Fact: Stonebraker used to party with Michael Jackson in the early 1980s when Thriller came out:

https://youtu.be/LCXWF-OEIkc?t=6m17s

assfaceon Apple Acquires FoundationDB

Mmm... they were just doing shared-data distributed MVCC. Nothing new there. My takeaway from spending some time with the documentation that their SQL layer was a hack.

assfaceon It Is Time For Basic Income

Because you don't live in a vacuum. Our society makes it possible so that you can earn a living. You're just paying back for having that opportunity to those that are less fortunate.

assfaceon Experience with ePaxos: Systems Research using Go

> Paper weaknesses

> Evaluated using prototypes of protocols in Go

Retarded. This is why I left academia.