assface

8 ms·

31.
by assface 8y ago
AFAIK It uses the MySQL frontend with a heavily modified InnoDB engine that writes to their shared-disk storage.
32.
by assface 8y ago
The Mighty Boosh - Future Sailors https://www.youtube.com/watch?v=eAbkh4TMRqg
33.
by assface 9y ago
Which "HyperDB" are you talking about? I already listed Tableau's HyPer. Here are the other "hyper" systems that I know about and they don't do LLVM compilation: * HyperDex ( http://hyperdex.org/
34.
by assface 9y ago
AFAIK, SQL Server's Hekaton engine only compiles the queries inside of stored procedures and UDFs. They do not compile every query that comes in from the client: https://docs.microsoft.com/en-us/sql/relational
35.
by assface 9y ago
AFAIK, there are only a handful of DBMSs that do complete query compilation with the LLVM: * MemSQL ( http://highscalability.com/blog/2016/9/7/code-generation-the... ) * Tableau/TUM HyPer ( https:&#x2
36.
by assface 9y ago
See CMU's Time-Series Database Lectures from last year: http://db.cs.cmu.edu/seminar2017/
37.
CMU Time Series Database Lectures(db.cs.cmu.edu)
211 points by assface 9y ago|17 comments
38.
by assface 9y ago
Richard Hipp has said that they have signed contracts to support SQLite3 for 35 years. SQLite4 is never going to happen.
39.
by assface 9y ago
> Cinnabon is surely only a little behind Philip Morris in collateral damage caused. I disagree. I had a bad bowel obstruction once after minor surgery. I was backed up for over a week. My doctor told me to head straight to the local mal
40.
by assface 9y ago
Not string lengths, but definitely other things. For example, Oracle is notorious for only allowing 1000 columns per table: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUE... They bumped it up to 1000
41.
by assface 9y ago
What you are referring to is called a "temporal database". Your specific example is called a "bitemporal database". https://en.wikipedia.org/wiki/Temporal_database https://en.wikipedia.or
42.
by assface 9y ago
> If p != np, then comp sci will lose much of its appeal. Say what? A lot of work is based on the assumption that P!=NP so you have to be clever in other ways.
43.
by assface 9y ago
CMU's DBMS is trying to do this: http://pelotondb.io
44.
by assface 10y ago
> No, no it really is not. It's getting grants, advising grad students, etc etc. You are talking about tenure-track or research professors. A teaching-track professor (typically) does not have PhD students so they do not have to get
45.
by assface 10y ago
> Not to mention that MIT and other 'elite schools' barely teach well anyways. Ignore this person, they don't know what they are talking about. For better or worse, the 'elite' schools have money. That means they
46.
by assface 10y ago
> No, building a database is not hard. Cool. Do you support existing reporting tools and libraries? What about standard APIs for data discovery (i.e., INFORMATION_SCHEMA)? What about transactions? What about tools for examining log files
47.
by assface 10y ago
> It’s relational, but not SQL. Why not? If you already support relational algebra, it seems like a non-brainer to just add SQL. Even if it's only SQL-92 you would be able to support some existing tools/ORMs almost for free.
48.
by assface 10y ago
> Given that CockrochDB is based on Spanner and F1, this DBaaS sounds like it will compete directly with them. Except that it's not. CockroachDB uses MVCC. Spanner uses 2PL and F1 uses OCC. Not the same at all.
49.
by assface 10y ago
It's over 15 years old.
50.
by assface 10y ago
> Within the spectrum of so-called "NewSQL" databases, there are basically two kinds: The guy that invented the term "NewSQL" seems to disagree with you: https://sigmodrecord.org/publications/sig
51.
by assface 10y ago
> Tangentially, I've always wondered why databases today still aren't capable of being self-tuning. http://pelotondb.io
52.
by assface 10y ago
Those degrees are not CS. AFAIK, CMU only has a software engineering online degree.
53.
by assface 10y ago
> Now, these things sound nice on paper, but they run completely contrary to my experience in dealing with universities in my community. If you aren't pay tuition, they won't tell you the time of day. Are you talking about facu
54.
by assface 10y ago
Our experiments with Boost ASIO have shown it to be slow. Has anybody else experienced similar problems?
55.
by assface 10y ago
This is not peer-reviewed. This is a tech report. Anybody can post these.
56.
by assface 10y ago
> As far as I know there isn't any autopilot that can fly a plane unattended CMU is working on this (seriously).
57.
by assface 10y ago
Correction: CMU CS undergraduate program admits 300 each year, 135 enroll. The acceptance rate is around 6%
58.
by assface 10y ago
Ignore this person, they don't know what they are talking about.
59.
by assface 10y ago
> If you would like to know why it's offensive to some people, I could educate you. Please do. https://i.imgur.com/jElyDnl.jpg
60.
by assface 10y ago
> Another contender was FoundationDB, No, it was not. FoundationDB's SQL layer was a joke. The system was horribly slow. Every DBA that I talked to that tried it said that it did not deserve the hype that it got.

More ›