{"id":18584,"date":"2021-06-15T08:02:03","date_gmt":"2021-06-15T05:02:03","guid":{"rendered":"http:\/\/dev.profelis.net\/?p=18584"},"modified":"2023-02-01T10:57:59","modified_gmt":"2023-02-01T07:57:59","slug":"postgresql-entegrasyonu","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2021\/06\/15\/postgresql-entegrasyonu\/","title":{"rendered":"PostgreSQL Entegrasyonu B\u00f6l\u00fcm 1: Uygulama Entegrasyonu"},"content":{"rendered":"

Ge\u00e7ti\u011fimiz son on y\u0131lda a\u00e7\u0131k kaynakl\u0131 veritabanlar\u0131, d\u00fcnya genelindeki geli\u015ftiricilerin ve veritaban\u0131 operat\u00f6rlerinin kalbini ve zihnini kazand\u0131. A\u00e7\u0131k kaynak trendlerine \u00e7ift t\u0131klad\u0131\u011f\u0131n\u0131zda PostgreSQL’in en \u00e7ok tercih edilen veritaban\u0131 oldu\u011funu a\u00e7\u0131k\u00e7a g\u00f6rebilirsiniz. Bunun nedenleri a\u00e7\u0131kt\u0131r: yenilik\u00e7ilik, g\u00fcvenilirlik, maliyet ve geni\u015f platform deste\u011fi.<\/p>\n

EDB’nin kurumsal m\u00fc\u015fterileriyle yapt\u0131\u011f\u0131 2020 y\u0131l\u0131 anketi, PostgreSQL’i m\u00fc\u015fteri ili\u015fkileri y\u00f6netimi veya e-ticaret i\u015flemleri (%54), veri depolar\u0131 veya raporlama sistemleri (%63) gibi analiz sistemleri ve web siteleri veya IoT uygulamalar\u0131 (%17) benzeri etkile\u015fimli yap\u0131lar gibi kay\u0131t sistemleri i\u00e7in kulland\u0131klar\u0131n\u0131 bize bildirmektedir. PostgreSQL’i t\u00fcm \u00f6zellikleriyle kurumsal yap\u0131lara nas\u0131l entegre edilece\u011fini anlamak \u00f6nemlidir.<\/p>\n

PostgreSQL Entegrasyonu adl\u0131 yeni serimizin bu ilk blog yaz\u0131s\u0131nda, geli\u015ftirmeyi h\u0131zland\u0131rmak ve \u00fcretim ortam\u0131na ge\u00e7mek i\u00e7in PostgreSQL’in kurumsal teknoloji yap\u0131lar\u0131na entegrasyonunu inceleyece\u011fiz. \u00d6nce bu alandaki \u00f6nemli b\u00f6l\u00fcme odaklanal\u0131m: veri olu\u015fturan ve kullanan uygulamalarla PostgreSQL entegrasyonu.<\/p>\n

\"Integrating<\/p>\n

Uygulamalar\u0131n Uyarlanmas\u0131<\/span><\/strong><\/h2>\n

PostgreSQL, C dilinde yaz\u0131lan uygulamalar i\u00e7in ba\u011flant\u0131 kurman\u0131n \u00f6nerilen yolu olan libpq<\/b><\/a> olarak adland\u0131r\u0131lm\u0131\u015f C tabanl\u0131 bir API sa\u011flar. Java tabanl\u0131 uygulamalar PostgreSQL JDBC s\u00fcr\u00fcc\u00fcs\u00fcnden<\/b><\/a> yararlan\u0131r. ODBC ve .NET s\u00fcr\u00fcc\u00fcleri PostgreSQL projesinden de edinilebilir. EDB, JDBC, ODBC ve .NET s\u00fcr\u00fcc\u00fclerinin Oracle ile uyumlu s\u00fcr\u00fcmlerini ve PostgreSQL’i uygulamaya Oracle’a benzeyen OCI uyumlu s\u00fcr\u00fcc\u00fcleri sa\u011flar. Bu s\u00fcr\u00fcc\u00fcler EDB Postgres Advanced Server ile birlikte kullan\u0131labilir.
\n<\/span><\/p>\n

Stackoverflow\u2019un 2020 y\u0131l\u0131nda PostgreSQL ile ilgili trafik analizi<\/b><\/a>, PostgreSQL geli\u015ftiricilerinin hangi programlama dillerini tercih etti\u011fi hakk\u0131nda bilgi sa\u011fl\u0131yor. Buna g\u00f6re Python, \u015fimdiye kadarki en pop\u00fcler ara\u00e7. Java’n\u0131n pop\u00fclerli\u011fi sabit dururken Ruby on Rails\u2019in pop\u00fclerli\u011fi ise azal\u0131yor gibi g\u00f6r\u00fcn\u00fcyor.<\/p>\n

PostgreSQL geli\u015ftiricileri hangi programlama dillerini tercih ediyor? Stackoverflow\u2019un geli\u015ftirme dilleri analizindeki PostgreSQL b\u00f6l\u00fcm\u00fcnden bu bilgiler sa\u011flanabilir.<\/p>\n

\"Integrating<\/p>\n

Django, psicopg2 veritaban\u0131 s\u00fcr\u00fcc\u00fcs\u00fcne g\u00fcvenmeyen Python uygulamalar\u0131 i\u00e7in son derece pop\u00fcler bir yap\u0131d\u0131r. Genellikle Hibernate veya Spring ile kullan\u0131lan Java, genellikle \u015firket i\u00e7inde geli\u015ftirilen uygulamalarda bulunur. Node.js, \u00f6zellikle React ve VUE.js, mikro hizmetler tipi mimarilerde ve web sistemleri i\u00e7in kullan\u0131l\u0131m\u0131 daha fazla giderek artmaktad\u0131r.
\n<\/span><\/p>\n

PostgreSQL’in teknolojik yap\u0131n\u0131za nas\u0131l entegre olaca\u011f\u0131n\u0131n i\u015flendi\u011fi Veri Entegrasyonu ve G\u00f6\u00e7’\u00fcn konu edilece\u011fi bu serideki bir sonraki blog yaz\u0131s\u0131 i\u00e7in bizi takip edin.<\/p>\n

Kaynak: Integrating PostgreSQL Part 1: Application Integration<\/a>, EDB Ekibi Nisan 29, 2021\n\u00a9 Copyright EnterpriseDB Corporation 2020 EnterpriseDB Corporation\n34 Crosby Drive Suite 201 Bedford, MA 01730\nEnterpriseDB and Postgres Enterprise Manager are registered trademarks of EnterpriseDB Corporation. EDB and EDB Postgres are trademarks of EnterpriseDB Corporation. Oracle is a registered trademark of Oracle, Inc. Other trademarks may be trademarks of their respective owners.<\/pre>","protected":false},"excerpt":{"rendered":"
Ge\u00e7ti\u011fimiz son on y\u0131lda a\u00e7\u0131k kaynakl\u0131 veritabanlar\u0131, d\u00fcnya genelindeki geli\u015ftiricilerin ve veritaban\u0131 operat\u00f6rlerinin kalbini ve zihnini kazand\u0131. A\u00e7\u0131k kaynak trendlerine \u00e7ift t\u0131klad\u0131\u011f\u0131n\u0131zda PostgreSQL’in en \u00e7ok tercih edilen veritaban\u0131 oldu\u011funu a\u00e7\u0131k\u00e7a g\u00f6rebilirsiniz. Bunun nedenleri a\u00e7\u0131kt\u0131r: yenilik\u00e7ilik, g\u00fcvenilirlik, maliyet ve geni\u015f platform…<\/p>","protected":false},"author":16,"featured_media":22104,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,45],"tags":[58,48,50],"class_list":["post-18584","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-yazi","tag-acikkaynak","tag-enterprisedb","tag-veritabani"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/18584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=18584"}],"version-history":[{"count":0,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/18584\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/22104"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=18584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=18584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=18584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}