How to convince people to choose PostgreSQL over MySQL?

Tobias May <[email protected]>
Newsgroups gmane.comp.db.postgresql.advocacy
Message-ID <[email protected]>
Mellow Greetings all,

I'm a junior DBA and PostgreSQL-enthusiast. Last year I switched to a
company where they promised to me the opportunity to dive deeper into
PostgreSQL.

At that time there was a lead developer, who was a
PostgreSQL-enthusiast, too. And there was an agreement that PostgreSQL
is the primary database backend for our product. Unfortunately she has
been frozen out by non-technical decision makers. Now there is only one
colleague and me (without authority to decide) left to advocate PostgreSQL.

Most of the developers in the company are used to MySQL. Although they
seem to accept PostgreSQL some still subtly question the decision and
I'm feeling, that I have to constantly defend the decision for PostgreSQL.

To be prepared I tried to collect and refine as much hard evidence as
possible, during the last couple of months, e.g,
https://grimoire.ca/mysql/choose-something-else,
https://www.youtube.com/watch?v=emgJtr9tIME (some points are not valid
anymore),
http://insights.dice.com/2015/03/19/why-i-choose-postgresql-over-mysqlmariadb/,
http://modern-sql.com/slides,
PostgreSQL is community-driven (huge plus!),
Oracle treats MySQL like a stepchild (understandably they don't want
competitors for "Oracle DB"), etc.

To me all these political and technical advantages of PostgreSQl over
MySQL are more than enough. But the results don't feel "resilient"
enough. It is also cumbersome to keep track of how far ahead PostgreSQL
is in comparison of features and standards compliance and providing
undeniable practical examples.

Finally:
How do I convince people to choose PostgreSQL over a MySQL?
Alternatively:
How do I cope with people, which refuse the available (too few?) facts?

Thank you so much for this little gem called PostgreSQL. Keep up the
great work.


Be well,

Tobias
0x589B8D01.asc (application/pgp-keys, 3 KB)
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v2

