MySQL vs PostgresQL: Pros and Cons for Default Database

By: Johnathon Wright on: July 05, 2020

I start up a lot of software with a database for small to mid-size apps that don't particularly have any requirements that would lend themselves to using one or the other SQL database. I just have to pick one. Here are some things I've discovered that inform my thinking about which one to choose.

PostGresQL MySQL
Setup: Installation Seemed simple but apt installed a version that seemed to make odd permission decisions wizard walks you though decisions. Works well. No odd defaults. Other than a lack of timezones.
Setup Permissions they have their own system. When I asked support to explain, they said I was an idiot. typical sql permissions
Support Channel: Pros Willing to share if you ask your questions in exactly they way they want you to ask. Willing to share and help people work through problems, but often want people to create sqllint things, which is time consuming.
Support Channel: Cons more concerned with proving they are great than being helpful can be unresponsive
ID indexes Can lose track of which ID is next after bulk insert. There's a workaround. Hopefully it happens when an admin is monitoring. :`( always knows which id is next.
Geography I hear great things. Distance and other calculations can be done using equations. Gets complicated fairly quickly.

PostgresQL random failures

``` jw@logopolis:/projects/unity/bonsai$ docker-compose run web rake db:drop

Starting bonsaidb1 ... done

PG::ObjectInUse: ERROR: database "unity_dev" is being accessed by other users

DETAIL: There is 1 other session using the database.

: DROP DATABASE IF EXISTS "unity_dev" ```

Just trying to drop a database. Apparently previous attempts are still running?





Comments:

goyard said: Thanks so much for giving everyone an exceptionally brilliant chance to read in detail from this web site. It is always very pleasant plus full of a great time for me and my office fellow workers to search your site at the very least 3 times weekly to find out the newest tips you have. And of course, I'm so at all times satisfied with your astonishing guidelines served by you. Some 4 facts in this posting are certainly the most suitable we have ever had. goyard [url=http://www.goyardus.com]goyard[/url]

curry 7 sour patch said: My spouse and i have been really joyous Jordan managed to conclude his survey because of the precious recommendations he acquired while using the weblog. It is now and again perplexing just to choose to be handing out information and facts which usually other folks may have been trying to sell. And we understand we now have the website owner to appreciate for that. The most important illustrations you've made, the simple site navigation, the relationships you will help to engender - it is everything powerful, and it is leading our son and us recognize that that matter is enjoyable, and that is seriously important. Thank you for the whole lot! curry 7 sour patch

yeezy boost 700 said: I precisely needed to say thanks yet again. I do not know what I could possibly have sorted out in the absence of the aspects documented by you directly on such a question. It previously was a real frustrating case in my position, nevertheless looking at the skilled way you solved the issue took me to weep over gladness. Now i am grateful for this help and even wish you really know what a powerful job your are carrying out educating some other people with the aid of your blog post. I'm certain you've never got to know all of us. yeezy boost 700

longchamp handbags said: I would like to show some appreciation to the writer just for bailing me out of this particular condition. Because of surfing around through the online world and obtaining ideas which are not helpful, I figured my life was done. Living devoid of the approaches to the issues you have sorted out all through the guide is a serious case, as well as the kind which might have in a wrong way damaged my career if I hadn't come across your blog post. That competence and kindness in controlling every part was very useful. I am not sure what I would have done if I hadn't discovered such a solution like this. I can now relish my future. Thanks very much for the skilled and result oriented guide. I won't hesitate to recommend the blog to anybody who wants and needs assistance about this topic. longchamp handbags

curry 6 said: My husband and i got really satisfied John could conclude his preliminary research via the ideas he came across from your own site. It's not at all simplistic just to be making a gift of steps which usually others have been trying to sell. And now we do know we now have the website owner to appreciate for this. The main illustrations you made, the straightforward site navigation, the friendships you will assist to instill - it's many powerful, and it's really leading our son in addition to the family reason why that article is amusing, and that is rather fundamental. Thank you for the whole thing! curry 6

lebron shoes said: Thanks a lot for giving everyone such a nice chance to read from here. It's always very terrific and also stuffed with a good time for me and my office colleagues to search your website no less than thrice in a week to study the new things you will have. And definitely, I'm usually fascinated with the mind-blowing pointers served by you. Certain two ideas in this posting are essentially the most efficient we have had. lebron shoes

balenciaga sneakers said: Thanks so much for giving everyone an extraordinarily brilliant chance to read critical reviews from this site. It is often so ideal plus full of a great time for me personally and my office friends to visit your website at a minimum three times a week to read through the newest things you have got. And definitely, I'm so certainly fascinated with all the impressive thoughts you serve. Some 2 tips on this page are clearly the most beneficial we've ever had. balenciaga sneakers
Back