https:\/\/www.postgresql.org\/docs\/current\/static\/functions-json.html<\/a>\u00a0adresine bakabilirsiniz.<\/p>\nJSON Veri Eklemek<\/h2>\n
\u00d6nce veri tipi json olan bir s\u00fctun i\u00e7eren bir tablo olu\u015ftural\u0131m:<\/p>\n
CREATE TABLE aile (id serial PRIMARY KEY, profil json);<\/code><\/pre>\nSonra bu tabloya json veri ekleyelim:<\/p>\n
\nINSERT INTO aile (profil) VALUES ('\n{{\"ad\": \"Katip\", \n \"fertler\": [ \n {\"fert\": {\"ili\u015fki\": \"baba\", \"ad\": \"H\u00fcseyin\" }}, \n {\"fert\": {\"ili\u015fki\": \"anne\", \"ad\": \"Saniye\" }}, \n {\"fert\": {\"ili\u015fki\": \"\u00e7ocuk\", \"ad\": \"Emrah\" }}, \n {\"fert\": {\"ili\u015fki\": \"\u00e7ocuk\", \"ad\": \"Sema\" }}]}\n');\n<\/code><\/pre>\nPostgreSQL tabloya veriyi eklemeden \u00f6nce JSON veriyi do\u011frulamaktad\u0131r.<\/p>\n
Dikkat!<\/strong> Ge\u00e7erli olmayan bir JSON veriyi json veri tipi olarak i\u015faretlenmi\u015f bir s\u00fctuna yerle\u015ftiremezsiniz!<\/div>\nJSON Veri Sorgulama<\/h2>\n
A\u015fa\u011f\u0131daki sorgu\u00a0 json_extract_path, json_array_elements, ve json_extract_path_text i\u015flevlerini kullanarak aile \u00fcyelerini getirmektedir.<\/p>\n
Sorguyu par\u00e7alay\u0131p anlatmaya \u00e7al\u0131\u015faca\u011f\u0131m:<\/p>\n
SELECT \njson_extract_path_text(profil, 'ad') AS aile,\njson_extract_path_text(json_array_elements (json_extract_path(profil,'fertler')), \n'fert','ad') As fert \nFROM aile;\n--\n aile | fert\n----------+--------- \nKatip | H\u00fcseyin\nKatip | Saniye\nKatip | Emrah \nKatip | Sema\n<\/code><\/pre>\nSELECT
\njson_extract_path_text(profil, ‘ad’) AS aile,1<\/span>
\njson_extract_path_text( 2<\/span> json_array_elements ( 3<\/span> json_extract_path(profil,’fertler’) 4<\/span> ), ‘fert’,’ad’) As fert FROM aile;<\/p>\n\n- Aile ad\u0131n\u0131 text olarak getirir<\/li>\n
- Aile ferdi ad\u0131n\u0131 text olarak getirir<\/li>\n
- Array elemanlar\u0131n\u0131 ayr\u0131 JSON objeleri olarak getirir<\/li>\n
- Aile fertlerini ayr\u0131 objeler olarak getirir<\/li>\n<\/ol>\n
Bu \u015fekilde yazmak yerine fonksiyonlar\u0131n k\u0131sayol operat\u00f6rlerini kullanmak daha kolay geliyor bana, muhtemelen obje tabanl\u0131 programlama yapanlara da bu daha do\u011fal gelecektir. Yukar\u0131daki sorgu bu durumda a\u015fa\u011f\u0131daki gibi daha kolay hale geliyor:<\/p>\n
SELECT profile->>'name' As family, \n json_array_elements((profile->'members')) #>> '{member,name}'::text[] AS member \nFROM families_j;\n<\/code><\/pre>\nJSON Sonu\u00e7 D\u00f6nd\u00fcrmek<\/h2>\n
row_to_json<\/strong> fonksiyonu ile se\u00e7ilen s\u00fctunlar\u0131 JSON format\u0131nda \u00e7\u0131kt\u0131 haline getirmek m\u00fcmk\u00fcnd\u00fcr.<\/p>\nselect row_to_json(words) from words;<\/code><\/pre>\nNot: olarak PostgreSQL ayn\u0131 zamanda di\u011fer veritabanlar\u0131 gibi XML de desteklemektir.<\/p>\n","protected":false},"excerpt":{"rendered":"
JSON veri tipi ve destekleyici i\u015flevler PostgreSQL 9.2 s\u00fcr\u00fcm\u00fc ile desteklenmeye ba\u015flad\u0131\u011f\u0131nda b\u00fcy\u00fck olay olmu\u015ftu. Bug\u00fcn ise PostgreSQL’in ard\u0131ndan di\u011fer veritabanlar\u0131 da birer birer bu veri tipine destek vermeye ba\u015flarken, PostgreSQL’de oturmu\u015f bir json deste\u011fi mevcut. JSON, web uygulamalar\u0131, JavaScript ve REST tabanl\u0131 mobil uygulama geli\u015ftirenler i\u00e7in vazge\u00e7ilmez bir dil hatta eskilerin deyimiyle sabir dil (lingua franca: ge\u00e7erli dil, ortak dil) durumunda. 9.4 s\u00fcr\u00fcm\u00fcnde ise JSON’\u0131n binary s\u00fcr\u00fcm\u00fc olan jsonb veri tipi deste\u011fi gelmi\u015fti.<\/p>","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,45],"tags":[48,60],"class_list":["post-1982","post","type-post","status-publish","format-standard","hentry","category-postgresql","category-yazi","tag-enterprisedb","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/1982","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=1982"}],"version-history":[{"count":0,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/1982\/revisions"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=1982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=1982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=1982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}