mQINBFk1fEoBEAC3quk4DARCNCWdcL6pl73Ytiqu7iaWPoSvF8GqRfQwUWDuh0Wa
Ae6z2x0eW2xDX+KdIFTw/awWpVsPDMgTK6gdN7kMPWuJk7TosflTcvEWoX+EvZCs
ec3L3Cuv10KJVwWKPqxx7rGbouUrAZ1e8iD2Ju8fZVd4XS81NCxDSTcH2v3OiMxn
azOt2PR2zwqJitx9hKBM8MbqSj4P/ZeehpTUWZZBg4wWn3qUU8br+kfntGB4QvrS
wC+WvlaY/ace2UCMSV0kyg5fKg8SKy3wR+/YXTHEWlYpGDosZNFSIT4sonkRuh8e
2oDrEb31SJZd+wEn3ZS9+Q+jx6/A63F94lP2h6AU/x/kx1quOov46CzVNrC4yW+C
/fSyiQ9cBIV4Ltwdt8v605UzFwYQa9Y6w75Ez4nroqZzlWsQMwmcY5UHN6mxlTHe
Ml0R5JFO5O87H9AHw8aeZbX0zZHyh3WA7ftRWbwNrFTUNiK7DlKzFgLX0Y57EMIX
lTTUAJvVuuE2R2GzPLZE4Vg104mIafVj9j9kG9PBjKcnoyv+7BdO/pPZSnseNpHB
LzN+gpMFB8M+98CLX/+T9WcnqhKsP/2NDV2ziBJriZpR8al6v2qMaewZFCdMQR1r
AOyeYux1GcxHT/0tSFVZNQBfyh855GAviTSrIAS2jlXIUsgEs4BhewJjjwARAQAB
tCNUb2JpYXMgTWF5IDx0b2JpYXMubUBpbnZlbnRhdGkub3JnPokCPgQTAQIAKAUC
WTV8SgIbAwUJA8JnAAYLCQgHAwIGFQgCCQoLBBYCAwECHgECF4AACgkQ1g1E01ib
jQHo3A//T0GjDSNWYoURuvLVg5ZyqU7fgDEDK0OCJe/Ee/ifyory0aB8+mViMKDx
YDAgVYaz1HeNubgPrjcOm/LmY2ysGcAXSehAO6c6YJTwOj6LZ+b8ASpYNyitq1v9
MdkiHWaiawMY7Eyb4zSv/iGRD1eOrd9GpOXL3VWKF6L5s0/6bGDS2MgMPmP/5k5x
6Qku7h9t8YlEMRCk2BNAW0VNbWVhXvjxCLF3nk38lE0vGfvMY8cnUaQM4ye+bMIS
ANcVoEj/J3KIGMfCqVMXy4fq0eiRfUkzVRH0nxUI/ZQcLYxJ86bI6wKnAiKQcP1k
rgur/60OIq5eD9sLpH4uB5rydHAh9MLLK5oMZeRkJ8XGkRZ6jTd5FMhVt6b7aUi1
U0q2JmZFYlmY5fO3Il4zSHHYTruPt811/grlk8mNXpQf5uh329kp3JsIUuTWIiJO
Rxx74XpNfpFJZpbB3BgRE7xk02XUPseh4OwNFSRyVpFojsl8J7p11VRqkq07R6dH
2KrFw+43Kh3ZvKH3aoVKEjfS77bIwneGtS0Czi+91S/UiOf35hjEhuq0FzrvhC5d
0X9KUYYj306uPUweqTDPdY+vqrcYA9RNYfOszk2CZWqclgpAbKDDzcS5QX5Pfj+x
kcPvu+Hrk9Wcpv2mWoftOajwtTBrrR9AWJu9L0ZpH8E688PgqY+5Ag0EWTV8SgEQ
AMCEBpu8WMfcUs812L0VDiApyxhv299EF2b1grJXh8BxUczH1spdTqUCj8XdtuPD
B8sN9jNrFDTDtKABpmez8LQtrIjKgTDRUIRBSMOEHEXU2eKrINAw6onLbo0RVnce
CUx0N7qv+ShNyTch9Zv0+nnOjK/hTsI7jH5nALPr+d4RTAeqD3frfzPz8nx7wHTb
u2OHAfaG7OGERgI/qvzR4xPk7rDFIZpz4FMMxmLUvNlsg8vDCN5MdWS1x+4F33I+
3kksoTk/5L5Ahl01z3pDKkg1HwwqI+2vHODpGlGyuRDCyi6zBpPAe/oT2S4PvrZe
ezh3FAsbi2xUelUl7SAvYQ/MKzRvipwhGikCU/f89cMKbzj2Caboler20n3PpUAD
AnrR3OkIeLSeoUXP3rsZDCdziuLSTVLBgN3CFsDfIE17642AxpK9bIqEJmZDg4mu
QgHOyEs91iXucYJrhO6joaBV1UjWvrObTKeeiewfEpH4p95Lr3t6RuhFAWChR94X
cjavZAGvyR+T1sg4U+oCQm55QgKon17AHNwvhxCPTqd4zZDqSTF9TZM5gJUBZ30G
FOew1UOu5gAhHva7ydebx0ygt1VOKsCYp1PSikP5LmmW2OMSxfVhPsapNCJ6V4kT
Ny9b+op/M7kZCDgby/wxeLM7AuNTNvLM9Jf9n/BvgzbjABEBAAGJAiUEGAECAA8F
Alk1fEoCGwwFCQPCZwAACgkQ1g1E01ibjQGqGBAArkV+itv8F7wsRLbBsPunMeMc
R861X+gd2kaqWP1bGDlIL+LlQ+lAYbTiS/FlJBfMvC9EEC/+ZDUNXhovomQ92/HC
pix2UVI/pTMLv9bTBy6dKvMRGu2RtcGGfRE+1ZDqrLl4Msid2IgvGeuUajfY3orv
Ceq3zzMEpt5F5oa/dUPN1d7ctDaH9lHlpcLs2+jlAViivkbsC+SZY+2GVjvHqJWN
HsxIQrHvHycQxjQzFcLbqGjH9gC3i8aCi87SZU9/Z6LE6wJNvFMZQwaLQvkavYm1
3gV+lk10rwrprJmVAYseRXjYpuAbefeV45NzOuZp6MO1mgF8dGfJR4+QIE+X77tb
rtode2yVeV96VONhIZLDd1CzjjQah7V7IP2t3/LccyJdEdRBFfkF2Ud0Cs+XYLis
l6cqk2n1SGIUcfnA1CNbGBr3QjCYqH04836y/NqndIM8XKAP+JbUryo0Yhho/OAD
VgIRh99layOYN+I092M0CW8GUbOw3YfT9XS7A2ovdt3/+OVUaCucdOJqpNI0hMoi
ROTkLC5VKVX6eOwe+tH8ndwJxku1ssTmKz0vLpkjOoPjPFBcB4hjMqFnKsDaUyZf
ACuW9aJWNfHig84FfMdeMRSOTKpmzhca4s7O2M+wszQ9PUzKqYRFE3Djx8yC6Wmp
cDwhohA/yI5yn89mp9w=
=43S9
-----END PGP PUBLIC KEY BLOCK-----
signature.asc (application/pgp-signature, 819 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBCAAGBQJZOu/GAAoJENYNRNNYm40BIiEP/imJqKQqYl7xkwFkrhm5GSpp
A41v9/XKd3GYS1XDcftBKxF08ydL7C4wnKoZ2URKUcFx7hRqEpYqtzJyBYO3l8NT
hgA6WerD0/n7/GXtQk/RoSBwgAKgvk1iTSBqK9QU4axOX5XB4t3bVFL5Y9hKsnvR
y4bzYMDNynJ0P3qmRul4L2buQVJP70uQiE62UMX8zaQojEaMLaXlg54l+b3KX5/I
LUqgJ+TZ5F1IYjsgfD8HN6lAKibj/dOL8OdsUY0FqSNc04ZdYwOSjvgvd+Oycca+
fg+lun80ovNguDQFdLoOeG4AoQpuzpAHJgJt1LFlHCJv0hgFfBRMPw5k6us5LbTA
ycdHKeX5DzNpg8Ohs4eFcqL/5vDPqO/9Lw1lD3Eoei1vuolBgS/rToGzpWdFWu1p
VLXYrpepd0bTqX2tCz7RkQB2DFLitFK/tpdM6JkX/ZfcwEbM+QH57RuBqBSNGLy0
VyFJ+59UiU7ewy5GGajN0F85p5shwgpJ0P8cgY8y5xutz2pCPHvE4FtBDUAu3eQ8
EMlKxIbBuBZLMW09M7nKXPvHgEgNUaf3Q3lQ2yhmQCna3hycdR+zUVirtalOSmnN
apZR40joZzVatWES6TdLnu94Xdd2ZHY5eoqrVY2nDzxtMrlO1wDuOpp1KJp8u8F6
V/KECbdENyh16dxnY3Ow
=aBXq
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.