my intention with the project was to add new features and not replace them. With a database like postgresql, we can cover more users, and many of them in the corporate environment. Database migration is an option, and I'm working on a tool to cover who want to do it.
I saw some advantages using postgresql, but it's necessary to do more benchmarks to see how its behavior under pressure. This was a little test : https://docs.google.com/document/d/1iPjAItQPNQCUagROLogf6GZH3NdPE_Wtn2KtAIhYwyE/edit?usp=sharingless Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/12 Shy Robbiani <shy.robbi...@gmail.com> > 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 >
_______________________________________________ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev