scragg

10 ms·

91.
by scragg 14y ago
Someone should write a client library so you can do ad hoc data aggregation queries without using SQL. You can call it NoMoSQL :)
92.
by scragg 14y ago
Well if they sold out, wouldn't the units available and sold be the same? Unless they are selling units that don't exist yet. Apple does this too, they say "We sold out in x hours" and neglect to say how many units they sold. That info d
93.
by scragg 14y ago
Anyone else notice one of the engineers does not blink in the video?
94.
by scragg 14y ago
How do you handle the size of the table (which I assume has many rows). Do the inserts start to slow down as it grows? How much RAM did you have for a master DB instance? Thanks for any input!
95.
by scragg 14y ago
Well this sort of explains the question I was thinking... which was how they would deal with such a massive table? At some point the indices will grow very large and need to be split up some how or they won't fit in RAM.
96.
by scragg 15y ago
I would like to add that MediaWiki does this. Here is the DB schema: http://upload.wikimedia.org/wikipedia/commons/2/2c/Mediawiki...
97.
by scragg 15y ago
When you do a SELECT * and with a join or two, you get the chance of field name conflicts which can cause logic errors. You either have to alias the conflicting fields, specify each field you want on the select, or prefix field names so th
98.
by scragg 15y ago
I can relate to the decision Reddit made. Moderating the content on a forum is alot of work and it's frustrating. Eliminating the grey area is probably the safest move (on a legal stand point) although it will create many angry users that