{"id":32210,"date":"2019-10-31T21:45:40","date_gmt":"2019-10-31T18:45:40","guid":{"rendered":"https:\/\/prohoster.info\/blog\/reliz-subd-sqlite-3-28\/"},"modified":"2019-10-31T21:45:40","modified_gmt":"2019-10-31T18:45:40","slug":"reliz-subd-sqlite-3-28","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/reliz-subd-sqlite-3-28","title":{"rendered":"SQLite 3.28 Datub\u0101zes izlai\u0161ana","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.mail-archive.com\/sqlite-announce@sqlite.org\/msg00078.html\">Prezent\u0113ts<\/a><\/noindex> izlaidums <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.28.0<\/a><\/noindex>, viegli lietojama datub\u0101ze, kas ir pieejama k\u0101 pievienojama bibliot\u0113ka. SQLite kods tiek izplat\u012bts k\u0101 publiskais \u012bpa\u0161ums (public domain), t.i., to var izmantot bez ierobe\u017eojumiem un bez maksas jebkuriem m\u0113r\u0137iem. SQLite izstr\u0101d\u0101t\u0101jus atbalsta speci\u0101li izveidota konsorcijs, kur\u0101 ietilpst t\u0101das komp\u0101nijas k\u0101 Adobe, Oracle, Mozilla, Bentley un Bloomberg. <\/p>\n<p>\u012bpa\u0161\u012bbas <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_28_0.html\">izmai\u0146as<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html\">Papla\u0161in\u0101ti<\/a><\/noindex>  logu funkcijas (window funkcijas vai anal\u012btisk\u0101s funkcijas, kas \u013cauj veikt apr\u0113\u0137inus katrai vaic\u0101juma rindai, izmantojot citas rindas): pievienota atbalsta izteiksme <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wexcls\">EXCLUDE<\/a><\/noindex>, par\u0101d\u012bj\u0101s iesp\u0113ja izmantot <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wchaining\">\u0137\u0113des<\/a><\/noindex> logu funkcijas (viens logs ir defin\u0113ts cit\u0101), nodro\u0161ina <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#grouptype\">atbalsts<\/a><\/noindex> grup\u0113\u0161anu, izmantojot GROUP izteiksmi, un \u012bstenoti RANGE ierobe\u017eojumi  <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">PRECEDING<\/a><\/noindex> un <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">FOLLOWING<\/a><\/noindex>;\n<li class=\"l\"> \u0423\u0441\u043e\u0432\u0435\u0440\u0448\u0435\u043d\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0430 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u044b &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_vacuum.html#vacuuminto\">VACUUM INTO<\/a><\/noindex>&#171;, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0442\u0435\u043f\u0435\u0440\u044c \u043c\u043e\u0436\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0441 \u0411\u0414, \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u043c\u0438 \u0432 \u0440\u0435\u0436\u0438\u043c\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f;\n<li class=\"l\"> Pievienotas jaunas vaic\u0101jumu optimiz\u0101cijas: <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/optoverview.html#like_opt\">Pa\u0101trin\u0101ta<\/a><\/noindex> \u0440\u0430\u0431\u043e\u0442\u0430 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0439 LIKE \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u043c \u0441\u043b\u043e\u0432\u043e\u043c ESCAPE \u0438 \u043f\u0440\u0438 \u0432\u043a\u043b\u044e\u0447\u0435\u043d\u043d\u043e\u043c \u0440\u0435\u0436\u0438\u043c\u0435 &#171;PRAGMA case_sensitive_like&#187;. \u041f\u0440\u0438 \u043d\u0430\u043b\u0438\u0447\u0438\u0438 <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/partialindex.html\">da\u013c\u0113js indekss<\/a><\/noindex> izsl\u0113gtas liekas p\u0101rbaudes par patiesi nosac\u012bjumiem, kas noteikti WHERE izteiksm\u0113;\n<li class=\"l\"> \u0412 CLI-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043a\u043e\u043c\u0430\u043d\u0434\u0430 &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/cli.html#param\">.parameter<\/a><\/noindex>&#187; \u0434\u043b\u044f \u0437\u0430\u0434\u0430\u043d\u0438\u044f <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_expr.html#varparam\">pievienojamos aizst\u0101j\u0113jus<\/a><\/noindex> (\u043c\u0430\u0441\u043a\u0438, \u043f\u043e\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c\u044b\u0435 \u0432 \u043b\u044e\u0431\u044b\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f SQL). \u0412 \u043a\u043e\u043c\u0430\u043d\u0434\u0435 &#171;.archive&#187; \u043f\u0435\u0440\u0435\u0440\u0430\u0431\u043e\u0442\u0430\u043d\u0430 \u043e\u043f\u0446\u0438\u044f &#171;&#8212;update&#187;, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0442\u0435\u043f\u0435\u0440\u044c \u043f\u0440\u043e\u043f\u0443\u0441\u043a\u0430\u0435\u0442 \u043d\u0435 \u0438\u0437\u043c\u0435\u043d\u0438\u0432\u0448\u0438\u0435\u0441\u044f \u0444\u0430\u0439\u043b\u044b, \u0443\u0436\u0435 \u043d\u0430\u0445\u043e\u0434\u044f\u0449\u0438\u0435\u0441\u044f \u0432 \u0430\u0440\u0445\u0438\u0432\u0435, \u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043e\u043f\u0446\u0438\u044f &#171;&#8212;insert&#187; \u0434\u043b\u044f \u0432\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u0444\u0430\u0439\u043b\u043e\u0432 \u0432 \u0430\u0440\u0445\u0438\u0432;\n<li class=\"l\"> Pievienots papla\u0161in\u0101jums <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/file\/ext\/misc\/fossildelta.c\">fossildelta.c<\/a><\/noindex>, kas \u013cauj izveidot, piem\u0113rot un analiz\u0113t <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/fossil\/doc\/trunk\/www\/delta_format.wiki\">delta izmai\u0146u form\u0101tu Fossil, kas tiek izmantots RBU papla\u0161in\u0101jum\u0101;<\/a><\/noindex> Uzlabota darba uzticam\u012bba ar boj\u0101tiem datub\u0101zes failiem;\n<li class=\"l\"> Izveidots projekta repozitorija spogulis uz\n<li class=\"l\"> (pamats <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlite\/sqlite\">GitHub<\/a><\/noindex> atbalst\u012bts, izmantojot versiju p\u0101rvald\u012bbas sist\u0113mu <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\">repozitorijs<\/a><\/noindex> Fossil <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/\">, kuru izstr\u0101d\u0101jis SQLite autors).<\/a><\/noindex>10 veidi, k\u0101 ietaup\u012bt uz IT infrastrukt\u016bru visiem\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Avots: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=50558\">opennet.lv<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.28.0, \u043b\u0435\u0433\u043a\u043e\u0432\u0435\u0441\u043d\u043e\u0439 \u0421\u0423\u0411\u0414, \u043e\u0444\u043e\u0440\u043c\u043b\u0435\u043d\u043d\u043e\u0439 \u0432 \u0432\u0438\u0434\u0435 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u043e\u0439 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438. \u041a\u043e\u0434 SQLite \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043a\u0430\u043a \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0435 \u0434\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 (public domain), \u0442.\u0435. \u043c\u043e\u0436\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0431\u0435\u0437 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0439 \u0438 \u0431\u0435\u0437\u0432\u043e\u0437\u043c\u0435\u0437\u0434\u043d\u043e \u0432 \u043b\u044e\u0431\u044b\u0445 \u0446\u0435\u043b\u044f\u0445. \u0424\u0438\u043d\u0430\u043d\u0441\u043e\u0432\u0443\u044e \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0443 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u043e\u0432 SQLite \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u044f\u0435\u0442 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u044b\u0439 \u043a\u043e\u043d\u0441\u043e\u0440\u0446\u0438\u0443\u043c, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u0445\u043e\u0434\u044f\u0442 \u0442\u0430\u043a\u0438\u0435 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438, \u043a\u0430\u043a Adobe, Oracle, Mozilla, Bentley \u0438 Bloomberg. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0420\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u044b \u043e\u043a\u043e\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 (window-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-32210","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/lv\/blog\/news\/reliz-subd-sqlite-3-28\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 SQLite 3.28 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/news\/reliz-subd-sqlite-3-28\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T18:45:40+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:45:40+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47 SQLite datub\u0101zes izlai\u0161ana 3.28 | ProHoster","description":"Prezent\u0113ta SQLite izlai\u0161ana.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/reliz-subd-sqlite-3-28","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 SQLite 3.28 | ProHoster","og:description":"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.","og:url":"https:\/\/prohoster.info\/lv\/blog\/news\/reliz-subd-sqlite-3-28","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T18:45:40+00:00","article:modified_time":"2019-10-31T18:45:40+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"32210","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-21 09:48:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 03:02:47","updated":"2026-01-21 09:48:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/32210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=32210"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/32210\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=32210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=32210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=32210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}