Re: No captcha
Yeah, no captcha for me either - just username, password and auth code (I have 2 factor auth enabled).
9 publicly visible posts • joined 10 Dec 2009
In what way do you think Postgres lacks LOB support? It has a large object datatype (lo) and APIs for chunked/random access to individual objects including JDBC/ODBC support, and it has a byte array (bytea) datatype which which most people generally use for storing images etc. these days.
My daughter's HTC Wildfire suffered from the stalled download problem, which took a few hours of swearing to sort out. My wife's HTC Hero's software worked fine. It was just the hardware that had a constant stream of problems on that one.
Meh, might as well admit I use an iPhone myself. No problems with the 3G or 4 (so far).
PostgreSQL allows concurrent insert/update/delete activity on a table, when creating an index using CREATE INDEX CONCURRENTLY. It does this in a vaguely similar manner to the script the story is about, by keeping track of the tuples that have changed whilst the index is being built, and then updating it with those changes before making it available for use.
The big difference is, that the code to do this is built into the server at a low level, rather than what can only be described as a very scary trigger based hack implemented outside of the database. I suppose that doesn't matter for Facebook though - who cares if the odd status update gets lost?
It's not correct to say that all databases require full table locks to create indexes. PostgreSQL for example, has had concurrent index builds for years using CREATE INDEX CONCURRENTLY. Even the standard CREATE INDEX only locks writers, unlike some databases which apparently also lock out readers.