{"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\/sq\/blog\/news\/vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite","title":{"rendered":"L\u00ebshimi i DBMS SQLite 3.42 dhe DuckDB 0.8.0. CG\/SQL me implementimin e procedurave t\u00eb ruajtura p\u00ebr SQLite","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Ishte publikuar rilis SQLite 3.42, nj\u00eb DBMS e leht\u00eb, e cila \u00ebsht\u00eb e konceptuar si nj\u00eb bibliotek\u00eb e integruar. Kodi SQLite shp\u00ebrndahet si pron\u00eb publike (public domain), dometh\u00ebn\u00eb mund t\u00eb p\u00ebrdoret pa kufizime dhe falas p\u00ebr \u00e7do q\u00ebllim. Mb\u00ebshtetje financiare p\u00ebr zhvilluesit e SQLite ofron nj\u00eb konsorcium i krijuar posa\u00e7\u00ebrisht, n\u00eb t\u00eb cilin p\u00ebrfshihen kompani si Adobe, Oracle, Mozilla, Bentley dhe Bloomberg.     <\/p>\n<p>Ndryshimet kryesore:  <\/p>\n<ul>\n<li class=\"l\"> P\u00ebr indekset e plot\u00eb FTS5 \u00ebsht\u00eb implementuar komanda secure-delete, e cila kryen pastrimin e plot\u00eb t\u00eb t\u00eb dh\u00ebnave mbet\u00ebse pas fshirjes.\n<li class=\"l\"> N\u00eb funksionet p\u00ebr p\u00ebrpunimin e t\u00eb dh\u00ebnave n\u00eb formatin JSON \u00ebsht\u00eb implementuar mb\u00ebshtetje p\u00ebr zgjerime JSON5.\n<li class=\"l\"> P\u00ebrmir\u00ebsuar planifikuesi i k\u00ebrkesave. Optimizimi \"count-of-view\" tani \u00ebsht\u00eb aktivizuar si parazgjedhje. Trajtimi i kolonave t\u00eb pap\u00ebrdorura n\u00eb n\u00ebnk\u00ebrkesa \u00ebsht\u00eb p\u00ebrjashtuar. Implementimi i optimizimit push-down \u00ebsht\u00eb p\u00ebrmir\u00ebsuar.\n<li class=\"l\"> N\u00eb nd\u00ebrfaqen e komand\u00ebs \u00ebsht\u00eb shtuar opsioni \"\u2014unsafe-testing\", i cili lejon p\u00ebrdorimin e disa komandave t\u00eb rrezikshme, si \"testctrl\", t\u00eb destinuara p\u00ebr t'u p\u00ebrdorur gjat\u00eb testimeve. N\u00eb modin e siguris\u00eb (\"\u2014safe\") lejohet p\u00ebrdorimi i komandave \"log on\" dhe \"log off\". \u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr ndar\u00ebsin \"\u2014\", pas t\u00eb cilit ndalohet trajtimi i opsioneve. Jan\u00eb shtuar parametrat \":inf\" dhe \":nan\", t\u00eb lidhur me vlerat pafund\u00ebsi dhe NaN.\n<li class=\"l\"> N\u00eb emrat e funksioneve SQL t\u00eb p\u00ebrcaktuara nga aplikacioni \u00ebsht\u00eb lejuar kryq\u00ebzimi me fjal\u00ebt ky\u00e7e CROSS, FULL, INNER, LEFT, NATURAL, OUTER dhe RIGHT.\n<li class=\"l\"> Kapasitetet e PRAGMA integrity_check jan\u00eb zgjeruar. \u00cbsht\u00eb shtuar kontrolli i p\u00ebrcaktimit t\u00eb vler\u00ebs NaN n\u00eb kolonat me kusht NOT NULL. Informatat e mesazheve t\u00eb gabimeve jan\u00eb p\u00ebrmir\u00ebsuar.\n<li class=\"l\"> N\u00eb plot\u00ebsimin e sesionit \u00ebsht\u00eb lejuar kapja e ndryshimeve nga tabelat pa ROWID.\n<li class=\"l\"> N\u00eb funksionin p\u00ebr pun\u00ebn me koh\u00ebn dhe datat \u00ebsht\u00eb shtuar modifikuesi \"subsec\" p\u00ebr p\u00ebrdorimin e pjes\u00ebve t\u00eb sekondave.\n<li class=\"l\"> Thell\u00ebsia e rekursionit p\u00ebr array dhe objekte JSON \u00ebsht\u00eb zvog\u00ebluar nga 2000 n\u00eb 1000 si parazgjedhje.      <\/ul>\n<p>P\u00ebrve\u00e7 k\u00ebsaj, \u00ebsht\u00eb formuar versioni i DBMS DuckDB 0.8.0, i cili zhvillon nj\u00eb variant t\u00eb SQLite, t\u00eb zgjeruar me mund\u00ebsi dhe optimizime p\u00ebr ekzekutimin e pyetjeve analitike, q\u00eb mbulojn\u00eb nj\u00eb pjes\u00eb t\u00eb konsiderueshme t\u00eb t\u00eb dh\u00ebnave t\u00eb ruajta, p\u00ebr shembull, duke realizuar agregimin e p\u00ebrmbajtjes s\u00eb tabelave ose bashkimin e disa tabelave t\u00eb m\u00ebdha. Ofron nj\u00eb dialekt t\u00eb zgjeruar t\u00eb gjuh\u00ebs SQL, duke p\u00ebrfshir\u00eb mund\u00ebsi t\u00eb tjera p\u00ebr p\u00ebrpunimin e pyetjeve shum\u00eb komplekse dhe t\u00eb zgjatura, si dhe mb\u00ebshtetje p\u00ebr lloje t\u00eb komplikuara (masiv, struktura, bashkime), ekzekutimin e shum\u00eb pyetjeve nj\u00ebkoh\u00ebsisht dhe ekzekutimin e pyetjeve direkt nga skedar\u00ebt n\u00eb formatet CSV, JSON dhe Parquet. Ka mund\u00ebsi p\u00ebr importimin nga DBMS PostgreSQL.     <\/p>\n<p>P\u00ebrve\u00e7 kodit t\u00eb shell-it nga SQLite, projekti p\u00ebrdor nj\u00eb parser t\u00eb nxjerr\u00eb n\u00eb nj\u00eb bibliotek\u00eb t\u00eb ve\u00e7ant\u00eb nga PostgreSQL, komponentin Date Math nga MonetDB, implementimin e vet t\u00eb funksioneve finesh (bazuar n\u00eb algoritmin Segment Tree Aggregation), nj\u00eb p\u00ebrpunues t\u00eb shprehjeve t\u00eb rregullta t\u00eb bazuar n\u00eb bibliotek\u00ebn RE2, optimizuesin e tij t\u00eb pyetjeve, mekanizmin MVCC p\u00ebr menaxhimin e ekzekutimit t\u00eb shum\u00ebfisht\u00eb t\u00eb detyrave (Kontrolli i Konkurenc\u00ebs me Versione t\u00eb Shumta), si dhe nj\u00eb motor t\u00eb vektorizuar p\u00ebr ekzekutimin e pyetjeve mbi baz\u00ebn e algoritmit Hyper-Pipelining Query Execution, i cili lejon p\u00ebr nj\u00eb operacion t\u00eb vetme t\u00eb p\u00ebrpunoj\u00eb grupe t\u00eb m\u00ebdha vlerash. Kodi i projektit shp\u00ebrndahet n\u00ebn licenc\u00ebn MIT.       <\/p>\n<p>N\u00eb versionin e ri t\u00eb DuckDB:    <\/p>\n<ul>\n<li class=\"l\"> Jan\u00eb shtuar shprehjet e reja \"PIVOT\" dhe \"UNPIVOT\" p\u00ebr transformimin e rreshtave n\u00eb kolona dhe anasjelltas.\n<li class=\"l\"> Jan\u00eb p\u00ebrmir\u00ebsuar paralelizmi gjat\u00eb importit dhe eksportit t\u00eb t\u00eb dh\u00ebnave. Nga java p\u00ebrfundim, lexohet nga skedar\u00ebt n\u00eb formatin CSV n\u00eb disa kanale dhe shkruhen n\u00eb shum\u00eb kanale kur p\u00ebrdoren formatet Parquet, CSV dhe JSON.\n<li class=\"l\"> \u00cbsht\u00eb shtuar operatori \"**\" p\u00ebr iterimin rekurziv t\u00eb katalog\u00ebve gjat\u00eb p\u00ebrcaktimit t\u00eb rrug\u00ebve t\u00eb skedar\u00ebve (p.sh., FROM \u2018data\/glob\/crawl\/stackoverflow\/**\/*.csv\u2019).\n<li class=\"l\"> Jan\u00eb shtuar mb\u00ebshtetje p\u00ebr operacionet e bashkimit (JOIN) p\u00ebr t\u00eb dh\u00ebnat n\u00eb form\u00eb t\u00eb serive temporale (prerjet e vlerave t\u00eb parametrave n\u00eb intervale t\u00eb caktuara kohore), n\u00eb t\u00eb cilat si kriter p\u00ebr bashkimin e regjistrimeve p\u00ebrdoret nj\u00eb p\u00ebrputhje e af\u00ebrt e vlerave n\u00eb fush\u00ebn e koh\u00ebs (p\u00ebr shembull, mund t\u00eb bashkohen regjistrimet, koha e t\u00eb cilave ndryshon jo m\u00eb shum\u00eb se 1 minut\u00eb).\n<li class=\"l\"> \u00ebsht\u00eb realizuar ngarkimi i vonuar i metadatave t\u00eb DB, i cili ka lejuar p\u00ebrshpejtimin e kthimit t\u00eb DBMS deri n\u00eb dhjet\u00ebra her\u00eb.\n<li class=\"l\"> Shtesa e mb\u00ebshtetjes p\u00ebr lidhjen e funksioneve t\u00eb personalizuara n\u00eb gjuh\u00ebn Python.\n<li class=\"l\"> Shtesa e mb\u00ebshtetjes p\u00ebr API ADBC (Arrow Database Connectivity) p\u00ebr kalimin e t\u00eb dh\u00ebnave duke p\u00ebrdorur Apache Arrow.\n<li class=\"l\"> Krijimi i nyj\u00ebs p\u00ebr integrimin me kodin n\u00eb gjuh\u00ebn Swift.\n<li class=\"l\"> Sjellja e operatorit t\u00eb ndarjes (\"\/\") \u00ebsht\u00eb ndryshuar, i cili tani kryen llogaritje me numra me pik\u00eb float si parazgjedhje, n\u00eb vend t\u00eb operacioneve t\u00eb numrave t\u00eb plot\u00eb. P\u00ebr ndarjen e numrave t\u00eb plot\u00eb \u00ebsht\u00eb propozuar nj\u00eb operator i ri \"\/\/\". Sjellja e vjet\u00ebr mund t\u00eb rikthehet duke konfiguruar \"SET integer_division=true;\".\n<li class=\"l\"> Metoda e trajtimit t\u00eb regjistrimeve NULL gjat\u00eb renditjes \u00ebsht\u00eb ndryshuar nga \"NULLS FIRST\" n\u00eb \"NULLS LAST\", dmth. vlerat NULL tani do t\u00eb shfaqen n\u00eb fund t\u00eb list\u00ebs, jo n\u00eb fillim. Sjellja e vjet\u00ebr mund t\u00eb rikthehet duke konfiguroni \"SET default_null_order='nulls_first';\".  <\/ul>\n<p>Gjithashtu mund t\u00eb sh\u00ebnohet projekti CG\/SQL i zhvilluar nga kompania Facebook, i cili ofron nj\u00eb gjenerator kodi p\u00ebr p\u00ebrdorimin e procedurave t\u00eb ruajtura me SQLite. CG\/SQL lejon p\u00ebrgatitjen e procedurave t\u00eb ruajtura n\u00eb nj\u00eb dialekt t\u00eb ve\u00e7ant\u00eb T-SQL (Transact-SQL), q\u00eb lejon thirrjen e funksioneve t\u00eb bibliotek\u00ebs standarde C dhe qasjen n\u00eb t\u00eb dh\u00ebna n\u00eb SQLite. Procedurat e ruajtura t\u00eb krijuara kompilohen n\u00eb kod n\u00eb gjuh\u00ebn C, q\u00eb p\u00ebrdor SQLite C API p\u00ebr ekzekutimin e veprimeve t\u00eb caktuara dhe trajtimin e pyetjeve t\u00eb komplikuara. Procedurat e kompiluar mund t\u00eb lidheshin me programe n\u00eb gjuh\u00ebt C, Java dhe Objective-C. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn MIT.<br \/>\n<br \/>Burimi: <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.2 - 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\/sq\/blog\/news\/vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\/sq\/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\udd47L\u00ebshimi i DBMS SQLite 3.42 dhe DuckDB 0.8.0. CG\/SQL me implementimin e procedurave t\u00eb ruajtura p\u00ebr SQLite | ProHoster","description":"\u00cbsht\u00eb publikuar l\u00ebshimi SQLite 3.42, nj\u00eb DBMS i leht\u00eb, i nd\u00ebrtuar si nj\u00eb bibliotek\u00eb e lidhur. Kodi SQLite shp\u00ebrndahet si pasuri publike (public domain), dmth.","canonical_url":"https:\/\/prohoster.info\/sq\/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":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/108630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=108630"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/108630\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=108630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=108630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=108630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}