Koozali.org: home of the SME Server

Will SME use postgresql instead MySQL in future?

Offline linuxhelp

  • *
  • 173
  • +0/-0
    • Linux PC & Server Support
Will SME use postgresql instead MySQL in future?
« on: November 04, 2010, 04:44:08 PM »
which are the advantages of postgresql?

thanks for informations..

Tom
Linux PC & Server Support
http://www.linuxonlinehelp.de
.. i Love SME..

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: Will SME use postgresql instead MySQL in future?
« Reply #1 on: November 04, 2010, 04:50:36 PM »
AFAIK no, there's no plans to move to postgresql

anyway, why do you ask such a question?

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Will SME use postgresql instead MySQL in future?
« Reply #2 on: November 04, 2010, 05:16:30 PM »
which are the advantages of postgresql?
Your best bet for this information is Google, a quick search will show you a amount of information: http://lmgtfy.com/?q=postgresql+vs+mysql

MySQL and PostgreSQL should be able to operate on SME Server simultaneously, MySQL is on the server as it is a requirement for the webmail system Horde that is part of the SME Server core, other than that there is no reason for MySQL being there perse. That being set a lot of applications are created for MySQL database servers, where there are programs that make use of a PostgreSQL database but they are certainly less in number.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline linuxhelp

  • *
  • 173
  • +0/-0
    • Linux PC & Server Support
Re: Will SME use postgresql instead MySQL in future?
« Reply #3 on: November 04, 2010, 05:54:34 PM »
Hello@ALL,

thanks for reply, i read about some news about plans of oracle
to make changes on mysql, to this mysql is not free. This was the
basic idea on my questions if there a plans to replace mysql at the
core system. I don't know much about postgresql but much online
newspapers wrote about it.

Are there some good howtos of mysql on SME to fine tune mysql?
(no tuning) or does the basic setup with cd always set the best settings
for ram and cache settings of mysql? (i am not a mysql guru)
Thanks Tom
Linux PC & Server Support
http://www.linuxonlinehelp.de
.. i Love SME..

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: Will SME use postgresql instead MySQL in future?
« Reply #4 on: November 04, 2010, 06:55:59 PM »
thanks for reply, i read about some news about plans of oracle
to make changes on mysql, to this mysql is not free.

Don't believe everything you read. The version of mysql used in SME is free and will always be free. Oracle can do nothing about that.

Did you search for mysql tuning advice?

Offline piran

  • *****
  • 502
  • +0/-0
Re: Will SME use postgresql instead MySQL in future?
« Reply #5 on: November 04, 2010, 07:31:24 PM »
...http://lmgtfy.com/?q=postgresql+vs+mysql

LMGTFY: How wonderfully offbeat ...and that terminating chide ;~)

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: Will SME use postgresql instead MySQL in future?
« Reply #6 on: November 04, 2010, 08:44:54 PM »
AFAIK no, there's no plans to move to postgresql

And it's very likely that there will not be. postgresql databases are a pain during upgrade. mysql is no trouble at all.