Tag: SQL

Andertoons 2.0 – This Time It’s PostgreSQL

andertoons2 Comments

One of the big changes we made in the new Andertoons.com was changing from a MySQL database to a PostgreSQL database.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

Yeah, I don’t understand it either, but if you go by their logos alone…

Psql

Mysql

…I’d bet an elephant could kick a dolphin’s ass any day of the week. So that’s good.

Enjoy!

Technorati Tags: , , ,

Tinkering

andertoons

OK, so my web guys and I have been working on some new stuff for everyone’s favorite cartoon website.

Most of it won’t even be visible to all but the most observant users, but it’s going to make administration for me a dream. Seriously, this is going to be like every MySQL dream I’ve ever had.

It’s a big big BIG change. We’re basically ripping out the guts of the site and replacing it with a shiny new engine. If we’ve done it right you shouldn’t notice a thing, but, of course, there’s probably gonna be a few glitches.

That being said, I’d like to thank everyone who visits the site, gets the daily email, subscribes to the blog toon, or whatever else you can come up with in advance for your patience. Trust me, it’ll be worth it down the line.

We have some crazy stuff coming down the pike that’ll knock your browser’s socks off.

Hang in there…

Technorati Tags: , , ,