{"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\/es\/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>Despu\u00e9s de un mes de desarrollo, se lanz\u00f3 la versi\u00f3n 3.48.0 de la base de datos embebida compacta. <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\">SQLite<\/a>, escrita en C y distribuida como dominio p\u00fablico.<\/p>\n<p><\/noindex><\/noindex>  <\/p>\n<p>Lista de cambios:<\/p>\n<ul>\n<li>Revisar el script configure utilizado para compilar SQLite desde el c\u00f3digo fuente, con el fin de corregir errores, mejorar el rendimiento y facilitar el mantenimiento del c\u00f3digo.<\/li>\n<li>\n<ul>\n<li>Esto no afecta al script configure en el archivo sqlite3-autoconf-NNNNNNN.tar.gz, para el cual el sistema de compilaci\u00f3n no ha cambiado.<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>La novedad clave es que en lugar de GNU Autoconf ahora se utiliza <a rel=\"nofollow\" href=\"https:\/\/msteveb.github.io\/autosetup\">Autosetup.<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>\n<ul>\n<li>Una de las ventajas de la nueva configuraci\u00f3n es que ya no es necesario instalar TCL para compilar la mayor\u00eda de los objetivos de compilaci\u00f3n de SQLite. TCL a\u00fan es necesario para ejecutar pruebas o para compilar programas auxiliares (como sqlite3_analyzer) que utilizan TCL, pero para la mayor\u00eda de los objetivos de compilaci\u00f3n comunes no se requiere TCL. Por lo tanto, a partir de este lanzamiento, las \u00fanicas dependencias para la compilaci\u00f3n son un compilador C y make o nmake.<\/li>\n<\/ul>\n<\/li>\n<li>Mejorado el comando EXPLAIN QUERY PLAN para \u00edndices.<\/li>\n<li>La funci\u00f3n SQL iif() ahora soporta dos par\u00e1metros. Tambi\u00e9n se ha a\u00f1adido la funci\u00f3n if(), como alternativa a iif().<\/li>\n<li>Se ha a\u00f1adido el comando .dbtotxt a la utilidad de consola sqlite3.<\/li>\n<li>Se ha a\u00f1adido la propiedad SQLITE_IOCAP_SUBPAGE_READ al m\u00e9todo xDeviceCharacteristics del objeto sqlite3_io_methods.<\/li>\n<li>Se ha a\u00f1adido la opci\u00f3n SQLITE_PREPARE_DONT_LOG a sqlite3_prepare_v3(), que previene el env\u00edo de advertencias al registro de errores si el texto SQL est\u00e1 mal formado. Esto permite utilizar sqlite3_prepare_v3() para la compilaci\u00f3n de prueba del texto SQL para verificar su correcci\u00f3n, sin saturar el registro de errores con mensajes falsos.<\/li>\n<li>Se ha incrementado el valor m\u00ednimo permitido del par\u00e1metro SQLITE_LIMIT_LENGTH de 1 a 30.<\/li>\n<li>Se ha a\u00f1adido el opcode SQLITE_FCNTL_NULL_IO, que establece un descriptor de archivo de bajo nivel o un descriptor de archivo para el objeto sqlite3_file de tal manera que ya no leer\u00e1 ni escribir\u00e1 en el archivo de la base de datos.<\/li>\n<li>Se ha ampliado la API auxiliar FTS5 xInstToken() para trabajar con consultas de prefijo mediante la opci\u00f3n de configuraci\u00f3n insttoken y la funci\u00f3n SQL fts5_insttoken().<\/li>\n<li>El n\u00famero m\u00e1ximo de argumentos para funciones SQL se ha incrementado de 127 a 1000.<\/li>\n<li>Se han eliminado rastros residuales de SQLITE_USER_AUTHENTICATION.<\/li>\n<li>Se han corregido errores.<\/li>\n<\/ul>\n<p>Fuente: <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\/es\/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=\"es_ES\" \/>\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\/es\/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":"Despu\u00e9s de un mes de desarrollo, se lanz\u00f3 la versi\u00f3n 3.48.0 compacta.","canonical_url":"https:\/\/prohoster.info\/es\/blog\/news\/sqlite-3-48-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"es_ES","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\/es\/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\/es\/wp-json\/wp\/v2\/posts\/121350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/comments?post=121350"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts\/121350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/media\/121351"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/media?parent=121350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/categories?post=121350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/tags?post=121350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}