now you get a faster computer that makes honey!

I used to say the same thing, but unfortunately it's not so clear cut. The intel drives which post such great random i/o numbers only do this because they are configured in write back cache mode w/volatile cache. The x25-M in write through mode can post about 50iops writing -- I'm not kidding. Also, wear&tear on the drive is much higher. IOW, the intel controller does not perform magic -- they cheated. The x25-e drive is configured the same way -- the performance drop for going to write-through is not so high (you can eek 1000ish iops out of a drive) but the drives are expensive and the the math doesn't work out all that well. The basic problem is that flash is plain and simply lousy at random writing just like hard drives. With a small NV cache on the drive, things could be completely different (and some boutique mfg IIRC already offer this) but until you see Intel, Seagate, or WD on a drive with NV guarantee for at least semi-reasonable price you will not see serious intrusion into the enterprise.

for the cases that you can't strictly do the query, we push the logic into a function call and dyna-sql it. (to hide the internals, it's actually mostly function calls over the low security interfaces). we also wrote a libpq wrapper to allow sending and receiving extremely complicated structures over libpq protocol efficiently. (here, if you're curious: http://libpqtypes.esilo.com/).

We use PostgreSQL. We expose the libpq not default port directly to the internet through pgbouncer. What we did:

*) Modify pgbouncer to only except extended protocol (parameterized) queries
*) Auto Generate list of allowed queries used by app to store in whitelist
*) Block all functions except auth if authenticated or to the whitelist othewise
have had zero problems. curious what you think.

Postgres has traditionally had lousy replication options. This of course is going to change with 9.0 hs/sr. Older versions of postgres (pre 8.x) had some operational difficulties that made it an awkward fit for high transaction load web environments. Now that those downsides are pretty much eliminated, it's about the best general purpose sql database out there -- it has many niceties/features that are rare/non-existent elsewhere. Transactional ddl for example.

11%...edging out ms sql server! Postgres 9.0 has built in replication -- it will be interesting to see how that affects its share of the open source db space.

It was nice of them to deallocate the cursor when done. Thanks!

I agree with most of what you said except for the comments on javascript. As a systems programmer you should understand that it is inefficient and silly to force the interface to refresh an entire page just to pull small pieces of data from the server and render them. There are many other wonderful things that javascript provides in terms of interface and user experience. Of course, I'd prefer a cleaner, more strongly typed language than what is probably the most informal language ever invented, but javascript is a big part of what makes the internet what it is today. applets and flash need to die though,

at least we're used to it...

A company creates a digital content distribution service that is (almost) single handedly keeping pc gaming alive and we speculate how unfair it is. To great things go great rewards...losing sight of that simple principle shows just how into twilight we have gone.

postgresql has short term transactional record locks as well as long term advisory locks. It has the ability to do paradox style locking if you are so inclined...

so...it's legal and acceptable to have copies, you just can't make them...

that's not fair at all..comparing the low end corolla with the volt...the volt's got better torque and much sportier times. to be fair, you need to start with the corolla xrs, which is 20k base price. the point still holds, but its even closer now.

That's a very fair point. I'll say this though: most libertarian economists warn about the dangers of governments using policy to direct economic matters. This criticism is very well founded; generally things start out well, but inevitably things go wrong and the perpetrators end up blaming the free market for all the problems. There are of course examples and counter examples on both sides, so things are completely black/white, but as a general trend it rings true. While libertarian economists (to use a stereotype) are political in the sense that they look at the economic problems resulting from political issues, they tend to think that economic policy should be apolitical...that is, get politicians of all striped out of the money business. Krugman is the nemesis of that line of thinking.

The problem with Krugman is that he is relentlessly political and that is a bad trait for an economist. He tireless argues for greater and greater interventions in the marketplace (that is, he's a statist) without taking into account the secondary effects of those interventions because that would contradict his world view. He's also very popular in Washington :-).