{"id":116050,"date":"2024-05-24T08:59:21","date_gmt":"2024-05-24T06:59:21","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-46"},"modified":"2024-05-24T08:59:21","modified_gmt":"2024-05-24T06:59:21","slug":"vypusk-subd-sqlite-3-46","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-sqlite-3-46","title":{"rendered":"Vydanie datab\u00e1zov\u00e9ho syst\u00e9mu SQLite 3.46","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Bol verzionovan\u00fd SQLite 3.46, \u013eahk\u00fd syst\u00e9m riadenia datab\u00e1z, ktor\u00fd je dostupn\u00fd ako pr\u00eddavn\u00e1 kni\u017enica. K\u00f3d SQLite je spr\u00edstupnen\u00fd ako verejn\u00e9 vlastn\u00edctvo (public domain), t.j. m\u00f4\u017ee sa pou\u017e\u00edva\u0165 bez obmedzen\u00ed a bezplatne na ak\u00e9ko\u013evek \u00fa\u010dely. Finan\u010dn\u00fa podporu pre v\u00fdvoj\u00e1rov SQLite poskytuje \u0161peci\u00e1lne zalo\u017een\u00fd konzorcium.     <\/p>\n<p>Hlavn\u00e9 zmeny:  <\/p>\n<ul>\n<li class=\"l\"> Bola poskytnut\u00e1 mo\u017enos\u0165 pou\u017e\u00edva\u0165 v \u010d\u00edslach odde\u013eova\u010d \u201e_\u201c pre preh\u013eadnej\u0161ie zobrazenie \u010d\u00edseln\u00fdch liter\u00e1lov (napr\u00edklad 1_234_567).\n<li class=\"l\"> Bola pridan\u00e1 SQL funkcia json_pretty() na generovanie \u010ditate\u013enej\u0161ieho v\u00fdstupu vo form\u00e1te JSON, naform\u00e1tovan\u00e9ho s pou\u017eit\u00edm odsadenia blokov.\n<li class=\"l\"> Mo\u017enosti oper\u00e1cie \u201ePRAGMA optimize\u201c boli roz\u0161\u00edren\u00e9; t\u00e1to oper\u00e1cia vykon\u00e1va optimaliz\u00e1ciu DB a v\u0161etk\u00fdch sch\u00e9m d\u00e1t na dosiahnutie najlep\u0161ej v\u00fdkonnosti dopytov. Bol implementovan\u00fd automaticky uplat\u0148ovan\u00fd limit na \u010das anal\u00fdzy DB, ktor\u00fd vylu\u010duje pr\u00edli\u0161 dlh\u00fd \u010das spracovania ve\u013ek\u00fdch DB. Pridan\u00e1 nov\u00e1 bitov\u00e1 maska \u201ePRAGMA optimize(0x10000)\u201c pre samostatn\u00fa kontrolu aktualiz\u00e1ci\u00ed vo v\u0161etk\u00fdch tabu\u013ek\u00e1ch. Zabezpe\u010den\u00e9 automatick\u00e9 op\u00e4tovn\u00e9 analyzovanie tabuliek, v ktor\u00fdch ch\u00fdbaj\u00fa z\u00e1znamy sqlite_stat1.\n<li class=\"l\"> Do SQL funkcie strftime() bola pridan\u00e1 podpora substit\u00faci\u00ed %G, %g, %U a %V.\n<li class=\"l\"> Do SQL funkci\u00ed na pr\u00e1cu s d\u00e1tumami a \u010dasom boli pridan\u00e9 nov\u00e9 modifik\u00e1tory ceiling a floor na riadenie spracovania nejednozna\u010dn\u00fdch d\u00e1tumov, ktor\u00e9 vznikaj\u00fa pri posunoch d\u00e1tumov o ur\u010dit\u00fd po\u010det mesiacov alebo rokov. Bol zabezpe\u010den\u00fd ignorovanie modifik\u00e1torov utc a localtime, ak m\u00e1 SQLite inform\u00e1cie o tom, \u017ee \u010das je u\u017e v zobrazovan\u00ed UTC alebo localtime.\n<li class=\"l\"> Urobili sa optimaliz\u00e1cie v pl\u00e1nova\u010di dopytov. Pre v\u00fdraz INSERT obsahuj\u00faci tis\u00edce hodn\u00f4t v sekcii VALUES je predvolene zahrnut\u00e1 optimaliz\u00e1cia \u201eVALUES-as-coroutine\u201c, ktor\u00e1 pribli\u017ene zdvojn\u00e1sobuje r\u00fdchlos\u0165 spracovania podobn\u00fdch v\u00fdrazov a tie\u017e zni\u017euje spotrebu pam\u00e4te na polovicu. Pre dopyty typu \u201eSELECT count(DISTINCT col) FROM \u2026\u201c je povolen\u00e9 pou\u017eitie indexov, aj ke\u010f ve\u013ekos\u0165 z\u00e1znamov v indexe nie je men\u0161ia ako z\u00e1znamy v tabu\u013eke. Vylep\u0161en\u00e1 logika ur\u010denia situ\u00e1ci\u00ed, ke\u010f sa v argumentoch SQL-funkci\u00ed uv\u00e1dzaj\u00fa kon\u0161tanty. Zabezpe\u010den\u00e9 uplatnenie optimaliz\u00e1cie push-down pre v\u00fdrazy WHERE, ktor\u00e9 obsahuj\u00fa nes\u00favisiace poddotazy.\n<li class=\"l\"> Zmenen\u00e1 logika spracovania prete\u010denia z\u00e1sobn\u00edka \u2014 pri zisten\u00ed nedostatku pam\u00e4te pre z\u00e1sobn\u00edk sa parser teraz pok\u00fa\u0161a priradi\u0165 dodato\u010dn\u00fa pam\u00e4\u0165 z haldy, namiesto zobrazenia chyby \u201eparser stack overflow\u201c.\n<li class=\"l\"> V JSON je povolen\u00e9 uv\u00e1dza\u0165 riadiace znaky v re\u0165azcov\u00fdch liter\u00e1loch JSON5. Zmenen\u00e1 logika fungovania oper\u00e1torov \u201e-&gt;\u201c a \u201e-&gt;&gt;\u201c, ke\u010f je na pravej strane re\u0165azcov\u00fd operand obsahuj\u00faci iba \u010d\u00edsla (pod\u013ea anal\u00f3gie s PostgreSQL s\u00fa teraz tak\u00e9 operandy spracov\u00e1van\u00e9 ako re\u0165azec).\n<li class=\"l\"> V hodnote DEFAULT v st\u013apcoch tabuliek je povolen\u00e9 uv\u00e1dzanie ve\u013ek\u00fdch hexadecim\u00e1lnych liter\u00e1lov.      <\/ul>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=61238\">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.46, \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\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0430 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0432 \u0447\u0438\u0441\u043b\u0430\u0445 \u0440\u0430\u0437\u0434\u0435\u043b\u0438\u0442\u0435\u043b\u044f &#171;_&#187; \u0434\u043b\u044f \u0431\u043e\u043b\u0435\u0435 \u043d\u0430\u0433\u043b\u044f\u0434\u043d\u043e\u0433\u043e \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0447\u0438\u0441\u043b\u043e\u0432\u044b\u0445 \u043b\u0438\u0442\u0435\u0440\u0430\u043b\u043e\u0432 (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, 1_234_567). \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 [&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-116050","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.46, \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-46\" \/>\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.46 | 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.46, \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-46\" \/>\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-05-24T06:59:21+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-05-24T06:59:21+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\udd47Uvo\u013enenie S\u00daBD SQLite 3.46 | ProHoster","description":"Bol uvo\u013enen\u00fd release SQLite 3.46, \u013eahkej S\u00daBD, ktor\u00e1 je dod\u00e1van\u00e1 ako pripojite\u013en\u00e1 kni\u017enica. K\u00f3d SQLite je \u0161\u00edren\u00fd ako verejn\u00e9 vlastn\u00edctvo (public domain), t.j.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-sqlite-3-46","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.46 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.46, \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-46","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-05-24T06:59:21+00:00","article:modified_time":"2024-05-24T06:59:21+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"116050","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 00:58:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 00:58:19","updated":"2026-01-23 00:58:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/116050","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=116050"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/116050\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=116050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=116050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=116050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}