Byl vyd\u00e1n SQLite 3.42, lehk\u00e1 datab\u00e1zov\u00e1 spr\u00e1va, kter\u00e1 je dostupn\u00e1 jako dynamick\u00e1 knihovna. K\u00f3d SQLite je distribuov\u00e1n 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 pro jak\u00e9koliv \u00fa\u010dely bez n\u00e1klad\u016f. Finan\u010dn\u00ed podporu v\u00fdvoj\u00e1\u0159\u016fm SQLite poskytuje speci\u00e1ln\u011b vytvo\u0159en\u00fd konsorcium, do kter\u00e9ho pat\u0159\u00ed spole\u010dnosti jako Adobe, Oracle, Mozilla, Bentley a Bloomberg. <\/p>\n
Hlavn\u00ed zm\u011bny: <\/p>\n
Krom\u011b toho byla vyd\u00e1na verze datab\u00e1zov\u00e9ho syst\u00e9mu DuckDB 0.8.0, kter\u00e1 roz\u0161i\u0159uje variantu SQLite o mo\u017enosti a optimalizace pro prov\u00e1d\u011bn\u00ed analytick\u00fdch dotaz\u016f, pokr\u00fdvaj\u00edc\u00edch v\u00fdznamnou \u010d\u00e1st ulo\u017een\u00fdch dat, nap\u0159\u00edklad prov\u00e1d\u011bj\u00edc\u00ed agregaci v\u0161ech obsahu tabulek nebo slou\u010den\u00ed n\u011bkolika velk\u00fdch tabulek. Poskytuje roz\u0161\u00ed\u0159enou variantu SQL, zahrnuj\u00edc\u00ed dal\u0161\u00ed mo\u017enosti pro zpracov\u00e1n\u00ed velmi slo\u017eit\u00fdch a dlouh\u00fdch dotaz\u016f a tak\u00e9 podporuj\u00edc\u00ed slo\u017eit\u00e9 typy (pole, struktury, unie), paraleln\u00ed prov\u00e1d\u011bn\u00ed n\u011bkolika dotaz\u016f a prov\u00e1d\u011bn\u00ed dotaz\u016f p\u0159\u00edmo z soubor\u016f ve form\u00e1tu CSV, JSON a Parquet. Existuje mo\u017enost importu z datab\u00e1z\u00ed PostgreSQL. <\/p>\n
Krom\u011b k\u00f3du Shell z SQLite projekt vyu\u017e\u00edv\u00e1 extern\u00ed knihovnu parseru z PostgreSQL, komponentu Date Math z MonetDB, vlastn\u00ed implementaci oknov\u00fdch funkc\u00ed (na z\u00e1klad\u011b algoritmu Segment Tree Aggregation), zpracovatele regula\u010dn\u00edch v\u00fdraz\u016f na z\u00e1klad\u011b knihovny RE2, vlastn\u00ed optimaliz\u00e1tor dotaz\u016f, mechanismus MVCC pro \u0159\u00edzen\u00ed paraleln\u00edho prov\u00e1d\u011bn\u00ed \u00faloh (Multi-Version Concurrency Control), a tak\u00e9 vektorov\u00fd engines pro vykon\u00e1v\u00e1n\u00ed dotaz\u016f na z\u00e1klad\u011b algoritmu Hyper-Pipelining Query Execution, kter\u00fd umo\u017e\u0148uje v jedn\u00e9 operaci zpracov\u00e1vat velk\u00e9 mno\u017estv\u00ed hodnot. K\u00f3d projektu je distribuov\u00e1n pod licenc\u00ed MIT. <\/p>\n
V nov\u00e9 verzi DuckDB: <\/p>\n
D\u00e1le lze zm\u00ednit rozv\u00edjen\u00fd projekt spole\u010dnosti Facebook CG\/SQL, kter\u00fd poskytuje gener\u00e1tor k\u00f3du pro pou\u017eit\u00ed ulo\u017een\u00fdch procedur se SQLite. CG\/SQL umo\u017e\u0148uje formulovat ulo\u017een\u00e9 procedury ve speci\u00e1ln\u00edm dialektu T-SQL (Transact-SQL), kter\u00fd umo\u017e\u0148uje vol\u00e1n\u00ed funkc\u00ed standardn\u00ed knihovny C a p\u0159\u00edstup k dat\u016fm v SQLite. Vytvo\u0159en\u00e9 ulo\u017een\u00e9 procedury se kompiluj\u00ed do k\u00f3du v jazyce C, kter\u00fd vyu\u017e\u00edv\u00e1 SQLite C API k vykon\u00e1v\u00e1n\u00ed ur\u010den\u00fdch akc\u00ed a zpracov\u00e1v\u00e1n\u00ed slo\u017eit\u00fdch dotaz\u016f. Zkompilovan\u00e9 ulo\u017een\u00e9 procedury mohou b\u00fdt p\u0159ipojeny k program\u016fm v jazyc\u00edch C, Java a Objective-C. K\u00f3d projektu je naps\u00e1n v jazyce C a je distribuov\u00e1n pod licenc\u00ed MIT. \u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.42, \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\u043b\u044f \u043f\u043e\u043b\u043d\u043e\u0442\u0435\u043a\u0441\u0442\u043e\u0432\u044b\u0445 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 FTS5 […]<\/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-108630","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Vyd\u00e1n\u00ed datab\u00e1ze SQLite 3.42 a DuckDB 0.8.0. CG\/SQL s implementac\u00ed ulo\u017een\u00fdch procedur pro SQLite | ProHoster","description":"Bylo zve\u0159ejn\u011bno vyd\u00e1n\u00ed SQLite 3.42, lehk\u00e9 datab\u00e1zov\u00e9 SODB, zformovan\u00e9 jako podm\u00edn\u011bn\u00e1 knihovna. K\u00f3d SQLite je distribuov\u00e1n jako ve\u0159ejn\u00e9 vlastnictv\u00ed (public domain), tj.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite","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.42 \u0438 DuckDB 0.8.0. CG\/SQL \u0441 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440 \u0434\u043b\u044f SQLite | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.42, \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-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite","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-05-19T10:48:16+00:00","article:modified_time":"2023-05-19T10:52:41+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\/108630","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=108630"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/108630\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=108630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=108630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=108630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
Zdroj: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"