What are the advantages of of using PostgreSQL for Opensim in comparison to mysql? Perfomance? Memory usage? Anything else? As far as I know, both have improved over the years and for me, as an average user and not a database guru, they are about the same. In other words, why should I switch if I have everything in place with MySQL?
On Sat, Oct 12, 2013 at 4:00 AM, Fernando Francisco de Oliveira < ferna...@oliveira.eti.br> wrote: > I hope so. I want to see it in production soon. cant wait to compile it > from oficial repository :) > > I'm working on the database migration tool, and it is almost done. (mysql > to postgresql) or any direction (even sqlite to postgres), mssql to > postgres. > as prototype its fixed to mysql to postgres, but adding the database > plugin, like opensim itself, it can be done only configuring the INI file. > > like this: > [Setup] > Databases = myopensim,osmyothersim > > [DatabaseOrigin] > StorageProvider = OpenSim.Data.MySQL.dll > ConnectionString = "Data Source=localhost;User ID=root;Password=***;Old > Guids=true;Database=" > > [DatabaseTarget] > StorageProvider = OpenSim.Data.PGSQL.dll > ConnectionString = "User > ID=postgres;Password=***;Host=localhost;Port=5432;Database=" > > > > Fernando Oliveira > http://oliveira.eti.br > > http://twitter.com/oliveira_lands > > > > > 2013/10/11 James Hughes <jam...@bluewallgroup.com> > >> On 10/10/2013 10:09 PM, Fernando Francisco de Oliveira wrote: >> >>> Hello >>> >>> I just requested a push from my fork of opensim to the nebadon git >>> opensim repository, that I created the PostgreSQL project to use this >>> database in opensim. >>> >>> https://github.com/ffoliveira/**opensimulator/tree/PostgreSQL<https://github.com/ffoliveira/opensimulator/tree/PostgreSQL> >>> >>> I already have a Mantis Account. >>> >>> I hope the code and it's use may improve opensim performance and gain >>> more users. >>> >>> Fernando Oliveira >>> http://oliveira.eti.br >>> >>> http://twitter.com/oliveira_**lands <http://twitter.com/oliveira_lands> >>> >>> >> Thanks Fernando. I have always been suspect of projects that had no PgSQL >> support :) I think it will be a nice addition to our little project. >> >> BlueWall >> >> >> >> ______________________________**_________________ >> Opensim-dev mailing list >> Opensim-dev@lists.berlios.de >> https://lists.berlios.de/**mailman/listinfo/opensim-dev<https://lists.berlios.de/mailman/listinfo/opensim-dev> >> > > > _______________________________________________ > Opensim-dev mailing list > Opensim-dev@lists.berlios.de > https://lists.berlios.de/mailman/listinfo/opensim-dev >
_______________________________________________ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev