quizotic

11 ms·

61.
by quizotic 10y ago
A profoundly important observation. Yes, using a limited set of physical structures simplifies the code and, in some cases, streamlines execution. But that's putting lipstick on a pig. With a handful of exceptions, database architectur
62.
by quizotic 10y ago
Curious! Ten days after a public disclosure, and no statement from McDonald's? Have they fixed the problem? Do they not know?
63.
by quizotic 10y ago
Hilarious :-) I don't care whether the lessons are useful or not. I just want to be able to write like this.
64.
by quizotic 10y ago
The point is that if a user on the right entered the update command, it would NOT return until after the transaction on the left committed, because there's a database lock on the balance when the left transaction did its update.
65.
by quizotic 10y ago
The efficiency challenge with serializable transactions comes mostly in the context of distributed transactions. Netezza/IBM had a reasonably efficient implementation. Instead of broadcasting individual locks, they shared ordering rela
66.
by quizotic 10y ago
Nitpick: while the gist is correct, the 2nd diagram illustrating how transactions don't help is subtly misleading. The diagram implies that time flows down in the diagram. If so, then the update on the right won't occur until afte
67.
by quizotic 10y ago
Wow! I use emacs every day, and this will make my life easier. Didn't know about these wonderful packages. And the automatic init-file generation probably save me hours and headaches.
68.
by quizotic 10y ago
This motivated me to sign up for ProtonMail. Now I want to send Mike Pompeo a congratulatory email! He seems like a decent guy. Does anyone know where to send an encrypted email to the incoming cia director?
69.
by quizotic 10y ago
> Honestly, I think AS should basically never be used for tables. I believe AS is required for self-joins. A common expository query is to find all employees who earn more than their managers, which can be expressed via "select name
70.
by quizotic 10y ago
And now the outage is over, at least for me
71.
by quizotic 10y ago
at least now http://status.aws.amazon.com/ reports increased error rates (as in 100%?)
72.
by quizotic 10y ago
I get this too. Their service status page doesn't indicate anything wrong, and ironically, the only way to contact them about the problem is to ... you guessed it ... sign into the management console :-)
73.
by quizotic 10y ago
She made me laugh and I learned a thing or two (after 60 years on this earth). Can't ask for more.
74.
by quizotic 11y ago
Also, the date on the publication is Mar 20, 2006. Seems odd that there wouldn't be more recent research.
75.
by quizotic 11y ago
I would give the same kind of advice that financial advisors give for getting out of credit card debt: "find the card with the highest interest rate, make minimum payments on all other cards, and pay as much as possible on the highest
76.
by quizotic 11y ago
Question re inflation and dark energy: current claims are that big-bang started with a very short period of inflation. Haven't heard/understood much on why inflations started or stopped. Now we posit dark energy, that causes accel
77.
by quizotic 11y ago
> Why not accept that C++ isn't a functional language, and realize that many die-hard C++ users won't use these features I'm a die-hard C++ user, and have come to love functional programming for a very C++y reason: improve
78.
by quizotic 11y ago
While not 'vanilla' Postgres, this appears to be packaged reasonably as a PG extension. Since no vanilla PG code was changed, you should be able to upgrade PG without worry. PG 9.5 introduces some support for parallelization along
79.
by quizotic 11y ago
In the old days, SQL operated on rectangular tables and produced rectangular tables ... which doesn't work so well for data that's better modelled as a tree or graph. But there now lots of ways to produced multi-valued output and
80.
by quizotic 11y ago
Oracle has tons of "features" that postgres lacks: * empty string == NULL in oracle * ROWNUM: it's kinda like a limit, but not * DUAL: hah. postgres eat your heart out. And of course there are business practice differences:
81.
by quizotic 11y ago
Robert Haas is the real deal, and will certainly have tested this feature. Perhaps I missed it, but I don't think the post specified how many rows were in the source. Could have been more than a million. Having a relatively expensive f
82.
by quizotic 11y ago
The post shows a 3.5x performance improvement for requested 4-way parallelism, so that's a significant improvement right now! You might be surprised how many queries are bound by memory bus bandwidth and CPU, rather than I/O ... b
83.
by quizotic 11y ago
Very fun read. Debunks casual and misleading uses of mathematics to make social arguments seem unassailable. For example, using percentages in an argument can be misleading when some quantities are (a) very small or (b) negative: (a) at-hom
84.
Ask HN: How do you store customer-supplied (POC) data?
1 points by quizotic 11y ago|1 comments
85.
by quizotic 11y ago
Yes, but why this minority? Why not allow 12 year olds to marry as a consititutional right? Why not allow brothers and sisters to marry? I'm not trying to make a slippery slope argument. I'm really asking. States license things al
86.
by quizotic 11y ago
I'm glad that my LBG friends can now marry anywhere. But damn, Scalia's counter opinion (and Roberts' opinion) strike me as well-considered and well-argued in the 2nd half of http://www.supremecourt.gov/opinio
87.
by quizotic 11y ago
"base salary is the amount you pay a salesperson to not close the wrong deals" This doesn't mesh with my experience, but I love the phrasing. And it makes me wonder whether and how to reward walking away from a deal that coul
88.
by quizotic 11y ago
There are commercial products that do a decent job of what you want. I have experience with Oracle Endeca, and have heard that Qlik is even better. Both have easy ways to load and visualize. There are research frameworks that are quite good
89.
by quizotic 11y ago
Man, this comment is simultaneously both SO right and SO wrong. I guess the tools we have today are set up for knowing what you want to learn. Named Entity Retrieval? Topic classification? Sentiment Extraction? OTOH, why should OP have to k
90.
by quizotic 11y ago
Back when I was a 16 year old mediocre chess player, the captain of our high school team took me aside, set up a position and asked "Do you like white or black?" I looked at the board and said "I don't know." And ch

More ›