{"id":475350,"date":"2025-09-19T05:08:29","date_gmt":"2025-09-19T05:08:29","guid":{"rendered":"https:\/\/savepearlharbor.com\/?p=475350"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=475350","title":{"rendered":"\u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438: \u043f\u043e\u0438\u0441\u043a \u043d\u0430 \u0418\u0418 \u0431\u0435\u0437 \u043b\u0438\u0448\u043d\u0435\u0439 \u043c\u043e\u0440\u043e\u043a\u0438"},"content":{"rendered":"<div xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\">\n<figure class=\"full-width \"><img decoding=\"async\" src=\"https:\/\/habrastorage.org\/r\/w1560\/getpro\/habr\/upload_files\/e35\/f08\/7f3\/e35f087f34292691c6c26e7a2cc4717c.png\" width=\"1024\" height=\"1024\" sizes=\"auto, (max-width: 780px) 100vw, 50vw\" srcset=\"https:\/\/habrastorage.org\/r\/w780\/getpro\/habr\/upload_files\/e35\/f08\/7f3\/e35f087f34292691c6c26e7a2cc4717c.png 780w,&#10;       https:\/\/habrastorage.org\/r\/w1560\/getpro\/habr\/upload_files\/e35\/f08\/7f3\/e35f087f34292691c6c26e7a2cc4717c.png 781w\" loading=\"lazy\" decode=\"async\"\/><\/figure>\n<p>\u041c\u044b \u0440\u0430\u0434\u044b \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u0442\u044c \u043d\u043e\u0432\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0434\u0435\u043b\u0430\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u0441 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u043c \u043f\u043e\u0438\u0441\u043a\u043e\u043c \u0442\u0430\u043a\u0438\u043c \u0436\u0435 \u043f\u0440\u043e\u0441\u0442\u044b\u043c, \u043a\u0430\u043a \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u0435 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u0430: <strong>\u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438<\/strong>.<br \/> \u0421 \u044d\u0442\u043e\u0439 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c\u044e Manticore Search \u0431\u0435\u0440\u0451\u0442 \u043d\u0430 \u0441\u0435\u0431\u044f \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u044e \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432 \u2014 \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u043b\u0438\u0448\u043d\u0438\u0445 \u043f\u0430\u0439\u043f\u043b\u0430\u0439\u043d\u043e\u0432, \u0432\u043d\u0435\u0448\u043d\u0438\u0445 \u0441\u0435\u0440\u0432\u0438\u0441\u043e\u0432 \u0438 \u0432\u043e\u0437\u043d\u0438.<\/p>\n<h3>\u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u0440\u0430\u043d\u044c\u0448\u0435<\/h3>\n<p>\u0414\u043e \u044d\u0442\u043e\u0433\u043e \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u043e\u0437\u043d\u0430\u0447\u0430\u043b \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0441:<\/p>\n<ul>\n<li>\n<p>\u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u043c\u0438 ML-\u0441\u0435\u0440\u0432\u0438\u0441\u0430\u043c\u0438 \u0434\u043b\u044f \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432,<\/p>\n<\/li>\n<li>\n<p>\u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u043c\u043e\u0434\u0435\u043b\u044f\u043c\u0438,<\/p>\n<\/li>\n<li>\n<p>\u0441\u0438\u043d\u0445\u0440\u043e\u043d\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f, \u0441\u0435\u0440\u0432\u0438\u0441\u0430 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432 \u0438 \u043f\u043e\u0438\u0441\u043a\u043e\u0432\u043e\u0433\u043e \u0434\u0432\u0438\u0436\u043a\u0430,<\/p>\n<\/li>\n<li>\n<p>\u043d\u0435\u0441\u043e\u0432\u043f\u0430\u0434\u0435\u043d\u0438\u0435\u043c \u0440\u0430\u0437\u043c\u0435\u0440\u043d\u043e\u0441\u0442\u0435\u0439 \u0432\u0435\u043a\u0442\u043e\u0440\u043e\u0432 \u0438 \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u0441 \u043f\u0440\u0435\u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0438\u043d\u0433\u043e\u043c,<\/p>\n<\/li>\n<li>\n<p>\u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u0435\u043c \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u043e\u0439 \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432 \u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437.<\/p>\n<\/li>\n<\/ul>\n<p>\u0422\u0435\u043f\u0435\u0440\u044c \u0432\u0441\u0451 \u044d\u0442\u043e \u043e\u0441\u0442\u0430\u043b\u043e\u0441\u044c \u0432 \u043f\u0440\u043e\u0448\u043b\u043e\u043c.<\/p>\n<h3>\u0427\u0442\u043e \u0442\u0430\u043a\u043e\u0435 \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438?<\/h3>\n<p>\u0421 \u0430\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0430\u043c\u0438 \u0432\u044b \u043f\u0440\u043e\u0441\u0442\u043e \u0432\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442\u0435 \u0442\u0435\u043a\u0441\u0442, \u0430 Manticore \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438:<\/p>\n<p>\u2728 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0441\u043e\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u043c\u043e\u0434\u0435\u043b\u0435\u0439<br \/>\u2728 \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u0442 \u0438\u0445 \u0432 \u0432\u0435\u043a\u0442\u043e\u0440\u043d\u044b\u0445 \u0438\u043d\u0434\u0435\u043a\u0441\u0430\u0445<br \/>\u2728 \u0434\u0430\u0451\u0442 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0438\u0441\u043a\u0430\u0442\u044c \u043d\u0430 \u0435\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u043c \u044f\u0437\u044b\u043a\u0435<br \/>\u2728 \u0441\u043a\u0440\u044b\u0432\u0430\u0435\u0442 \u0432\u0441\u044e \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u044c, \u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0432\u0430\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0431\u043e\u0442\u0443 \u043d\u0430\u0434 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u043e\u043c<\/p>\n<h3>\u041a\u0430\u043a \u044d\u0442\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442<\/h3>\n<p>\u0421\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0441\u043e\u0437\u0434\u0430\u0451\u0442\u0441\u044f \u0432\u0441\u0435\u0433\u043e \u0432 3 \u0448\u0430\u0433\u0430:<\/p>\n<h4>1. \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/h4>\n<pre><code class=\"sql\">CREATE TABLE products (    title TEXT,    description TEXT,    category STRING,    price INT,    vector FLOAT_VECTOR KNN_TYPE='hnsw' HNSW_SIMILARITY='l2'        MODEL_NAME='sentence-transformers\/all-MiniLM-L6-v2'        FROM='title,description');<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:87px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u0412\u0441\u0451 \u0437\u0430\u0434\u0430\u0451\u0442\u0441\u044f \u043e\u0434\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u043e\u0439: Manticore \u0441\u0430\u043c \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0438\u0437 \u043f\u043e\u043b\u0435\u0439 <code>title<\/code> \u0438 <code>description<\/code>.<\/p>\n<h4>2. \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445<\/h4>\n<pre><code class=\"sql\">INSERT INTO products(id, title, description, category, price) VALUES  (1, 'green hiking backpack', 'Lightweight backpack suitable for hiking trails', 'outdoors', 5999),  (2, 'laptop sleeve', 'Slim padded case for 15-inch laptops', 'electronics', 1999),  ...  (20, 'wooden puzzle box', 'Challenging mechanical puzzle made of natural wood', 'toys', 1899);<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u0414\u0430\u043d\u043d\u044b\u0435 \u043e\u0445\u0432\u0430\u0442\u044b\u0432\u0430\u044e\u0442 \u0440\u0430\u0437\u043d\u044b\u0435 \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u0438: \u0442\u043e\u0432\u0430\u0440\u044b \u0434\u043b\u044f \u043e\u0442\u0434\u044b\u0445\u0430, \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u0438\u043a\u0443, \u043c\u0435\u0431\u0435\u043b\u044c, \u043a\u043d\u0438\u0433\u0438, \u0438\u0433\u0440\u0443\u0448\u043a\u0438 \u0438 \u0434\u0440\u0443\u0433\u043e\u0435.<\/p>\n<p>\u041e\u0431\u0440\u0430\u0442\u0438\u0442\u0435 \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435: \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u0432\u0435\u043a\u0442\u043e\u0440\u043e\u0432 \u0432\u0440\u0443\u0447\u043d\u0443\u044e \u2014 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438.<br \/><em>(\u0446\u0435\u043d\u044b \u0443\u043a\u0430\u0437\u0430\u043d\u044b \u0432 \u0446\u0435\u043d\u0442\u0430\u0445: 5999 = $59.99)<\/em><\/p>\n<h4>3. \u041f\u043e\u0438\u0441\u043a \u043d\u0430 \u0435\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u043c \u044f\u0437\u044b\u043a\u0435<\/h4>\n<pre><code class=\"sql\">SELECT id, title, description, price, knn_dist()FROM products WHERE knn(vector, 5, 'lightweight laptop backpack for trail hiking')LIMIT 5;<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442:<\/p>\n<pre><code>| id  | title                   | description                                      | price | knn_dist() || --- | ----------------------- | ------------------------------------------------ | ----- | ---------- ||  9  | outdoor laptop pack     | Trail-optimized backpack with laptop sleeve      |  7800 | 0.3539     ||  1  | green hiking backpack   | Lightweight backpack suitable for hiking trails  |  5999 | 0.5311     ||  5  | mountain hiking bag     | Durable trail-ready backpack for mountain hikes  |  8950 | 0.6203     ||  4  | black laptop backpack   | Spacious backpack with padded laptop compartment |  6900 | 0.6578     || 10  | compact hiking backpack | Light and foldable backpack for trail hikes      |  4200 | 0.6859     |<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u0417\u0430\u043f\u0440\u043e\u0441 <em>\u00ab\u043b\u0451\u0433\u043a\u0438\u0439 \u0440\u044e\u043a\u0437\u0430\u043a \u0434\u043b\u044f \u043d\u043e\u0443\u0442\u0431\u0443\u043a\u0430 \u0438 \u043f\u043e\u0445\u043e\u0434\u043e\u0432\u00bb<\/em> \u0432\u0435\u0440\u043d\u0443\u043b \u0432 \u043f\u0435\u0440\u0432\u0443\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c \u00aboutdoor laptop pack\u00bb \u2014 \u043e\u043d \u0441\u043e\u0447\u0435\u0442\u0430\u0435\u0442 \u0438 \u043d\u043e\u0443\u0442\u0431\u0443\u043a, \u0438 \u043f\u043e\u0445\u043e\u0434\u044b. \u0414\u0430\u043b\u0435\u0435 \u0438\u0434\u0443\u0442 \u0442\u0443\u0440\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u0438 \u043d\u043e\u0443\u0442\u0431\u0443\u0447\u043d\u044b\u0435 \u0440\u044e\u043a\u0437\u0430\u043a\u0438.<\/p>\n<h3>\u0412\u044b\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u043e\u0434\u0445\u043e\u0434\u044f\u0449\u0443\u044e \u043c\u043e\u0434\u0435\u043b\u044c<\/h3>\n<p>\u041c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0440\u0430\u0437\u043d\u044b\u0435 \u043c\u043e\u0434\u0435\u043b\u0438 \u0432 \u0437\u0430\u0432\u0438\u0441\u0438\u043c\u043e\u0441\u0442\u0438 \u043e\u0442 \u0437\u0430\u0434\u0430\u0447:<\/p>\n<p>\ud83c\udfe0 <strong>\u041b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u0435 (<\/strong><a href=\"https:\/\/huggingface.co\/\" rel=\"noopener noreferrer nofollow\"><strong>Hugging Face<\/strong><\/a><strong>)<\/strong> \u2014 \u0431\u0435\u0437 \u043a\u043b\u044e\u0447\u0435\u0439 \u0438 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0439<br \/>\ud83c\udf10 <strong>OpenAI<\/strong> \u2014 \u043b\u0443\u0447\u0448\u0438\u0435 \u043f\u043e \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0443 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u043a\u0438<br \/>\ud83d\ude80 <strong>Voyage \u0438 Jina<\/strong> \u2014 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u043f\u043e\u0434 \u0440\u0430\u0437\u043d\u044b\u0435 \u044f\u0437\u044b\u043a\u0438 \u0438 \u0434\u043e\u043c\u0435\u043d\u044b \u043f\u0440\u0435\u0434\u043c\u0435\u0442\u043d\u043e\u0439 \u043e\u0431\u043b\u0430\u0441\u0442\u0438<\/p>\n<h3>\u0413\u0438\u0431\u0440\u0438\u0434\u043d\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u0438 \u0444\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u044f (\u043f\u0440\u0438\u043c\u0435\u0440 SQL)<\/h3>\n<p>\u041a\u043e\u043c\u0431\u0438\u043d\u0438\u0440\u0443\u0439\u0442\u0435 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u043a\u0443, \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u0441\u043b\u043e\u0432\u0430 \u0438 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u043d\u044b\u0435 \u0444\u0438\u043b\u044c\u0442\u0440\u044b \u0432 \u043e\u0434\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435:<\/p>\n<pre><code class=\"sql\">SELECT id, price, highlight()FROM productsWHERE knn(vector, 7, 'lightweight laptop backpack for trail hiking')  AND category = 'outdoors'  AND MATCH('\"lightweight laptop backpack for trail hiking\"\/0.5');<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><strong>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b:<\/strong><\/p>\n<pre><code>+------+-------+-----------------------------------------------------------------------------------------------+| id   | price | highlight()                                                                                   |+------+-------+-----------------------------------------------------------------------------------------------+|    9 |  7800 | outdoor &lt;b&gt;laptop&lt;\/b&gt; pack | &lt;b&gt;Trail&lt;\/b&gt;-optimized &lt;b&gt;backpack&lt;\/b&gt; with &lt;b&gt;laptop&lt;\/b&gt; sleeve ||    1 |  5999 | green &lt;b&gt;hiking backpack&lt;\/b&gt; | &lt;b&gt;Lightweight backpack&lt;\/b&gt; suitable &lt;b&gt;for hiking&lt;\/b&gt; trails  ||    5 |  8950 | mountain &lt;b&gt;hiking&lt;\/b&gt; bag | Durable &lt;b&gt;trail&lt;\/b&gt;-ready &lt;b&gt;backpack for&lt;\/b&gt; mountain hikes    ||   10 |  4200 | compact &lt;b&gt;hiking backpack&lt;\/b&gt; | Light and foldable &lt;b&gt;backpack for trail&lt;\/b&gt; hikes           |+------+-------+-----------------------------------------------------------------------------------------------+<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><em>\u041f\u0440\u0438\u043c\u0435\u0447\u0430\u043d\u0438\u0435: \u0444\u0443\u043d\u043a\u0446\u0438\u044f <\/em><code><em>highlight()<\/em><\/code><em> \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0440\u0430\u0437\u043c\u0435\u0442\u043a\u0443 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, <\/em><code><em>&lt;b&gt;...&lt;\/b&gt;<\/em><\/code><em>).<\/em><\/p>\n<p>\u042d\u0442\u0430 \u043c\u043e\u0449\u043d\u0430\u044f \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f \u043e\u0434\u043d\u043e\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e:<\/p>\n<ul>\n<li>\n<p>\u0444\u0438\u043b\u044c\u0442\u0440\u0443\u0435\u0442 \u043f\u043e \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u0438 (<em>outdoors<\/em>),<\/p>\n<\/li>\n<li>\n<p>\u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0435\u0442 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0443\u044e \u0440\u0435\u043b\u0435\u0432\u0430\u043d\u0442\u043d\u043e\u0441\u0442\u044c \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432,<\/p>\n<\/li>\n<li>\n<p>\u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0441\u043e\u0432\u043f\u0430\u0434\u0435\u043d\u0438\u0439 \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0442\u0435\u043a\u0441\u0442\u0430 \u0447\u0435\u0440\u0435\u0437 \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u0441\u043b\u043e\u0432\u0430,<\/p>\n<\/li>\n<li>\n<p>\u0438 \u043f\u043e\u0434\u0441\u0432\u0435\u0447\u0438\u0432\u0430\u0435\u0442 \u043d\u0430\u0439\u0434\u0435\u043d\u043d\u044b\u0435 \u0442\u0435\u0440\u043c\u0438\u043d\u044b.<\/p>\n<\/li>\n<\/ul>\n<p>\u0412\u0441\u0451 \u044d\u0442\u043e \u2014 \u0432 \u043e\u0434\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435!<\/p>\n<h3>\u041f\u043e\u043b\u043d\u0430\u044f \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 HTTP\/JSON API<\/h3>\n<p>\u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0431\u0435\u0437 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u0441 HTTP\/JSON API \u0432 Manticore, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0442\u043e\u0442 \u0436\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b, \u0447\u0442\u043e \u0438 SQL, \u043d\u043e \u0447\u0435\u0440\u0435\u0437 REST-\u044d\u043d\u0434\u043f\u043e\u0438\u043d\u0442\u044b.<\/p>\n<h4>\u0412\u0441\u0442\u0430\u0432\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0447\u0435\u0440\u0435\u0437 JSON (\u043f\u0440\u0438\u043c\u0435\u0440 HTTP\/JSON API)<\/h4>\n<p>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 \u044d\u043d\u0434\u043f\u043e\u0438\u043d\u0442 <code>\/insert<\/code> \u2014 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0431\u0443\u0434\u0443\u0442 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438:<\/p>\n<pre><code class=\"bash\">curl \"http:\/\/localhost:9308\/insert\" -H \"Content-Type: application\/json\" \\  -d '{    \"table\": \"products\",     \"id\": 21,     \"doc\": {      \"title\": \"wireless headphones\",       \"description\": \"Bluetooth headphones with noise cancellation\",       \"category\": \"electronics\",       \"price\": 15900    }  }'<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><strong>\u041e\u0442\u0432\u0435\u0442:<\/strong><\/p>\n<pre><code class=\"json\">{  \"table\": \"products\",  \"id\": 21,  \"created\": true,  \"result\": \"created\",  \"status\": 201}<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<h4>\u041c\u0430\u0441\u0441\u043e\u0432\u0430\u044f \u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0441 \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0430\u043c\u0438 (\u043f\u0440\u0438\u043c\u0435\u0440 HTTP\/JSON API)<\/h4>\n<p>\u0412\u0441\u0442\u0430\u0432\u043b\u044f\u0439\u0442\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u043e\u0432 \u0441\u0440\u0430\u0437\u0443 \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u044d\u043d\u0434\u043f\u043e\u0438\u043d\u0442\u0430 <code>\/bulk<\/code>:<\/p>\n<pre><code class=\"bash\">curl \"http:\/\/localhost:9308\/bulk\" -H \"Content-Type: application\/x-ndjson\" \\  --data-raw $'{\"insert\": {\"table\": \"products\", \"id\": 22, \"doc\": {\"title\": \"gaming laptop\", \"description\": \"High-performance laptop for gaming and work\", \"category\": \"electronics\", \"price\": 159900}}}{\"insert\": {\"table\": \"products\", \"id\": 23, \"doc\": {\"title\": \"smartphone\", \"description\": \"Latest flagship smartphone with 5G\", \"category\": \"electronics\", \"price\": 89900}}}{\"insert\": {\"table\": \"products\", \"id\": 24, \"doc\": {\"title\": \"tablet computer\", \"description\": \"Lightweight tablet for work and entertainment\", \"category\": \"electronics\", \"price\": 49900}}}'<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><strong>\u041e\u0442\u0432\u0435\u0442:<\/strong><\/p>\n<pre><code class=\"json\">{  \"items\": [    {      \"bulk\": {        \"table\": \"products\",        \"_id\": 24,        \"created\": 3,        \"deleted\": 0,        \"updated\": 0,        \"result\": \"created\",        \"status\": 201      }    }  ],  \"current_line\": 3,  \"skipped_lines\": 0,  \"errors\": false,  \"error\": \"\"}<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u041c\u0430\u0441\u0441\u043e\u0432\u0430\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u0432\u0441\u0442\u0430\u0432\u0438\u043b\u0430 3 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 \u0441 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u043c\u0438 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0430\u043c\u0438.<\/p>\n<h4>\u0421\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u0447\u0435\u0440\u0435\u0437 JSON (\u043f\u0440\u0438\u043c\u0435\u0440 HTTP\/JSON API)<\/h4>\n<p>\u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0439\u0442\u0435 \u043f\u043e\u0438\u0441\u043a \u0441 \u0435\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e-\u044f\u0437\u044b\u043a\u043e\u0432\u044b\u043c\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u0430\u043c\u0438, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u044d\u043d\u0434\u043f\u043e\u0438\u043d\u0442 <code>\/search<\/code>:<\/p>\n<pre><code class=\"bash\">curl \"http:\/\/localhost:9308\/search\" -H \"Content-Type: application\/json\" \\  -d '{    \"table\": \"products\",    \"_source\": [\"title\"],    \"size\": 5,    \"knn\": {      \"field\": \"vector\",      \"query\": \"outdoor hiking adventure\",      \"k\": 3    }  }'<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><strong>\u041e\u0442\u0432\u0435\u0442:<\/strong><\/p>\n<pre><code class=\"json\">`json{  \"took\": 8,  \"timed_out\": false,  \"hits\": {    \"total\": 24,    \"total_relation\": \"eq\",    \"hits\": [      {        \"_id\": 18,        \"_score\": 1,        \"_knn_dist\": 0.75467718,        \"_source\": {          \"title\": \"children's adventure book\"        }      },      {        \"_id\": 1,        \"_score\": 1,        \"_knn_dist\": 0.83226496,        \"_source\": {          \"title\": \"green hiking backpack\"        }      },      {        \"_id\": 5,        \"_score\": 1,        \"_knn_dist\": 0.89348459,        \"_source\": {          \"title\": \"mountain hiking bag\"        }      },      {        \"_id\": 10,        \"_score\": 1,        \"_knn_dist\": 0.92611158,        \"_source\": {          \"title\": \"compact hiking backpack\"        }      },      {        \"_id\": 3,        \"_score\": 1,        \"_knn_dist\": 0.98721427,        \"_source\": {          \"title\": \"travel daypack\"        }      }    ]  }}<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u0417\u0430\u043f\u0440\u043e\u0441 <em>\u00aboutdoor hiking adventure\u00bb<\/em> \u0432\u0435\u0440\u043d\u0443\u043b \u043f\u0435\u0440\u0432\u044b\u043c <em>children\u2019s adventure book<\/em> (\u0440\u0430\u0441\u0441\u0442\u043e\u044f\u043d\u0438\u0435 0.755), \u0430 \u0437\u0430\u0442\u0435\u043c \u2014 \u0440\u044e\u043a\u0437\u0430\u043a\u0438 \u0434\u043b\u044f \u043f\u043e\u0445\u043e\u0434\u043e\u0432. \u042d\u0442\u043e \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442, \u0447\u0442\u043e \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u043d\u0430\u0445\u043e\u0434\u0438\u0442 \u043a\u043e\u043d\u0446\u0435\u043f\u0442\u0443\u0430\u043b\u044c\u043d\u043e \u0431\u043b\u0438\u0437\u043a\u0438\u0435 \u0432\u0435\u0449\u0438, \u0430 \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0447\u043d\u044b\u0435 \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u0441\u043b\u043e\u0432\u0430.<\/p>\n<h4>\u0424\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u044f \u0438 \u0433\u0438\u0431\u0440\u0438\u0434\u043d\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u0447\u0435\u0440\u0435\u0437 JSON (\u043f\u0440\u0438\u043c\u0435\u0440 HTTP\/JSON API)<\/h4>\n<p>\u041a\u043e\u043c\u0431\u0438\u043d\u0438\u0440\u0443\u0439\u0442\u0435 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u0441 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u043c\u0438 \u0444\u0438\u043b\u044c\u0442\u0440\u0430\u043c\u0438:<\/p>\n<pre><code class=\"bash\">curl \"http:\/\/localhost:9308\/search\" -H \"Content-Type: application\/json\" \\  -d '{    \"table\": \"products\",    \"_source\": [\"title\", \"price\"],    \"size\": 5,    \"knn\": {      \"field\": \"vector\",       \"query\": \"technology electronic device\",      \"k\": 5,      \"filter\": {        \"range\": {\"price\": {\"gte\": 15000}}      }    }  }'<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><strong>\u041e\u0442\u0432\u0435\u0442:<\/strong><\/p>\n<pre><code class=\"json\">{  \"took\": 10,  \"timed_out\": false,  \"hits\": {    \"total\": 5,    \"total_relation\": \"eq\",    \"hits\": [      {        \"_id\": 24,        \"_score\": 1,        \"_knn_dist\": 1.31113040,        \"_source\": {          \"title\": \"tablet computer\",          \"price\": 49900        }      },      {        \"_id\": 23,        \"_score\": 1,        \"_knn_dist\": 1.56920886,        \"_source\": {          \"title\": \"smartphone\",          \"price\": 89900        }      },      {        \"_id\": 22,        \"_score\": 1,        \"_knn_dist\": 1.59042466,        \"_source\": {          \"title\": \"gaming laptop\",          \"price\": 159900        }      },      {        \"_id\": 16,        \"_score\": 1,        \"_knn_dist\": 1.84979212,        \"_source\": {          \"title\": \"office chair\",          \"price\": 27900        }      },      {        \"_id\": 21,        \"_score\": 1,        \"_knn_dist\": 1.88567829,        \"_source\": {          \"title\": \"wireless headphones\",          \"price\": 15900        }      }    ]  }}<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u0417\u0430\u043f\u0440\u043e\u0441 <em>\u00abtechnology electronic device\u00bb<\/em> \u0441 \u0444\u0438\u043b\u044c\u0442\u0440\u043e\u043c \u043f\u043e \u0446\u0435\u043d\u0435 (\u2265 $150) \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e \u043f\u0440\u0438\u043e\u0440\u0438\u0442\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043b \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u0438\u043a\u0443 \u0438 \u0438\u0441\u043a\u043b\u044e\u0447\u0438\u043b \u0434\u0435\u0448\u0451\u0432\u044b\u0435 \u0442\u043e\u0432\u0430\u0440\u044b \u0432\u0440\u043e\u0434\u0435 \u043f\u043e\u0445\u043e\u0434\u043d\u044b\u0445 \u0440\u044e\u043a\u0437\u0430\u043a\u043e\u0432 \u0438\u043b\u0438 \u043c\u0435\u043b\u043a\u043e\u0439 \u0442\u0435\u0445\u043d\u0438\u043a\u0438. \u00abTablet computer\u00bb \u043e\u043a\u0430\u0437\u0430\u043b\u0441\u044f \u0432\u044b\u0448\u0435 \u0432\u0441\u0435\u0433\u043e \u0438\u0437-\u0437\u0430 \u0441\u0438\u043b\u044c\u043d\u043e\u0433\u043e \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u0441\u043e\u0432\u043f\u0430\u0434\u0435\u043d\u0438\u044f.<\/p>\n<h4>\u0412\u0435\u043a\u0442\u043e\u0440\u044b \u0432\u0440\u0443\u0447\u043d\u0443\u044e vs \u0430\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438<\/h4>\n<p>HTTP\/JSON API \u0438 SQL \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0442 \u043e\u0431\u0430 \u0432\u0430\u0440\u0438\u0430\u043d\u0442\u0430:<\/p>\n<ul>\n<li>\n<p>\u0430\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438: <code>\"query\": \"outdoor hiking adventure\"<\/code><\/p>\n<\/li>\n<li>\n<p>\u0432\u0440\u0443\u0447\u043d\u0443\u044e \u0437\u0430\u0434\u0430\u043d\u043d\u044b\u0435 \u0432\u0435\u043a\u0442\u043e\u0440\u044b: <code>\"query\": [0.1, 0.2, 0.3, ...]<\/code><\/p>\n<\/li>\n<\/ul>\n<p>\u042d\u0442\u043e \u0434\u0430\u0451\u0442 \u0433\u0438\u0431\u043a\u043e\u0441\u0442\u044c \u2014 \u043c\u043e\u0436\u043d\u043e \u0441\u043c\u0435\u0448\u0438\u0432\u0430\u0442\u044c \u0430\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0438 \u0441\u0432\u043e\u0438 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0432\u044b\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u044b\u0435 \u0432\u0435\u043a\u0442\u043e\u0440\u044b \u0432 \u043e\u0434\u043d\u043e\u043c \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0438.<\/p>\n<h3>\u0418\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u044f \u0441 OpenAI<\/h3>\n<p>\u0414\u043b\u044f \u0435\u0449\u0451 \u0431\u043e\u043b\u0435\u0435 \u0442\u043e\u0447\u043d\u043e\u0433\u043e \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u043f\u043e\u043d\u0438\u043c\u0430\u043d\u0438\u044f \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043c\u043e\u0434\u0435\u043b\u0438 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432 OpenAI:<\/p>\n<pre><code class=\"sql\">-- Create table with OpenAI embeddingsCREATE TABLE products_openai (  title TEXT,  description TEXT,  category string,  price INT,  vector FLOAT_VECTOR KNN_TYPE='hnsw' HNSW_SIMILARITY='l2'    MODEL_NAME='openai\/text-embedding-ada-002'    FROM='title, description'    API_KEY='your-openai-api-key');-- Insert data (embeddings generated via OpenAI API)INSERT INTO products_openai(title, description, category, price) VALUES  ('smartphone device', 'latest mobile technology with advanced features', 'electronics', 79900),  ('laptop computer', 'portable workstation for developers and professionals', 'electronics', 129900);-- Search with natural languageSELECT id, title, description, knn_dist()FROM products_openai WHERE knn(vector, 2, 'mobile phone technology');<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><strong>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b:<\/strong><\/p>\n<pre><code>+---------------------+-------------------+-------------------------------------------------------+------------+| id                  | title             | description                                           | knn_dist() |+---------------------+-------------------+-------------------------------------------------------+------------+| 2309215617435041807 | smartphone device | latest mobile technology with advanced features       | 0.20333229 || 2309215617435041808 | laptop computer   | portable workstation for developers and professionals | 0.40197325 |+---------------------+-------------------+-------------------------------------------------------+------------+<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0437\u0430\u043f\u0440\u043e\u0441 <em>\u00abmobile phone technology\u00bb<\/em> \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e \u0440\u0430\u0441\u043f\u043e\u0437\u043d\u0430\u043b, \u0447\u0442\u043e \u0441\u043c\u0430\u0440\u0442\u0444\u043e\u043d \u043a\u0443\u0434\u0430 \u0431\u043b\u0438\u0436\u0435 \u043f\u043e \u0441\u043c\u044b\u0441\u043b\u0443, \u0447\u0435\u043c \u043d\u043e\u0443\u0442\u0431\u0443\u043a.<\/p>\n<h3>\u0414\u043b\u044f \u043f\u0440\u043e\u0434\u0430\u043a\u0448\u0435\u043d\u0430<\/h3>\n<p>\u26a1 <strong>\u0411\u044b\u0441\u0442\u0440\u043e<\/strong>: \u0438\u043d\u0434\u0435\u043a\u0441\u0430\u0446\u0438\u044f HNSW, \u043e\u043f\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u0430\u044f \u043a\u0432\u0430\u043d\u0442\u0438\u0437\u0430\u0446\u0438\u044f, \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0435 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435<br \/>\ud83d\udee1\ufe0f <strong>\u041d\u0430\u0434\u0451\u0436\u043d\u043e<\/strong>: \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u043e\u0432\u0430\u0439\u0434\u0435\u0440\u043e\u0432 \u043c\u043e\u0434\u0435\u043b\u0435\u0439, \u0437\u0430\u0449\u0438\u0442\u0430 \u043e\u0442 \u043f\u0443\u0441\u0442\u044b\u0445 \u0432\u0435\u043a\u0442\u043e\u0440\u043e\u0432<br \/>\ud83d\udd27 <strong>\u0413\u0438\u0431\u043a\u043e<\/strong>: \u043c\u043e\u0436\u043d\u043e \u0441\u0442\u0440\u043e\u0438\u0442\u044c \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0438\u0437 \u043b\u044e\u0431\u044b\u0445 \u043f\u043e\u043b\u0435\u0439<\/p>\n<h3>\u0413\u0434\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438<\/h3>\n<p>\ud83d\udecd\ufe0f \u041f\u043e\u0438\u0441\u043a \u0432 e-commerce: \u00ab\u0432\u043e\u0434\u043e\u043d\u0435\u043f\u0440\u043e\u043d\u0438\u0446\u0430\u0435\u043c\u044b\u0435 \u0431\u043e\u0442\u0438\u043d\u043a\u0438 \u0434\u043b\u044f \u043f\u043e\u0445\u043e\u0434\u043e\u0432\u00bb \u2192 \u0440\u0435\u043b\u0435\u0432\u0430\u043d\u0442\u043d\u044b\u0435 \u0442\u043e\u0432\u0430\u0440\u044b<br \/>\ud83d\udcda \u041f\u043e\u0438\u0441\u043a \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u043e\u0432: \u00ab\u043a\u043e\u043d\u0442\u0440\u0430\u043a\u0442\u044b \u043e \u0437\u0430\u0449\u0438\u0442\u0435 \u0434\u0430\u043d\u043d\u044b\u0445\u00bb \u2192 \u043d\u0443\u0436\u043d\u044b\u0435 \u044e\u0440\u0438\u0434\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u044b<br \/>\ud83c\udfb5 \u0420\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438 \u043a\u043e\u043d\u0442\u0435\u043d\u0442\u0430: \u00ab\u044d\u043d\u0435\u0440\u0433\u0438\u0447\u043d\u0430\u044f \u043c\u0443\u0437\u044b\u043a\u0430 \u0434\u043b\u044f \u0442\u0440\u0435\u043d\u0438\u0440\u043e\u0432\u043e\u043a\u00bb \u2192 \u043f\u043e\u0434\u0431\u043e\u0440 \u043f\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043d\u0438\u044e<br \/>\ud83c\udfe0 \u041f\u043e\u0438\u0441\u043a \u043d\u0435\u0434\u0432\u0438\u0436\u0438\u043c\u043e\u0441\u0442\u0438: \u00ab\u0443\u044e\u0442\u043d\u044b\u0435 \u043a\u0432\u0430\u0440\u0442\u0438\u0440\u044b \u0440\u044f\u0434\u043e\u043c \u0441 \u043f\u0430\u0440\u043a\u043e\u043c\u00bb \u2192 \u043e\u0431\u044a\u044f\u0432\u043b\u0435\u043d\u0438\u044f, \u043f\u043e\u0434\u0445\u043e\u0434\u044f\u0449\u0438\u0435 \u043f\u043e \u0441\u0442\u0438\u043b\u044e \u0436\u0438\u0437\u043d\u0438<\/p>\n<h3>\u0415\u0449\u0451 \u043f\u0440\u0438\u043c\u0435\u0440\u044b<\/h3>\n<p>\u0414\u0430\u0432\u0430\u0439\u0442\u0435 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c, \u043a\u0430\u043a \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u043d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0435 \u0432 \u0440\u0430\u0437\u043d\u044b\u0445 \u0441\u0446\u0435\u043d\u0430\u0440\u0438\u044f\u0445 \u043f\u043e\u0438\u0441\u043a\u0430:<\/p>\n<h4>\u041f\u043e\u0438\u0441\u043a \u0442\u043e\u0432\u0430\u0440\u043e\u0432 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0438 \u043f\u0440\u043e\u0434\u0443\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u0438<\/h4>\n<pre><code class=\"sql\">SELECT id, title, description, price, knn_dist()FROM products WHERE knn(vector, 3, 'work productivity office')LIMIT 3;<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p> <strong>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b:<\/strong><\/p>\n<pre><code>+------+----------------------+----------------------------------------------------------+-------+------------+| id   | title                | description                                              | price | knn_dist() |+------+----------------------+----------------------------------------------------------+-------+------------+|   24 | tablet computer      | Lightweight tablet for work and entertainment            | 49900 |   1.306459 ||   16 | office chair         | Ergonomic office chair with lumbar support and mesh back | 27900 | 1.44871426 ||   17 | notebook and pen set | Elegant A5 notebook with smooth-writing pen              |  1200 | 1.48466742 |+------+----------------------+----------------------------------------------------------+-------+------------+<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u0417\u0430\u043f\u0440\u043e\u0441 <em>\u00abwork productivity office\u00bb<\/em> \u0432\u0435\u0440\u043d\u0443\u043b \u043e\u0444\u0438\u0441\u043d\u0443\u044e \u043c\u0435\u0431\u0435\u043b\u044c, \u043a\u0430\u043d\u0446\u0435\u043b\u044f\u0440\u0438\u044e \u0438 \u0440\u0430\u0431\u043e\u0447\u0438\u0435 \u0430\u043a\u0441\u0435\u0441\u0441\u0443\u0430\u0440\u044b.<\/p>\n<h4>\u0423\u043c\u043d\u0430\u044f \u0444\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u044f \u043f\u043e \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u044f\u043c<\/h4>\n<p>\u0418\u043d\u043e\u0433\u0434\u0430 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f <em>\u0441\u043b\u0438\u0448\u043a\u043e\u043c<\/em> \u0448\u0438\u0440\u043e\u043a\u0438\u043c. \u0417\u0430\u043f\u0440\u043e\u0441 <em>\u00abusb charger for outdoor camping\u00bb<\/em> \u0431\u0435\u0437 \u0444\u0438\u043b\u044c\u0442\u0440\u0430 \u0432\u0435\u0440\u043d\u0443\u043b \u0441\u043e\u043b\u043d\u0435\u0447\u043d\u044b\u0435 \u0437\u0430\u0440\u044f\u0434\u043a\u0438, \u0440\u044e\u043a\u0437\u0430\u043a\u0438 \u0438 \u0442\u0443\u0440\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0441\u043d\u0430\u0440\u044f\u0436\u0435\u043d\u0438\u0435.<\/p>\n<pre><code class=\"sql\">SELECT id, title, description, price, knn_dist()FROM products WHERE knn(vector, 5, 'usb charger for outdoor camping');<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u041d\u043e \u0435\u0441\u043b\u0438 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0444\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u044e \u043f\u043e \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u0438:<\/p>\n<pre><code>SELECT id, highlight()FROM products WHERE knn(vector, 5, 'usb charger for outdoor camping')  AND category = 'electronics'  AND MATCH('\"usb charger for outdoor camping\"\/0.5')LIMIT 3;<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><strong>\u0422\u043e\u0447\u043d\u044b\u0439 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442:<\/strong><\/p>\n<pre><code>+------+-------------------------------------------------------------------------------------------------------+| id   | highlight()                                                                                           |+------+-------------------------------------------------------------------------------------------------------+|   11 | portable solar &lt;b&gt;charger&lt;\/b&gt; | Foldable solar panel &lt;b&gt;charger for&lt;\/b&gt; phones and &lt;b&gt;USB&lt;\/b&gt; devices |+------+-------------------------------------------------------------------------------------------------------+<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p><em>\u041f\u0440\u0438\u043c\u0435\u0447\u0430\u043d\u0438\u0435: \u0444\u0443\u043d\u043a\u0446\u0438\u044f <\/em><code><em>highlight()<\/em><\/code><em> \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0440\u0430\u0437\u043c\u0435\u0442\u043a\u0443 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, <\/em><code><em>&lt;b&gt;...&lt;\/b&gt;<\/em><\/code><em>). \u0416\u0438\u0440\u043d\u044b\u0439 \u0448\u0440\u0438\u0444\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u043f\u0440\u0438\u0432\u0435\u0434\u0451\u043d \u0434\u043b\u044f \u0443\u0434\u043e\u0431\u0441\u0442\u0432\u0430 \u0447\u0442\u0435\u043d\u0438\u044f.<\/em><\/p>\n<p>\u041a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u043f\u043e\u043d\u0438\u043c\u0430\u043d\u0438\u044f + \u0444\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u0438 \u043f\u043e \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u0438 + \u043f\u043e\u0438\u0441\u043a\u0430 \u043f\u043e \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u043c \u0441\u043b\u043e\u0432\u0430\u043c \u0434\u0430\u043b\u0430 \u043d\u0430\u043c \u0438\u043c\u0435\u043d\u043d\u043e \u0442\u043e, \u0447\u0442\u043e \u043c\u044b \u0445\u043e\u0442\u0435\u043b\u0438!<\/p>\n<h4>\u041f\u043e\u0438\u0441\u043a \u0434\u043b\u044f \u0440\u0430\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0439 \u0438 \u043a\u0440\u0435\u0430\u0442\u0438\u0432\u0430<\/h4>\n<pre><code class=\"sql\">SELECT id, title, description, price, knn_dist()FROM products WHERE knn(vector, 3, 'fun creative play toys')LIMIT 3;<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p> <strong>\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b:<\/strong><\/p>\n<pre><code>+------+---------------------------+----------------------------------------------------+-------+------------+| id   | title                     | description                                        | price | knn_dist() |+------+---------------------------+----------------------------------------------------+-------+------------+|    8 | camping gear set          | Complete set for weekend camping adventures        | 12000 | 1.30462146 ||   20 | wooden puzzle box         | Challenging mechanical puzzle made of natural wood |  1899 |   1.305056 ||   18 | children's adventure book | Illustrated storybook about outdoor exploration    |  1299 | 1.47192979 |+------+---------------------------+----------------------------------------------------+-------+------------+<\/code><div class=\"code-explainer\"><a href=\"https:\/\/sourcecraft.dev\/\" class=\"tm-button code-explainer__link\" style=\"visibility: hidden;\"><img style=\"width:14px;height:14px;object-fit:cover;object-position:left;\"\/><\/a><\/div><\/pre>\n<p>\u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u043f\u043e\u043d\u044f\u043b\u0438 \u0438\u0434\u0435\u044e <em>\u00abfun creative play\u00bb<\/em> \u0438 \u043d\u0430\u0448\u043b\u0438 \u0441\u043d\u0430\u0440\u044f\u0436\u0435\u043d\u0438\u0435 \u0434\u043b\u044f \u043f\u0440\u0438\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0439, \u0433\u043e\u043b\u043e\u0432\u043e\u043b\u043e\u043c\u043a\u0438 \u0438 \u0434\u0435\u0442\u0441\u043a\u0438\u0435 \u043a\u043d\u0438\u0433\u0438 \u2014 \u0432\u0441\u0451, \u0447\u0442\u043e \u0441\u0432\u044f\u0437\u0430\u043d\u043e \u0441 \u0442\u0432\u043e\u0440\u0447\u0435\u0441\u0442\u0432\u043e\u043c \u0438 \u0438\u0433\u0440\u043e\u0439.<\/p>\n<h3>\u0427\u0442\u043e \u0432\u043d\u0443\u0442\u0440\u0438<\/h3>\n<p>\u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442:<\/p>\n<ul>\n<li>\n<p><strong>Sentence Transformers<\/strong> \u0434\u043b\u044f \u043f\u043e\u043d\u0438\u043c\u0430\u043d\u0438\u044f \u0441\u043c\u044b\u0441\u043b\u0430,<\/p>\n<\/li>\n<li>\n<p><strong>HNSW <\/strong>\u0434\u043b\u044f \u0431\u044b\u0441\u0442\u0440\u043e\u0433\u043e \u043f\u043e\u0438\u0441\u043a\u0430 \u043f\u043e \u0441\u0445\u043e\u0434\u0441\u0442\u0432\u0443, <\/p>\n<\/li>\n<li>\n<p><strong>\u0443\u043c\u043d\u043e\u0435 \u043a\u044d\u0448\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435<\/strong> \u0434\u043b\u044f \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0439 \u0440\u0430\u0431\u043e\u0442\u044b,<\/p>\n<\/li>\n<li>\n<p><strong>\u041c\u0443\u043b\u044c\u0442\u0438-\u043f\u0440\u043e\u0432\u0430\u0439\u0434\u0435\u0440\u043d\u044b\u0435 API<\/strong>  \u0434\u043b\u044f \u0433\u0438\u0431\u043a\u043e\u0441\u0442\u0438.<\/p>\n<\/li>\n<\/ul>\n<h3>\u041f\u043e\u043f\u0440\u043e\u0431\u0443\u0439\u0442\u0435 \u043f\u0440\u044f\u043c\u043e \u0441\u0435\u0439\u0447\u0430\u0441<\/h3>\n<p>\u041a\u0430\u043a \u0432\u0438\u0434\u043d\u043e \u0438\u0437 \u043f\u0440\u0438\u043c\u0435\u0440\u043e\u0432, \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0434\u0430\u044e\u0442 \u043c\u043e\u0449\u043d\u044b\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u043f\u043e\u0438\u0441\u043a\u0430 \u043f\u0440\u0438 \u043c\u0438\u043d\u0438\u043c\u0430\u043b\u044c\u043d\u043e\u0439 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0435. \u0411\u0443\u0434\u044c \u0442\u043e:<\/p>\n<ul>\n<li>\n<p><strong>\u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b e-commerce<\/strong> \u0441 \u043f\u043e\u0438\u0441\u043a\u043e\u043c \u043f\u043e \u0435\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u043c\u0443 \u044f\u0437\u044b\u043a\u0443,<\/p>\n<\/li>\n<li>\n<p><strong>\u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043a\u043e\u043d\u0442\u0435\u043d\u0442\u043e\u043c<\/strong> \u0441 \u0443\u043c\u043d\u044b\u043c \u043f\u043e\u0438\u0441\u043a\u043e\u043c \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u043e\u0432,<\/p>\n<\/li>\n<li>\n<p><strong>\u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u0434\u0432\u0438\u0436\u043a\u0438<\/strong>, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u043e\u043d\u0438\u043c\u0430\u044e\u0442 \u043d\u0430\u043c\u0435\u0440\u0435\u043d\u0438\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439,<\/p>\n<\/li>\n<li>\n<p><strong>\u0431\u0430\u0437\u044b \u0437\u043d\u0430\u043d\u0438\u0439<\/strong> \u0441 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u043c\u0438 \u043e\u0442\u0432\u0435\u0442\u0430\u043c\u0438 \u043d\u0430 \u0432\u043e\u043f\u0440\u043e\u0441\u044b,<\/p>\n<\/li>\n<\/ul>\n<p>\u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0441\u043d\u0438\u043c\u0430\u044e\u0442 \u0441\u0430\u043c\u0443\u044e \u0441\u043b\u043e\u0436\u043d\u0443\u044e \u0447\u0430\u0441\u0442\u044c \u2014 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0430\u043c\u0438.<br \/>\u0410 \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0441\u043e\u0441\u0440\u0435\u0434\u043e\u0442\u043e\u0447\u0438\u0442\u044c\u0441\u044f \u043d\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043b\u044e\u0431\u044f\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0438.<\/p>\n<p><strong>\ud83d\ude80 \u0413\u043e\u0442\u043e\u0432\u044b \u043f\u0440\u043e\u043a\u0430\u0447\u0430\u0442\u044c \u043f\u043e\u0438\u0441\u043a?<\/strong><br \/>\ud83d\udc49 <a href=\"https:\/\/manticoresearch.com\/install\/\" rel=\"noopener noreferrer nofollow\">\u0421\u043a\u0430\u0447\u0430\u0439\u0442\u0435 Manticore Search<\/a> \u0438 \u043f\u043e\u043f\u0440\u043e\u0431\u0443\u0439\u0442\u0435 \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438.<br \/>\ud83d\udcda <a href=\"https:\/\/manual.manticoresearch.com\/Searching\/KNN\" rel=\"noopener noreferrer nofollow\">\u041e\u0437\u043d\u0430\u043a\u043e\u043c\u044c\u0442\u0435\u0441\u044c \u0441 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0435\u0439 \u043f\u043e KNN.<\/a><br \/>\ud83d\udcac \u041f\u0440\u0438\u0441\u043e\u0435\u0434\u0438\u043d\u044f\u0439\u0442\u0435\u0441\u044c \u043a <a href=\"https:\/\/slack.manticoresearch.com\/\" rel=\"noopener noreferrer nofollow\">Slack-\u0441\u043e\u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0443<\/a> \u0438 \u0434\u0435\u043b\u0438\u0442\u0435\u0441\u044c \u043e\u043f\u044b\u0442\u043e\u043c.<\/p>\n<p>\u0412\u043e\u043f\u0440\u043e\u0441\u044b \u0438\u043b\u0438 \u043e\u0442\u0437\u044b\u0432\u044b? \u0414\u043e\u0431\u0440\u043e \u043f\u043e\u0436\u0430\u043b\u043e\u0432\u0430\u0442\u044c \u043d\u0430 <a href=\"https:\/\/forum.manticoresearch.com\/\" rel=\"noopener noreferrer nofollow\">\u0444\u043e\u0440\u0443\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430<\/a> \u0438\u043b\u0438 \u0432 <a href=\"https:\/\/twitter.com\/manticoresearch\" rel=\"noopener noreferrer nofollow\">Twitter.<\/a> \u0422\u0430\u043a\u0436\u0435 \u0432 \u0422\u0435\u043b\u0435\u0433\u0440\u0430\u043c \u0443 \u043d\u0430\u0441 \u0435\u0441\u0442\u044c \u0431\u043e\u043b\u044c\u0448\u043e\u0439 <a href=\"https:\/\/@manticore_chat\" rel=\"noopener noreferrer nofollow\">\u0440\u0443\u0441\u0441\u043a\u043e\u044f\u0437\u044b\u0447\u043d\u044b\u0439 \u0447\u0430\u0442<\/a>.<\/p>\n<\/div>\n<p>\u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438 <a href=\"https:\/\/habr.com\/ru\/articles\/947632\/\">https:\/\/habr.com\/ru\/articles\/947632\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041c\u044b \u0440\u0430\u0434\u044b \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u0442\u044c \u043d\u043e\u0432\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0434\u0435\u043b\u0430\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u0441 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u043c \u043f\u043e\u0438\u0441\u043a\u043e\u043c \u0442\u0430\u043a\u0438\u043c \u0436\u0435 \u043f\u0440\u043e\u0441\u0442\u044b\u043c, \u043a\u0430\u043a \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u0435 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u0430: \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438. \u0421 \u044d\u0442\u043e\u0439 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c\u044e Manticore Search \u0431\u0435\u0440\u0451\u0442 \u043d\u0430 \u0441\u0435\u0431\u044f \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u044e \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432 \u2014 \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u043b\u0438\u0448\u043d\u0438\u0445 \u043f\u0430\u0439\u043f\u043b\u0430\u0439\u043d\u043e\u0432, \u0432\u043d\u0435\u0448\u043d\u0438\u0445 \u0441\u0435\u0440\u0432\u0438\u0441\u043e\u0432 \u0438 \u0432\u043e\u0437\u043d\u0438.\u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u0440\u0430\u043d\u044c\u0448\u0435\u0414\u043e \u044d\u0442\u043e\u0433\u043e \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u043e\u0437\u043d\u0430\u0447\u0430\u043b \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u0438 \u0441:\u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u043c\u0438 ML-\u0441\u0435\u0440\u0432\u0438\u0441\u0430\u043c\u0438 \u0434\u043b\u044f \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432,\u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u043c\u043e\u0434\u0435\u043b\u044f\u043c\u0438,\u0441\u0438\u043d\u0445\u0440\u043e\u043d\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f, \u0441\u0435\u0440\u0432\u0438\u0441\u0430 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432 \u0438 \u043f\u043e\u0438\u0441\u043a\u043e\u0432\u043e\u0433\u043e \u0434\u0432\u0438\u0436\u043a\u0430,\u043d\u0435\u0441\u043e\u0432\u043f\u0430\u0434\u0435\u043d\u0438\u0435\u043c \u0440\u0430\u0437\u043c\u0435\u0440\u043d\u043e\u0441\u0442\u0435\u0439 \u0432\u0435\u043a\u0442\u043e\u0440\u043e\u0432 \u0438 \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u0441 \u043f\u0440\u0435\u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0438\u043d\u0433\u043e\u043c,\u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0435\u043d\u0438\u0435\u043c \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u043e\u0439 \u0433\u0435\u043d\u0435\u0440\u0430\u0446\u0438\u0438 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432 \u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437.\u0422\u0435\u043f\u0435\u0440\u044c \u0432\u0441\u0451 \u044d\u0442\u043e \u043e\u0441\u0442\u0430\u043b\u043e\u0441\u044c \u0432 \u043f\u0440\u043e\u0448\u043b\u043e\u043c.\u0427\u0442\u043e \u0442\u0430\u043a\u043e\u0435 \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438?\u0421 \u0430\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0430\u043c\u0438 \u0432\u044b \u043f\u0440\u043e\u0441\u0442\u043e \u0432\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442\u0435 \u0442\u0435\u043a\u0441\u0442, \u0430 Manticore \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438:\u2728 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0441\u043e\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u043c\u043e\u0434\u0435\u043b\u0435\u0439\u2728 \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u0442 \u0438\u0445 \u0432 \u0432\u0435\u043a\u0442\u043e\u0440\u043d\u044b\u0445 \u0438\u043d\u0434\u0435\u043a\u0441\u0430\u0445\u2728 \u0434\u0430\u0451\u0442 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0438\u0441\u043a\u0430\u0442\u044c \u043d\u0430 \u0435\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u043c \u044f\u0437\u044b\u043a\u0435\u2728 \u0441\u043a\u0440\u044b\u0432\u0430\u0435\u0442 \u0432\u0441\u044e \u0441\u043b\u043e\u0436\u043d\u043e\u0441\u0442\u044c, \u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0432\u0430\u043c \u0442\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0431\u043e\u0442\u0443 \u043d\u0430\u0434 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u043e\u043c\u041a\u0430\u043a \u044d\u0442\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442\u0421\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0441\u043e\u0437\u0434\u0430\u0451\u0442\u0441\u044f \u0432\u0441\u0435\u0433\u043e \u0432 3 \u0448\u0430\u0433\u0430:1. \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044bCREATE TABLE products (    title TEXT,    description TEXT,    category STRING,    price INT,    vector FLOAT_VECTOR KNN_TYPE=&#8217;hnsw&#8217; HNSW_SIMILARITY=&#8217;l2&#8242;        MODEL_NAME=&#8217;sentence-transformers\/all-MiniLM-L6-v2&#8242;        FROM=&#8217;title,description&#8217;);\u0412\u0441\u0451 \u0437\u0430\u0434\u0430\u0451\u0442\u0441\u044f \u043e\u0434\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u043e\u0439: Manticore \u0441\u0430\u043c \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0438\u0437 \u043f\u043e\u043b\u0435\u0439 title \u0438 description.2. \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445INSERT INTO products(id, title, description, category, price) VALUES  (1, &#8216;green hiking backpack&#8217;, &#8216;Lightweight backpack suitable for hiking trails&#8217;, &#8216;outdoors&#8217;, 5999),  (2, &#8216;laptop sleeve&#8217;, &#8216;Slim padded case for 15-inch laptops&#8217;, &#8216;electronics&#8217;, 1999),  &#8230;  (20, &#8216;wooden puzzle box&#8217;, &#8216;Challenging mechanical puzzle made of natural wood&#8217;, &#8216;toys&#8217;, 1899);\u0414\u0430\u043d\u043d\u044b\u0435 \u043e\u0445\u0432\u0430\u0442\u044b\u0432\u0430\u044e\u0442 \u0440\u0430\u0437\u043d\u044b\u0435 \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u0438: \u0442\u043e\u0432\u0430\u0440\u044b \u0434\u043b\u044f \u043e\u0442\u0434\u044b\u0445\u0430, \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u0438\u043a\u0443, \u043c\u0435\u0431\u0435\u043b\u044c, \u043a\u043d\u0438\u0433\u0438, \u0438\u0433\u0440\u0443\u0448\u043a\u0438 \u0438 \u0434\u0440\u0443\u0433\u043e\u0435.\u041e\u0431\u0440\u0430\u0442\u0438\u0442\u0435 \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435: \u043d\u0438\u043a\u0430\u043a\u0438\u0445 \u0432\u0435\u043a\u0442\u043e\u0440\u043e\u0432 \u0432\u0440\u0443\u0447\u043d\u0443\u044e \u2014 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438.(\u0446\u0435\u043d\u044b \u0443\u043a\u0430\u0437\u0430\u043d\u044b \u0432 \u0446\u0435\u043d\u0442\u0430\u0445: 5999 = $59.99)3. \u041f\u043e\u0438\u0441\u043a \u043d\u0430 \u0435\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u043c \u044f\u0437\u044b\u043a\u0435SELECT id, title, description, price, knn_dist()FROM products WHERE knn(vector, 5, &#8216;lightweight laptop backpack for trail hiking&#8217;)LIMIT 5;\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442:| id  | title                   | description                                      | price | knn_dist() || &#8212; | &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; | &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; | &#8212;&#8212; | &#8212;&#8212;&#8212;- ||  9  | outdoor laptop pack     | Trail-optimized backpack with laptop sleeve      |  7800 | 0.3539     ||  1  | green hiking backpack   | Lightweight backpack suitable for hiking trails  |  5999 | 0.5311     ||  5  | mountain hiking bag     | Durable trail-ready backpack for mountain hikes  |  8950 | 0.6203     ||  4  | black laptop backpack   | Spacious backpack with padded laptop compartment |  6900 | 0.6578     || 10  | compact hiking backpack | Light and foldable backpack for trail hikes      |  4200 | 0.6859     |\u0417\u0430\u043f\u0440\u043e\u0441 \u00ab\u043b\u0451\u0433\u043a\u0438\u0439 \u0440\u044e\u043a\u0437\u0430\u043a \u0434\u043b\u044f \u043d\u043e\u0443\u0442\u0431\u0443\u043a\u0430 \u0438 \u043f\u043e\u0445\u043e\u0434\u043e\u0432\u00bb \u0432\u0435\u0440\u043d\u0443\u043b \u0432 \u043f\u0435\u0440\u0432\u0443\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c \u00aboutdoor laptop pack\u00bb \u2014 \u043e\u043d \u0441\u043e\u0447\u0435\u0442\u0430\u0435\u0442 \u0438 \u043d\u043e\u0443\u0442\u0431\u0443\u043a, \u0438 \u043f\u043e\u0445\u043e\u0434\u044b. \u0414\u0430\u043b\u0435\u0435 \u0438\u0434\u0443\u0442 \u0442\u0443\u0440\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u0438 \u043d\u043e\u0443\u0442\u0431\u0443\u0447\u043d\u044b\u0435 \u0440\u044e\u043a\u0437\u0430\u043a\u0438.\u0412\u044b\u0431\u0438\u0440\u0430\u0435\u043c \u043f\u043e\u0434\u0445\u043e\u0434\u044f\u0449\u0443\u044e \u043c\u043e\u0434\u0435\u043b\u044c\u041c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0440\u0430\u0437\u043d\u044b\u0435 \u043c\u043e\u0434\u0435\u043b\u0438 \u0432 \u0437\u0430\u0432\u0438\u0441\u0438\u043c\u043e\u0441\u0442\u0438 \u043e\u0442 \u0437\u0430\u0434\u0430\u0447:\ud83c\udfe0 \u041b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u0435 (Hugging Face) \u2014 \u0431\u0435\u0437 \u043a\u043b\u044e\u0447\u0435\u0439 \u0438 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0439\ud83c\udf10 OpenAI \u2014 \u043b\u0443\u0447\u0448\u0438\u0435 \u043f\u043e \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0443 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u043a\u0438\ud83d\ude80 Voyage \u0438 Jina \u2014 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u043f\u043e\u0434 \u0440\u0430\u0437\u043d\u044b\u0435 \u044f\u0437\u044b\u043a\u0438 \u0438 \u0434\u043e\u043c\u0435\u043d\u044b \u043f\u0440\u0435\u0434\u043c\u0435\u0442\u043d\u043e\u0439 \u043e\u0431\u043b\u0430\u0441\u0442\u0438\u0413\u0438\u0431\u0440\u0438\u0434\u043d\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u0438 \u0444\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u044f (\u043f\u0440\u0438\u043c\u0435\u0440 SQL)\u041a\u043e\u043c\u0431\u0438\u043d\u0438\u0440\u0443\u0439\u0442\u0435 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u043a\u0443, \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u0441\u043b\u043e\u0432\u0430 \u0438 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u043d\u044b\u0435 \u0444\u0438\u043b\u044c\u0442\u0440\u044b \u0432 \u043e\u0434\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435:SELECT id, price, highlight()FROM productsWHERE knn(vector, 7, &#8216;lightweight laptop backpack for trail hiking&#8217;)  AND category = &#8216;outdoors&#8217;  AND MATCH(&#8216;&#187;lightweight laptop backpack for trail hiking&#187;\/0.5&#8217;);\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b:+&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+| id   | price | highlight()                                                                                   |+&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+|    9 |  7800 | outdoor &lt;b&gt;laptop&lt;\/b&gt; pack | &lt;b&gt;Trail&lt;\/b&gt;-optimized &lt;b&gt;backpack&lt;\/b&gt; with &lt;b&gt;laptop&lt;\/b&gt; sleeve ||    1 |  5999 | green &lt;b&gt;hiking backpack&lt;\/b&gt; | &lt;b&gt;Lightweight backpack&lt;\/b&gt; suitable &lt;b&gt;for hiking&lt;\/b&gt; trails  ||    5 |  8950 | mountain &lt;b&gt;hiking&lt;\/b&gt; bag | Durable &lt;b&gt;trail&lt;\/b&gt;-ready &lt;b&gt;backpack for&lt;\/b&gt; mountain hikes    ||   10 |  4200 | compact &lt;b&gt;hiking backpack&lt;\/b&gt; | Light and foldable &lt;b&gt;backpack for trail&lt;\/b&gt; hikes           |+&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;+\u041f\u0440\u0438\u043c\u0435\u0447\u0430\u043d\u0438\u0435: \u0444\u0443\u043d\u043a\u0446\u0438\u044f highlight() \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0440\u0430\u0437\u043c\u0435\u0442\u043a\u0443 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, &lt;b&gt;&#8230;&lt;\/b&gt;).\u042d\u0442\u0430 \u043c\u043e\u0449\u043d\u0430\u044f \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u044f \u043e\u0434\u043d\u043e\u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e:\u0444\u0438\u043b\u044c\u0442\u0440\u0443\u0435\u0442 \u043f\u043e \u043a\u0430\u0442\u0435\u0433\u043e\u0440\u0438\u0438 (outdoors),\u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0435\u0442 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0443\u044e \u0440\u0435\u043b\u0435\u0432\u0430\u043d\u0442\u043d\u043e\u0441\u0442\u044c \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u043e\u0432,\u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0441\u043e\u0432\u043f\u0430\u0434\u0435\u043d\u0438\u0439 \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0442\u0435\u043a\u0441\u0442\u0430 \u0447\u0435\u0440\u0435\u0437 \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u0441\u043b\u043e\u0432\u0430,\u0438 \u043f\u043e\u0434\u0441\u0432\u0435\u0447\u0438\u0432\u0430\u0435\u0442 \u043d\u0430\u0439\u0434\u0435\u043d\u043d\u044b\u0435 \u0442\u0435\u0440\u043c\u0438\u043d\u044b.\u0412\u0441\u0451 \u044d\u0442\u043e \u2014 \u0432 \u043e\u0434\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435!\u041f\u043e\u043b\u043d\u0430\u044f \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 HTTP\/JSON API\u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0431\u0435\u0437 \u043f\u0440\u043e\u0431\u043b\u0435\u043c \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0442 \u0441 HTTP\/JSON API \u0432 Manticore, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044f \u0442\u043e\u0442 \u0436\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b, \u0447\u0442\u043e \u0438 SQL, \u043d\u043e \u0447\u0435\u0440\u0435\u0437 REST-\u044d\u043d\u0434\u043f\u043e\u0438\u043d\u0442\u044b.\u0412\u0441\u0442\u0430\u0432\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0447\u0435\u0440\u0435\u0437 JSON (\u043f\u0440\u0438\u043c\u0435\u0440 HTTP\/JSON API)\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 \u044d\u043d\u0434\u043f\u043e\u0438\u043d\u0442 \/insert \u2014 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0438 \u0431\u0443\u0434\u0443\u0442 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438:curl &#171;http:\/\/localhost:9308\/insert&#187; -H &#171;Content-Type: application\/json&#187; \\  -d &#8216;{    &#171;table&#187;: &#171;products&#187;,     &#171;id&#187;: 21,     &#171;doc&#187;: {      &#171;title&#187;: &#171;wireless headphones&#187;,       &#171;description&#187;: &#171;Bluetooth headphones with noise cancellation&#187;,       &#171;category&#187;: &#171;electronics&#187;,       &#171;price&#187;: 15900    }  }&#8217;\u041e\u0442\u0432\u0435\u0442:{  &#171;table&#187;: &#171;products&#187;,  &#171;id&#187;: 21,  &#171;created&#187;: true,  &#171;result&#187;: &#171;created&#187;,  &#171;status&#187;: 201}\u041c\u0430\u0441\u0441\u043e\u0432\u0430\u044f \u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0441 \u0410\u0432\u0442\u043e\u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0430\u043c\u0438 (\u043f\u0440\u0438\u043c\u0435\u0440 HTTP\/JSON API)\u0412\u0441\u0442\u0430\u0432\u043b\u044f\u0439\u0442\u0435 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u043e\u0432 \u0441\u0440\u0430\u0437\u0443 \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u044d\u043d\u0434\u043f\u043e\u0438\u043d\u0442\u0430 \/bulk:curl &#171;http:\/\/localhost:9308\/bulk&#187; -H &#171;Content-Type: application\/x-ndjson&#187; \\  &#8212;data-raw $'{&#171;insert&#187;: {&#171;table&#187;: &#171;products&#187;, &#171;id&#187;: 22, &#171;doc&#187;: {&#171;title&#187;: &#171;gaming laptop&#187;, &#171;description&#187;: &#171;High-performance laptop for gaming and work&#187;, &#171;category&#187;: &#171;electronics&#187;, &#171;price&#187;: 159900}}}{&#171;insert&#187;: {&#171;table&#187;: &#171;products&#187;, &#171;id&#187;: 23, &#171;doc&#187;: {&#171;title&#187;: &#171;smartphone&#187;, &#171;description&#187;: &#171;Latest flagship smartphone with 5G&#187;, &#171;category&#187;: &#171;electronics&#187;, &#171;price&#187;: 89900}}}{&#171;insert&#187;: {&#171;table&#187;: &#171;products&#187;, &#171;id&#187;: 24, &#171;doc&#187;: {&#171;title&#187;: &#171;tablet computer&#187;, &#171;description&#187;: &#171;Lightweight tablet for work and entertainment&#187;, &#171;category&#187;: &#171;electronics&#187;, &#171;price&#187;: 49900}}}&#8217;\u041e\u0442\u0432\u0435\u0442:{  &#171;items&#187;: [    {      &#171;bulk&#187;: {        &#171;table&#187;: &#171;products&#187;,        &#171;_id&#187;: 24,        &#171;created&#187;: 3,        &#171;deleted&#187;: 0,        &#171;updated&#187;: 0,        &#171;result&#187;: &#171;created&#187;,        &#171;status&#187;: 201      }    }  ],  &#171;current_line&#187;: 3,  &#171;skipped_lines&#187;: 0,  &#171;errors&#187;: false,  &#171;error&#187;: &#171;&#187;}\u041c\u0430\u0441\u0441\u043e\u0432\u0430\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f \u0443\u0441\u043f\u0435\u0448\u043d\u043e \u0432\u0441\u0442\u0430\u0432\u0438\u043b\u0430 3 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430 \u0441 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u043c\u0438 \u044d\u043c\u0431\u0435\u0434\u0434\u0438\u043d\u0433\u0430\u043c\u0438.\u0421\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u0447\u0435\u0440\u0435\u0437 JSON (\u043f\u0440\u0438\u043c\u0435\u0440 HTTP\/JSON API)\u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0439\u0442\u0435 \u043f\u043e\u0438\u0441\u043a \u0441 \u0435\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e-\u044f\u0437\u044b\u043a\u043e\u0432\u044b\u043c\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u0430\u043c\u0438, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u044d\u043d\u0434\u043f\u043e\u0438\u043d\u0442 \/search:curl &#171;http:\/\/localhost:9308\/search&#187; -H &#171;Content-Type: application\/json&#187; \\  -d &#8216;{    &#171;table&#187;: &#171;products&#187;,    &#171;_source&#187;: [&#171;title&#187;],    &#171;size&#187;: 5,    &#171;knn&#187;: {      &#171;field&#187;: &#171;vector&#187;,      &#171;query&#187;: &#171;outdoor hiking adventure&#187;,      &#171;k&#187;: 3    }  }&#8217;\u041e\u0442\u0432\u0435\u0442:`json{  &#171;took&#187;: 8,  &#171;timed_out&#187;: false,  &#171;hits&#187;: {    &#171;total&#187;: 24,    &#171;total_relation&#187;: &#171;eq&#187;,    &#171;hits&#187;: [      {        &#171;_id&#187;: 18,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 0.75467718,        &#171;_source&#187;: {          &#171;title&#187;: &#171;children&#8217;s adventure book&#187;        }      },      {        &#171;_id&#187;: 1,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 0.83226496,        &#171;_source&#187;: {          &#171;title&#187;: &#171;green hiking backpack&#187;        }      },      {        &#171;_id&#187;: 5,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 0.89348459,        &#171;_source&#187;: {          &#171;title&#187;: &#171;mountain hiking bag&#187;        }      },      {        &#171;_id&#187;: 10,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 0.92611158,        &#171;_source&#187;: {          &#171;title&#187;: &#171;compact hiking backpack&#187;        }      },      {        &#171;_id&#187;: 3,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 0.98721427,        &#171;_source&#187;: {          &#171;title&#187;: &#171;travel daypack&#187;        }      }    ]  }}\u0417\u0430\u043f\u0440\u043e\u0441 \u00aboutdoor hiking adventure\u00bb \u0432\u0435\u0440\u043d\u0443\u043b \u043f\u0435\u0440\u0432\u044b\u043c children\u2019s adventure book (\u0440\u0430\u0441\u0441\u0442\u043e\u044f\u043d\u0438\u0435 0.755), \u0430 \u0437\u0430\u0442\u0435\u043c \u2014 \u0440\u044e\u043a\u0437\u0430\u043a\u0438 \u0434\u043b\u044f \u043f\u043e\u0445\u043e\u0434\u043e\u0432. \u042d\u0442\u043e \u043f\u043e\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442, \u0447\u0442\u043e \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u043d\u0430\u0445\u043e\u0434\u0438\u0442 \u043a\u043e\u043d\u0446\u0435\u043f\u0442\u0443\u0430\u043b\u044c\u043d\u043e \u0431\u043b\u0438\u0437\u043a\u0438\u0435 \u0432\u0435\u0449\u0438, \u0430 \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0447\u043d\u044b\u0435 \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u0441\u043b\u043e\u0432\u0430.\u0424\u0438\u043b\u044c\u0442\u0440\u0430\u0446\u0438\u044f \u0438 \u0433\u0438\u0431\u0440\u0438\u0434\u043d\u044b\u0439 \u043f\u043e\u0438\u0441\u043a \u0447\u0435\u0440\u0435\u0437 JSON (\u043f\u0440\u0438\u043c\u0435\u0440 HTTP\/JSON API)\u041a\u043e\u043c\u0431\u0438\u043d\u0438\u0440\u0443\u0439\u0442\u0435 \u0441\u0435\u043c\u0430\u043d\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u043f\u043e\u0438\u0441\u043a \u0441 \u0442\u0440\u0430\u0434\u0438\u0446\u0438\u043e\u043d\u043d\u044b\u043c\u0438 \u0444\u0438\u043b\u044c\u0442\u0440\u0430\u043c\u0438:curl &#171;http:\/\/localhost:9308\/search&#187; -H &#171;Content-Type: application\/json&#187; \\  -d &#8216;{    &#171;table&#187;: &#171;products&#187;,    &#171;_source&#187;: [&#171;title&#187;, &#171;price&#187;],    &#171;size&#187;: 5,    &#171;knn&#187;: {      &#171;field&#187;: &#171;vector&#187;,       &#171;query&#187;: &#171;technology electronic device&#187;,      &#171;k&#187;: 5,      &#171;filter&#187;: {        &#171;range&#187;: {&#171;price&#187;: {&#171;gte&#187;: 15000}}      }    }  }&#8217;\u041e\u0442\u0432\u0435\u0442:{  &#171;took&#187;: 10,  &#171;timed_out&#187;: false,  &#171;hits&#187;: {    &#171;total&#187;: 5,    &#171;total_relation&#187;: &#171;eq&#187;,    &#171;hits&#187;: [      {        &#171;_id&#187;: 24,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 1.31113040,        &#171;_source&#187;: {          &#171;title&#187;: &#171;tablet computer&#187;,          &#171;price&#187;: 49900        }      },      {        &#171;_id&#187;: 23,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 1.56920886,        &#171;_source&#187;: {          &#171;title&#187;: &#171;smartphone&#187;,          &#171;price&#187;: 89900        }      },      {        &#171;_id&#187;: 22,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 1.59042466,        &#171;_source&#187;: {          &#171;title&#187;: &#171;gaming laptop&#187;,          &#171;price&#187;: 159900        }      },      {        &#171;_id&#187;: 16,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 1.84979212,        &#171;_source&#187;: {          &#171;title&#187;: &#171;office chair&#187;,          &#171;price&#187;: 27900        }      },      {        &#171;_id&#187;: 21,        &#171;_score&#187;: 1,        &#171;_knn_dist&#187;: 1.88567829,        &#171;_source&#187;: {          &#171;title&#187;: &#171;wireless headphones&#187;,          &#171;price&#187;: 15900        }      }    ]  }}\u0417\u0430\u043f\u0440\u043e\u0441 \u00abtechnology electronic device\u00bb \u0441 \u0444\u0438\u043b\u044c\u0442\u0440\u043e\u043c \u043f\u043e \u0446\u0435\u043d\u0435 (\u2265 $150) \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e \u043f\u0440\u0438\u043e\u0440\u0438\u0442\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043b \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u0438\u043a\u0443 \u0438 \u0438\u0441\u043a\u043b\u044e\u0447\u0438\u043b \u0434\u0435\u0448\u0451\u0432\u044b\u0435 \u0442\u043e\u0432\u0430\u0440\u044b \u0432\u0440\u043e\u0434\u0435 \u043f\u043e\u0445\u043e\u0434\u043d\u044b\u0445 \u0440\u044e\u043a\u0437\u0430\u043a\u043e\u0432 \u0438\u043b\u0438 \u043c\u0435\u043b\u043a\u043e\u0439 \u0442\u0435\u0445\u043d\u0438\u043a\u0438. \u00abTablet computer\u00bb \u043e\u043a\u0430\u0437\u0430\u043b\u0441\u044f \u0432\u044b\u0448\u0435 \u0432\u0441\u0435\u0433\u043e \u0438\u0437-\u0437\u0430&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-475350","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/475350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=475350"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/475350\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=475350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=475350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=475350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}