{"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\/fr\/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>Apr\u00e8s un mois de d\u00e9veloppement, la version 3.48.0 de la base de donn\u00e9es embarqu\u00e9e compacte a \u00e9t\u00e9 publi\u00e9e. <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\">SQLite<\/a>, \u00e9crite en C et diffus\u00e9e comme domaine public.<\/p>\n<p><\/noindex><\/noindex>  <\/p>\n<p>Liste des changements :<\/p>\n<ul>\n<li>R\u00e9\u00e9criture du script configure utilis\u00e9 pour compiler SQLite \u00e0 partir du code source, afin de corriger des erreurs, d'am\u00e9liorer les performances et de faciliter la maintenance du code.<\/li>\n<li>\n<ul>\n<li>Cela n'affecte pas le script configure dans l'archive sqlite3-autoconf-NNNNNNN.tar.gz, pour lequel le syst\u00e8me de construction n'a pas chang\u00e9.<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>L'innovation cl\u00e9 est que, \u00e0 la place de GNU Autoconf, on utilise d\u00e9sormais <a rel=\"nofollow\" href=\"https:\/\/msteveb.github.io\/autosetup\">Autosetup.<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>Un des avantages du nouveau configurateur est qu'il n'est plus n\u00e9cessaire d'installer TCL pour compiler la plupart des cibles de compilation de SQLite. TCL est toujours requis pour ex\u00e9cuter des tests ou pour compiler des programmes auxiliaires (par exemple, sqlite3_analyzer) utilisant TCL, mais pour la majorit\u00e9 des cibles de compilation courantes, TCL n'est pas n\u00e9cessaire. Ainsi, \u00e0 partir de cette version, les seules d\u00e9pendances pour la compilation sont le compilateur C et make ou nmake.<\/li>\n<\/ul>\n<\/li>\n<li>La commande EXPLAIN QUERY PLAN pour les index a \u00e9t\u00e9 am\u00e9lior\u00e9e.<\/li>\n<li>La fonction SQL iif() prend d\u00e9sormais en charge deux param\u00e8tres. La fonction if() a \u00e9galement \u00e9t\u00e9 ajout\u00e9e comme alternative \u00e0 iif().<\/li>\n<li>Une nouvelle commande .dbtotxt a \u00e9t\u00e9 ajout\u00e9e \u00e0 l'utilitaire de console sqlite3.<\/li>\n<li>La propri\u00e9t\u00e9 SQLITE_IOCAP_SUBPAGE_READ a \u00e9t\u00e9 ajout\u00e9e \u00e0 la m\u00e9thode xDeviceCharacteristics de l'objet sqlite3_io_methods.<\/li>\n<li>L'option SQLITE_PREPARE_DONT_LOG a \u00e9t\u00e9 ajout\u00e9e \u00e0 sqlite3_prepare_v3(), emp\u00eachant l'envoi d'avertissements dans le journal des erreurs si le texte SQL est mal form\u00e9. Cela permet d'utiliser sqlite3_prepare_v3() pour une compilation de test du texte SQL afin de v\u00e9rifier sa validit\u00e9, sans encombrer le journal des erreurs avec de faux messages.<\/li>\n<li>La valeur minimale du param\u00e8tre SQLITE_LIMIT_LENGTH a \u00e9t\u00e9 augment\u00e9e de 1 \u00e0 30.<\/li>\n<li>Un opcode SQLITE_FCNTL_NULL_IO a \u00e9t\u00e9 ajout\u00e9, \u00e9tablissant un descripteur de fichier de bas niveau pour l'objet sqlite3_file de sorte qu'il ne lira ni n'\u00e9crira dans le fichier de la base de donn\u00e9es.<\/li>\n<li>L'API auxiliaire FTS5 xInstToken() a \u00e9t\u00e9 \u00e9tendue pour fonctionner avec les requ\u00eates de pr\u00e9fixes gr\u00e2ce \u00e0 l'option de configuration insttoken et \u00e0 la fonction SQL fts5_insttoken().<\/li>\n<li>Le nombre maximum d'arguments pour les fonctions SQL a \u00e9t\u00e9 augment\u00e9 de 127 \u00e0 1000.<\/li>\n<li>Les traces r\u00e9siduelles de SQLITE_USER_AUTHENTICATION ont \u00e9t\u00e9 supprim\u00e9es.<\/li>\n<li>Des corrections de bogues ont \u00e9t\u00e9 effectu\u00e9es.<\/li>\n<\/ul>\n<p>Source : <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.2 - 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\/fr\/blog\/news\/sqlite-3-48-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\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\/fr\/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":"Apr\u00e8s un mois de d\u00e9veloppement, la version 3.48.0 compacte a \u00e9t\u00e9 publi\u00e9e.","canonical_url":"https:\/\/prohoster.info\/fr\/blog\/news\/sqlite-3-48-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"fr_FR","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\/fr\/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\/fr\/wp-json\/wp\/v2\/posts\/121350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/comments?post=121350"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/121350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media\/121351"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=121350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=121350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=121350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}