{"id":1239,"date":"2018-03-15T22:44:43","date_gmt":"2018-03-15T20:44:43","guid":{"rendered":"http:\/\/fatihsoysal.com\/blog\/?p=1239"},"modified":"2018-09-14T18:09:29","modified_gmt":"2018-09-14T15:09:29","slug":"postgresql-mysql-karsilastirmasi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/","title":{"rendered":"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131"},"content":{"rendered":"

Merhaba,\u00a0Projeleriniz i\u00e7in hangi veritaban\u0131n\u0131 kullanaca\u011f\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcn\u00fcrken, t\u00fcm a\u00e7\u0131k kaynak RDBMS’lerin ayn\u0131 oldu\u011funu d\u00fc\u015f\u00fcnerek hata yapmay\u0131n!<\/p>\n

PostgreSQL ve MySQL aras\u0131nda radikal farkl\u0131l\u0131klar var. \u0130ki sistem aras\u0131ndaki farkl\u0131l\u0131klar\u0131 de\u011ferlendirdikten sonra bilin\u00e7li bir karar verilmelidir.<\/p>\n

PostgreSQL ve MySQL aras\u0131ndaki en yayg\u0131n olarak de\u011ferlendirilen \u00f6zelliklerin benzerlik ve farkl\u0131l\u0131klar\u0131n\u0131n bir \u00f6zetini bu makale i\u00e7erisinde bulabileceksiniz.<\/p>\n

\u0130ki veri taban\u0131 aras\u0131nda bir\u00e7ok benzerlikler olsa da, \u00e7ok farkl\u0131 farkl\u0131l\u0131klar da vard\u0131r. \u0130kisi aras\u0131nda adil ve do\u011fru bir kar\u015f\u0131la\u015ft\u0131rma sa\u011flamaya \u00e7al\u0131\u015ft\u0131m, ancak sonunda, benzersiz senaryonuzu de\u011ferlendirmek ve hangi veritaban\u0131n\u0131n \u00f6zel kullan\u0131m durumunuza en uygun oldu\u011funu sizler belirleyeceksiniz.<\/p>\n

\"\"<\/p>\n

Yakla\u015f\u0131k 25-26 ay kadar b\u00fcy\u00fck bir projede PostgreSQL kulland\u0131m, daha \u00f6ncesinde MySQL’i s\u0131k s\u0131k projelerimde kullanm\u0131\u015ft\u0131m ve halen kullanmaya devam ediyorum. Dilerseniz ana ba\u015fl\u0131klar halince kar\u015f\u0131la\u015ft\u0131rmalar\u0131m\u0131za ba\u015flayal\u0131m.<\/p>\n

A\u00e7\u0131k kaynak<\/strong><\/p>\n

A\u00e7\u0131k kaynakl\u0131 yaz\u0131l\u0131mlar bildi\u011finiz \u00fczere, benzersiz olan \u00f6zelliklere (maliyet, esneklik, \u00f6zg\u00fcrl\u00fck, g\u00fcvenlik) sahiptir. A\u00e7\u0131k kaynak yaz\u0131l\u0131m\u0131 serbest\u00e7e kullan\u0131labilir ve herkes taraf\u0131ndan yeniden da\u011f\u0131t\u0131labilir, de\u011fi\u015ftirilebilir. A\u00e7\u0131k kaynak yaz\u0131l\u0131mlar\u0131n, uzun vadeli s\u00fcrd\u00fcr\u00fclebilirli\u011fi vard\u0131r. D\u00fcnya \u00e7ap\u0131nda bir topluluk veya bireysel geli\u015ftiriciler toplulu\u011fu taraf\u0131ndan olu\u015fturulmu\u015f ve desteklenmi\u015ftir; bunlar\u0131n bir\u00e7o\u011fu, i\u015fbirli\u011fi ve g\u00f6n\u00fcll\u00fcl\u00fck gibi a\u00e7\u0131k kaynak de\u011ferleri esas al\u0131narak olu\u015fturulmu\u015f topluluklard\u0131r.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

PostgreSQL, \u00e7e\u015fitli \u015firketler ve bireysel kat\u0131l\u0131mc\u0131lar grubu olan PostgreSQL Global Development Group taraf\u0131ndan geli\u015ftirilmi\u015ftir.<\/p>\n

\u00dccretsiz ve a\u00e7\u0131k kaynakl\u0131 bir veritaban\u0131d\u0131r. PostgreSQL, BSD veya MIT lisanslar\u0131na benzer bir liberal A\u00e7\u0131k Kaynak lisans\u0131 olan PostgreSQL lisans\u0131 alt\u0131nda yay\u0131nlanmaktad\u0131r.<\/td>\n

MySQL, kaynak kodunu, \u00e7e\u015fitli \u00f6zel anla\u015fmalar\u0131n yan\u0131 s\u0131ra GNU Genel Kamu Lisans\u0131 \u015fartlar\u0131na uygun hale getirmi\u015ftir.<\/p>\n

\u015eu anda Oracle Corporation’a aittir, a\u00e7\u0131k kaynakl\u0131 veritaban\u0131d\u0131r ama tescilli kullan\u0131m i\u00e7in \u00e7e\u015fitli \u00fccretli s\u00fcr\u00fcmler de sunmaktad\u0131r.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

ACID Uygunlu\u011fu<\/strong><\/p>\n

ACID, veritaban\u0131 i\u015flemlerinin bir \u00f6zellik k\u00fcmesidir. ACID uyumlulu\u011fu, tek bir i\u015flem s\u0131ras\u0131nda \u00e7ok say\u0131da de\u011fi\u015fiklik yap\u0131ld\u0131\u011f\u0131nda bile, olas\u0131 ar\u0131za durumunda sistemde hi\u00e7bir verinin kaybolmamas\u0131n\u0131 ve yanl\u0131\u015f ileti\u015fim yap\u0131lmamas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

PostgreSQL, ACID ile uyumludur ve t\u00fcm gereksinimlerin kar\u015f\u0131lanmas\u0131n\u0131 sa\u011flar.<\/p>\n<\/td>\n

\n

MySQL, InnoDB ve NDB Cluster Storage motorlar\u0131n\u0131 kullan\u0131rken, ACID uyumludur.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

SQL Uyumlulu\u011fu<\/strong><\/p>\n

SQL uyumu, bir veritaban\u0131n\u0131n t\u00fcm yap\u0131land\u0131r\u0131lm\u0131\u015f sorgu dili y\u00f6nergelerini ve standartlar\u0131n\u0131 kar\u015f\u0131lamas\u0131 ve uygulamas\u0131 gereken bir standartt\u0131r. \u015eirketler bir uygulama i\u00e7in heterojen veritabanlar\u0131yla \u00e7al\u0131\u015fmak istediklerinde bu \u00e7ok \u00f6nemlidir.<\/p>\n

SQL uyumlulu\u011funa sahip olmak, verileri bir SQL uyumlu veritaban\u0131ndan di\u011ferine (\u00f6r. Oracle’dan PostgreSQL veya SQL Server’a) ta\u015f\u0131may\u0131 \u00e7ok kolayla\u015ft\u0131r\u0131r.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/p>\n<\/td>\n<\/tr>\n

PostgreSQL b\u00fcy\u00fck \u00f6l\u00e7\u00fcde SQL uyumludur. Her bir \u00f6zellik i\u00e7in uygunluk seviyesi, resmi d\u00f6k\u00fcmantasyonun Ek D’sinde a\u00e7\u0131k\u00e7a belirtilmi\u015ftir ve herhangi bir sapma, PostgreSQL k\u0131lavuzunun \u201cReferans\u201d b\u00f6l\u00fcm\u00fcnde a\u00e7\u0131k\u00e7a belgelenmi\u015ftir.<\/p>\n

D\u00f6k\u00fcmantasyon kayna\u011f\u0131<\/span><\/a><\/p>\n

PostgreSQL, SQL’in \u00f6nemli \u00f6zelliklerinin \u00e7o\u011funu destekler: 2011. Tam \u00c7ekirdek uyumlulu\u011fu i\u00e7in gerekli olan 179 zorunlu \u00f6zellik aras\u0131ndan, PostgreSQL en az 160’\u0131 ile uyumludur. Ayr\u0131ca, desteklenen iste\u011fe ba\u011fl\u0131 \u00f6zelliklerin uzun bir listesi vard\u0131r. Yazma s\u0131ras\u0131nda, herhangi bir veritaban\u0131 y\u00f6netim sisteminin mevcut s\u00fcr\u00fcm\u00fcn\u00fcn Core SQL’e tam uygunluk g\u00f6stermedi\u011fini belirtmekte fayda var: 2011.<\/td>\n

MySQL, baz\u0131 s\u00fcr\u00fcmlerde k\u0131smen uyumludur (\u00f6rn. CHECK k\u0131s\u0131tlamalar\u0131n\u0131 desteklemez).<\/p>\n

D\u00f6k\u00fcmantasyon kayna\u011f\u0131<\/span><\/a><\/p>\n

\u00dcr\u00fcnle ana hedeflerimizden biri, SQL standard\u0131yla uyum i\u00e7inde \u00e7al\u0131\u015fmaya devam etmektir, ancak h\u0131z veya g\u00fcvenilirlikten \u00f6d\u00fcn vermeden. SQL’e eklenti eklemek veya SQL tabanl\u0131 olmayan \u00f6zellikler i\u00e7in destek sa\u011flamaktan korkmazsak, bu, MySQL Server’\u0131n kullan\u0131c\u0131 taban\u0131m\u0131z\u0131n b\u00fcy\u00fck bir b\u00f6l\u00fcm\u00fc i\u00e7in kullan\u0131labilirli\u011fini b\u00fcy\u00fck \u00f6l\u00e7\u00fcde art\u0131r\u0131r.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Da\u011f\u0131t\u0131lm\u0131\u015f Veritaban\u0131<\/strong><\/p>\n

Veritaban\u0131 \u00e7o\u011faltmas\u0131, bir bilgisayardaki veya veritaban\u0131ndaki bir veritaban\u0131ndaki verilerin bir di\u011ferinde bir veritaban\u0131na s\u0131k s\u0131k elektronik olarak kopyalanmas\u0131d\u0131r, b\u00f6ylece t\u00fcm kullan\u0131c\u0131lar ayn\u0131 bilgi d\u00fczeyini payla\u015f\u0131r. Sonu\u00e7, kullan\u0131c\u0131lar\u0131n ba\u015fkalar\u0131n\u0131n \u00e7al\u0131\u015fmalar\u0131na m\u00fcdahale etmeden g\u00f6revleriyle ilgili verilere eri\u015febilecekleri da\u011f\u0131t\u0131lm\u0131\u015f bir veritaban\u0131d\u0131r.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

PostgreSQL, Master-Standby replikasyonunu destekler ve standby sunucular i\u00e7in neredeyse ger\u00e7ek zamanl\u0131 replikasyon ve hot standby yetenekleri ile sonu\u00e7lanan son derece h\u0131zl\u0131 WAL i\u015flemi \u00fcreten \u00f6nemli geli\u015ftirmeler getirdi.<\/p>\n<\/td>\n

\n

MySQL, Master-Beklemedeki \u00e7o\u011faltmay\u0131 destekler.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Performans<\/strong><\/p>\n

Performans, yaln\u0131zca belirli kullan\u0131c\u0131lar\u0131n saf gereksinimlerine ve uygulaman\u0131n yap\u0131s\u0131na ba\u011fl\u0131 oldu\u011fu i\u00e7in potansiyel senaryolar\u0131n \u00f6l\u00e7\u00fclerini de\u011ferlendirerek \u00f6l\u00e7\u00fclebilen bir aland\u0131r.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

PostgreSQL, okuma ve yazma h\u0131zlar\u0131n\u0131n \u00e7ok \u00f6nemli oldu\u011fu ve verilerin do\u011frulanmas\u0131 gereken b\u00fcy\u00fck sistemlerde yayg\u0131n olarak kullan\u0131lmaktad\u0131r. Ayr\u0131ca, yaln\u0131zca co\u011frafi veri deste\u011fi, okuma kilidi olmayan e\u015fzamanl\u0131l\u0131k ve benzeri (\u00f6rne\u011fin Oracle, SQL Server) gibi ticari \u00e7\u00f6z\u00fcmlerde kullan\u0131labilen \u00e7e\u015fitli performans optimizasyonlar\u0131n\u0131 destekler.<\/p>\n

Genel olarak, PostgreSQL performans\u0131, karma\u015f\u0131k sorgular\u0131n y\u00fcr\u00fct\u00fclmesini gerektiren sistemlerde en iyi \u015fekilde kullan\u0131l\u0131r.<\/p>\n

Okuma \/ yazma h\u0131zlar\u0131 gerekti\u011finde ve kapsaml\u0131 veri analizi gerekti\u011finde PostgreSQL, OLTP \/ OLAP sistemlerinde iyi performans g\u00f6sterir.<\/p>\n

PostgreSQL ayr\u0131ca, \u0130\u015f Zekas\u0131 uygulamalar\u0131yla da iyi \u00e7al\u0131\u015f\u0131r, ancak h\u0131zl\u0131 okuma \/ yazma h\u0131zlar\u0131 gerektiren Veri Ambar\u0131 ve veri analizi uygulamalar\u0131 i\u00e7in daha uygundur.<\/td>\n

MySQL, sadece basit veri i\u015flemleri i\u00e7in bir veri taban\u0131na ihtiya\u00e7 duyan web tabanl\u0131 projeler i\u00e7in yayg\u0131n olarak kullan\u0131lmaktad\u0131r. Dolay\u0131s\u0131yla, MySQL’e a\u011f\u0131r bir y\u00fck y\u00fcklendi\u011finde ya da karma\u015f\u0131k sorgular\u0131 tamamlamaya \u00e7al\u0131\u015f\u0131rken d\u00fc\u015f\u00fck performans g\u00f6stermesi olas\u0131d\u0131r.<\/p>\n

MySQL, sadece okuma h\u0131zlar\u0131 gerekti\u011finde OLAP \/ OLTP sistemlerinde iyi performans g\u00f6sterir.<\/p>\n

MySQL + InnoDB, OLTP senaryolar\u0131 i\u00e7in \u00e7ok iyi okuma \/ yazma h\u0131zlar\u0131 sa\u011flar. Genel olarak, MySQL y\u00fcksek e\u015fzamanl\u0131l\u0131k senaryolar\u0131 ile iyi performans g\u00f6sterir.<\/p>\n

\u0130\u015f zekas\u0131 uygulamalar\u0131 genellikle a\u011f\u0131r a\u011f\u0131r i\u015fledi\u011finden, MySQL’e bu konuda g\u00fcvenilirsiniz, \u0130\u015f Zekas\u0131 uygulamalar\u0131yla iyi \u00e7al\u0131\u015f\u0131r.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

G\u00fcvenlik<\/strong><\/p>\n

Veritaban\u0131 g\u00fcvenli\u011fi, bir veritaban\u0131n\u0131 k\u00f6t\u00fc niyetli tehditler ve sald\u0131r\u0131lardan korumak i\u00e7in kullan\u0131lan toplu \u00f6nlemleri ifade eder. Veritaban\u0131 ortam\u0131nda g\u00fcvenli\u011fi sa\u011flayan \u00e7ok say\u0131da s\u00fcre\u00e7, ara\u00e7 ve metodoloji terimler vard\u0131r.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

PostgreSQL, izinleri ayarlamak ve s\u00fcrd\u00fcrmek i\u00e7in devral\u0131nm\u0131\u015f rollere sahiptir. PostgreSQL, istemci \/ sunucu ileti\u015fimini \u015fifrelemek i\u00e7in ba\u011flant\u0131lar i\u00e7in yerel SSL deste\u011fine sahiptir. Ayr\u0131ca Sat\u0131r Seviyesi G\u00fcvenli\u011fi de vard\u0131r.<\/p>\n

Buna ek olarak, PostgreSQL SELinux g\u00fcvenlik politikas\u0131na dayal\u0131 ek eri\u015fim kontrolleri sa\u011flayan SE-PostgreSQL olarak adland\u0131r\u0131lan dahili bir geli\u015ftirme ile birlikte gelir. Daha fazla detay i\u00e7in buray\u0131<\/a> inceleyebilirsiniz.<\/td>\n

\n

MySQL, bir kullan\u0131c\u0131n\u0131n ger\u00e7ekle\u015ftirmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131 t\u00fcm ba\u011flant\u0131lar, sorgular ve di\u011fer i\u015flemler i\u00e7in Eri\u015fim Denetimi Listelerine (ACL) dayanan g\u00fcvenli\u011fi uygular.<\/p>\n

MySQL istemcileri ve sunucular aras\u0131nda SSL \u015fifreli ba\u011flant\u0131lar i\u00e7in baz\u0131 destekler de vard\u0131r.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Cloud Deste\u011fi<\/strong><\/p>\n

Daha fazla i\u015fletme, verilerini buluta kayd\u0131rmay\u0131 tercih ettik\u00e7e, veritaban\u0131n\u0131z\u0131 destekleyen bulut sa\u011flay\u0131c\u0131lar\u0131n\u0131 bulma yetene\u011fi giderek daha da \u00f6nem kazan\u0131yor. Cloud hosting, sunucular\u0131n esnekli\u011fini sa\u011flar ve kapasitelerini h\u0131zla geni\u015fletmenize veya daraltman\u0131za izin verir. Ayr\u0131ca, en yo\u011fun i\u015f y\u00fcklerini kolayca y\u00f6netirken potansiyel ar\u0131za s\u00fcresinin azalt\u0131lmas\u0131na da olanak tan\u0131r.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Amazon, Google ve Microsoft dahil olmak \u00fczere t\u00fcm b\u00fcy\u00fck bulut servis sa\u011flay\u0131c\u0131lar\u0131 taraf\u0131ndan desteklenir.<\/p>\n<\/td>\n

\n

Amazon, Google ve Microsoft dahil olmak \u00fczere t\u00fcm b\u00fcy\u00fck bulut servis sa\u011flay\u0131c\u0131lar\u0131 taraf\u0131ndan desteklenir.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Topluluk Deste\u011fi<\/strong><\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

PostgreSQL, mevcut \u00f6zellikleri s\u00fcrekli olarak geli\u015ftiren \u00e7ok g\u00fc\u00e7l\u00fc ve aktif bir toplulu\u011fa sahipken, yenilik\u00e7i i\u015fleyicileri, yeni \u00f6zellikler ve g\u00fcvenlik ile en geli\u015fmi\u015f veritaban\u0131 olmay\u0131 s\u00fcrd\u00fcrmek i\u00e7in \u00e7abalamaktad\u0131r.<\/p>\n<\/td>\n

\n

MySQL’in, \u00f6zellikle Oracle’\u0131n sat\u0131n al\u0131nmas\u0131n\u0131 takiben, \u00f6zellikle mevcut \u00f6zelliklerin zaman zaman ortaya \u00e7\u0131kan baz\u0131 yeni \u00f6zelliklerle s\u00fcrd\u00fcr\u00fclmesine odaklanan b\u00fcy\u00fck bir katk\u0131da bulunanlar toplulu\u011fu vard\u0131r.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

NoSQL \u00d6zellikleri \/ JSON Deste\u011fi<\/strong><\/p>\n

NoSQL ve JSON her ikisi de bu s\u0131ralar \u00e7ok pop\u00fcler. NoSQL uyumlu veritabanlar\u0131 daha yayg\u0131n hale geliyor. JSON, bildi\u011finiz gibi key \/ value e\u015flemeleri k\u00fcmelerini depolamas\u0131na ve iletmesine olanak veren basit bir veri bi\u00e7imidir.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

PostgreSQL, yerel XML deste\u011fi ve HSTORE ile anahtar \/ de\u011fer \u00e7iftleri gibi JSON ve di\u011fer NoSQL \u00f6zelliklerini destekler. Ayr\u0131ca daha h\u0131zl\u0131 eri\u015fim i\u00e7in JSON verilerini indekslemeyi de destekler.<\/p>\n<\/td>\n

\n

MySQL’in JSON veri t\u00fcr\u00fc deste\u011fi vard\u0131r, ancak ba\u015fka bir NoSQL \u00f6zelli\u011fi yoktur. JSON i\u00e7in indekslemeyi desteklemez.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Programlama Dilleri Deste\u011fi<\/strong><\/p>\n

Programlama dilleri deste\u011fi, \u00e7ok \u00e7e\u015fitli geli\u015ftiricilerin, en yetkin olduklar\u0131 dilde birka\u00e7 g\u00f6revi yerine getirmelerine yard\u0131mc\u0131 olur. Geli\u015ftiriciler, duruma g\u00f6re, sunucuda veya istemcide belirli bir prosed\u00fcr\u00fcn ger\u00e7ekle\u015ftirilip ger\u00e7ekle\u015ftirilmeyece\u011fine serbest\u00e7e karar verebilir, \u00e7\u00fcnk\u00fc sunucu, veritaban\u0131 i\u015flevleri i\u00e7in \u00e7ok \u00e7e\u015fitli farkl\u0131 programlama dillerini desteklemektedir. Programlama dilleri, geli\u015ftiricilere daha fazla g\u00fc\u00e7 verme e\u011filimindedir.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n
\n

PostgreSQL<\/span><\/span><\/p>\n<\/td>\n

\n

MySQL<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

PostgreSQL, C \/ C ++, Java, JavaScript, .Net, PHP, R, Perl, Python, Ruby, Tcl ve di\u011ferleri dahil olmak \u00fczere \u00e7ok \u00e7e\u015fitli programlama dillerini destekler; Kullan\u0131c\u0131 taraf\u0131ndan sa\u011flanan kodu ayr\u0131 s\u00fcre\u00e7lerde \u00e7al\u0131\u015ft\u0131rmak (hatta arka plan \u00e7al\u0131\u015fanlar\u0131 olarak \u00e7al\u0131\u015fmak) bile m\u00fcmk\u00fcnd\u00fcr.<\/p>\n<\/td>\n

\n

Sunucu tarafl\u0131 (Server Side) programlama dillerinde kullan\u0131labilir.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Sizin de konu ile ilgili g\u00f6r\u00fc\u015fleriniz varsa yorum b\u00f6l\u00fcm\u00fcnden payla\u015fabilirsiniz. Bir sonraki makalede g\u00f6r\u00fc\u015fmek \u00fczere.<\/p>\n","protected":false},"excerpt":{"rendered":"Merhaba,\u00a0Projeleriniz i\u00e7in hangi veritaban\u0131n\u0131 kullanaca\u011f\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcn\u00fcrken, t\u00fcm a\u00e7\u0131k kaynak RDBMS’lerin ayn\u0131 oldu\u011funu d\u00fc\u015f\u00fcnerek hata yapmay\u0131n! PostgreSQL ve MySQL…","protected":false},"author":1,"featured_media":1242,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[138,644,121,10],"tags":[647,645,646],"class_list":{"0":"post-1239","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-mysql","8":"category-postgresql","9":"category-sql","10":"category-yazilim","11":"tag-postgresql-mi-mysql-mi","12":"tag-postgresql-ve-mysql-karsilastirmasi","13":"tag-postgresql-vs-mysql","14":"cs-entry","15":"cs-video-wrap"},"yoast_head":"\nPostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131\" \/>\n<meta property=\"og:description\" content=\"Merhaba,\u00a0Projeleriniz i\u00e7in hangi veritaban\u0131n\u0131 kullanaca\u011f\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcn\u00fcrken, t\u00fcm a\u00e7\u0131k kaynak RDBMS’lerin ayn\u0131 oldu\u011funu d\u00fc\u015f\u00fcnerek hata yapmay\u0131n! PostgreSQL ve MySQL…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-15T20:44:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-14T15:09:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"403\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131\",\"datePublished\":\"2018-03-15T20:44:43+00:00\",\"dateModified\":\"2018-09-14T15:09:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/\"},\"wordCount\":1771,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg\",\"keywords\":[\"PostgreSQL mi MySQL mi\",\"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131\",\"PostgreSQL vs MySQL\"],\"articleSection\":[\"MySQL\",\"PostgreSQL\",\"SQL\",\"Yaz\u0131l\u0131m\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#respond\"]}],\"copyrightYear\":\"2018\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/\",\"name\":\"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg\",\"datePublished\":\"2018-03-15T20:44:43+00:00\",\"dateModified\":\"2018-09-14T15:09:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#primaryimage\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg\",\"width\":800,\"height\":403},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131","og_description":"Merhaba,\u00a0Projeleriniz i\u00e7in hangi veritaban\u0131n\u0131 kullanaca\u011f\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcn\u00fcrken, t\u00fcm a\u00e7\u0131k kaynak RDBMS’lerin ayn\u0131 oldu\u011funu d\u00fc\u015f\u00fcnerek hata yapmay\u0131n! PostgreSQL ve MySQL…","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2018-03-15T20:44:43+00:00","article_modified_time":"2018-09-14T15:09:29+00:00","og_image":[{"width":800,"height":403,"url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg","type":"image\/jpeg"}],"author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"9 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131","datePublished":"2018-03-15T20:44:43+00:00","dateModified":"2018-09-14T15:09:29+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/"},"wordCount":1771,"commentCount":1,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg","keywords":["PostgreSQL mi MySQL mi","PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131","PostgreSQL vs MySQL"],"articleSection":["MySQL","PostgreSQL","SQL","Yaz\u0131l\u0131m"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#respond"]}],"copyrightYear":"2018","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/","name":"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#primaryimage"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg","datePublished":"2018-03-15T20:44:43+00:00","dateModified":"2018-09-14T15:09:29+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#primaryimage","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2018\/03\/mysql-vs-postgresql.jpg","width":800,"height":403},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-mysql-karsilastirmasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL ve MySQL Kar\u015f\u0131la\u015ft\u0131rmas\u0131"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/1239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=1239"}],"version-history":[{"count":4,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/1239\/revisions"}],"predecessor-version":[{"id":1899,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/1239\/revisions\/1899"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media\/1242"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=1239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=1239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=1239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}