{"id":183732,"date":"2026-10-11T16:54:25","date_gmt":"2026-10-11T14:54:25","guid":{"rendered":"https:\/\/prohoster.info\/blog\/news\/dostupna-subd-sqlite-3-54-s-optimizacziyami-rasshireniem-cli-i-prekrashheniem-podderzhki-windows-xp"},"modified":"2026-10-11T16:54:30","modified_gmt":"2026-10-11T14:54:30","slug":"sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support","status":"publish","type":"post","link":"https:\/\/prohoster.info\/lv\/blog\/news\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support","title":{"rendered":"Pieejama SQLite 3.54 datu b\u0101ze ar optimiz\u0101cij\u0101m, CLI papla\u0161in\u0101jumu un Windows XP atbalsta p\u0101rtrauk\u0161anu","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Publik\u0113ta SQLite 3.54 versija, viegl\u0101k\u0101 DBMS, kas veidota k\u0101 pievienojam\u0101 bibliot\u0113ka. SQLite kods tiek izplat\u012bts k\u0101 sabiedriskais \u012bpa\u0161ums (public domain), t.i., to var izmantot bez ierobe\u017eojumiem un bezatl\u012bdz\u012bbas jebk\u0101diem m\u0113r\u0137iem. SQLite izstr\u0101d\u0101t\u0101ju finan\u0161u atbalstu nodro\u0161ina speci\u0101li izveidots konsorcijs. <\/p>\n<p>Galven\u0101s izmai\u0146as:<\/p>\n<ul>\n<li class=\"l\"> Ir veiktas optimiz\u0101cijas, kas \u013c\u0101vu\u0161as pa\u0101trin\u0101t speedtest1 testa izpildi par aptuveni 4% sal\u012bdzin\u0101jum\u0101 ar iepriek\u0161\u0113jo versiju un par 7.5% sal\u012bdzin\u0101jum\u0101 ar 3.51 versiju pirms gada. Rezult\u0101ti var main\u012bties atkar\u012bb\u0101 no slodzes veida, kompil\u0101cijas opcij\u0101m, CPU, kompilatora un oper\u0113t\u0101jsist\u0113mas.\n<li class=\"l\"> SQLite r\u012bc\u012bb\u0101 ir ieviesta iesp\u0113ja izmantot escape sec\u012bbas, lai par\u0101d\u012btu papildu inform\u0101ciju par st\u0101vokli komandrindas iel\u016bgum\u0101, piem\u0113ram, \"\/x\" par atv\u0113rtu transakciju, \"\/r\" las\u0101m\u0101 datub\u0101z\u0113, \"\/m\" \u016bdens\u017e\u0101\u013cu datub\u0101z\u0113, kas tiek glab\u0101ta tikai atmi\u0146\u0101, \"\/f\" faila nosaukuma pievieno\u0161anai ar datub\u0101zi, \"\/v\" SQLite versijas par\u0101d\u012b\u0161anai, \"\/:\" un \"\/;\" nosac\u012bjumu izteikumu veido\u0161anai, \"\/u\" un \"\/h\" lietot\u0101ja un saimniekdatora nosaukuma pievieno\u0161anai. Komandrindas aicin\u0101juma \u0161ablona iestat\u012b\u0161ana notiek caur vides main\u012bgajiem SQLITE_PS1 un SQLITE_PS2.\n<li class=\"l\"> SQLite r\u012bc\u012bb\u0101 komandas \".mode\" pievienotas opcijas \"--ifmt\", \"--rowcount on\" un \"--titles always\" skaitlisko form\u0101tu iestat\u012b\u0161anai un rindu skait\u012bt\u0101ja un virsraksta r\u0101d\u012b\u0161anai. Izmain\u012bts komandas \".diskused\" izpildes meh\u0101nisms. Noklus\u0113juma gad\u012bjum\u0101 saglab\u0101ts virsraksts ar kolonnu nosaukumiem, ja vaic\u0101jums neatgrieza rindas, k\u0101 ar\u012b atsl\u0113gta nulles bajtu t\u012br\u012b\u0161ana, kad blob izmesti Unix sist\u0113m\u0101s.\n<li class=\"l\"> Vaic\u0101jumu pl\u0101not\u0101j\u0101 pa\u0101trin\u0101ta UPDATE oper\u0101ciju izpilde gad\u012bjumos, kad ir izteiksmes indeksi, bet indekss\u0113jam\u0101 v\u0113rt\u012bba nemain\u0101s. Optimiz\u0113ta oper\u0101ciju \"expr OR TRUE\" un \"expr OR FALSE\" izpilde. Nodro\u0161in\u0101ta DISTINCT izteiksmes ignor\u0113\u0161ana SELECT apak\u0161vaic\u0101jumos, kas nor\u0101d\u012bti labaj\u0101 pus\u0113 no oper\u0101tora \"IN\". Pa\u0101trin\u0101ta apstr\u0101de un samazin\u0101ta atmi\u0146as pat\u0113ri\u0146\u0161, nor\u0101dot UNION vaic\u0101jumos izteiksmi \"LIMIT 1\".\n<li class=\"l\"> ALTER TABLE komand\u0101 nodro\u0161in\u0101ts k\u013c\u016bdas zi\u0146ojums par jebkur\u0101m m\u0113\u0123in\u0101jumiem pievienot, dz\u0113st vai p\u0101rd\u0113v\u0113t kolonnas ar rezerv\u0113tajiem nosaukumiem \"ROWID\", \"_ROWID_\" un \"OID\".\n<li class=\"l\"> Ir pievienota SQL funkcija diskused() der\u012bg\u0101s vietas nov\u0113rt\u0113\u0161anai, ko tabulas un indeksi aiz\u0146em uz kr\u0101tuves.\n<li class=\"l\"> SQL funkcij\u0101s printf() un format() pievienotas aizvietojumvietas \"%J\" un \"%j\" izvad\u012b\u0161anai JSON form\u0101t\u0101.\n<li class=\"l\"> Datumu un laika funkcij\u0101 pievienoti modifikatori \"weekday -N\" un \"end of\".\n<li class=\"l\"> Sist\u0113m\u0101s ar O_TMPFILE atbalstu funkcij\u0101 open(), \u0161\u012b re\u017e\u012bma izmanto\u0161ana ir nepiecie\u0161ama, lai izveidotu pagaidu failus.\n<li class=\"l\"> Vec\u0101ko Windows oper\u0113t\u0101jsist\u0113mu versiju, tostarp Windows CE un Windows XP, atbalsts ir p\u0101rtraukts. Minim\u0101l\u0101 versija ir Windows Vista.\n<\/ul>\n<p>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=66442\">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.54, \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: \u041f\u0440\u043e\u0432\u0435\u0434\u0435\u043d\u044b \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438, \u043f\u043e\u0437\u0432\u043e\u043b\u0438\u0432\u0448\u0438\u0435 \u0443\u0441\u043a\u043e\u0440\u0438\u0442\u044c \u043f\u0440\u043e\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 \u0442\u0435\u0441\u0442\u0430 speedtest1 \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u043d\u0430 4% \u043f\u043e \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044e \u0441 \u043f\u0440\u043e\u0448\u043b\u043e\u0439 \u0432\u0435\u0440\u0441\u0438\u0435\u0439 \u0438 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-183732","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5 - 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.54, \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=\"Alexander Kovalev\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/lv\/blog\/news\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 SQLite 3.54 \u0441 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f\u043c\u0438, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c CLI \u0438 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0438\u0435\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 Windows XP | 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.54, \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\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support\" \/>\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=\"2026-10-11T14:54:25+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-10-11T14:54:30+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Pieejama SQLite 3.54 datu b\u0101zu p\u0101rvald\u012bbas sist\u0113ma ar optimiz\u0101cij\u0101m, CLI papla\u0161in\u0101\u0161anu un Windows XP atbalsta p\u0101rtrauk\u0161anu | ProHoster","description":"Ir izlaista SQLite 3.54 versija, viegla datu b\u0101zu p\u0101rvald\u012bbas sist\u0113ma, kas veidota k\u0101 pievienojama bibliot\u0113ka. SQLite kods tiek izplat\u012bts k\u0101 publiskais \u012bpa\u0161ums (public domain).","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support","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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 SQLite 3.54 \u0441 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f\u043c\u0438, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c CLI \u0438 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0438\u0435\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 Windows XP | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.54, \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\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support","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":"2026-10-11T14:54:25+00:00","article:modified_time":"2026-10-11T14:54:30+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/183732","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=183732"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/183732\/revisions"}],"predecessor-version":[{"id":183733,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/183732\/revisions\/183733"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=183732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=183732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=183732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}