Re: Web application development on Win32, deployment on Linux

> > > I currently maintain a website which is deployed on LAMP,
> but it is
> > > developed on Windows (WAMP?). I'm considering moving both to use
> > > PostgreSQL. I'm curious as to whether others are following a
> > > similar development/deployment model and if so, what
> > > pitfalls/gotchas they have found. For example, I refresh
> production
> > > tables on a weekly basis from the development database.
> Linux MySQL
> > > is case-sensitive about table names but Windows isn't, so
> I have to
> > > modify table names like 'whatsnew' on Windows to
> 'WhatsNew' before I
> > > can run the reload script on Linux.
> >
> > [snip replication - can't answer that]
>
> Regarding replication, the Slony-I guys state that their
> project is not yet ported to Windows, but giving that there
> is a pthread library for Windows (which is about the only
> thing it lacks, apparently) then it should be possible to
> port it rather easily. I'm sure they'd welcome it if
> somebody were to do the legwork. I know of several people
> who would be very glad to have Win32 Slony-I.

Dave, Andreas, me and Hiroshi are working on this. It's not at top-speed
right now due to the main projects feature freeze, but work is in
progress, and it's definitly doable.

(Hey, I knew that. Should've answered from the beginning :P)

//Magnus