{"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\/no\/blog\/news\/vypusk-subd-sqlite-3-42-i-duckdb-0-8-0-cg-sql-s-realizacziej-hranimyh-proczedur-dlya-sqlite","title":{"rendered":"Utgivelsen av databasen SQLite 3.42 og DuckDB 0.8.0. CG\/SQL med implementering av lagrede prosedyrer for SQLite","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Utgitt er SQLite 3.42, en lettvekts DBMS, designet som et tilleggsbibliotek. Koden til SQLite distribueres som offentlig domene, det vil si at den kan brukes uten begrensninger og gratis for alle form\u00e5l. \u00d8konomisk st\u00f8tte til SQLite-utviklerne gis av et spesialopprettet konsortium, som inkluderer selskaper som Adobe, Oracle, Mozilla, Bentley og Bloomberg.     <\/p>\n<p>Hovedendringer:  <\/p>\n<ul>\n<li class=\"l\"> For fulltekstindekser FTS5 er det implementert en kommando for secure-delete, som utf\u00f8rer en fullstendig rensing av eventuelle gjenv\u00e6rende data etter sletting.\n<li class=\"l\"> I funksjoner for datah\u00e5ndtering i JSON-format er det implementert st\u00f8tte for JSON5-utvidelser.\n<li class=\"l\"> Forbedret foresp\u00f8rselplanlegger. Som standard er optimalisering av \u00abcount-of-view\u00bb aktivert. Behandling av ubrukte kolonner i underforesp\u00f8rslene er utelukket. Implementeringen av push-down-optimalisering er forbedret.\n<li class=\"l\"> Det er lagt til en ny kommando i kommandolinjegrensesnittet \u00ab--unsafe-testing\u00bb, som tillater bruk av visse farlige kommandoer, som \u00ab.testctrl\u00bb, beregnet til testing. I trygt modus (\u00ab--safe\u00bb) er bruk av kommandoene \u00ab.log on\u00bb og \u00ab.log off\u00bb tillatt. St\u00f8tte for separatoren \u00ab--\u00bb er lagt til, for argumenter etter hvilken behandling av alternativer sl\u00e5s av. Det er lagt til parametrene \u00ab:inf\u00bb og \u00ab:nan\u00bb, relatert til verdiene uendelig og NaN.\n<li class=\"l\"> I navnene p\u00e5 SQL-funksjoner definert p\u00e5 applikasjonssiden er kryssing med n\u00f8kkelordene CROSS, FULL, INNER, LEFT, NATURAL, OUTER og RIGHT tillatt.\n<li class=\"l\"> Mulighetene til PRAGMA integrity_check er utvidet. En sjekk for angivelse av verdien NaN i kolonner med forholdet NOT NULL er lagt til. Feilmeldinger har f\u00e5tt bedre informasjonsverdi.\n<li class=\"l\"> I tillegg skal session tillate fangst av endringer fra tabeller uten ROWID.\n<li class=\"l\"> I funksjonen for tid og dato er det lagt til en modifikator \u00absubsec\u00bb for \u00e5 bruke br\u00f8kdeler av sekunder.\n<li class=\"l\"> Standard dybde for rekursjon for JSON-arrays og objekter er redusert fra 2000 til 1000.      <\/ul>\n<p>I tillegg er det lansert en versjon av databasen DuckDB 0.8.0, som utvikler en variant av SQLite, utvidet med funksjoner og optimaliseringer for \u00e5 utf\u00f8re analytiske sp\u00f8rringer som dekker en betydelig del av de lagrede dataene, for eksempel ved \u00e5 aggregere hele innholdet i tabeller eller sl\u00e5 sammen flere store tabeller. Den tilbyr en utvidet SQL-dialekt, som inkluderer ekstra funksjoner for \u00e5 h\u00e5ndtere sv\u00e6rt komplekse og tidkrevende sp\u00f8rringer, samt som st\u00f8tter komplekse datatyper (arrayer, strukturer, unioner), samtidig kj\u00f8ring av flere sp\u00f8rringer, og kan kj\u00f8re sp\u00f8rringer direkte fra filer i formatene CSV, JSON og Parquet. Det er st\u00f8tte for import fra PostgreSQL.     <\/p>\n<p>I tillegg til shell-koden fra SQLite bruker prosjektet en parser fra PostgreSQL, som er flyttet til et eget bibliotek, Date Math-komponenten fra MonetDB, sin egen implementering av vindusfunksjoner (basert p\u00e5 Segment Tree Aggregation-algoritmen), en regul\u00e6r uttrykkbehandler basert p\u00e5 RE2-biblioteket, egne sp\u00f8rringsoptimaliseringsverkt\u00f8y, MVCC-mekanisme for h\u00e5ndtering av samtidig kj\u00f8ring av oppgaver (Multi-Version Concurrency Control), samt en vektorisert foresp\u00f8rselsevalueringsmotor basert p\u00e5 Hyper-Pipelining Query Execution-algoritmen, som gj\u00f8r det mulig \u00e5 h\u00e5ndtere store mengder data i \u00e9n operasjon. Prosjektkoden distribueres under MIT-lisensen.       <\/p>\n<p>I den nye versjonen av DuckDB:    <\/p>\n<ul>\n<li class=\"l\"> Nye uttrykk som \u00abPIVOT\u00bb og \u00abUNPIVOT\u00bb er lagt til for \u00e5 transformere rader til kolonner og omvendt.\n<li class=\"l\"> Parallellisering ved import og eksport av data er forbedret. Som standard er det implementert flere tr\u00e5der for \u00e5 lese fra CSV-filer og flertr\u00e5det skriving ved bruk av Parquet-, CSV- og JSON-formater.\n<li class=\"l\"> Operatoren \u00ab**\u00bb er lagt til for rekursiv gjennomgang av kataloger n\u00e5r filstier bestemmes (f.eks. FROM \u2018data\/glob\/crawl\/stackoverflow\/**\/*.csv\u2019;).\n<li class=\"l\"> St\u00f8tte for sammensl\u00e5ingsoperasjoner (JOIN) for data i form av tidsserier (verdikutt av parametere over angitte tidsintervaller) er lagt til, hvor registreringene sl\u00e5s sammen ved hjelp av ikke-n\u00f8yaktige, men omtrentlige samsvarsverdier i tidsfeltet (for eksempel kan poster sl\u00e5s sammen hvis tiden deres ikke avviker med mer enn 1 minutt).\n<li class=\"l\"> Forsinket lasting av databasemetadata er implementert, noe som har akselerert oppstarten av databasen med flere titalls ganger.\n<li class=\"l\"> St\u00f8tte for tilkobling av brukerdefinerte funksjoner p\u00e5 Python-spr\u00e5ket er lagt til.\n<li class=\"l\"> St\u00f8tte for ADBC API (Arrow Database Connectivity) for dataoverf\u00f8ring med Apache Arrow er lagt til.\n<li class=\"l\"> Binding for integrering med kode p\u00e5 Swift-spr\u00e5ket er implementert.\n<li class=\"l\"> Oppf\u00f8rselen til divisjonsoperatoren (\u00ab\/\u00bb) er endret, den utf\u00f8rer n\u00e5 som standard beregninger med flyttall i stedet for heltallsoperasjoner. En ny operator \u00ab\/\/\u00bb er foresl\u00e5tt for heltallsdivisjon. Den gamle oppf\u00f8rselen kan gjenopprettes ved \u00e5 sette \u00abSET integer_division=true;\u00bb.\n<li class=\"l\"> Metoden for \u00e5 h\u00e5ndtere nullverdier ved sortering er endret fra \u00abNULLS FIRST\u00bb til \u00abNULLS LAST\u00bb, dvs. NULL-verdier vil n\u00e5 vises p\u00e5 slutten av listen i stedet for starten. Den gamle oppf\u00f8rselen kan gjenopprettes ved \u00e5 sette \u00abSET default_null_order='nulls_first';\u00bb.  <\/ul>\n<p>I tillegg kan prosjektet CG\/SQL, utviklet av Facebook, nevnes, som tilbyr en kodegenerator for lagrede prosedyrer med SQLite. CG\/SQL lar deg skrive lagrede prosedyrer i en spesialvariant av T-SQL (Transact-SQL), som tillater anrop av funksjoner fra standard C-biblioteket og tilgang til data i SQLite. De opprettede lagrede prosedyrene blir kompilerte til C-kode, som bruker SQLite C API for \u00e5 utf\u00f8re spesifiserte handlinger og behandle komplekse foresp\u00f8rsel. De kompilerte lagrede prosedyrene kan knyttes til programmer p\u00e5 C, Java og Objective-C. Prosjektkoden er skrevet i C og distribueres under MIT-lisensen.<br \/>\n<br \/>Kilde: <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.5.1 - 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\/no\/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.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"nn_NO\" \/>\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\/no\/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\udd47Utgivelsen av DBMS SQLite 3.42 og DuckDB 0.8.0. CG\/SQL med implementering av lagrede prosedyrer for SQLite | ProHoster","description":"Utgivelsen av SQLite 3.42, en lettvekts DBMS som presenteres som et delt bibliotek, er publisert. Koden til SQLite er tilgjengelig som offentlig domene (public domain), dvs.","canonical_url":"https:\/\/prohoster.info\/no\/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":"nn_NO","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\/no\/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\/no\/wp-json\/wp\/v2\/posts\/108630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/comments?post=108630"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/posts\/108630\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/media?parent=108630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/categories?post=108630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/no\/wp-json\/wp\/v2\/tags?post=108630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}