about photos bookshelf portfolio blog home
Begin main content

Sun to integrate PostgreSQL into Solaris 10 [software.newsforge.com]

This is very good news. Hopefully this will be another tool to help IT departments and companies look at Postgres as an alternative for mid-range databases.

The sort of things that are implemented in MySQL or Sybase are much better (IMO) developed on Postgresql. The only impediment to being a total replacement for all enterprise DBMS products apart from Oracle is better replication support. Even many applications using Oracle would be excellent candidates for Postgres if they are not using Oracle's real winning features like the Media server.

02:14 PM, 24 Nov 2005 by Mark Aufflick Permalink | Comments (0)

del.icio.us uses perl/mason

And I discovered this tidbit because i hit a bad database handle in their code and they have fatal error display turned on!


System error

error:  Can't call method "prepare" on an undefined value at /www/del.icio.us/comp/user/get line 13.
context: 
... 
9:  my $usedb = 'master';
10:  my $ret;
11: 
12:  if (!$auth_user) { $usedb = 'user' }
13:  if (!exists ($db->{$usedb})) { $usedb = 'master' }
14:  $user_name_q->{$usedb} = $db->{$usedb}->prepare('select * from users where user_name = ?');
15:  my $query = $user_name_q->{$usedb};
16:  $query->execute(lc($user_name));
17: 
... 
code stack:  /www/del.icio.us/comp/user/get:13
/www/del.icio.us/site/dhandler:194
/www/del.icio.us/site/autohandler:108

I'm surprised they don't use some sort of global cache for prepared statements - that query must get run a LOT.

10:50 AM, 24 Nov 2005 by Mark Aufflick Permalink | Comments (0)

XML

Blog Categories

software (4)
  ..heads up 'tunes (4)

Notifications

Icon of Envelope Request notifications

Syndication Feed

XML

Recent Comments

  1. Mark Aufflick: all good ideas
  2. Unregistered Visitor: Excellent!
  3. Mark Aufflick: Hey thanks
  4. Unregistered Visitor: Fantastic entry
  5. Mark Aufflick: Bah - dashboard widgets
  6. Unregistered Visitor: Nice
  7. Mark Aufflick: elegant maths (as opposed to elegant rabbit)
  8. Unregistered Visitor: Does that really matter?
  9. Mark Aufflick: Inspiration
  10. Unregistered Visitor: Perhaps...