{"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\/hu\/blog\/news\/vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite","title":{"rendered":"Megjelent az SQLite 3.42 \u00e9s a DuckDB 0.8.0. CG\/SQL t\u00e1rolt elj\u00e1r\u00e1sok megval\u00f3s\u00edt\u00e1s\u00e1val az SQLite sz\u00e1m\u00e1ra.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Megjelent az SQLite 3.42, egy k\u00f6nny\u0171s\u00faly\u00fa DBMS, amely plug-in k\u00f6nyvt\u00e1rr\u00e1 van form\u00e1zva. Az SQLite k\u00f3dja k\u00f6zkincs (public domain), azaz korl\u00e1toz\u00e1sok n\u00e9lk\u00fcl haszn\u00e1lhat\u00f3 \u00e9s ingyenesen b\u00e1rmilyen c\u00e9lra. Az SQLite fejleszt\u0151inek p\u00e9nz\u00fcgyi t\u00e1mogat\u00e1s\u00e1t egy k\u00fcl\u00f6n l\u00e9trehozott konzorcium biztos\u00edtja, amelyben olyan c\u00e9gek szerepelnek, mint az Adobe, Oracle, Mozilla, Bentley \u00e9s Bloomberg.     <\/p>\n<p>F\u0151bb v\u00e1ltoz\u00e1sok:  <\/p>\n<ul>\n<li class=\"l\"> A FTS5 teljes sz\u00f6veges indexekhez a secure-delete parancs val\u00f3s\u00edtja meg a t\u00f6rl\u00e9s ut\u00e1ni maradv\u00e1nyadatok teljes elt\u00e1vol\u00edt\u00e1s\u00e1t.\n<li class=\"l\"> A JSON form\u00e1tum\u00fa adatok feldolgoz\u00e1s\u00e1ra szolg\u00e1l\u00f3 funkci\u00f3kban a JSON5 kiterjeszt\u00e9sek t\u00e1mogat\u00e1sa val\u00f3sult meg.\n<li class=\"l\"> Jav\u00edtott\u00e1k a lek\u00e9rdez\u00e9s-tervez\u0151t. Alap\u00e9rtelmez\u00e9s szerint aktiv\u00e1lva van a 'count-of-view' optimaliz\u00e1l\u00e1s. Kiz\u00e1rt\u00e1k a nem haszn\u00e1lt oszlopok feldolgoz\u00e1s\u00e1t az al-lek\u00e9rdez\u00e9sekben. Fejlesztett\u00e9k a push-down optimaliz\u00e1l\u00e1s megval\u00f3s\u00edt\u00e1s\u00e1t.\n<li class=\"l\"> A parancssoros fel\u00fclethez hozz\u00e1adt\u00e1k az '--unsafe-testing' opci\u00f3t, amely lehet\u0151v\u00e9 teszi bizonyos vesz\u00e9lyes parancsok, p\u00e9ld\u00e1ul a '.testctrl' haszn\u00e1lat\u00e1t, amelyek tesztel\u00e9shez vannak sz\u00e1nva. Biztons\u00e1gos m\u00f3dban ('--safe') enged\u00e9lyezett a '.log on' \u00e9s '.log off' parancsok haszn\u00e1lata. Hozz\u00e1adt\u00e1k a '--' elv\u00e1laszt\u00f3t, amely ut\u00e1n az opci\u00f3k feldolgoz\u00e1sa letilt\u00e1sra ker\u00fcl. \u00daj ':inf' \u00e9s ':nan' param\u00e9terek kapcsol\u00f3dnak a v\u00e9gtelen \u00e9s NaN \u00e9rt\u00e9kekhez.\n<li class=\"l\"> Az alkalmaz\u00e1soldalon defini\u00e1lt SQL-funkci\u00f3k neveiben megengedett a keresztez\u0151d\u00e9s a CROSS, FULL, INNER, LEFT, NATURAL, OUTER \u00e9s RIGHT kulcsszavakkal.\n<li class=\"l\"> Kib\u0151v\u00edtett\u00e9k a PRAGMA integrity_check lehet\u0151s\u00e9geit. Hozz\u00e1adt\u00e1k a NaN \u00e9rt\u00e9k megad\u00e1s\u00e1nak ellen\u0151rz\u00e9s\u00e9t a NOT NULL felt\u00e9tellel rendelkez\u0151 oszlopokban. Javult a hiba\u00fczenetek t\u00e1j\u00e9koztat\u00f3 jellege.\n<li class=\"l\"> A session kieg\u00e9sz\u00edt\u00e9sben enged\u00e9lyezve van a ROWID n\u00e9lk\u00fcli t\u00e1bl\u00e1kb\u00f3l sz\u00e1rmaz\u00f3 v\u00e1ltoz\u00e1sok elfog\u00e1sa.\n<li class=\"l\"> Az id\u0151- \u00e9s d\u00e1tumkezel\u0151 funkci\u00f3hoz hozz\u00e1adt\u00e1k a 'subsec' m\u00f3dos\u00edt\u00f3t a m\u00e1sodpercek t\u00f6red\u00e9keinek felhaszn\u00e1l\u00e1s\u00e1ra.\n<li class=\"l\"> A JSON t\u00f6mb\u00f6k \u00e9s objektumok rekurzi\u00f3 m\u00e9lys\u00e9ge alap\u00e9rtelmez\u00e9s szerint 2000-r\u0151l 1000-re cs\u00f6kkent.      <\/ul>\n<p>Ezen k\u00edv\u00fcl elk\u00e9sz\u00fclt a DuckDB 0.8.0 kiad\u00e1sa, amely az SQLite tov\u00e1bbfejlesztett v\u00e1ltozata, optimaliz\u00e1lva az analitikai lek\u00e9rdez\u00e9sek futtat\u00e1s\u00e1ra, amelyek a t\u00e1rolt adatok jelent\u0151s r\u00e9sz\u00e9t lefedik, p\u00e9ld\u00e1ul az \u00f6sszes t\u00e1bl\u00e1zat tartalm\u00e1nak aggreg\u00e1l\u00e1s\u00e1t vagy t\u00f6bb nagy t\u00e1bl\u00e1zat egyes\u00edt\u00e9s\u00e9t. Az SQL nyelv kiterjesztett dialektus\u00e1t biztos\u00edtja, amely tov\u00e1bbi lehet\u0151s\u00e9geket tartalmaz nagyon bonyolult \u00e9s hossz\u00fa ideig tart\u00f3 lek\u00e9rdez\u00e9sek kezel\u00e9s\u00e9re, valamint t\u00e1mogatja a bonyolult t\u00edpusokat (t\u00f6mb\u00f6k, strukt\u00far\u00e1k, uni\u00f3k), t\u00f6bb lek\u00e9rdez\u00e9s p\u00e1rhuzamos v\u00e9grehajt\u00e1s\u00e1t \u00e9s a lek\u00e9rdez\u00e9sek k\u00f6zvetlen v\u00e9grehajt\u00e1s\u00e1t CSV, JSON \u00e9s Parquet form\u00e1tum\u00fa f\u00e1jlokb\u00f3l. Lehets\u00e9ges import\u00e1lni a PostgreSQL adatb\u00e1zisb\u00f3l.     <\/p>\n<p>A SQLite burkol\u00f3 k\u00f3dj\u00e1n k\u00edv\u00fcl a projekt egy k\u00fcl\u00f6n k\u00f6nyvt\u00e1rba kiemelt PostgreSQL parser-t, MonetDB-b\u00f3l sz\u00e1rmaz\u00f3 Date Math komponenst, saj\u00e1t implement\u00e1ci\u00f3t az ablakos funkci\u00f3khoz (a Segment Tree Aggregation algoritmus alapjain), a RE2 k\u00f6nyvt\u00e1ron alapul\u00f3 regul\u00e1ris kifejez\u00e9s kezel\u0151t, egy saj\u00e1t lek\u00e9rdez\u00e9s optimaliz\u00e1l\u00f3t, MVCC feladatkezel\u00e9si mechanizmust (Multi-Version Concurrency Control), valamint egy Hyper-Pipelining Query Execution algoritmuson alapul\u00f3 vektoriz\u00e1lt lek\u00e9rdez\u00e9s v\u00e9grehajt\u00f3 motort is haszn\u00e1l, amely lehet\u0151v\u00e9 teszi nagy adat\u00e9rt\u00e9khalmazok p\u00e1rhuzamos feldolgoz\u00e1s\u00e1t egyetlen m\u0171velet sor\u00e1n. A projekt k\u00f3dja MIT licenc alatt ker\u00fcl forgalomba.       <\/p>\n<p>Az \u00faj DuckDB verzi\u00f3ban:    <\/p>\n<ul>\n<li class=\"l\"> \u00daj 'PIVOT' \u00e9s 'UNPIVOT' kifejez\u00e9sek ker\u00fcltek hozz\u00e1ad\u00e1sra a sorok oszlopokk\u00e1, illetve az oszlopok sorokk\u00e1 alak\u00edt\u00e1s\u00e1hoz.\n<li class=\"l\"> Javult az adatok import\u00e1l\u00e1s\u00e1nak \u00e9s export\u00e1l\u00e1s\u00e1nak p\u00e1rhuzamos\u00edt\u00e1sa. Alap\u00e9rtelmez\u00e9s szerint a CSV form\u00e1tum\u00fa f\u00e1jlok olvas\u00e1sa t\u00f6bb sz\u00e1lon, m\u00edg a Parquet, CSV \u00e9s JSON form\u00e1tumok eset\u00e9n t\u00f6bb sz\u00e1lon t\u00f6rt\u00e9nik a \u00edr\u00e1s.\n<li class=\"l\"> Hozz\u00e1adt\u00e1k a '**' oper\u00e1tort a f\u00e1jl\u00fatvonalak meghat\u00e1roz\u00e1s\u00e1hoz sz\u00fcks\u00e9ges rekurz\u00edv k\u00f6nyvt\u00e1rbej\u00e1r\u00e1s sor\u00e1n (p\u00e9ld\u00e1ul: FROM 'data\/glob\/crawl\/stackoverflow\/**\/*.csv').\n<li class=\"l\"> Hozz\u00e1adva a csatlakoz\u00e1si (JOIN) m\u0171veletek t\u00e1mogat\u00e1sa id\u0151beli sorozatk\u00e9nt \u00e1br\u00e1zolt adatok eset\u00e9n (parameter v\u00e1g\u00e1s megfelel\u0151 id\u0151k\u00f6z\u00f6nk\u00e9nt), ahol a rekordok \u00f6sszekapcsol\u00e1s\u00e1nak krit\u00e9riuma nem pontos, hanem megk\u00f6zel\u00edt\u0151leges \u00e9rt\u00e9kek egyeztet\u00e9se az id\u0151mez\u0151ben (p\u00e9ld\u00e1ul lehet\u0151s\u00e9g van \u00f6sszevonni azokat a rekordokat, amelyek id\u0151pontja legfeljebb 1 perccel k\u00fcl\u00f6nb\u00f6zik).\n<li class=\"l\"> Megval\u00f3s\u00edtott\u00e1k az adatb\u00e1zis metainform\u00e1ci\u00f3inak k\u00e9sleltetett bet\u00f6lt\u00e9s\u00e9t, amely t\u00f6bb t\u00edzszeres\u00e9re gyors\u00edtotta az adatb\u00e1zis elind\u00edt\u00e1s\u00e1t.\n<li class=\"l\"> T\u00e1mogat\u00e1s ker\u00fclt hozz\u00e1ad\u00e1sra a felhaszn\u00e1l\u00f3i funkci\u00f3k Python nyelven t\u00f6rt\u00e9n\u0151 csatlakoztat\u00e1s\u00e1hoz.\n<li class=\"l\"> Hozz\u00e1adva az ADBC (Arrow Database Connectivity) API t\u00e1mogat\u00e1sa az adatok Apache Arrow haszn\u00e1lat\u00e1val t\u00f6rt\u00e9n\u0151 tov\u00e1bb\u00edt\u00e1s\u00e1hoz.\n<li class=\"l\"> Megval\u00f3s\u00edtva a Swift nyelv\u0171 k\u00f3dokkal val\u00f3 integr\u00e1ci\u00f3s k\u00f6tel\u00e9k.\n<li class=\"l\"> Megv\u00e1ltozott a '\/' oper\u00e1tor viselked\u00e9se, mostant\u00f3l alap\u00e9rtelmez\u00e9s szerint lebeg\u0151pontos sz\u00e1m\u00edt\u00e1sokat v\u00e9gez, nem eg\u00e9sz sz\u00e1m m\u0171veleteket. Az eg\u00e9sz sz\u00e1mok oszt\u00e1s\u00e1ra \u00faj '\/\/' oper\u00e1tort javasolnak. A r\u00e9gi viselked\u00e9s vissza\u00e1ll\u00edthat\u00f3 a 'SET integer_division=true;' be\u00e1ll\u00edt\u00e1ssal.\n<li class=\"l\"> A null \u00e9rt\u00e9kek kezel\u00e9si m\u00f3dja a rendez\u00e9s sor\u00e1n megv\u00e1ltozott a 'NULLS FIRST'-r\u0151l 'NULLS LAST'-ra, azaz a NULL \u00e9rt\u00e9kek most a lista v\u00e9g\u00e9n fognak megjelenni, nem pedig az elej\u00e9n. A r\u00e9gi viselked\u00e9s vissza\u00e1ll\u00edthat\u00f3 a 'SET default_null_order='nulls_first';' be\u00e1ll\u00edt\u00e1ssal.  <\/ul>\n<p>Tov\u00e1bb\u00e1 eml\u00edthet\u0151 a Facebook \u00e1ltal fejlesztett CG\/SQL projekt, amely t\u00e1rolt elj\u00e1r\u00e1sok haszn\u00e1lat\u00e1ra k\u00f3dgener\u00e1l\u00f3t biztos\u00edt SQLite-hoz. A CG\/SQL lehet\u0151v\u00e9 teszi a t\u00e1rolt elj\u00e1r\u00e1sok megfogalmaz\u00e1s\u00e1t egy speci\u00e1lis T-SQL (Transact-SQL) dialektusban, amely lehet\u0151v\u00e9 teszi a szabv\u00e1nyos C k\u00f6nyvt\u00e1r f\u00fcggv\u00e9nyeinek h\u00edv\u00e1s\u00e1t \u00e9s az adatok el\u00e9r\u00e9s\u00e9t SQLite-ban. A l\u00e9trehozott t\u00e1rolt elj\u00e1r\u00e1sok C nyelven k\u00f3dol\u00f3dnak, \u00e9s SQLite C API-t haszn\u00e1lnak a megadott m\u0171veletek v\u00e9grehajt\u00e1s\u00e1ra \u00e9s \u00f6sszetett lek\u00e9rdez\u00e9sek kezel\u00e9s\u00e9re. A leford\u00edtott t\u00e1rolt elj\u00e1r\u00e1sok csatlakoztathat\u00f3k C, Java \u00e9s Objective-C nyelven \u00edrt programokhoz. A projekt k\u00f3dja C nyelven van kidolgozva \u00e9s MIT licenc alatt terjesztik.<br \/>\n<br \/>Forr\u00e1s: <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.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.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\/hu\/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.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\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\/hu\/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\udd47Az SQLite 3.42 \u00e9s a DuckDB 0.8.0 kiad\u00e1sa. CG\/SQL t\u00e1rolt elj\u00e1r\u00e1sok megval\u00f3s\u00edt\u00e1ssal SQLite-hoz | ProHoster","description":"Megjelent az SQLite 3.42, egy k\u00f6nny\u0171s\u00faly\u00fa DBMS, amely dinamikusan bet\u00f6lthet\u0151 k\u00f6nyvt\u00e1r form\u00e1j\u00e1ban van megjelen\u00edtve. Az SQLite k\u00f3dja k\u00f6z\u00e9rdek\u0171 tulajdonk\u00e9nt (public domain) terjesztett.","canonical_url":"https:\/\/prohoster.info\/hu\/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":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/108630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=108630"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/108630\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=108630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=108630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=108630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}