{"id":168285,"date":"2026-04-10T11:12:04","date_gmt":"2026-04-10T09:12:04","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-53"},"modified":"2026-04-10T11:12:04","modified_gmt":"2026-04-10T09:12:04","slug":"vypusk-subd-sqlite-3-53","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-sqlite-3-53","title":{"rendered":"Vydanie datab\u00e1zov\u00e9ho syst\u00e9mu SQLite 3.53","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Bolestn\u00fd de\u0148 SQLite 3.53, \u013eahk\u00e1 datab\u00e1zov\u00e1 spr\u00e1va, ktor\u00e1 je dostupn\u00e1 ako pripojite\u013en\u00e1 kni\u017enica. Verzia 3.52 bola zru\u0161en\u00e1. K\u00f3d SQLite je distribuovan\u00fd ako verejn\u00fd majetok (public domain), tak\u017ee ho mo\u017eno pou\u017e\u00edva\u0165 bez obmedzen\u00ed a zadarmo na ak\u00fdko\u013evek \u00fa\u010del. Finan\u010dn\u00fa podporu v\u00fdvoj\u00e1rom SQLite poskytuje \u0161peci\u00e1lne vytvoren\u00fd konzorcium.     <\/p>\n<p>Hlavn\u00e9 zmeny:  <\/p>\n<ul>\n<li class=\"l\"> Opraven\u00e1 chyba, ktor\u00e1 sp\u00f4sobovala po\u0161kodenie datab\u00e1zy. Probl\u00e9m sa vyskytoval od verzie SQLite 3.7.0 (rok 2010) a ovplyv\u0148oval datab\u00e1zy v re\u017eime WAL (Write-Ahead Logging) a prejavoval sa v d\u00f4sledku pretekania pri s\u00fa\u010dasnom otv\u00e1ran\u00ed dvoch alebo viacer\u00fdch pripojen\u00ed k datab\u00e1ze, ktor\u00e9 sa pok\u00fa\u0161ali zapisova\u0165 alebo potvrdi\u0165 transakcie v jednom in\u0161tancii datab\u00e1zy. Tvrd\u00ed sa, \u017ee okolnosti ved\u00face k zlyhaniu sa vyskytuj\u00fa mimoriadne zriedka a podarilo sa ich zopakova\u0165 len v \u0161peci\u00e1lne vytvorenom testovacom scen\u00e1ri.\n<li class=\"l\"> V t\u00edme &#171;ALTER TABLE&#187; je povolen\u00e9 odstra\u0148ova\u0165 kontroly &#171;NOT NULL&#187; a &#171;CHECK&#187;.\n<li class=\"l\"> Pridan\u00e1 pr\u00edkaz &#171;REINDEX EXPRESSIONS&#187; na prestavbu indexov na z\u00e1klade v\u00fdrazov, v ktor\u00fdch sa ako prvok indexu pou\u017e\u00edva funkcia nad st\u013apcom alebo oper\u00e1cia nad st\u013apcami. Tento pr\u00edkaz sa m\u00f4\u017ee pou\u017ei\u0165 na obnovenie expirovan\u00fdch indexov.\n<li class=\"l\"> Vo vn\u00fatri do\u010dasn\u00fdch sp\u00fa\u0161\u0165a\u010dov vytvoren\u00fdch pr\u00edkazom &#171;CREATE TEMP TRIGGER&#187; a aplikovan\u00fdch na tabu\u013eky v in\u00fdch datab\u00e1zach je povolen\u00e1 zmena tabuliek alebo dotazy na \u00fadaje z tabuliek.\n<li class=\"l\"> V pr\u00edkaze &#171;VACUUM INTO&#187; pri ur\u010den\u00ed cie\u013eov\u00e9ho s\u00faboru cez URL je mo\u017en\u00e9 pou\u017ei\u0165 parameter &#171;reserve=N&#187; na ur\u010denie po\u010dtu vytv\u00e1ran\u00fdch z\u00e1loh datab\u00e1zy.\n<li class=\"l\"> Implementovan\u00e9 nov\u00e9 SQL funkcie json_array_insert() a jsonb_array_insert() na vkladanie prvkov do pol\u00ed JSON.\n<li class=\"l\"> Pridan\u00e1 a zapojen\u00e1 v utilite pr\u00edkazov\u00e9ho riadku kni\u017enica QRF (Query Result Formatter) na form\u00e1tovanie v\u00fdsledkov vykonania SQL dopytov do \u013eahko \u010ditate\u013en\u00e9ho form\u00e1tu.\n<li class=\"l\"> Zmeny v utilite pr\u00edkazov\u00e9ho riadku:\n<ul>\n<li class=\"l\"> Pr\u00edkaz &#171;.mode&#187; bol v\u00fdrazne roz\u0161\u00edren\u00fd.\n<li class=\"l\">  Zlep\u0161en\u00e9 generovanie v\u00fdstupu, napr\u00edklad je predvolene zahrnut\u00e9 vykreslenie r\u00e1mov a \u010d\u00edseln\u00e9 hodnoty s\u00fa teraz zarovnan\u00e9 doprava pri tabulovanom v\u00fdstupe.\n<li class=\"l\"> Boli zabezpe\u010den\u00e9 ignorovanie znakov &#171;;&#187; po pr\u00edkazoch.\n<li class=\"l\"> Obsah uveden\u00fdch v pr\u00edkazovom riadku s\u00faborov s pr\u00edponami *.sql a *.txt sa teraz \u010d\u00edta a interpretuje ako s\u00fabory SQL v\u00fdrazov a dot pr\u00edkazov.\n<li class=\"l\"> Do pr\u00edkazu &#171;.timer&#187; bola pridan\u00e1 podpora hodnoty &#171;once&#187; na pou\u017eitie \u010dasova\u010da iba na nasleduj\u00faci SQL v\u00fdraz.\n<li class=\"l\">  Do pr\u00edkazu &#171;.progress&#187; bola pridan\u00e1 mo\u017enos\u0165 &#171;&#8212;timeout S&#187; na n\u00faten\u00e9 preru\u0161enie SQL v\u00fdrazu po uplynut\u00ed \u010dasov\u00e9ho limitu.\n<li class=\"l\"> V pr\u00edkaze &#171;.indexes&#187; sa zmenilo spr\u00e1vanie \u0161abl\u00f3n, ktor\u00e9 sa teraz aplikuj\u00fa na n\u00e1zvy indexov, nie na n\u00e1zvy indexovan\u00fdch tabuliek.      <\/ul>\n<li class=\"l\"> Boli vykonan\u00e9 optimaliz\u00e1cie v pl\u00e1nova\u010di dotazov, ktor\u00e9 ur\u00fdchlili pr\u00e1cu s f\u00faziou tabuliek a oper\u00e1ciami EXCEPT, INTERSECT a UNION.\n<li class=\"l\"> Vylep\u0161en\u00fd v\u00fdkon funkci\u00ed prevodu \u010d\u00edsel s pohyblivou desatinnou \u010diarkou na textov\u00fa reprezent\u00e1ciu.\n<li class=\"l\"> Do implement\u00e1cie, kompilovanej do medziov\u00fdkonn\u00e9ho k\u00f3du WebAssembly, bola pridan\u00e1 VFS &#171;opfs-wl&#187;, identick\u00e1 VFS &#171;opfs&#187;, ale vyu\u017e\u00edvaj\u00faca API Web Locks na pr\u00e1cu s blok\u00e1dami.\n<li class=\"l\"> Do utility sqlite3_rsync bola pridan\u00e1 mo\u017enos\u0165 &#171;-p|&#8212;port&#187;.\n<li class=\"l\"> Podpora platformy Windows RT bola ukon\u010den\u00e1.        <\/ul>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=65182\">opennet.ru<\/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.53, \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. \u0412\u044b\u043f\u0443\u0441\u043a 3.52 \u0431\u044b\u043b \u043e\u0442\u043c\u0435\u043d\u0451\u043d. \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: \u0423\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u0430 \u043e\u0448\u0438\u0431\u043a\u0430, \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0432\u0448\u0430\u044f \u043a \u043f\u043e\u0432\u0440\u0435\u0436\u0434\u0435\u043d\u0438\u044e \u0411\u0414. \u041f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u043e\u0432\u0430\u043b\u0430 \u043d\u0430\u0447\u0438\u043d\u0430\u044f \u0441 \u0432\u0435\u0440\u0441\u0438\u0438 SQLite [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-168285","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.53, \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. \u0412\u044b\u043f\u0443\u0441\u043a 3.52 \u0431\u044b\u043b \u043e\u0442\u043c\u0435\u043d\u0451\u043d. \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=\"Erik Peterson\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-sqlite-3-53\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\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.53 | 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.53, \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. \u0412\u044b\u043f\u0443\u0441\u043a 3.52 \u0431\u044b\u043b \u043e\u0442\u043c\u0435\u043d\u0451\u043d. \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\/sk\/blog\/news\/vypusk-subd-sqlite-3-53\" \/>\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-04-10T09:12:04+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-04-10T09:12:04+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\udd47Vydanie DBMS SQLite 3.53 | ProHoster","description":"Bol vydan\u00fd release SQLite 3.53, \u013eahkej DBMS, prezentovanej vo forme z\u00e1suvnej kni\u017enice. Vydanie 3.52 bolo zru\u0161en\u00e9. K\u00f3d SQLite je distribuovan\u00fd ako verejn\u00fd majetok (public domain), t.j.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-sqlite-3-53","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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.53 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.53, \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. \u0412\u044b\u043f\u0443\u0441\u043a 3.52 \u0431\u044b\u043b \u043e\u0442\u043c\u0435\u043d\u0451\u043d. \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\/sk\/blog\/news\/vypusk-subd-sqlite-3-53","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-04-10T09:12:04+00:00","article:modified_time":"2026-04-10T09:12:04+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/168285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=168285"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/168285\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=168285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=168285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=168285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}