Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-12 Thread 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

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-12 Thread Fernando Francisco de Oliveira
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

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-12 Thread 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

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-12 Thread Fernando Francisco de Oliveira
Good. It would be nice to see the results when you get it. I'm going to conduct some more tests on my server too. The preliminary tests I've done at my home computer, with win8 and lots of stuff installed. Timothy Rogers did some tests on his servers and got better results that I did. Fernando

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-11 Thread James Stallings II
Hi Sean, Migration would most readily be accomplished with the very excellent OAR capability provided by Justin Clarke-Casey a few years back ;) Cheers On Thu, Oct 10, 2013 at 11:18 PM, Fernando Francisco de Oliveira ferna...@oliveira.eti.br wrote: Hello, thank you for your support. Me and

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-11 Thread Fernando Francisco de Oliveira
Yes, but for griders, I think it need a migration too, what oar can't do ... Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/11 James Stallings II james.stalli...@gmail.com Hi Sean, Migration would most readily be accomplished with the very excellent

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-11 Thread 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

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-11 Thread Fernando Francisco de Oliveira
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,

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-10 Thread James Stallings II
Brilliant Fernando, Cheers! James On Thu, Oct 10, 2013 at 9:09 PM, Fernando Francisco de Oliveira ferna...@oliveira.eti.br 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

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-10 Thread Diva Canto
I don't have any objections on taking this into core, as long as Fernando is willing to maintain it in the long run. Thanks, Fernando. On 10/10/2013 7:09 PM, Fernando Francisco de Oliveira wrote: Hello I just requested a push from my fork of opensim to the nebadon git opensim repository,

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-10 Thread Sean McNamara
This is very cool! Fernando -- are there any quantitative results of how well PostgreSQL handles OpenSim's workload compared to MySQL/MariaDB? Has anyone tested the performance to see if it is actually better? I know it's very hard to compare two database systems, because you can easily produce

Re: [Opensim-dev] PostgreSQL data module for OpenSim

2013-10-10 Thread Fernando Francisco de Oliveira
Hello, thank you for your support. Me and Timothy did some preliminary tests and it seens to work in a some way better than mysql. But as you said it depends from each environment where it is been tested. I'm working on a software tool do do the migrations from any opensim supported database to