{"id":102412,"date":"2021-11-28T09:36:50","date_gmt":"2021-11-28T07:36:50","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-37"},"modified":"2021-11-28T09:36:50","modified_gmt":"2021-11-28T07:36:50","slug":"vypusk-subd-sqlite-3-37","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-sqlite-3-37","title":{"rendered":"Verze datab\u00e1zov\u00e9ho syst\u00e9mu SQLite 3.37","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Byla vyd\u00e1na verze SQLite 3.37, lehk\u00e9ho datab\u00e1zov\u00e9ho syst\u00e9mu, kter\u00fd je poskytov\u00e1n jako p\u0159ipojiteln\u00e1 knihovna. K\u00f3d SQLite je \u0161\u00ed\u0159en jako ve\u0159ejn\u00fd majetek (public domain), co\u017e znamen\u00e1, \u017ee m\u016f\u017ee b\u00fdt pou\u017e\u00edv\u00e1n bez omezen\u00ed a zdarma pro jak\u00e9koli \u00fa\u010dely. Finan\u010dn\u00ed podporu v\u00fdvoj\u00e1\u0159\u016fm SQLite poskytuje speci\u00e1ln\u011b vytvo\u0159en\u00fd konzorcium, do kter\u00e9ho pat\u0159\u00ed spole\u010dnosti jako Adobe, Oracle, Mozilla, Bentley a Bloomberg.     <\/p>\n<p>Hlavn\u00ed zm\u011bny:  <\/p>\n<ul>\n<li class=\"l\"> Byla p\u0159id\u00e1na podpora pro vytv\u00e1\u0159en\u00ed tabulek se znakem \u201eSTRICT\u201c, kter\u00fd vy\u017eaduje povinn\u00e9 ur\u010den\u00ed typu p\u0159i deklaraci sloupc\u016f a aplikuje p\u0159\u00edsnou kontrolu shody typ\u016f p\u0159id\u00e1van\u00fdch dat do sloupc\u016f. P\u0159i nastaven\u00ed t\u00e9to volby SQLite za\u010dne vyhazovat chybu, pokud opravdu nelze p\u0159ev\u00e9st zadan\u00e1 data na typ sloupce. Nap\u0159\u00edklad, pokud je sloupec vytvo\u0159en jako \u201eINTEGER\u201c, pak p\u0159ed\u00e1n\u00ed \u0159et\u011bzce \u2018123\u2019 povede k p\u0159id\u00e1n\u00ed \u010d\u00edsla 123, ale pokus o uveden\u00ed \u2018xyz\u2019 skon\u010d\u00ed chybou.\n<li class=\"l\"> V operaci \u201eALTER TABLE ADD COLUMN\u201c byla p\u0159id\u00e1na kontrola podm\u00ednek existence \u0159\u00e1dk\u016f p\u0159i p\u0159id\u00e1v\u00e1n\u00ed sloupc\u016f s kontrolami na z\u00e1klad\u011b v\u00fdrazu \u201eCHECK\u201c nebo s podm\u00ednkami \u201eNOT NULL\u201c.\n<li class=\"l\"> Byl implementov\u00e1n v\u00fdraz \u201ePRAGMA table_list\u201c, kter\u00fd poskytuje informace o tabulk\u00e1ch a pohledech.\n<li class=\"l\"> V rozhran\u00ed p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku byla implementov\u00e1na p\u0159\u00edkaz \u201e.connection\u201c, kter\u00fd umo\u017e\u0148uje sou\u010dasn\u011b podporovat v\u00edce p\u0159ipojen\u00ed k DB.\n<li class=\"l\"> Byl p\u0159id\u00e1n parametr \u201e\u2014safe\u201c, kter\u00fd deaktivuje CLI p\u0159\u00edkazy a SQL v\u00fdrazy, kter\u00e9 umo\u017e\u0148uj\u00ed prov\u00e1d\u011bt operace s datab\u00e1zov\u00fdmi soubory odli\u0161n\u00fdmi od t\u011bch, kter\u00e9 jsou uvedeny v p\u0159\u00edkazov\u00e9m \u0159\u00e1dku DB.\n<li class=\"l\"> Byla provedena optimalizace v\u00fdkonu \u010dten\u00ed SQL v\u00fdraz\u016f, kter\u00e9 jsou rozd\u011bleny do n\u011bkolika \u0159\u00e1dk\u016f v CLI.\n<li class=\"l\"> Byly p\u0159id\u00e1ny funkce sqlite3_autovacuum_pages(), sqlite3_changes64() a sqlite3_total_changes64().\n<li class=\"l\"> V pl\u00e1nova\u010di dotaz\u016f bylo zaji\u0161t\u011bno ignorov\u00e1n\u00ed v\u00fdraz\u016f \u201eORDER BY\u201c ve vno\u0159en\u00fdch dotazech a pohledech, pokud odstran\u011bn\u00ed t\u011bchto v\u00fdraz\u016f nem\u011bn\u00ed s\u00e9mantiku dotazu.\n<li class=\"l\"> Bylo zm\u011bn\u011bno roz\u0161\u00ed\u0159en\u00ed generate_series(START,END,STEP), p\u0159i\u010dem\u017e prvn\u00ed parametr (\u201aSTART\u2018) byl p\u0159eveden na obligatorn\u00ed. Pro n\u00e1vrat star\u00e9ho chov\u00e1n\u00ed je mo\u017en\u00e9 znovu sestavit s volbou \u201e-DZERO_ARGUMENT_GENERATE_SERIES\u201c.\n<li class=\"l\"> Byla sn\u00ed\u017eena spot\u0159eba pam\u011bti pro ukl\u00e1d\u00e1n\u00ed sch\u00e9matu datab\u00e1ze.    <\/ul>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=56244\">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.37, \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 Adobe, Oracle, Mozilla, Bentley \u0438 Bloomberg. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446 [&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-102412","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.37, \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-37\" \/>\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.37 | 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.37, \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-37\" \/>\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=\"2021-11-28T07:36:50+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2021-11-28T07:36:50+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 datab\u00e1zov\u00e9ho syst\u00e9mu SQLite 3.37 | ProHoster","description":"Byla vyd\u00e1na verze SQLite 3.37, lehk\u00e9ho datab\u00e1zov\u00e9ho syst\u00e9mu, kter\u00fd je poskytov\u00e1n jako p\u0159ipojiteln\u00e1 knihovna. K\u00f3d SQLite je \u0161\u00ed\u0159en jako ve\u0159ejn\u00fd majetek (public domain), co\u017e znamen\u00e1, \u017ee m\u016f\u017ee b\u00fdt pou\u017e\u00edv\u00e1n bez omezen\u00ed a zdarma pro jak\u00e9koli \u00fa\u010dely.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-sqlite-3-37","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.37 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.37, \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-37","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":"2021-11-28T07:36:50+00:00","article:modified_time":"2021-11-28T07:36:50+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"102412","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-11-28 07:37:44","updated":"2022-09-27 15:24:33","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/102412","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=102412"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/102412\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=102412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=102412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=102412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}