Interview with Josh Berkus of PostgreSQL 41
SilentBob4 writes "The PostgreSQL database project has recently released Version 8.0, which was received with quite some fanfare, mostly due to its first-ever Windows port. Mad Penguin talked with Josh Berkus, one of the core team members, to find out how 8.0 has fared since its official release on January 17, 2005. Full interview."
Fatal Flaws (Score:5, Interesting)
Firstly, the broken Unicode support, which arose because certain collation functions doesn't work well on UTF-8 (PostGre uses UTF-8, Win32 prefers UCS-2). The tone you get from reading the bug/support forums are disdainful, pointing the problem to Win32 libraries and suggesting that it should not be in the confines of the PostGres team to fix Windows bugs. Nevertheless, if they already put so much effort to porting to Win32, it seems strange that they are adopting such a stance instead of proactively trying to fix that problem.
Secondly, there is no support for the Win1252 code page, which is very commonly used in English Windows, while mind-bogglingly, there seem to be all other code-pages from Cyrillic to Arabic. This makes migration of data from SQL Server very difficult, and using Latin-1 doesn't help when it encounters characters like `. Yes, Windows should be whacked on the bottom for introducing such shitty incompatibilities but that doesn't solve the problem. The other solution to this problem - to convert to UTF-8 instead - is unavailable because of first problem.
I have been trying to persuade my company to shift from SQL Server to PostGreSQL on Windows (for some reasons, we cannot move over to Linux yet). But after hitting these brick walls - I've giving up. Here's to hoping!
Kudos to Josh and the PostgreSQL team! (Score:3, Interesting)
There is a buzz around (Score:3, Interesting)