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 :)<br>
<br>
<div class="gmail_quote">On Sat, Oct 12, 2013 at 3:39 PM, Fernando Francisco de Oliveira <span dir="ltr"><<a href="mailto:fernando@oliveira.eti.br" target="_blank">fernando@oliveira.eti.br</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div dir="ltr">
<div>my intention with the project was to add new features and not replace them.</div>
<div>With a database like postgresql, we can cover more users, and many of them in the corporate environment.</div>
<div>Database migration is an option, and I'm working on a tool to cover who want to do it.</div>
<div><br></div>
<div>I saw some advantages using postgresql, but it's necessary to do more benchmarks to see how its behavior under pressure.</div>
<div>This was a little test : <a href="https://docs.google.com/document/d/1iPjAItQPNQCUagROLogf6GZH3NdPE_Wtn2KtAIhYwyE/edit?usp=sharingless" target="_blank">https://docs.google.com/document/d/1iPjAItQPNQCUagROLogf6GZH3NdPE_Wtn2KtAIhYwyE/edit?usp=sharingless</a></div>
<div><br></div>
<div><br></div></div>
<div class="gmail_extra"><br clear="all">
<div>
<div dir="ltr">Fernando Oliveira
<div><a href="http://oliveira.eti.br/" target="_blank">http://oliveira.eti.br</a><br><br><a href="http://twitter.com/oliveira_lands" target="_blank">http://twitter.com/oliveira_lands</a>
<div>
<div><br></div>
<div><br></div></div></div></div></div><br><br>
<div class="gmail_quote">2013/10/12 Shy Robbiani <span dir="ltr"><<a href="mailto:shy.robbiani@gmail.com" target="_blank">shy.robbiani@gmail.com</a>></span><br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div>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?</div>
<div>
<div>
<div> </div>
<div class="gmail_quote">On Sat, Oct 12, 2013 at 4:00 AM, Fernando Francisco de Oliveira <span dir="ltr"><<a href="mailto:fernando@oliveira.eti.br" target="_blank">fernando@oliveira.eti.br</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div dir="ltr">I hope so. I want to see it in production soon. cant wait to compile it from oficial repository :)
<div><br></div>
<div>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.</div>
<div>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.</div>
<div><br></div>
<div>like this:</div>
<div>
<div>[Setup]</div>
<div>Databases = myopensim,osmyothersim</div>
<div><br></div>
<div>[DatabaseOrigin]</div>
<div>StorageProvider = OpenSim.Data.MySQL.dll</div>
<div>ConnectionString = "Data Source=localhost;User ID=root;Password=***;Old Guids=true;Database="</div>
<div><br></div>
<div>[DatabaseTarget]</div>
<div>StorageProvider = OpenSim.Data.PGSQL.dll</div>
<div>ConnectionString = "User ID=postgres;Password=***;Host=localhost;Port=5432;Database="</div></div>
<div><br></div>
<div><br></div></div>
<div class="gmail_extra">
<div><br clear="all">
<div>
<div dir="ltr">Fernando Oliveira
<div><a href="http://oliveira.eti.br/" target="_blank">http://oliveira.eti.br</a><br><br><a href="http://twitter.com/oliveira_lands" target="_blank">http://twitter.com/oliveira_lands</a>
<div>
<div><br></div>
<div><br></div></div></div></div></div><br><br></div>
<div>
<div>
<div class="gmail_quote">2013/10/11 James Hughes <span dir="ltr"><<a href="mailto:jamesh@bluewallgroup.com" target="_blank">jamesh@bluewallgroup.com</a>></span><br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div>
<div>On 10/10/2013 10:09 PM, Fernando Francisco de Oliveira wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">Hello<br><br>I just requested a push from my fork of opensim to the nebadon git<br>opensim repository, that I created the PostgreSQL project to use this<br>
database in opensim.<br><br><a href="https://github.com/ffoliveira/opensimulator/tree/PostgreSQL" target="_blank">https://github.com/ffoliveira/<u></u>opensimulator/tree/PostgreSQL</a><br><br>I already have a Mantis Account.<br>
<br>I hope the code and it's use may improve opensim performance and gain<br>more users.<br><br>Fernando Oliveira<br><a href="http://oliveira.eti.br/" target="_blank">http://oliveira.eti.br</a><br><br><a href="http://twitter.com/oliveira_lands" target="_blank">http://twitter.com/oliveira_<u></u>lands</a><br>
<br></blockquote><br></div></div>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.<br><br>BlueWall
<div>
<div><br><br><br>______________________________<u></u>_________________<br>Opensim-dev mailing list<br><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank">Opensim-dev@lists.berlios.de</a><br><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/<u></u>mailman/listinfo/opensim-dev</a><br>
</div></div></blockquote></div><br></div></div></div><br>_______________________________________________<br>Opensim-dev mailing list<br><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank">Opensim-dev@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br></blockquote></div><br></div></div><br>_______________________________________________<br>
Opensim-dev mailing list<br><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank">Opensim-dev@lists.berlios.de</a><br><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
</blockquote></div><br></div><br>_______________________________________________<br>Opensim-dev mailing list<br><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank">Opensim-dev@lists.berlios.de</a><br><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
</blockquote></div><br>