I use both. The choice of which to you depends on the application - google is your very good friend ./Ok3ch On Tue, Jun 10, 2014 at 8:42 PM, gisho <gichuhie@gmail.com> wrote:
I recently migrated my system from MySQL to PostgreSQL. I had different processes relying on a common table. The Dependant process could not get data that has not been explicitly committed after an insert, something that works out of the box with PostgreSQL. I can't say am conversant with either but thats my only beef with MySQL.
On Tue, Jun 10, 2014 at 9:47 PM, Joseph Tintale <jayxtintale@gmail.com> wrote:
Hello George, I have used both postgresql and mysql. Deciding on using either depends mainly on which of the two you are more conversant with and the availability of developers if you want to assemble a team to work with.
From my experience, mysql is easier to set up and maintain while postgresql has a deeper learning curving.
Postgresql in the other hand is more compliant with the SQL standards such that in future if your app scales and you decide to migrate to say oracle, it will be a breeze.
There is a well written article by digitalocean comparing several SQL flavour that i would recommend you read through. Find the link below.
https://www.digitalocean.com/community/tutorials/sqlite-vs-mysql-vs-postgres...
Regards, Joseph.
On Tuesday, June 10, 2014, TheMburu George <themburu@gmail.com> wrote:
Hi skunks
Firstly who is well versatile in postgreSQL?
Secondly for those who have used both, what would recommend or how do both rate?
./TheMburu
-- Conservatism is the adherence to the old tried against the new untried.
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke