PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS), derived from the Berkeley Postgres database management system. "PostgreSQL is one of the best-managed open source projects out there" a friend-in-the-know told me about 2 years ago, so today we feature a mini-interview with five members of the PostgreSQL team about their plans on the popular DB.
Permalink for comment
To read all comments associated with this story, please click here.
Postgresql has had unicode support for quite some time now. It's very very popular in Japan, more so than any other OS database, mainly because of it's early support for locales and multi-byte encoding. Prior to 7.2 you had to explicitly compile multi-byte in, but now it's just there.
Full text indexing is still handled by an external package. There are actually two, tsearch and fts, and they each have their strengths and weaknesses.
Keep in mind, the fact that the full text searching is an "add on" is actually a good sign. It means you have a database that can be extended by users into spaces the main developers may not have time to go into, and tested and retested without waiting for it to get "integrated" into the core. It's easy as heck to install either full text engine, and they're quite fast.
Postgresql has had unicode support for quite some time now. It's very very popular in Japan, more so than any other OS database, mainly because of it's early support for locales and multi-byte encoding. Prior to 7.2 you had to explicitly compile multi-byte in, but now it's just there.
Full text indexing is still handled by an external package. There are actually two, tsearch and fts, and they each have their strengths and weaknesses.
Keep in mind, the fact that the full text searching is an "add on" is actually a good sign. It means you have a database that can be extended by users into spaces the main developers may not have time to go into, and tested and retested without waiting for it to get "integrated" into the core. It's easy as heck to install either full text engine, and they're quite fast.