{"id":36652,"date":"2026-03-06T11:24:27","date_gmt":"2026-03-06T16:24:27","guid":{"rendered":"https:\/\/www.lpi.org\/articles\/\/"},"modified":"2026-03-06T11:25:07","modified_gmt":"2026-03-06T16:25:07","slug":"databases-for-ai-should-you-use-a-vector-database","status":"publish","type":"post","link":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/","title":{"rendered":"Databases for AI: Should You Use a Vector Database?"},"content":{"rendered":"<p>The first article in this series laid out the role of vectors in machine learning and LLMs, along with vector representations in software. Now we&#8217;ll embark on a quick tour of databases and how they meet the modern challenges of AI.<\/p>\n<h2>Vector Databases<\/h2>\n<p>Since AI is basically vectors and vectors are AI, why not design databases specially around the vector operations listed in the previous section? Over the past decade, many such databases have been created. The free software options include <a href=\"https:\/\/milvus.io\/intro\">Milvus<\/a>, <a href=\"https:\/\/qdrant.tech\/\">Qdrant<\/a>, <a href=\"https:\/\/weaviate.io\/\">Weaviate<\/a>, <a href=\"https:\/\/vespa.ai\/\">Vespa<\/a>, <a href=\"https:\/\/www.trychroma.com\/\">ChromaDB<\/a>, and <a href=\"https:\/\/lancedb.com\/\">LanceDB<\/a>.<\/p>\n<p>What are the differences between these databases? A few are compared in <a href=\"https:\/\/neurlcreators.substack.com\/p\/comparing-vector-databases-in-2025\">this article<\/a>. Some databases are optimized for small projects such as prototypes, while others are optimized for production. Given the importance of querying major AI services, as described in the previous article in this series, the databases vie for supremacy in their integration with outside services. They also offer different types of indexes and various tools for data management, such as replication. Many companies offer cloud access to the databases.<\/p>\n<p>An article by <a href=\"https:\/\/www.tigerdata.com\/\">TigerData<\/a> (previously<a href=\"https:\/\/dev.to\/tigerdata\/timescale-is-now-tigerdata-building-the-modern-postgresql-for-the-analytical-and-agentic-era-3a51\"> named Timescale<\/a>), a company that offers tools for manipulating vectors within PostgreSQL, argues that <a href=\"https:\/\/www.tigerdata.com\/blog\/vector-databases-are-the-wrong-abstraction\">vector databases are inappropriate for AI applications<\/a>. The thrust of TigerData&#8217;s argument is that the vectors are usually consulted together with the content (text, audio, video, chemical and biological sequences, etc.) from which the vectors were generated in the first place. It makes sense, in the article&#8217;s argument, to keep all the varied types of data together. They also point out that the vectors are &#8220;derived data&#8221; in database terminology, that they need to change in tandem with changes to that data, and therefore that vectors lose much of their value when separated from the source data.<\/p>\n<p>I will not make a judgment about the validity of the arguments in the article. <a href=\"https:\/\/medium.com\/data-and-beyond\/sql-vs-vector-databases-choosing-the-right-tool-for-your-ai-powered-application-eb3bef40921b\">Another article<\/a> makes a more balanced assessment of the tradeoffs between traditional databases and vector databases. I think that many organizations use popular services or outside sources to generate vectors, and don&#8217;t want to store the source data or refer to it after generating the vectors. Some vector databases such as Weaviate provide storage for source data as well as output vectors. Furthermore, if a vector database performs its role in the application extremely well, managing its integration with other parts of the environment might be worthwhile.<\/p>\n<p>Glauber Costa, the founder of <a href=\"https:\/\/turso.tech\/vector\">Turso<\/a>, also cites many observers who say that text search, working on the original data, can produce better results than vector searches.<\/p>\n<p>Each organization has to figure out its own needs and what type of database best meets those needs. General-purpose databases are attempting to be of use for AI. So we&#8217;ll proceed to look at those.<\/p>\n<h2>SQL for vector operations<\/h2>\n<p>With the VECTOR data type in SQL, relational databases have evolved to support AI. Vectors are supported in <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/9.0\/en\/vector-functions.html\">MySQL<\/a> and its fork, <a href=\"https:\/\/mariadb.org\/projects\/mariadb-vector\/\">MariaDB<\/a>, with the basic functions to measure the distance between vectors. Mark Hinkle, CEO of Peripety Labs, an AI consultancy, says that MariaDB has more vector support currently than MySQL, but that both are at early stages.<\/p>\n<p>Whereas MySQL\/MariaDB were always designed to be stripped down and simple (it was years before they even supported transactions), PostgreSQL seems to try to be all things to all people. Look for something that can run on an SQL database\u2014PostgreSQL is almost certain to have an operation or extension that does it.<\/p>\n<p>Two <a href=\"https:\/\/www.tigerdata.com\/blog\/making-postgresql-a-better-ai-database\">extensions by TigerData<\/a>, <a href=\"https:\/\/github.com\/timescale\/pgai\">pgai<\/a> and <a href=\"https:\/\/github.com\/pgvector\/pgvector\">pgvector<\/a>, connect PostgreSQL to the larger AI world. pgai automatically updates the vectors when the source data changes in the database, while pgvector offers vector similarity search.<\/p>\n<p>PostgreSQL also offers <a href=\"https:\/\/github.com\/postgresml\/postgresml\">GPU acceleration<\/a>. The TigerData article cites benchmarks in a claim that PostgreSQL can handle vectors much faster than a vector database.<\/p>\n<p>The <a href=\"https:\/\/turso.tech\/vector\">Turso company has created a new open source database from SQLite<\/a> to include a column that contains a vector encoding, and to update it automatically when changes are made to the row.<\/p>\n<p>Other open source databases that offer SQL interfaces along with specialized AI support include <a href=\"https:\/\/www.yugabyte.com\/\">Yugabyte<\/a> and <a href=\"https:\/\/clickhouse.com\/clickhouse\">ClickHouse<\/a>.<\/p>\n<p>The choice of a vector database versus a general-purpose one might turn on whether you need to search other data besides embeddings. A variety of &#8220;hybrid search&#8221; techniques retrieve rows from databases based on some balance between vector searches and more standard queries. Karl Fogel, a partner at <a href=\"https:\/\/opentechstrategies.com\/\">Open Tech Strategies, LLC<\/a>, advises LLM users to store data in a general-purpose database that has vector support, except for specialized applications with performance needs in specific operations that can be met only by a specific vector database.<\/p>\n<h2>And All the Rest<\/h2>\n<p>Nobody wants to be left out of the new AI territory. As the old clich\u00e9 goes, &#8220;Be there or be square&#8221; (which is limited to only two dimensions in a field that manipulates millions).<\/p>\n<p>MongoDB boasts of its <a href=\"https:\/\/www.mongodb.com\/products\/platform\/atlas-vector-search\">Atlas Vector Search<\/a>, which retrieves data from the major services. Their documentation <a href=\"https:\/\/www.mongodb.com\/company\/blog\/technical\/contextualized-chunk-embeddings-combining-local-detail-with-global-context\">shows an example of storing data in the database<\/a>. Another important database engine from the NoSQL era, Cassandra, <a href=\"https:\/\/planetcassandra.org\/post\/building-an-infinitely-smart-ai-powered-by-the-worlds-largest-scalable-database-apache-cassandra-part-1\/\">claims to be useful for generative AI<\/a>.<\/p>\n<p><a href=\"https:\/\/www.elastic.co\/elasticsearch\">Elasticsearch<\/a>, a database with a long history in the area of text search, now has an <a href=\"https:\/\/alexklibisz.github.io\/elastiknn\/api\/\">extension<\/a> to index, store, and search for vectors.<\/p>\n<p>Even graph databases have gotten into the field of AI, as illustrated by an article titled &#8220;<a href=\"https:\/\/neo4j.com\/generativeai\/\">Neo4j for GenAI<\/a>.&#8221;<\/p>\n<h2>An AI Ecosystem<\/h2>\n<p>The term &#8220;ecosystem&#8221; is overused (particularly in computing) but it&#8217;s useful when conceiving the riches of different software tools that work together. Particularly in free and open source software, a wealth of different tools come at trending topics from a variety of angles, each offering one little piece of the application pipeline.<\/p>\n<p>The essence of AI is creating useful structures from unstructured data. I hope this article has helped to show how structured data can support modern AI.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.lpi.org\/blog\/2026\/02\/25\/databases-for-ai-vectors-embeddings-and-architecture\/\">&lt;&lt; Read the previous post of this series<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The first article in this series laid ou &#8230; <a href=\"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/\" class=\"button-link\">Read more<\/a><\/p>\n","protected":false},"author":44,"featured_media":36653,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"country":[],"language":[304],"ppma_author":[495],"class_list":["post-36652","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-none","language-english"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Databases for AI: Should You Use a Vector Database? - Linux Professional Institute (LPI)<\/title>\n<meta name=\"description\" content=\"SQL vector support vs vector databases: how modern databases handle embeddings, AI search, and hybrid queries.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Databases for AI: Should You Use a Vector Database?\" \/>\n<meta property=\"og:description\" content=\"SQL vector support vs vector databases: how modern databases handle embeddings, AI search, and hybrid queries.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Linux Professional Institute (LPI)\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/LPIConnect\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-06T16:24:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-06T16:25:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.lpi.org\/wp-content\/uploads\/2026\/03\/article-Databases-for-AI-Part-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"994\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Andrew Oram\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@lpiconnect\" \/>\n<meta name=\"twitter:site\" content=\"@lpiconnect\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andrew Oram\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9810\u4f30\u95b1\u8b80\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/\"},\"author\":{\"name\":\"Andrew Oram\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#\\\/schema\\\/person\\\/3406dc82718aebf8c9e647fe3a54116a\"},\"headline\":\"Databases for AI: Should You Use a Vector Database?\",\"datePublished\":\"2026-03-06T16:24:27+00:00\",\"dateModified\":\"2026-03-06T16:25:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/\"},\"wordCount\":988,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/article-Databases-for-AI-Part-2.jpg\",\"articleSection\":[\"- None -\"],\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/\",\"url\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/\",\"name\":\"Databases for AI: Should You Use a Vector Database? - Linux Professional Institute (LPI)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/article-Databases-for-AI-Part-2.jpg\",\"datePublished\":\"2026-03-06T16:24:27+00:00\",\"dateModified\":\"2026-03-06T16:25:07+00:00\",\"description\":\"SQL vector support vs vector databases: how modern databases handle embeddings, AI search, and hybrid queries.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/article-Databases-for-AI-Part-2.jpg\",\"contentUrl\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/article-Databases-for-AI-Part-2.jpg\",\"width\":1440,\"height\":994,\"caption\":\"Databases for AI: Should You Use a Vector Database?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/blog\\\/2026\\\/03\\\/06\\\/databases-for-ai-should-you-use-a-vector-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases for AI: Should You Use a Vector Database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#website\",\"url\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/\",\"name\":\"Linux Professional Institute (LPI)\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#organization\",\"name\":\"Linux Professional Institute (LPI)\",\"url\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/logo.png\",\"width\":496,\"height\":175,\"caption\":\"Linux Professional Institute (LPI)\"},\"image\":{\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/LPIConnect\",\"https:\\\/\\\/x.com\\\/lpiconnect\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/35136\",\"https:\\\/\\\/www.instagram.com\\\/lpi_org\\\/\",\"https:\\\/\\\/fosstodon.org\\\/@LPI\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/zh-hant\\\/#\\\/schema\\\/person\\\/3406dc82718aebf8c9e647fe3a54116a\",\"name\":\"Andrew Oram\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/cropped-andy-oram-bio-96x96.jpgdbb3f146554e46589556139ade4d760d\",\"url\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/cropped-andy-oram-bio-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.lpi.org\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/cropped-andy-oram-bio-96x96.jpg\",\"caption\":\"Andrew Oram\"},\"description\":\"Andy is a writer and editor in the computer field. His editorial projects at O'Reilly Media ranged from a legal guide covering intellectual property to a graphic novel about teenage hackers. Andy also writes often on health IT, on policy issues related to the Internet, and on trends affecting technical innovation and its effects on society. Print publications where his work has appeared include The Economist, Communications of the ACM, Copyright World, the Journal of Information Technology &amp; Politics, Vanguardia Dossier, and Internet Law and Business. Conferences where he has presented talks include O'Reilly's Open Source Convention, FISL (Brazil), FOSDEM (Brussels), DebConf, and LibrePlanet. Andy participates in the Association for Computing Machinery's policy organization, USTPC.\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Databases for AI: Should You Use a Vector Database? - Linux Professional Institute (LPI)","description":"SQL vector support vs vector databases: how modern databases handle embeddings, AI search, and hybrid queries.","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:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/","og_locale":"zh_TW","og_type":"article","og_title":"Databases for AI: Should You Use a Vector Database?","og_description":"SQL vector support vs vector databases: how modern databases handle embeddings, AI search, and hybrid queries.","og_url":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/","og_site_name":"Linux Professional Institute (LPI)","article_publisher":"https:\/\/www.facebook.com\/LPIConnect","article_published_time":"2026-03-06T16:24:27+00:00","article_modified_time":"2026-03-06T16:25:07+00:00","og_image":[{"width":1440,"height":994,"url":"https:\/\/www.lpi.org\/wp-content\/uploads\/2026\/03\/article-Databases-for-AI-Part-2.jpg","type":"image\/jpeg"}],"author":"Andrew Oram","twitter_card":"summary_large_image","twitter_creator":"@lpiconnect","twitter_site":"@lpiconnect","twitter_misc":{"\u4f5c\u8005:":"Andrew Oram","\u9810\u4f30\u95b1\u8b80\u6642\u9593":"5 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/#article","isPartOf":{"@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/"},"author":{"name":"Andrew Oram","@id":"https:\/\/www.lpi.org\/zh-hant\/#\/schema\/person\/3406dc82718aebf8c9e647fe3a54116a"},"headline":"Databases for AI: Should You Use a Vector Database?","datePublished":"2026-03-06T16:24:27+00:00","dateModified":"2026-03-06T16:25:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/"},"wordCount":988,"commentCount":1,"publisher":{"@id":"https:\/\/www.lpi.org\/zh-hant\/#organization"},"image":{"@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.lpi.org\/wp-content\/uploads\/2026\/03\/article-Databases-for-AI-Part-2.jpg","articleSection":["- None -"],"inLanguage":"zh-TW","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/","url":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/","name":"Databases for AI: Should You Use a Vector Database? - Linux Professional Institute (LPI)","isPartOf":{"@id":"https:\/\/www.lpi.org\/zh-hant\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/#primaryimage"},"image":{"@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.lpi.org\/wp-content\/uploads\/2026\/03\/article-Databases-for-AI-Part-2.jpg","datePublished":"2026-03-06T16:24:27+00:00","dateModified":"2026-03-06T16:25:07+00:00","description":"SQL vector support vs vector databases: how modern databases handle embeddings, AI search, and hybrid queries.","breadcrumb":{"@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/"]}]},{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/#primaryimage","url":"https:\/\/www.lpi.org\/wp-content\/uploads\/2026\/03\/article-Databases-for-AI-Part-2.jpg","contentUrl":"https:\/\/www.lpi.org\/wp-content\/uploads\/2026\/03\/article-Databases-for-AI-Part-2.jpg","width":1440,"height":994,"caption":"Databases for AI: Should You Use a Vector Database?"},{"@type":"BreadcrumbList","@id":"https:\/\/www.lpi.org\/zh-hant\/blog\/2026\/03\/06\/databases-for-ai-should-you-use-a-vector-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.lpi.org\/zh-hant\/"},{"@type":"ListItem","position":2,"name":"Databases for AI: Should You Use a Vector Database?"}]},{"@type":"WebSite","@id":"https:\/\/www.lpi.org\/zh-hant\/#website","url":"https:\/\/www.lpi.org\/zh-hant\/","name":"Linux Professional Institute (LPI)","description":"","publisher":{"@id":"https:\/\/www.lpi.org\/zh-hant\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.lpi.org\/zh-hant\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-TW"},{"@type":"Organization","@id":"https:\/\/www.lpi.org\/zh-hant\/#organization","name":"Linux Professional Institute (LPI)","url":"https:\/\/www.lpi.org\/zh-hant\/","logo":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/www.lpi.org\/zh-hant\/#\/schema\/logo\/image\/","url":"https:\/\/www.lpi.org\/wp-content\/uploads\/2023\/04\/logo.png","contentUrl":"https:\/\/www.lpi.org\/wp-content\/uploads\/2023\/04\/logo.png","width":496,"height":175,"caption":"Linux Professional Institute (LPI)"},"image":{"@id":"https:\/\/www.lpi.org\/zh-hant\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/LPIConnect","https:\/\/x.com\/lpiconnect","https:\/\/www.linkedin.com\/company\/35136","https:\/\/www.instagram.com\/lpi_org\/","https:\/\/fosstodon.org\/@LPI"]},{"@type":"Person","@id":"https:\/\/www.lpi.org\/zh-hant\/#\/schema\/person\/3406dc82718aebf8c9e647fe3a54116a","name":"Andrew Oram","image":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/www.lpi.org\/wp-content\/uploads\/2023\/07\/cropped-andy-oram-bio-96x96.jpgdbb3f146554e46589556139ade4d760d","url":"https:\/\/www.lpi.org\/wp-content\/uploads\/2023\/07\/cropped-andy-oram-bio-96x96.jpg","contentUrl":"https:\/\/www.lpi.org\/wp-content\/uploads\/2023\/07\/cropped-andy-oram-bio-96x96.jpg","caption":"Andrew Oram"},"description":"Andy is a writer and editor in the computer field. His editorial projects at O'Reilly Media ranged from a legal guide covering intellectual property to a graphic novel about teenage hackers. Andy also writes often on health IT, on policy issues related to the Internet, and on trends affecting technical innovation and its effects on society. Print publications where his work has appeared include The Economist, Communications of the ACM, Copyright World, the Journal of Information Technology &amp; Politics, Vanguardia Dossier, and Internet Law and Business. Conferences where he has presented talks include O'Reilly's Open Source Convention, FISL (Brazil), FOSDEM (Brussels), DebConf, and LibrePlanet. Andy participates in the Association for Computing Machinery's policy organization, USTPC."}]}},"views":649,"authors":[{"term_id":495,"user_id":44,"is_guest":0,"slug":"aoramexample-com","display_name":"Andrew Oram","avatar_url":"https:\/\/www.lpi.org\/wp-content\/uploads\/2023\/07\/cropped-andy-oram-bio-96x96.jpg","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/posts\/36652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/users\/44"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/comments?post=36652"}],"version-history":[{"count":2,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/posts\/36652\/revisions"}],"predecessor-version":[{"id":36664,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/posts\/36652\/revisions\/36664"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/media\/36653"}],"wp:attachment":[{"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/media?parent=36652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/categories?post=36652"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/country?post=36652"},{"taxonomy":"language","embeddable":true,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/language?post=36652"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.lpi.org\/zh-hant\/wp-json\/wp\/v2\/ppma_author?post=36652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}