{"id":183732,"date":"2026-10-11T16:54:25","date_gmt":"2026-10-11T14:54:25","guid":{"rendered":"https:\/\/prohoster.info\/blog\/news\/dostupna-subd-sqlite-3-54-s-optimizacziyami-rasshireniem-cli-i-prekrashheniem-podderzhki-windows-xp"},"modified":"2026-10-11T16:54:30","modified_gmt":"2026-10-11T14:54:30","slug":"sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support","status":"publish","type":"post","link":"https:\/\/prohoster.info\/it\/blog\/news\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support","title":{"rendered":"\u00c8 disponibile il DBMS SQLite 3.54 con ottimizzazioni, estensione CLI e termine del supporto per Windows XP","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u00c8 stata rilasciata la versione 3.54 di SQLite, un DBMS leggero fornito come libreria collegabile. Il codice di SQLite \u00e8 distribuito come dominio pubblico, ovvero pu\u00f2 essere utilizzato senza restrizioni e gratuitamente per qualsiasi scopo. Il supporto finanziario per gli sviluppatori di SQLite \u00e8 fornito da un consorzio creato appositamente. <\/p>\n<p>Variazioni principali:<\/p>\n<ul>\n<li class=\"l\"> Sono state effettuate ottimizzazioni che hanno permesso di accelerare il superamento del test speedtest1 di circa il 4% rispetto alla versione precedente e del 7,5% rispetto alla release 3.51 di un anno fa. I risultati possono variare a seconda del tipo di carico, delle opzioni di compilazione, della CPU, del compilatore e del sistema operativo.\n<li class=\"l\"> Nell'utilit\u00e0 sqlite \u00e8 implementata la possibilit\u00e0 di utilizzare sequenze di escape per mostrare ulteriori informazioni sullo stato nel prompt dei comandi, ad esempio, \"\/x\" per informazioni sulla transazione aperta, \"\/r\" per il DB in modalit\u00e0 di sola lettura, \"\/m\" per un DB memorizzato solo in memoria, \"\/f\" per inserire il nome del file con il DB, \"\/v\" per mostrare la versione di SQLite, \"\/:\" e \"\/;\" per costruire espressioni condizionali, \"\/u\" e \"\/h\" per inserire il nome utente e l'host. La configurazione del modello del prompt dei comandi pu\u00f2 essere effettuata attraverso le variabili d'ambiente SQLITE_PS1 e SQLITE_PS2.\n<li class=\"l\"> Nell'utilit\u00e0 sqlite, al comando \".mode\" sono state aggiunte le opzioni \"--ifmt\", \"--rowcount on\" e \"--titles always\" per configurare il formato dei numeri in virgola mobile e gestire la visualizzazione del contatore delle righe e del titolo. \u00c8 stato sostituito il gestore del comando \".diskused\". Per impostazione predefinita, il titolo con i nomi delle colonne viene mantenuto se la query non restituisce righe, e la pulizia dei byte nulli durante l'output dei blob nei sistemi Unix \u00e8 disabilitata.\n<li class=\"l\"> Nel pianificatore delle query \u00e8 stato accelerato l'esecuzione delle operazioni UPDATE in situazioni in cui ci sono indici su espressioni, ma il valore indicizzabile non cambia. \u00c8 stata ottimizzata l'esecuzione delle operazioni \"expr OR TRUE\" e \"expr OR FALSE\". \u00c8 stata garantita l'ignoranza dell'espressione DISTINCT nelle sottoquery SELECT specificate a destra dell'operatore \"IN\". \u00c8 stata accelerata l'elaborazione e ridotto il consumo di memoria quando si specifica nell'UNION l'espressione \"LIMIT 1\".\n<li class=\"l\"> Nel comando ALTER TABLE \u00e8 stato garantito un messaggio di errore per qualsiasi tentativo di aggiungere, rimuovere o rinominare colonne con nomi riservati \"ROWID\", \"_ROWID_\" e \"OID\".\n<li class=\"l\"> \u00c8 stata aggiunta la funzione SQL diskused() per stimare lo spazio occupato dalle tabelle e dagli indici sullo storage.\n<li class=\"l\"> Nelle funzioni SQL printf() e format() sono state aggiunte le sostituzioni \"%J\" e \"%j\" per l'output in formato JSON.\n<li class=\"l\"> Nella funzione di lavoro con date e orari sono stati aggiunti i modificatori \"weekday -N\" e \"end of\".\n<li class=\"l\"> Nei sistemi che supportano il flag O_TMPFILE nella funzione open(), questa modalit\u00e0 \u00e8 attivata durante la creazione di file temporanei.\n<li class=\"l\"> \u00c8 stata interrotta la supporto per le vecchie versioni di Windows, inclusi Windows CE e Windows XP. La versione minima dichiarata \u00e8 Windows Vista.\n<\/ul>\n<p>Fonte: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=66442\">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.54, \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\u043e\u0432\u0435\u0434\u0435\u043d\u044b \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438, \u043f\u043e\u0437\u0432\u043e\u043b\u0438\u0432\u0448\u0438\u0435 \u0443\u0441\u043a\u043e\u0440\u0438\u0442\u044c \u043f\u0440\u043e\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 \u0442\u0435\u0441\u0442\u0430 speedtest1 \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u043d\u0430 4% \u043f\u043e \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044e \u0441 \u043f\u0440\u043e\u0448\u043b\u043e\u0439 \u0432\u0435\u0440\u0441\u0438\u0435\u0439 \u0438 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-183732","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - 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.54, \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=\"Alexander Kovalev\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/it\/blog\/news\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"it_IT\" \/>\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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 SQLite 3.54 \u0441 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f\u043c\u0438, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c CLI \u0438 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0438\u0435\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 Windows XP | 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.54, \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\/it\/blog\/news\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support\" \/>\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=\"2026-10-11T14:54:25+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-10-11T14:54:30+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47\u00c8 disponibile il DBMS SQLite 3.54 con ottimizzazioni, estensione CLI e interruzione del supporto per Windows XP | ProHoster","description":"\u00c8 stata pubblicata la versione SQLite 3.54, un DBMS leggero, fornito come libreria plug-in. Il codice di SQLite \u00e8 distribuito come dominio pubblico, cio\u00e8.","canonical_url":"https:\/\/prohoster.info\/it\/blog\/news\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"it_IT","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\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 SQLite 3.54 \u0441 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f\u043c\u0438, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435\u043c CLI \u0438 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0438\u0435\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 Windows XP | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.54, \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\/it\/blog\/news\/sqlite-3-54-released-with-optimizations-cli-enhancements-and-end-of-windows-xp-support","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":"2026-10-11T14:54:25+00:00","article:modified_time":"2026-10-11T14:54:30+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/183732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/comments?post=183732"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/183732\/revisions"}],"predecessor-version":[{"id":183733,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/183732\/revisions\/183733"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/media?parent=183732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/categories?post=183732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/tags?post=183732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}