{"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\/pl\/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 miesi\u0105cu prac rozwojowych wydano wersj\u0119 3.48.0 kompaktowej wbudowanej bazy danych. <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\">SQLite<\/a>, napisanej w j\u0119zyku C i dystrybuowanej jako oprogramowanie publiczne.<\/p>\n<p><\/noindex><\/noindex>  <\/p>\n<p>Lista zmian:<\/p>\n<ul>\n<li>Przeprojektowanie skryptu configure, u\u017cywanego do kompilacji SQLite z kodu \u017ar\u00f3d\u0142owego, w celu naprawy b\u0142\u0119d\u00f3w, zwi\u0119kszenia wydajno\u015bci i poprawy utrzymywalno\u015bci kodu.<\/li>\n<li>\n<ul>\n<li>Nie wp\u0142ywa to na skrypt configure w archiwum sqlite3-autoconf-NNNNNNN.tar.gz, dla kt\u00f3rego system budowania nie uleg\u0142 zmianie.<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>Kluczow\u0105 nowo\u015bci\u0105 jest to, \u017ce zamiast GNU Autoconf u\u017cywa si\u0119 teraz <a rel=\"nofollow\" href=\"https:\/\/msteveb.github.io\/autosetup\">Autosetup.<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>Jedn\u0105 z zalet nowego konfiguratora jest to, \u017ce nie ma potrzeby instalacji TCL do kompilacji wi\u0119kszo\u015bci cel\u00f3w budowy SQLite. TCL wci\u0105\u017c jest wymagany do uruchamiania test\u00f3w lub do kompilacji program\u00f3w pomocniczych (np. sqlite3_analyzer), kt\u00f3re u\u017cywaj\u0105 TCL, ale do wi\u0119kszo\u015bci standardowych cel\u00f3w budowy TCL nie jest potrzebny. W ten spos\u00f3b, od tej wersji, jedynymi zale\u017cno\u015bciami do budowy s\u0105 kompilator C oraz make lub nmake.<\/li>\n<\/ul>\n<\/li>\n<li>Poprawiono polecenie EXPLAIN QUERY PLAN dla indeks\u00f3w.<\/li>\n<li>Funkcja SQL iif() teraz obs\u0142uguje dwa parametry. Dodano tak\u017ce funkcj\u0119 if(), jako alternatyw\u0119 dla iif().<\/li>\n<li>Do konsolowego narz\u0119dzia sqlite3 dodano polecenie .dbtotxt.<\/li>\n<li>Dodano w\u0142a\u015bciwo\u015b\u0107 SQLITE_IOCAP_SUBPAGE_READ do metody xDeviceCharacteristics obiektu sqlite3_io_methods.<\/li>\n<li>Dodano opcj\u0119 SQLITE_PREPARE_DONT_LOG do sqlite3_prepare_v3(), zapobiegaj\u0105c\u0105 wysy\u0142aniu ostrze\u017ce\u0144 do dziennika b\u0142\u0119d\u00f3w, gdy tekst SQL jest niepoprawnie sformu\u0142owany. Umo\u017cliwia to u\u017cycie sqlite3_prepare_v3() do testowej kompilacji tekstu SQL w celu sprawdzenia jego poprawno\u015bci, nie zanieczyszczaj\u0105c dziennika b\u0142\u0119d\u00f3w fa\u0142szywymi komunikatami.<\/li>\n<li>Zwi\u0119kszono minimaln\u0105 dopuszczaln\u0105 warto\u015b\u0107 parametru SQLITE_LIMIT_LENGTH z 1 do 30.<\/li>\n<li>Dodano opcode SQLITE_FCNTL_NULL_IO, kt\u00f3ry ustawia niskopoziomowy deskryptor pliku lub deskryptor pliku dla obiektu sqlite3_file w taki spos\u00f3b, \u017ce nie b\u0119dzie on ju\u017c czyta\u0142 lub zapisywa\u0142 w pliku bazy danych.<\/li>\n<li>Rozszerzono pomocnicze API FTS5 xInstToken() do obs\u0142ugi zapyta\u0144 prefiksowych za pomoc\u0105 opcji konfiguracji insttoken oraz funkcji SQL fts5_insttoken().<\/li>\n<li>Maksymalna liczba argument\u00f3w dla funkcji SQL zwi\u0119kszona z 127 do 1000.<\/li>\n<li>Usuni\u0119to pozosta\u0142o\u015bci SQLITE_USER_AUTHENTICATION.<\/li>\n<li>Naprawiono b\u0142\u0119dy.<\/li>\n<\/ul>\n<p>\u0179r\u00f3d\u0142o: <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.1.1 - 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\/pl\/blog\/news\/sqlite-3-48-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"pl_PL\" \/>\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\/pl\/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 miesi\u0105cu prac rozwojowych wydano wersj\u0119 3.48.0 kompaktowej.","canonical_url":"https:\/\/prohoster.info\/pl\/blog\/news\/sqlite-3-48-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pl_PL","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\/pl\/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\/pl\/wp-json\/wp\/v2\/posts\/121350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/comments?post=121350"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts\/121350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/media\/121351"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/media?parent=121350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/categories?post=121350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/tags?post=121350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}