Specs of Salons Subscription System

legLess writes "Scott Rosenburg, Salon's VP of operations, wrote an interesting article for Web Techniques about Salon's subscription system. It goes into a fair amount of technical detail (JavaBeans and JSP on Linux for login and authentication; Perl, HTML::Mason and MySQL (CD: and oracle) for content). He also talks about their subscription numbers, what drove them to do it, and their plans for the future (technical and operational). A little fluffy, but still a good read."

Comments

Re:what the fuck?

[Billly Gates]

The next version of the upcoming slashcode supports postgreSQL. Unlike mySQL, postgreSQL offers nested selects, transaction support, and ansi-sql 92 compliancy. Infact it may be the most sql-92 compliant database around. It may not be as fast as an embedded quick and ditry file system for internal programming jobs, which mysql was designed for. But postgreSQL is quite good as a standalone database. Of course nothing beats big iron databases like Oracle, DB2, Sybase and MS-SQL but if your on a tight budget postgresSQL will do wonders. ALso the next version should support replication which is essential in any enterprise level database. I believe MYSQl is qite behind in this. Why PostgreSQL is not the defacto poor man's database is beyond me. However in Japan all the linux magazines and books mainly only focus on PostgreSQL and the situation is reverse there. I believe www.phpbuilder.com did a test with postgreSQL and Mysql to see which was more scalable and PostgreSQL kicked ass.( I am too lazy to look up the url.)

RedHat chose postgreSQL for a reason and not mysql. Hmm I wonder why?