{"id":121350,"date":"2025-01-15T15:46:21","date_gmt":"2025-01-15T13:46:22","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/sqlite-3-48-0"},"modified":"2025-01-15T15:46:21","modified_gmt":"2025-01-15T13:46:22","slug":"sqlite-3-48-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/sqlite-3-48-0","title":{"rendered":"SQLite 3.48.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"SQLite 3.48.0\" src=\"\/wp-content\/uploads\/2025\/01\/2bedc2caa04e2d64823731d4ad4a0e83.jpg\" style=\"display:block;margin: 0 auto;\" \/>                              <noindex>      <noindex><\/p>\n<p>Po mesiaci v\u00fdvoja bol vydan\u00fd 3.48.0, kompaktn\u00e1 zabudovate\u013en\u00e1 S\u00daDB. <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\">SQLite<\/a>, nap\u00edsan\u00e1 v jazyku C a distribuovan\u00e1 ako verejn\u00e9 vlastn\u00edctvo.<\/p>\n<p><\/noindex><\/noindex>  <\/p>\n<p>Zoznam zmien:<\/p>\n<ul>\n<li>Prepracovanie skriptu configure, pou\u017e\u00edvan\u00e9ho na zostavenie SQLite z p\u00f4vodn\u00e9ho zdroja, s cie\u013eom opravy ch\u00fdb, zv\u00fd\u0161enia v\u00fdkonu a zlep\u0161enia \u00fadr\u017eby k\u00f3du.<\/li>\n<li>\n<ul>\n<li>Toto nem\u00e1 vplyv na skript configure v arch\u00edve sqlite3-autoconf-NNNNNNN.tar.gz, pre ktor\u00fd sa syst\u00e9m zostavenia nezmenil.<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>K\u013e\u00fa\u010dov\u00fdm novinkou je, \u017ee namiesto GNU Autoconf sa teraz pou\u017e\u00edva <a rel=\"nofollow\" href=\"https:\/\/msteveb.github.io\/autosetup\">Autosetup<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>Jednou z v\u00fdhod novej konfigur\u00e1cie je, \u017ee na zostavenie v\u00e4\u010d\u0161iny cie\u013eov zostavenia SQLite u\u017e nie je potrebn\u00e9 in\u0161talova\u0165 TCL. TCL je st\u00e1le potrebn\u00e9 na sp\u00fa\u0161\u0165anie testov alebo na zostavenie pomocn\u00fdch programov (napr\u00edklad sqlite3_analyzer), ktor\u00e9 pou\u017e\u00edvaj\u00fa TCL, ale pre v\u00e4\u010d\u0161inu be\u017en\u00fdch cie\u013eov zostavenia TCL nie je potrebn\u00e9. Tak\u017ee od tohto vydania s\u00fa jedin\u00fdmi z\u00e1vislos\u0165ami na zostavenie kompil\u00e1tor C a make alebo nmake.<\/li>\n<\/ul>\n<\/li>\n<li>Zlep\u0161en\u00e1 pr\u00edkaz EXPLAIN QUERY PLAN pre indexy.<\/li>\n<li>SQL-funkcia iif() teraz podporuje dva parametre. Pridan\u00e1 bola aj funkcia if() ako alternat\u00edva k iif().<\/li>\n<li>Do konzolov\u00e9ho n\u00e1stroja sqlite3 bola pridan\u00e1 pr\u00edkaz .dbtotxt.<\/li>\n<li>Pridan\u00e1 vlastnos\u0165 SQLITE_IOCAP_SUBPAGE_READ do met\u00f3dy xDeviceCharacteristics objektu sqlite3_io_methods.<\/li>\n<li>Pridan\u00e1 vo\u013eba SQLITE_PREPARE_DONT_LOG do sqlite3_prepare_v3(), ktor\u00e1 zabra\u0148uje odoslaniu varovan\u00ed do protokolu ch\u00fdb, ak je SQL-text nespr\u00e1vne formulovan\u00fd. To umo\u017e\u0148uje vyu\u017eitie sqlite3_prepare_v3() na testovaciu kompil\u00e1ciu SQL-textu na overenie jeho spr\u00e1vnosti, bez zanech\u00e1vania falo\u0161n\u00fdch spr\u00e1v v protokole ch\u00fdb.<\/li>\n<li>Minimalne pr\u00edpustn\u00e1 hodnota parametra SQLITE_LIMIT_LENGTH bola zv\u00fd\u0161en\u00e1 zo 1 na 30.<\/li>\n<li>Pridan\u00fd opk\u00f3d SQLITE_FCNTL_NULL_IO, ktor\u00fd nastavuje n\u00edzko\u00farov\u0148ov\u00fd s\u00faborov\u00fd deskriptor alebo s\u00faborov\u00fd deskriptor pre objekt sqlite3_file tak, aby u\u017e ne\u010d\u00edtal alebo nep\u00edsal do s\u00faboru datab\u00e1zy.<\/li>\n<li>Roz\u0161\u00edren\u00fd pomocn\u00fd API FTS5 xInstToken() na pr\u00e1cu s prefixov\u00fdmi po\u017eiadavkami pomocou vo\u013eby konfigur\u00e1cie insttoken a SQL-funkcie fts5_insttoken().<\/li>\n<li>Maxim\u00e1lny po\u010det argumentov pre SQL funkcie bol zv\u00fd\u0161en\u00fd zo 127 na 1000.<\/li>\n<li>Odstr\u00e1nen\u00e9 zvy\u0161kov\u00e9 stopy SQLITE_USER_AUTHENTICATION.<\/li>\n<li>Opraven\u00e9 chyby.<\/li>\n<\/ul>\n<p>Zdroj: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.linux.org.ru\/news\/opensource\/17848327\">linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u043c\u0435\u0441\u044f\u0446\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0441\u043e\u0441\u0442\u043e\u044f\u043b\u0441\u044f \u0432\u044b\u043f\u0443\u0441\u043a 3.48.0 \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u043e\u0439 \u0432\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u043e\u0439 \u0421\u0423\u0411\u0414 SQLite, \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043d\u043e\u0439 \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 C \u0438 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u043c\u043e\u0439, \u043a\u0430\u043a \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0435 \u0434\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435. \u0421\u043f\u0438\u0441\u043e\u043a \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439: \u041f\u0435\u0440\u0435\u0440\u0430\u0431\u043e\u0442\u043a\u0430 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 configure, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u043e\u0433\u043e \u0434\u043b\u044f \u0441\u0431\u043e\u0440\u043a\u0438 SQLite \u0438\u0437 \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0433\u043e \u043a\u043e\u0434\u0430, \u0441 \u0446\u0435\u043b\u044c\u044e \u0438\u0441\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043e\u0448\u0438\u0431\u043e\u043a, \u043f\u043e\u0432\u044b\u0448\u0435\u043d\u0438\u044f \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u0438 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u044f \u0441\u043e\u043f\u0440\u043e\u0432\u043e\u0436\u0434\u0430\u0435\u043c\u043e\u0441\u0442\u0438 \u043a\u043e\u0434\u0430. \u042d\u0442\u043e \u043d\u0435 \u0432\u043b\u0438\u044f\u0435\u0442 \u043d\u0430 \u0441\u043a\u0440\u0438\u043f\u0442 configure \u0432 \u0430\u0440\u0445\u0438\u0432\u0435 sqlite3-autoconf-NNNNNNN.tar.gz, \u0434\u043b\u044f \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0441\u0431\u043e\u0440\u043a\u0438 \u043d\u0435 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":121351,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-121350","post","type-post","status-publish","format-standard","has-post-thumbnail","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=\"\u041f\u043e\u0441\u043b\u0435 \u043c\u0435\u0441\u044f\u0446\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0441\u043e\u0441\u0442\u043e\u044f\u043b\u0441\u044f \u0432\u044b\u043f\u0443\u0441\u043a 3.48.0 \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u043e\u0439.\" \/>\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\/sqlite-3-48-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\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\udd47SQLite 3.48.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u043c\u0435\u0441\u044f\u0446\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0441\u043e\u0441\u0442\u043e\u044f\u043b\u0441\u044f \u0432\u044b\u043f\u0443\u0441\u043a 3.48.0 \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u043e\u0439.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sk\/blog\/news\/sqlite-3-48-0\" \/>\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-01-15T13:46:22+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-01-15T13:46:22+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.48.0 | ProHoster","description":"Po mesiaci v\u00fdvoja bol vydan\u00fd 3.48.0 kompaktn\u00fd.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/sqlite-3-48-0","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\udd47SQLite 3.48.0 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u043c\u0435\u0441\u044f\u0446\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0441\u043e\u0441\u0442\u043e\u044f\u043b\u0441\u044f \u0432\u044b\u043f\u0443\u0441\u043a 3.48.0 \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u043e\u0439.","og:url":"https:\/\/prohoster.info\/sk\/blog\/news\/sqlite-3-48-0","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-01-15T13:46:22+00:00","article:modified_time":"2025-01-15T13:46:22+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"121350","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 09:43:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 09:43:19","updated":"2026-01-23 09:43: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\/121350","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=121350"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/121350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media\/121351"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=121350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=121350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=121350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}