Re: [GENERAL] anyone have experience with using Talend ETL tool

2008-04-01 Thread Tomás Di Doménico
Irina Connelly wrote: Hi, I am looking around for an ETL tool to transfer data from one Postgres database to another periodically. I was wondering if anyone has used Talend's Open Studio or any other ETL tools and wouldn't mind sharing their thoughts. Thanks, Irina I've been using

Re: [GENERAL] PostgreSQL and MOLAP ?

2008-03-11 Thread Tomás Di Doménico
Joe Conway wrote: Kevin Kempter wrote: Anyone know of any MOLAP/MDDB/MDX Business Intelligence reporting solutions tahat work on top of PostgreSQL ? I haven't used it myself, but you could check out Mondrian: http://sourceforge.net/projects/mondrian/ HTH Joe And for a complete

Re: [GENERAL] Documenting a DB schema

2008-03-04 Thread Tomás Di Doménico
Check http://www.postgresql.org/docs/8.3/interactive/sql-comment.html Cheers! Shahaf Abileah wrote: I’m looking for a systematic way to document the schema for the database behind our website (www.redfin.com http://www.redfin.com/), so that the developers using this database have a better

[GENERAL] Trying to understand encoding.

2008-02-15 Thread Tomás Di Doménico
Greetings. I'm currently using 8.3, but I've been coping with this since previous versions. I'm trying to integrate some LATIN1 and some UTF8 DBs into a single UTF8 one. To avoid the Invalid UNICODE character... error, I used iconv to convert the LATIN1 dumps to UTF8. Now I have the data into

Re: [GENERAL] Trying to understand encoding.

2008-02-15 Thread Tomás Di Doménico
Geez. My default terminal didn't support UNICODE. Shame on me :P Thanks! Douglas McNaught wrote: On 2/15/08, Tomás Di Doménico [EMAIL PROTECTED] wrote: Now I have the data into the UTF8 DB, and using graphical clients everything seems to be great. The thing is, when I query the data via