Hi Anton - Thanks for adding Postgres support to Alchemi.
There were a few changes I had to make to get SQL Server to work however. Specifically, there were a few queries in GenericManagerDatabaseStorage that you had changed that work with Postgres but don't with SQL Server. What I did was refactor those queries into their own methods (e.g., protected virtual string GetPowerUsageSqlQuery() ) within GenericManagerDatabaseStorage and then overrode the methods in PostgresqlManagerDatabaseStorage to return the Postgres version of those same queries. You may want to take a look at GenericManagerDatabaseStorage and PostgresqlManagerDatabaseStorage to see how and what I did. You also might want to test to ensure that the changes I made still work with Postgres. They _should_, but I don't have Alchemi installed on Postgres here. However, once again, thanks. Jonathan On 2/14/07, Anton Melser <[EMAIL PROTECTED]> wrote: > > On 13/02/07, Matt Valerio <[EMAIL PROTECTED]> wrote: > > Hi Anton, > > > > Adding PostgreSQL support would be awesome -- we'd love to add your > > contributions to the codebase. > > > > Are you familiar with Subversion? I can add you as a developer so you > can > > check out a copy of the repository, make your changes, and commit > it. What > > is your Sourceforge username? Let me know and I can set that up if > you'd > > like. > > Hi, > My sourceforge username is antonovich. I am fairly familiar with > subversion... though mainly via command line on linux. I have > installed both ankhsvn (a real pain) and tortoisesvn (not so bad), and > my changes were to a copy of trunk which I got on Saturday. If you > don't mind giving me commit for my first contribution then I am more > than happy (less work!) to just add my username and password to my > current setup and commit away. > Cheers > Anton > ps. I am also very keen to be involved in moving to a non-rdbms > storage solution... something like a fully managed oodbms that we can > pass between managers? > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Alchemi-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/alchemi-developers
