{"id":113031,"date":"2024-01-21T17:28:02","date_gmt":"2024-01-21T15:28:02","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-45"},"modified":"2024-01-21T17:28:02","modified_gmt":"2024-01-21T15:28:02","slug":"vypusk-subd-sqlite-3-45","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-sqlite-3-45","title":{"rendered":"Vyd\u00e1n\u00ed datab\u00e1zov\u00e9ho syst\u00e9mu SQLite 3.45","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Bol vydan\u00fd release SQLite 3.45, \u013eahkej datab\u00e1zy spr\u00e1vy, ktor\u00e1 je navrhnut\u00e1 ako pripojite\u013en\u00e1 kni\u017enica. K\u00f3d SQLite je \u0161\u00edren\u00fd ako verejn\u00fd majetok (public domain), t. j. m\u00f4\u017ee by\u0165 pou\u017e\u00edvan\u00fd bez obmedzen\u00ed a bezodplatne na ak\u00e9ko\u013evek \u00fa\u010dely. Finan\u010dn\u00fa podporu pre v\u00fdvoj\u00e1rov SQLite zabezpe\u010duje \u0161peci\u00e1lne vytvoren\u00fd konzorcium, do ktor\u00e9ho patr\u00ed aj spolo\u010dnosti ako Bentley, Bloomberg, Expensify a Navigation Data Standard.    <\/p>\n<p>Hlavn\u00e9 zmeny:  <\/p>\n<ul>\n<li class=\"l\"> V\u0161etky SQL-funkcie pre pr\u00e1cu s form\u00e1tom JSON boli prepracovan\u00e9 a preveden\u00e9 na nov\u00fd intern\u00fd form\u00e1t stromovej anal\u00fdzy JSONB, ktor\u00fd sa serializuje a m\u00f4\u017ee by\u0165 uchov\u00e1van\u00fd v datab\u00e1ze na vyl\u00fa\u010denie opakovan\u00e9ho rozparsovania pri pou\u017e\u00edvan\u00ed hodn\u00f4t JSON. Nov\u00e9 verzie funkci\u00ed, ktor\u00e9 generuj\u00fa JSON, teraz vytv\u00e1raj\u00fa bin\u00e1rny form\u00e1t JSONB namiesto textov\u00e9ho. Do funkcie json_valid() bol pridan\u00fd volite\u013en\u00fd druh\u00fd argument, prostredn\u00edctvom ktor\u00e9ho m\u00f4\u017eete zada\u0165 bitov\u00fa masku ur\u010duj\u00facu znaky platn\u00e9ho JSON (napr\u00edklad pri zadan\u00ed 0x04 bude uznan\u00e1 blob JSONB za spr\u00e1vnu, pri zadan\u00ed 0x01 textov\u00fd JSON vo form\u00e1te RFC-8259 a pri zadan\u00ed 0x05 oba varianty).\n<li class=\"l\"> Do virtu\u00e1lnej tabu\u013eky FTS5, pou\u017e\u00edvan\u00e9 na fulltextov\u00e9 vyh\u013ead\u00e1vanie, bola pridan\u00e1 mo\u017enos\u0165 tokendata, ktor\u00e1 umo\u017e\u0148uje pou\u017ei\u0165 vlastn\u00e9 tokeniz\u00e9ry.\n<li class=\"l\"> Predvolene je aktivovan\u00e1 optimaliz\u00e1cia SQLITE_DIRECT_OVERFLOW_READ, pri ktorej sa overflow-str\u00e1nky, ktor\u00fdch ve\u013ekos\u0165 presahuje \u0161tandardn\u00fa ve\u013ekos\u0165 b-tree str\u00e1nky, \u010d\u00edtaj\u00fa priamo z s\u00faboru a obch\u00e1dzaj\u00fa cache. Na vypnutie pri kompil\u00e1cii je mo\u017en\u00e9 pou\u017ei\u0165 vo\u013ebu &#171;-DSQLITE_DIRECT_OVERFLOW_READ=0&#187;.\n<li class=\"l\"> V pl\u00e1nova\u010di dopytov bola zv\u00fd\u0161en\u00e1 efektivita optimaliz\u00e1cie transit\u00edvnych obmedzen\u00ed (transitive constraint) a vylep\u0161en\u00e9 ignorovanie indexov, ktor\u00e9 s\u00fa pova\u017eovan\u00e9 za nekvalitn\u00e9 pri vykon\u00e1van\u00ed oper\u00e1cie ANALYZE.\n<li class=\"l\"> V pr\u00edkazovom riadku bolo vylep\u0161en\u00e9 zobrazenie obsahu v k\u00f3dovan\u00ed UTF-8 na platforme Windows. Zabezpe\u010den\u00e9 automatick\u00e9 rozpoznanie pou\u017eitia CLI rozhrania pri sp\u00fa\u0161\u0165an\u00ed skriptov &#171;.dump&#187; a zavedenie pr\u00edslu\u0161n\u00fdch zmien v nastaveniach, ako s\u00fa &#171;.dbconfig defensive off&#187; a &#171;.dbconfig dqs_dll on&#187;.\n<li class=\"l\"> Do aplik\u00e1ciou definovan\u00fdch SQL-funkci\u00ed bola pridan\u00e1 vlastnos\u0165 SQLITE_RESULT_SUBTYPE, ktor\u00e1 umo\u017e\u0148uje vyvola\u0165 z funkcie sqlite3_result_subtype() na kontrolu podtypov argumentov.      <\/ul>\n<p>\u010ealej m\u00f4\u017eeme poznamena\u0165 rozvoj v experiment\u00e1lnych zostav\u00e1ch SQLite nov\u00e9ho re\u017eimu vedenia transak\u010dn\u00fdch z\u00e1znamov \u2014 WAL2 (&#171;PRAGMA journal_mode = wal2&#187;), pri ktorom sa pou\u017e\u00edvaj\u00fa dva wal-s\u00fabory (&#171;database-wal&#187; a &#171;database-wal2&#187;) namiesto jedn\u00e9ho. Pri z\u00e1pise \u00fadajov do DB sa vykon\u00e1va pridanie nov\u00fdch \u00fadajov do prv\u00e9ho wal-s\u00faboru. Ak prv\u00fd wal-s\u00fabor dosiahne dostato\u010dne ve\u013ek\u00fa ve\u013ekos\u0165, prech\u00e1dza sa na z\u00e1pis do druh\u00e9ho s\u00faboru. Po prechode na druh\u00fd wal-s\u00fabor sa prv\u00fd st\u00e1va dostupn\u00fdm na potvrdenie zmien (checkpoint) a prep\u00edsanie. T\u00fdmto sp\u00f4sobom, ke\u010f druh\u00fd wal-s\u00fabor dosiahne ve\u013ek\u00fa ve\u013ekos\u0165, doch\u00e1dza k prechodu sp\u00e4\u0165 na prv\u00fd a pod., \u010do rie\u0161i probl\u00e9m s nekontrolovate\u013en\u00fdm narastan\u00edm wal-s\u00faboru v situ\u00e1ci\u00e1ch, ke\u010f sa transakcia dlho nepotvrdzuje alebo sa vykon\u00e1vaj\u00fa dlh\u00e9 procesy \u010d\u00edtania.<br \/>\n<br \/>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=60460\">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.45, \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 Bentley, Bloomberg, Expensify \u0438 Navigation Data Standard. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0412\u0441\u0435 SQL-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f [&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-113031","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5.1 - 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.45, \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\/sk\/blog\/news\/vypusk-subd-sqlite-3-45\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\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.45 | 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.45, \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\/sk\/blog\/news\/vypusk-subd-sqlite-3-45\" \/>\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=\"2024-01-21T15:28:02+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-21T15:28:02+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.45 | ProHoster","description":"Bol zverejnen\u00fd vydanie SQLite 3.45, \u013eahkej DBMS, ktor\u00e1 je tvoren\u00e1 vo forme pripojite\u013enej kni\u017enice. 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-45","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.45 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.45, \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\/sk\/blog\/news\/vypusk-subd-sqlite-3-45","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":"2024-01-21T15:28:02+00:00","article:modified_time":"2024-01-21T15:28:02+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\/113031","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=113031"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/113031\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=113031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=113031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=113031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}