<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">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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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 class="HOEnZb"><div class="h5">
<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">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>