{"id":11272,"date":"2025-02-02T06:15:12","date_gmt":"2025-02-02T03:15:12","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/"},"modified":"2025-02-02T06:15:12","modified_gmt":"2025-02-02T03:15:12","slug":"postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/","title":{"rendered":"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama"},"content":{"rendered":"<p><body><\/p>\n<p>PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama<\/p>\n<p>OpenAI&#8217;nin sundu\u011fu g\u00fc\u00e7l\u00fc dil modelleri, metinleri anlaml\u0131 say\u0131sal temsiller olan &#8220;g\u00f6m\u00fcl\u00fc vekt\u00f6rlere&#8221; d\u00f6n\u00fc\u015ft\u00fcrmemizi sa\u011flar.  Bu vekt\u00f6rler, metinlerin anlam\u0131n\u0131 yakalayan \u00e7ok boyutlu noktalar gibidir.  Ancak, bu vekt\u00f6rleri etkili bir \u015fekilde depolamak ve aralar\u0131ndaki benzerlikleri bulmak i\u00e7in uygun bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fcne ihtiya\u00e7 duyar\u0131z.  \u0130\u015fte tam bu noktada PostgreSQL ve onun g\u00fc\u00e7l\u00fc uzant\u0131s\u0131 pgvector devreye giriyor.<\/p>\n<p>Bu makalede, OpenAI g\u00f6m\u00fcl\u00fc vekt\u00f6rlerini PostgreSQL&#8217;de pgvector kullanarak nas\u0131l depolayaca\u011f\u0131n\u0131z\u0131 ve daha sonra bu verileri benzerlik arama i\u015flemleriyle nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131m.  \u00d6ncelikle, pgvector&#8217;\u0131 kurup yap\u0131land\u0131rmakla ba\u015flayal\u0131m.<\/p>\n<h2>pgvector Kurulumu ve Yap\u0131land\u0131rmas\u0131<\/h2>\n<p>\u00d6ncelikle, PostgreSQL sunucunuza pgvector uzant\u0131s\u0131n\u0131 kurmal\u0131s\u0131n\u0131z.  Bunun i\u00e7in, PostgreSQL&#8217;in komut sat\u0131r\u0131n\u0131 kullanarak a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n<pre><code class=\"language-sql\">\nCREATE EXTENSION pgvector;\n<\/code><\/pre>\n<p>Uzant\u0131y\u0131 kurduktan sonra, vekt\u00f6r verilerini depolayacak bir tablo olu\u015fturabilirsiniz.  \u00d6rne\u011fin,  metin ve ona kar\u015f\u0131l\u0131k gelen vekt\u00f6r\u00fc saklamak i\u00e7in a\u015fa\u011f\u0131daki gibi bir tablo olu\u015fturabiliriz:<\/p>\n<pre><code class=\"language-sql\">\nCREATE TABLE documents (\n  id SERIAL PRIMARY KEY,\n  text TEXT,\n  embedding VECTOR(1536)\n);\n<\/code><\/pre>\n<p>Bu \u00f6rnekte,  <code>embedding<\/code> s\u00fctunu 1536 boyutlu bir vekt\u00f6r\u00fc temsil eder.  OpenAI&#8217;nin baz\u0131 modellerinden gelen g\u00f6m\u00fcl\u00fc vekt\u00f6rlerin boyutu 1536 olabilir.  Modelinize g\u00f6re bu say\u0131y\u0131 de\u011fi\u015ftirmeniz gerekebilir.  \u015eimdi, OpenAI&#8217;den ald\u0131\u011f\u0131n\u0131z g\u00f6m\u00fcl\u00fc vekt\u00f6rleri bu tabloya ekleyebilirsiniz.<\/p>\n<h2>OpenAI G\u00f6m\u00fcl\u00fc Vekt\u00f6rlerinin Depolama ve Sorgulama \u0130\u015flemleri<\/h2>\n<p>OpenAI API&#8217;sini kullanarak metinlerin g\u00f6m\u00fcl\u00fc vekt\u00f6rlerini olu\u015fturduktan sonra, bu vekt\u00f6rleri PostgreSQL tablosuna ekleyebilirsiniz.  A\u015fa\u011f\u0131daki \u00f6rnekte, Python ve psycopg2 k\u00fct\u00fcphanesini kullanarak bu i\u015flemi g\u00f6steriyorum:<\/p>\n<pre><code class=\"language-python\">\nimport openai\nimport psycopg2\n\n# OpenAI API anahtar\u0131n\u0131z\u0131 buraya ekleyin\nopenai.api_key = \"YOUR_OPENAI_API_KEY\"\n\n# PostgreSQL ba\u011flant\u0131 bilgilerinizi buraya ekleyin\nconn = psycopg2.connect(\"dbname=your_dbname user=your_user password=your_password\")\ncur = conn.cursor()\n\ndef embed_text(text):\n  response = openai.Embedding.create(input=text, model=\"text-embedding-ada-002\")\n  embedding = response['data'][0]['embedding']\n  return embedding\n\n# \u00d6rnek metin\ntext = \"Bu bir \u00f6rnek metindir.\"\nembedding = embed_text(text)\n\n# Veriyi veritaban\u0131na ekleme\ncur.execute(\"INSERT INTO documents (text, embedding) VALUES (%s, %s)\", (text, embedding))\nconn.commit()\n\ncur.close()\nconn.close()\n<\/code><\/pre>\n<p>Verileri ekledikten sonra, pgvector&#8217;\u0131n sa\u011flad\u0131\u011f\u0131 <code><-><\/code> operat\u00f6r\u00fc ile benzerlik aramas\u0131 yapabilirsiniz.  \u00d6rne\u011fin,  veritaban\u0131nda en benzer metni bulmak i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabilirsiniz:<\/p>\n<pre><code class=\"language-sql\">\nSELECT text FROM documents ORDER BY embedding <-> '[0.1, 0.2, ...]' LIMIT 1;\n<\/code><\/pre>\n<p>Burada,  <code>'[0.1, 0.2, ...]'<\/code> yerine yeni bir g\u00f6m\u00fcl\u00fc vekt\u00f6r girmeniz gerekiyor.  Bu sorgu, veritaban\u0131ndaki di\u011fer vekt\u00f6rlere g\u00f6re en yak\u0131n olan vekt\u00f6r\u00fc bulur ve ona kar\u015f\u0131l\u0131k gelen metni d\u00f6nd\u00fcr\u00fcr.<\/p>\n<h2>Sonu\u00e7<\/h2>\n<p>PostgreSQL ve pgvector, OpenAI g\u00f6m\u00fcl\u00fc vekt\u00f6rlerini depolamak ve sorgulamak i\u00e7in g\u00fc\u00e7l\u00fc ve \u00f6l\u00e7eklenebilir bir \u00e7\u00f6z\u00fcm sunar.  Bu makalede,  temel kurulum ad\u0131mlar\u0131ndan, veri ekleme ve benzerlik aramas\u0131 i\u015flemlerine kadar t\u00fcm s\u00fcreci ele ald\u0131k.  Bu y\u00f6ntem, b\u00fcy\u00fck miktarda metin verisiyle \u00e7al\u0131\u015f\u0131rken benzerlik arama i\u015flemlerini optimize etmenize yard\u0131mc\u0131 olur ve yapay zeka uygulamalar\u0131n\u0131z\u0131n performans\u0131n\u0131 art\u0131r\u0131r. Daha detayl\u0131 bilgi ve \u00f6rnekler i\u00e7in  <a href=\"https:\/\/fatihsoysal.com\">fatihsoysal.com<\/a> adresini ziyaret edebilirsiniz. Ayr\u0131ca,  <a href=\"https:\/\/dev.to\/simplr_sh\/storing-and-querying-openai-embeddings-in-postgresql-with-pgvector-2ib7\">bu makaleye kaynak olan \u0130ngilizce makaleye<\/a> de bakabilirsiniz. <\/p>\n<p>#Etiketler: OpenAI, G\u00f6m\u00fcl\u00fc Vekt\u00f6rler, Embeddings, PostgreSQL, pgvector, Vekt\u00f6r Veritaban\u0131, Benzerlik Aramas\u0131, Yapay Zeka, Makine \u00d6\u011frenmesi<br \/>\n<\/body><br \/>\n<\/html><\/p>\n","protected":false},"excerpt":{"rendered":"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama OpenAI&#8217;nin sundu\u011fu g\u00fc\u00e7l\u00fc dil modelleri, metinleri anlaml\u0131 say\u0131sal&hellip;","protected":false},"author":1,"featured_media":0,"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":[1],"tags":[],"class_list":{"0":"post-11272","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama<\/title>\n<meta name=\"description\" content=\"OpenAI&#039;nin sundu\u011fu g\u00fc\u00e7l\u00fc dil modelleri, metinleri anlaml\u0131 say\u0131sal temsiller olan &quot;g\u00f6m\u00fcl\u00fc vekt\u00f6rlere&quot; d\u00f6n\u00fc\u015ft\u00fcrmemizi sa\u011flar. Bu vekt\u00f6rler, metinlerin anlam\u0131n\u0131 yakalayan \u00e7ok boyutlu noktalar gibidir. Ancak, bu vekt\u00f6rleri etkili bir \u015fekilde depolamak ve aralar\u0131ndaki benzerlikleri bulmak i\u00e7in uygun bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fcne ihtiya\u00e7 duyar\u0131z. \u0130\u015fte tam bu noktada PostgreSQL ve onun g\u00fc\u00e7l\u00fc uzant\u0131s\u0131 pgvector devreye giriyor.\" \/>\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-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama\" \/>\n<meta property=\"og:description\" content=\"OpenAI&#039;nin sundu\u011fu g\u00fc\u00e7l\u00fc dil modelleri, metinleri anlaml\u0131 say\u0131sal temsiller olan &quot;g\u00f6m\u00fcl\u00fc vekt\u00f6rlere&quot; d\u00f6n\u00fc\u015ft\u00fcrmemizi sa\u011flar. Bu vekt\u00f6rler, metinlerin anlam\u0131n\u0131 yakalayan \u00e7ok boyutlu noktalar gibidir. Ancak, bu vekt\u00f6rleri etkili bir \u015fekilde depolamak ve aralar\u0131ndaki benzerlikleri bulmak i\u00e7in uygun bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fcne ihtiya\u00e7 duyar\u0131z. \u0130\u015fte tam bu noktada PostgreSQL ve onun g\u00fc\u00e7l\u00fc uzant\u0131s\u0131 pgvector devreye giriyor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-02T03:15:12+00:00\" \/>\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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama\",\"datePublished\":\"2025-02-02T03:15:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/\"},\"wordCount\":491,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/\",\"name\":\"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-02-02T03:15:12+00:00\",\"description\":\"OpenAI'nin sundu\u011fu g\u00fc\u00e7l\u00fc dil modelleri, metinleri anlaml\u0131 say\u0131sal temsiller olan \\\"g\u00f6m\u00fcl\u00fc vekt\u00f6rlere\\\" d\u00f6n\u00fc\u015ft\u00fcrmemizi sa\u011flar. Bu vekt\u00f6rler, metinlerin anlam\u0131n\u0131 yakalayan \u00e7ok boyutlu noktalar gibidir. Ancak, bu vekt\u00f6rleri etkili bir \u015fekilde depolamak ve aralar\u0131ndaki benzerlikleri bulmak i\u00e7in uygun bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fcne ihtiya\u00e7 duyar\u0131z. \u0130\u015fte tam bu noktada PostgreSQL ve onun g\u00fc\u00e7l\u00fc uzant\u0131s\u0131 pgvector devreye giriyor.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama\"}]},{\"@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 pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama","description":"OpenAI'nin sundu\u011fu g\u00fc\u00e7l\u00fc dil modelleri, metinleri anlaml\u0131 say\u0131sal temsiller olan \"g\u00f6m\u00fcl\u00fc vekt\u00f6rlere\" d\u00f6n\u00fc\u015ft\u00fcrmemizi sa\u011flar. Bu vekt\u00f6rler, metinlerin anlam\u0131n\u0131 yakalayan \u00e7ok boyutlu noktalar gibidir. Ancak, bu vekt\u00f6rleri etkili bir \u015fekilde depolamak ve aralar\u0131ndaki benzerlikleri bulmak i\u00e7in uygun bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fcne ihtiya\u00e7 duyar\u0131z. \u0130\u015fte tam bu noktada PostgreSQL ve onun g\u00fc\u00e7l\u00fc uzant\u0131s\u0131 pgvector devreye giriyor.","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-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama","og_description":"OpenAI'nin sundu\u011fu g\u00fc\u00e7l\u00fc dil modelleri, metinleri anlaml\u0131 say\u0131sal temsiller olan \"g\u00f6m\u00fcl\u00fc vekt\u00f6rlere\" d\u00f6n\u00fc\u015ft\u00fcrmemizi sa\u011flar. Bu vekt\u00f6rler, metinlerin anlam\u0131n\u0131 yakalayan \u00e7ok boyutlu noktalar gibidir. Ancak, bu vekt\u00f6rleri etkili bir \u015fekilde depolamak ve aralar\u0131ndaki benzerlikleri bulmak i\u00e7in uygun bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fcne ihtiya\u00e7 duyar\u0131z. \u0130\u015fte tam bu noktada PostgreSQL ve onun g\u00fc\u00e7l\u00fc uzant\u0131s\u0131 pgvector devreye giriyor.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-02-02T03:15:12+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama","datePublished":"2025-02-02T03:15:12+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/"},"wordCount":491,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/","name":"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-02-02T03:15:12+00:00","description":"OpenAI'nin sundu\u011fu g\u00fc\u00e7l\u00fc dil modelleri, metinleri anlaml\u0131 say\u0131sal temsiller olan \"g\u00f6m\u00fcl\u00fc vekt\u00f6rlere\" d\u00f6n\u00fc\u015ft\u00fcrmemizi sa\u011flar. Bu vekt\u00f6rler, metinlerin anlam\u0131n\u0131 yakalayan \u00e7ok boyutlu noktalar gibidir. Ancak, bu vekt\u00f6rleri etkili bir \u015fekilde depolamak ve aralar\u0131ndaki benzerlikleri bulmak i\u00e7in uygun bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fcne ihtiya\u00e7 duyar\u0131z. \u0130\u015fte tam bu noktada PostgreSQL ve onun g\u00fc\u00e7l\u00fc uzant\u0131s\u0131 pgvector devreye giriyor.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-ve-pgvector-ile-openai-gomulu-verileri-depolama-ve-sorgulama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL ve pgvector ile OpenAI G\u00f6m\u00fcl\u00fc Verileri Depolama ve Sorgulama"}]},{"@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\/11272","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=11272"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/11272\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=11272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=11272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=11272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}