{"id":108630,"date":"2023-05-19T12:48:16","date_gmt":"2023-05-19T10:48:16","guid":{"rendered":"https:\/\/prohoster.info\/?p=108630"},"modified":"2023-05-19T12:52:41","modified_gmt":"2023-05-19T10:52:41","slug":"vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite","title":{"rendered":"Vydanie datab\u00e1zov\u00e9ho syst\u00e9mu SQLite 3.42 a DuckDB 0.8.0. CG\/SQL s implement\u00e1ciou ulo\u017een\u00fdch proced\u00far pre SQLite","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Bol release SQLite 3.42, \u013eahk\u00e9ho DBMS, zverejnen\u00e9ho ako kni\u017enica. K\u00f3d SQLite je uvo\u013enen\u00fd ako verejn\u00fd majetok (public domain), t.j. m\u00f4\u017ee sa pou\u017e\u00edva\u0165 bez obmedzen\u00ed a bez n\u00e1hrady za ak\u00fdko\u013evek \u00fa\u010del. Finan\u010dn\u00fa podporu v\u00fdvoj\u00e1rom SQLite poskytuje \u0161peci\u00e1lne vytvoren\u00fd konzorcium, do ktor\u00e9ho patr\u00ed tak\u00e1 spolo\u010dnos\u0165 ako Adobe, Oracle, Mozilla, Bentley a Bloomberg.     <\/p>\n<p>Hlavn\u00e9 zmeny:  <\/p>\n<ul>\n<li class=\"l\"> Pre plnotextov\u00e9 indexy FTS5 bola implementovan\u00e1 pr\u00edkaz secure-delete, ktor\u00fd vykon\u00e1va \u00fapln\u00e9 vymazanie v\u0161etk\u00fdch zvy\u0161kov\u00fdch \u00fadajov po odstr\u00e1nen\u00ed.\n<li class=\"l\"> Vo funkci\u00e1ch na spracovanie d\u00e1t vo form\u00e1te JSON bola implementovan\u00e1 podpora roz\u0161\u00edren\u00ed JSON5.\n<li class=\"l\"> Vylep\u0161en\u00fd pl\u00e1nova\u010d po\u017eiadaviek. Predvolene je zapnut\u00e1 optimaliz\u00e1cia \u201ecount-of-view\u201c. Spracovanie nepou\u017e\u00edvan\u00fdch st\u013apcov v poddotazoch bolo vyl\u00fa\u010den\u00e9. Vylep\u0161en\u00e1 implement\u00e1cia optimaliz\u00e1cie push-down.\n<li class=\"l\"> Do pr\u00edkazov\u00e9ho rozhrania bola pridan\u00e1 mo\u017enos\u0165 \u201e--unsafe-testing\u201c, ktor\u00e1 umo\u017e\u0148uje pou\u017e\u00edva\u0165 niektor\u00e9 nebezpe\u010dn\u00e9 pr\u00edkazy ako \u201e.testctrl\u201c, ur\u010den\u00e9 na pou\u017eitie pri testovan\u00ed. V bezpe\u010dnom re\u017eime (\u201e--safe\u201c) je povolen\u00e9 pou\u017e\u00edvanie pr\u00edkazov \u201e.log on\u201c a \u201e.log off\u201c. Pridan\u00e1 podpora odde\u013eova\u010da \u201e--\u201c, po ktorom sa preru\u0161\u00ed spracovanie mo\u017enost\u00ed. Pridan\u00e9 parametre \u201e:inf\u201c a \u201e:nan\u201c, t\u00fdkaj\u00face sa hodn\u00f4t nekone\u010dno a NaN.\n<li class=\"l\"> V n\u00e1zvoch SQL-funkci\u00ed definovan\u00fdch na strane aplik\u00e1cie bolo povolen\u00e9 prekrytie s k\u013e\u00fa\u010dov\u00fdmi slovami CROSS, FULL, INNER, LEFT, NATURAL, OUTER a RIGHT.\n<li class=\"l\"> Mo\u017enosti PRAGMA integrity_check boli roz\u0161\u00edren\u00e9. Pridan\u00e1 kontrola, ktor\u00e1 zabezpe\u010duje, \u017ee hodnota NaN sa nach\u00e1dza v st\u013apcoch s podmienkou NOT NULL. Vylep\u0161en\u00e1 informa\u010dnos\u0165 chybov\u00fdch spr\u00e1v.\n<li class=\"l\"> V dodatku session je povolen\u00fd zachyt\u00e1vanie zmien z tabuliek bez ROWID.\n<li class=\"l\"> Do funkcie na pr\u00e1cu s \u010dasom a d\u00e1tumami bol pridan\u00fd modifik\u00e1tor \u201esubsec\u201c na pou\u017eitie s\u010d\u00edtania sek\u00fand.\n<li class=\"l\"> H\u013abka rekurzie pre polia a objekty JSON bola predvolene zn\u00ed\u017een\u00e1 z 2000 na 1000.      <\/ul>\n<p>Okrem in\u00e9ho bol vydan\u00fd syst\u00e9m DuckDB 0.8.0, ktor\u00fd predstavuje variantu SQLite roz\u0161\u00edren\u00fd o mo\u017enosti a optimaliz\u00e1cie pre vykon\u00e1vanie analytick\u00fdch dotazov, pokr\u00fdvaj\u00face podstatn\u00fa \u010das\u0165 ulo\u017een\u00fdch d\u00e1t, napr\u00edklad vykon\u00e1vaj\u00face agreg\u00e1ciu cel\u00e9ho obsahu tabuliek alebo zl\u00fa\u010denie viacer\u00fdch ve\u013ek\u00fdch tabuliek. Poskytuje roz\u0161\u00edren\u00fd dialekt SQL, ktor\u00fd obsahuje \u010fal\u0161ie funkcie na spracovanie ve\u013emi zlo\u017eit\u00fdch a dlh\u00fdch dotazov, ako aj podporuje zlo\u017eit\u00e9 typy (pole, \u0161trukt\u00fary, unie), s\u00fa\u010dasn\u00e9 vykon\u00e1vanie viacer\u00fdch dotazov a vykon\u00e1vanie dotazov priamo z s\u00faborov vo form\u00e1te CSV, JSON a Parquet. Existuje mo\u017enos\u0165 importu z datab\u00e1zy PostgreSQL.     <\/p>\n<p>Okrem k\u00f3du shellu zo SQLite projekt pou\u017e\u00edva samostatne vy\u010dlenen\u00fa kni\u017enicu pre parser z PostgreSQL, komponent Date Math z MonetDB, vlastn\u00fa implement\u00e1ciu oknov\u00fdch funkci\u00ed (na z\u00e1klade algoritmu Segment Tree Aggregation), spracovate\u013e regul\u00e1rnych v\u00fdrazov zalo\u017een\u00fd na kni\u017enici RE2, vlastn\u00e9ho optimaliz\u00e1tora dotazov, MVCC mechanizmus riadenia s\u00fabe\u017en\u00e9ho vykon\u00e1vania \u00faloh (Multi-Version Concurrency Control), ako aj vektorovan\u00fd engine na vykon\u00e1vanie dotazov zalo\u017een\u00fd na algoritme Hyper-Pipelining Query Execution, ktor\u00fd umo\u017e\u0148uje spracov\u00e1va\u0165 ve\u013ek\u00e9 mno\u017einy hodn\u00f4t v jednej oper\u00e1cii. K\u00f3d projektu je distribuovan\u00fd pod licenciou MIT.       <\/p>\n<p>V novej verzii DuckDB:    <\/p>\n<ul>\n<li class=\"l\"> Pridan\u00e9 nov\u00e9 v\u00fdrazy \u201ePIVOT\u201c a \u201eUNPIVOT\u201c na transform\u00e1ciu riadkov na st\u013apce a naopak.\n<li class=\"l\"> Zlep\u0161en\u00e9 paralelizovanie pri importe a exporte d\u00e1t. Predvolene sa implementovalo \u010d\u00edtanie zo s\u00faborov vo form\u00e1te CSV v nieko\u013ek\u00fdch vl\u00e1knach a viacvl\u00e1knov\u00e9 z\u00e1pisy pri pou\u017eit\u00ed form\u00e1tov Parquet, CSV a JSON.\n<li class=\"l\"> Pridan\u00fd oper\u00e1tor \u201e**\u201c na rekurz\u00edvne preh\u013ead\u00e1vanie adres\u00e1rov pri ur\u010dovan\u00ed s\u00faborov\u00fdch ciest (napr. FROM \u2018data\/glob\/crawl\/stackoverflow\/**\/*.csv\u2019;).\n<li class=\"l\"> Bola pridan\u00e1 podpora oper\u00e1ci\u00ed zl\u00fa\u010denia (JOIN) pre d\u00e1ta vo forme \u010dasovej rady (\u00faseky hodn\u00f4t parametrov v pravideln\u00fdch intervaloch), v ktor\u00fdch ako krit\u00e9rium zl\u00fa\u010denia z\u00e1znamov sa pou\u017e\u00edva nie presn\u00e1, ale pribli\u017en\u00e1 zhoda hodn\u00f4t v poli s \u010dasom (napr\u00edklad je mo\u017en\u00e9 zl\u00fa\u010di\u0165 z\u00e1znamy, ktor\u00fdch \u010das sa l\u00ed\u0161i najviac o 1 min\u00fatu).\n<li class=\"l\"> Bola implementovan\u00e1 oneskoren\u00e1 na\u010d\u00edtanie metad\u00e1t DB, \u010do umo\u017enilo desiatkykr\u00e1t ur\u00fdchli\u0165 spustenie syst\u00e9mov DB.\n<li class=\"l\"> Pridan\u00e1 podpora pripojenia pou\u017e\u00edvate\u013esk\u00fdch funkci\u00ed v jazyku Python.\n<li class=\"l\"> Pridan\u00e1 podpora API ADBC (Arrow Database Connectivity) na prenos d\u00e1t s vyu\u017eit\u00edm Apache Arrow.\n<li class=\"l\"> Implementovan\u00e1 v\u00e4zba na integr\u00e1ciu s k\u00f3dom v jazyku Swift.\n<li class=\"l\"> Zmenen\u00e9 spr\u00e1vanie oper\u00e1tora delenia (\u201e\/\u201c), ktor\u00fd teraz predvolene vykon\u00e1va v\u00fdpo\u010dty s pl\u00e1vaj\u00facou desatinnou \u010diarkou namiesto cel\u00fdch \u010d\u00edsel. Pre cel\u00e9 delenie bol navrhnut\u00fd nov\u00fd oper\u00e1tor \u201e\/\/\u201c. Star\u00e9 spr\u00e1vanie je mo\u017en\u00e9 obnovi\u0165 nastaven\u00edm \u201eSET integer_division=true;\u201c.\n<li class=\"l\"> Met\u00f3da spracovania nulov\u00fdch z\u00e1znamov pri trieden\u00ed bola zmenen\u00e1 z \u201eNULLS FIRST\u201c na \u201eNULLS LAST\u201c, t.j. hodnoty NULL sa teraz zobrazia na konci, nie na za\u010diatku zoznamu. Star\u00e9 spr\u00e1vanie je mo\u017en\u00e9 obnovi\u0165 nastaven\u00edm \u201eSET default_null_order='nulls_first';\u201c.  <\/ul>\n<p>\u010ealej m\u00f4\u017ee by\u0165 uveden\u00fd projekt CG\/SQL, vyvinut\u00fd spolo\u010dnos\u0165ou Facebook, ktor\u00fd poskytuje gener\u00e1tor k\u00f3du na pou\u017eitie ulo\u017een\u00fdch proced\u00far s SQLite. CG\/SQL umo\u017e\u0148uje vytvori\u0165 ulo\u017een\u00e9 proced\u00fary v \u0161peci\u00e1lnom dialekte T-SQL (Transact-SQL), ktor\u00fd umo\u017e\u0148uje volanie funkci\u00ed \u0161tandardnej kni\u017enice jazyka C a pr\u00edstup k \u00fadajom v SQLite. Vytvoren\u00e9 ulo\u017een\u00e9 proced\u00fary sa kompiluj\u00fa do k\u00f3du v jazyku C, ktor\u00fd pou\u017e\u00edva SQLite C API na vykon\u00e1vanie zadan\u00fdch akci\u00ed a spracovanie zlo\u017eit\u00fdch dotazov. Kompilovan\u00e9 ulo\u017een\u00e9 proced\u00fary m\u00f4\u017eu by\u0165 pripojen\u00e9 k programom v jazykoch C, Java a Objective-C. K\u00f3d projektu je nap\u00edsan\u00fd v jazyku C a distribuuje sa pod licenciou MIT.<br \/>\n<br \/>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=59157\">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.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 [&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-108630","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - 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.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.\" \/>\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\/sk\/blog\/news\/vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\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.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\" \/>\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.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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sk\/blog\/news\/vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite\" \/>\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-05-19T10:48:16+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-05-19T10:52:41+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\udd47Vydanie SODB SQLite 3.42 a DuckDB 0.8.0. CG\/SQL s implement\u00e1ciou ulo\u017een\u00fdch proced\u00far pre SQLite | ProHoster","description":"Vydan\u00fd release SQLite 3.42, \u013eahkej SODB, formulovanej ako pripojite\u013en\u00e1 kni\u017enica. K\u00f3d SQLite sa distribuuje ako verejn\u00e9 vlastn\u00edctvo (public domain), t.j.","canonical_url":"https:\/\/prohoster.info\/sk\/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":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/108630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=108630"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/108630\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=108630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=108630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=108630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}