9 posts • joined Thursday 10th December 2009 14:55 GMT
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.
What a refreshing change...
... to read the comments on an article about Apple and not see a mass of rabid hatred from people who have probably never have used their products.
I must be on the wrong website. Or maybe I stepped into an alternate reality when I woke up this morning.
There's no reason the cloud cannot be in your own data center. Some of the vendors have some really cool features these days that are a sysadmin's dream for management, efficiency and availability of services. Eucalyptus is also cool, but has a fair way to go to catch up.
- Geek's Guide to Britain INSIDE GCHQ: Welcome to Cheltenham's cottage industry
- 'Catastrophic failure' of 3D-printed gun in Oz Police test
- Game Theory Is the next-gen console war already One?
- BBC suspends CTO after it wastes £100m on doomed IT system
- Peak Facebook: British users lose their Liking for Zuck's ad empire