{"id":147391,"date":"2025-11-05T17:11:54","date_gmt":"2025-11-05T15:11:54","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-51"},"modified":"2025-11-05T17:11:54","modified_gmt":"2025-11-05T15:11:54","slug":"vypusk-subd-sqlite-3-51","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-sqlite-3-51","title":{"rendered":"SQLite 3.51 datu b\u0101zes izlai\u0161ana","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Public\u0113ts SQLite 3.51 laidienu, viegla datu b\u0101ze, kas pieejama k\u0101 saist\u0101ma bibliot\u0113ka. SQLite kods tiek izplat\u012bts k\u0101 publiska \u012bpa\u0161uma (public domain) saturs, t.i., to var izmantot bez ierobe\u017eojumiem un bez maksas jebk\u0101diem m\u0113r\u0137iem. Finansi\u0101lo atbalstu SQLite izstr\u0101d\u0101t\u0101jiem sniedz \u012bpa\u0161i izveidots konsorcijs.     <\/p>\n<p>Galven\u0101s izmai\u0146as:  <\/p>\n<ul>\n<li class=\"l\"> Pievienotas jaunas JSON funkcijas jsonb_each() un jsonb_tree(), kas at\u0161\u0137iras no iepriek\u0161\u0113j\u0101m pieejamaj\u0101m funkcij\u0101m json_each() un json_tree() ar to, ka t\u0101s atgrie\u017e JSONB v\u0113rt\u012bbas, ja datu tips ir mas\u012bvs vai objekts.\n<li class=\"l\"> Carray un percentile papla\u0161in\u0101\u0161anas kods ir p\u0101rvietots uz pam datni &#171;sqlite3.c&#187; ar ieb\u016bv\u0113tu SQLite kodu. P\u0113c noklus\u0113juma \u0161ie papla\u0161in\u0101jumi ir izsl\u0113gti un pieprasa r\u0101d\u012bt b\u016bvniec\u012bbas parametrus &#171;-DSQLITE_ENABLE_CARRAY&#187; un &#171;-DSQLITE_ENABLE_PERCENTILE&#187;.\n<li class=\"l\"> Uzlabota saskarne SQLite izmanto\u0161anai Tcl skriptos. Komandai &#171;eval&#187; pievienota karogs &#171;-asdict&#187;, lai izvad\u012btu virknes, izmantojot &#171;dict&#187; tipa viet\u0101 &#171;array&#187;. Pievienota iesp\u0113ja p\u0101rtraukt lietot\u0101ja funkcijas, lai atgrieztu NULL v\u0113rt\u012bbu.\n<li class=\"l\"> Izmai\u0146as komandl\u012bnijas saskarn\u0113:\n<ul>\n<li class=\"l\"> Komandas &#171;.timer&#187; precizit\u0101te palielin\u0101ta l\u012bdz mikrosekund\u0113m;\n<li class=\"l\"> Format\u0113\u0161anas re\u017e\u012bmos &#171;box&#187; un &#171;column&#187; ieviesta dubult\u0101 platuma simbolu atbalsts;\n<li class=\"l\"> Komanda &#171;.imposter&#187; tagad var sniegt tikai las\u0101mu imposter-tabulu (\u013cauj piek\u013c\u016bt datiem indekss k\u0101 tabulai), kas darbojas ar VACUUM oper\u0101ciju un neprasa izpild\u012b\u0161anu ar karogu &#171;&#8212;unsafe-testing&#187;;\n<li class=\"l\"> Sqlite utilit\u0101tei un komandai &#171;.open&#187; pievienota iesp\u0113ja &#171;&#8212;ifexists&#187;.\n<li class=\"l\"> Maksim\u0101lais rindi\u0146as platums, kas iestat\u012bts ar komandu &#171;.width&#187;, ir ierobe\u017eots l\u012bdz 30000 simboliem.   <\/ul>\n<li class=\"l\"> Veiktas veiktsp\u0113jas optimiz\u0101cijas:\n<ul>\n<li class=\"l\"> Samazin\u0101ta slodze uz CPU transaction fiks\u0101cijas laik\u0101, kad piek\u013cuve ierobe\u017eota uz las\u012b\u0161anu;\n<li class=\"l\"> Uzlabota apvieno\u0161anas (JOIN) oper\u0101ciju noteik\u0161ana, kas neatgrie\u017e rindas pamatojoties uz to, ka viena vai vair\u0101kas tabulas nesatur rindas;\n<li class=\"l\"> Izsl\u0113gta skal\u0101r\u0101s apak\u0161vaic\u0101juma izpilde, kas neietekm\u0113 rezult\u0101tu;\n<li class=\"l\"> Logu funkciju darb\u012bba ir pa\u0101trin\u0101ta vaic\u0101jumos ar izteiksmi &#171;BETWEEN \ud83d\ude21 FOLLOWING AND :y FOLLOWING&#187; un \u013coti lielu v\u0113rt\u012bbu &#171;:y&#187;.   <\/ul>\n<li class=\"l\"> Pievienota pragmas &#171;PRAGMA wal_checkpoint=NOOP&#187; un funkcija API sqlite3_wal_checkpoint() izmai\u0146u fiks\u0113\u0161anai WAL \u017eurn\u0101l\u0101.\n<li class=\"l\"> API pievienotas funkcijas sqlite3_set_errmsg() un sqlite3_db_status64().\n<li class=\"l\"> JavaScript\/WASM SQLite versij\u0101 atbalst\u012bta s\u0113juma veido\u0161ana WebAssembly ar 64 bitu adres\u0113m.\n<li class=\"l\"> Palielin\u0101ta datu b\u0101zu iztur\u012bba pret boj\u0101jumiem lietojumprogramm\u0101s, kas no\u0146em POSIX blo\u0137\u0113jumus, izmantojot close() izsaukumu.\n<li class=\"l\"> Uzlabota VxWorks platformas atbalsts.      <\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=64186\">opennet.lv<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.51, \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. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u044b \u043d\u043e\u0432\u044b\u0435 JSON-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 jsonb_each() \u0438 jsonb_tree(), \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0442\u0441\u044f \u043e\u0442 \u0440\u0430\u043d\u0435\u0435 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 json_each() \u0438 json_tree() \u0442\u0435\u043c, [&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-147391","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=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.51, \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.\" \/>\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\/vypusk-subd-sqlite-3-51\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 SQLite 3.51 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.51, \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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-sqlite-3-51\" \/>\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=\"2025-11-05T15:11:54+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-11-05T15:11:54+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\udd47SQLite 3.51 datu b\u0101zes p\u0101rvald\u012bbas sist\u0113mas izlai\u0161ana | ProHoster","description":"Public\u0113ts SQLite 3.51 izlai\u0161anas, viegl\u0101s datu b\u0101zu p\u0101rvald\u012bbas sist\u0113mas, kas pieejama k\u0101 pievienojam\u0101 bibliot\u0113ka. SQLite kods tiek izplat\u012bts k\u0101 publiska \u012bpa\u0161uma (public domain), t.i.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-sqlite-3-51","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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 SQLite 3.51 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.51, \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.","og:url":"https:\/\/prohoster.info\/lv\/blog\/news\/vypusk-subd-sqlite-3-51","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":"2025-11-05T15:11:54+00:00","article:modified_time":"2025-11-05T15:11:54+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"147391","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":"default","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-23 15:46:20","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 15:46:20","updated":"2026-01-23 15:46:20","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\/147391","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=147391"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/147391\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=147391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=147391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=147391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}