[Opensim-dev] PostgreSQL data module for OpenSim

[Shy Robbiani]

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 <
fernando at 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 <jamesh at 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 at 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 at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20131012/8d6d3201/attachment-0001.html>