Re: [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 <
ferna...@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 
>
>> 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 
>>>
>>>>  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
>
___
Opensim-dev mailing list
Opensim-dev@lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-dev

Re: [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 <
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 
>
>>  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
>>>
>>> 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 
>>>
>>>
>> 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
>>
>
>
> ___
> 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] Current state of region border crossing support for vehicles

[Shy Robbiani]

Hello, I'm highly interested in region border crossing support for vehicles
(actually vehicle types airplane, balloon and boat). As such I already
explored Opensim 12 - 18 months ago. There was a lot of rumor about
BulletSim and upcoming work that will be done in the direction of my
interests, so I decided to wait.

Now, one year later, I'm happy to see big improvements with BulletSim but I
still cant see any improvements in region border crossing. I read a side
note in the dev meeting minutes of 2013/08/20 where Nebadon mentioned that
Melanie is itching to get vehicle border crossing in before someone else
attempts it. However, I cant find any further information nor anything else
related in the Mantis.

What are the current plans, are there any? Am I missing something or is the
hype over? And what can I actively do to get the work done that's needed to
get it as fast as possible? From my side I can offer some time for testing
on both, Windows and/or Debian Linux. I'm not a crack, but in addition to
LSL I also have an average knowledge of C#/.Net and can at least read and
understand the code or even make small changes. I'm somewhat familiar with
OpenMetaverse and have a deep knowledge of Radegast and its plugin concept.

Now it's your turn to get on me with your suggestions and information how
to proceed.
___
Opensim-dev mailing list
Opensim-dev@lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-dev