Search Postgresql Archives

Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





--- On Mon, 6/29/09, Tguru <guru@xxxxxxxxxx> wrote:

> From: Tguru <guru@xxxxxxxxxx>
> Subject: Re:  Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
> To: pgsql-general@xxxxxxxxxxxxxx
> Date: Monday, June 29, 2009, 1:33 PM
> 
> To migrate the site, you can use an open source ETL tool.
> 
> Talend Open Studio is an open source ETL tool for data
> integration and
> migration experts. It's easy to learn for a non-technical
> user. What
> distinguishes Talend, when it comes to business users, is
> the tMap
> component. It allows the user to get a graphical and
> functional view of
> integration processes. 
> For more information: http://www.talend.com/
> 

> Justin-95 wrote:

> > 
> > 
> > APseudoUtopia wrote:
> > 
> >   thread, then logs out (intending to
> read all the other forum threads
> > at some point in the future when they log in again).
> If I used a VIEW,
> > it would automatically consider all those unread forum
> posts to be
> > read when the user logs out.
> > 
> >   
> > That wouldn't work. What if a user logs in, reads only
> one forum 
> > 
> > 
> > You are keeping a list of all the forums a user has
> read,  i would not
> > worry about making sure the table tracking user
> activity has duplicate
> > key values. The select can be limited to return just
> on row with the
> > highest time stamp then compare this result to figure
> out what forms
> > the user has not read yet.  This eliminates one of
> problems but creates
> > a problem where table tracking user activity is going
> bloat but in low
> > traffic times delete the duplicate values. 
> > 
> > A similar topic was discussed  on the performance 
> mailing list, where
> > updates are hung for several seconds for a similar
> tracking table... 
> > http://archives.postgresql.org/pgsql-performance/2009-06/msg00300.php
> 
> > 
> >   
> > 
> > 
> > 
> > 


another option is Pentaho, is good and easy too http://kettle.pentaho.org/




-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux