[Opensim-dev] PostgreSQL data module for OpenSim

[Shy Robbiani]

Interesting. I'll give it a try on my test sims and watch memory
consumption as memory limitations are often an issue for some virtual
server installs. And yes, it's always good to have options. I'm glad to see
it in the git master :)

On Sat, Oct 12, 2013 at 3:39 PM, Fernando Francisco de Oliveira <
fernando at oliveira.eti.br> wrote:

>  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.robbiani at 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 <
>> 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
>>>
>>
>>
>> _______________________________________________
>> Opensim-dev mailing list
>> Opensim-dev at lists.berlios.de
>> 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/e1b13df5/attachment-0001.html>