{"id":111250,"date":"2023-11-02T03:10:48","date_gmt":"2023-11-02T01:10:48","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-44"},"modified":"2023-11-02T03:10:48","modified_gmt":"2023-11-02T01:10:48","slug":"vypusk-subd-sqlite-3-44","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-sqlite-3-44","title":{"rendered":"Vyd\u00e1n\u00ed datab\u00e1zov\u00e9ho syst\u00e9mu SQLite 3.44","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Byl zve\u0159ejn\u011bn nov\u00fd release SQLite 3.44, lehk\u00e9 datab\u00e1zov\u00e9 syst\u00e9mu, kter\u00fd je poskytov\u00e1n jako knihovna. K\u00f3d SQLite je \u0161\u00ed\u0159en jako ve\u0159ejn\u00e9 vlastnictv\u00ed (public domain), co\u017e znamen\u00e1, \u017ee m\u016f\u017ee b\u00fdt pou\u017e\u00edv\u00e1n bez omezen\u00ed a bezplatn\u011b pro jak\u00e9koli \u00fa\u010dely. Finan\u010dn\u00ed podporu v\u00fdvoj\u00e1\u0159\u016fm SQLite zaji\u0161\u0165uje speci\u00e1ln\u011b vytvo\u0159en\u00fd konzorcium, do kter\u00e9ho pat\u0159\u00ed spole\u010dnosti jako Bentley, Bloomberg, Expensify a Navigation Data Standard.    <\/p>\n<p>Hlavn\u00ed zm\u011bny:  <\/p>\n<ul>\n<li class=\"l\"> V agrega\u010dn\u00edch funkc\u00edch je po posledn\u00edm parametru povoleno uv\u00e9st v\u00fdraz \u201eORDER BY\u201c pro zpracov\u00e1n\u00ed argument\u016f funkce ve stanoven\u00e9m po\u0159ad\u00ed, co\u017e m\u016f\u017ee b\u00fdt u\u017eite\u010dn\u00e9 pro funkce, jako jsou string_agg() a json_group_array().\n<li class=\"l\"> Byla p\u0159id\u00e1na podpora skal\u00e1rn\u00edch SQL funkc\u00ed concat() a concat_ws(), kter\u00e9 jsou kompatibiln\u00ed s PostgreSQL, MS SQL Server a MySQL.\n<li class=\"l\"> Byla p\u0159id\u00e1na podpora agrega\u010dn\u00ed funkce string_agg(), kter\u00e1 je kompatibiln\u00ed s PostgreSQL a MS SQL Server.\n<li class=\"l\"> Do SQL funkce strftime() byla p\u0159id\u00e1na podpora pro specifi k\u00e1tory \u201e%e\u201c, \u201e%F\u201c, \u201e%I\u201c, \u201e%k\u201c, \u201e%l\u201c, \u201e%p\u201c, \u201e%P\u201c, \u201e%R\u201c, \u201e%T\u201c a \u201e%u\u201c.\n<li class=\"l\"> V\u00fdstup mnoha chyb souvisej\u00edc\u00edch s v\u00fdrazem \u201eCREATE TABLE\u201c je nyn\u00ed vykazov\u00e1n po proveden\u00ed v\u00fdrazu \u201eCREATE TABLE\u201c, nikoli po prvn\u00edm pou\u017eit\u00ed tabulky.\n<li class=\"l\"> V p\u0159\u00edkazu \u201ePRAGMA integrity_check\u201c byla implementov\u00e1na kontrola konzistence obsahu r\u016fzn\u00fdch integrovan\u00fdch virtu\u00e1ln\u00edch tabulek pou\u017e\u00edvan\u00fdch v roz\u0161\u00ed\u0159en\u00edch FTS3, FTS4, FTS5, RTREE a GEOPOLY.\n<li class=\"l\"> Zabudovan\u00e9 virtu\u00e1ln\u00ed tabulky pou\u017e\u00edvan\u00e9 v roz\u0161\u00ed\u0159en\u00edch FTS3, FTS4, FTS5, RTREE a GEOPOLY lze nyn\u00ed pou\u017e\u00edt uvnit\u0159 trigger\u016f.\n<li class=\"l\"> P\u0159i nastaven\u00ed SQLITE_DBCONFIG_DEFENSIVE je zaji\u0161t\u011bna ochrana p\u0159ed aktivac\u00ed re\u017eimu \u201ePRAGMA writable_schema\u201c.\n<li class=\"l\"> P\u0159i kompilaci pomoc\u00ed Microsoft C je ve v\u00fdchoz\u00edm nastaven\u00ed povolena mo\u017enost SQLITE_USE_SEH (Structured Exception Handling).\n<li class=\"l\"> Byly provedeny optimalizace v pl\u00e1nova\u010di dotaz\u016f, kter\u00e9 se t\u00fdkaj\u00ed \u010d\u00e1ste\u010dn\u00e9ho skenov\u00e1n\u00ed index\u016f, p\u0159i specifikaci konstantn\u00ed hodnoty pro sloupec tabulky ve v\u00fdrazu WHERE. Kv\u016fli zji\u0161t\u011bn\u00fdm regrese byla deaktivov\u00e1na optimalizace skenov\u00e1n\u00ed pohled\u016f, kter\u00e1 byla p\u0159id\u00e1na ve verzi 3.42.0.\n<li class=\"l\"> Byla zaji\u0161t\u011bna runtime kontrola podpory syst\u00e9mu pro typ \u201elong double\u201c s p\u0159esnost\u00ed vy\u0161\u0161\u00ed ne\u017e u typu \u201edouble\u201c.\n<li class=\"l\"> V p\u0159\u00edkazov\u00e9m rozhran\u00ed pro Windows je pro vstup a v\u00fdstup ve v\u00fdchoz\u00edm nastaven\u00ed pou\u017eita k\u00f3dov\u00e1n\u00ed UTF-8 (pro deaktivaci je k dispozici mo\u017enost \u201e\u2014no-utf8\u201c).    <\/ul>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=60035\">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.44, \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, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u0445\u043e\u0434\u044f\u0442 \u0442\u0430\u043a\u0438\u0435 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438, \u043a\u0430\u043a Bentley, Bloomberg, Expensify \u0438 Navigation Data Standard. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0412 \u0430\u0433\u0440\u0435\u0433\u0430\u0442\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u044f\u0445 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-111250","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.44, \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=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-sqlite-3-44\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 SQLite 3.44 | 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.44, \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\/cs\/blog\/news\/vypusk-subd-sqlite-3-44\" \/>\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=\"2023-11-02T01:10:48+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-11-02T01:10:48+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\udd47Vyd\u00e1n\u00ed DB SQLite 3.44 | ProHoster","description":"Byl zve\u0159ejn\u011bn nov\u00fd release SQLite 3.44, lehk\u00e9 datab\u00e1zov\u00e9 syst\u00e9mu, kter\u00fd je poskytov\u00e1n jako knihovna. K\u00f3d SQLite je \u0161\u00ed\u0159en jako ve\u0159ejn\u00e9 vlastnictv\u00ed (public domain), co\u017e znamen\u00e1, \u017ee m\u016f\u017ee b\u00fdt pou\u017e\u00edv\u00e1n bez omezen\u00ed a bezplatn\u011b pro jak\u00e9koli \u00fa\u010dely.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-sqlite-3-44","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 SQLite 3.44 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.44, \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\/cs\/blog\/news\/vypusk-subd-sqlite-3-44","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":"2023-11-02T01:10:48+00:00","article:modified_time":"2023-11-02T01:10:48+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/111250","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=111250"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/111250\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=111250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=111250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=111250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}