{"id":147391,"date":"2025-11-05T17:11:54","date_gmt":"2025-11-05T15:11:54","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-51"},"modified":"2025-11-05T17:11:54","modified_gmt":"2025-11-05T15:11:54","slug":"vypusk-subd-sqlite-3-51","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/news\/vypusk-subd-sqlite-3-51","title":{"rendered":"Megjelent az SQLite 3.51 adatb\u00e1zis-kezel\u0151 rendszer.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Megjelent az SQLite 3.51, egy k\u00f6nny\u0171s\u00faly\u00fa DBMS, amely dinamikus k\u00f6nyvt\u00e1rk\u00e9nt van megfogalmazva. Az SQLite k\u00f3dja k\u00f6zszolg\u00e1ltat\u00e1sk\u00e9nt el\u00e9rhet\u0151, ami azt jelenti, hogy korl\u00e1toz\u00e1sok n\u00e9lk\u00fcl \u00e9s ingyenesen haszn\u00e1lhat\u00f3 b\u00e1rmilyen c\u00e9lra. Az SQLite fejleszt\u0151inek p\u00e9nz\u00fcgyi t\u00e1mogat\u00e1s\u00e1t egy kifejezetten erre a c\u00e9lra l\u00e9trehozott konzorcium biztos\u00edtja. <\/p>\n
F\u0151bb v\u00e1ltoz\u00e1sok: <\/p>\n
\n
\u00daj JSON-funkci\u00f3k, a jsonb_each() \u00e9s a jsonb_tree() ker\u00fcltek bevezet\u00e9sre, amelyek elt\u00e9rnek a kor\u00e1bban el\u00e9rhet\u0151 json_each() \u00e9s json_tree() funkci\u00f3kt\u00f3l, mivel JSONB \u00e9rt\u00e9ket adnak vissza t\u00f6mb vagy objektum t\u00edpus\u00fa adatok eset\u00e9n.\n
A carray and percentile extension code has been moved to the main file «sqlite3.c» with embedded SQLite code. By default, these extensions are disabled and require the parameters «-DSQLITE_ENABLE_CARRAY» and «-DSQLITE_ENABLE_PERCENTILE» to be specified during the build.\n
The interface for using SQLite in Tcl scripts has been improved. A flag «-asdict» has been added to the «eval» command to output strings using the «dict» type instead of «array». It is now possible to interrupt user functions to return a NULL value.\n
V\u00e1ltoz\u00e1sok a parancssori fel\u00fcleten:\n
\n
The accuracy of the «.timer» command has been increased to microseconds.\n
Support for double-width characters has been implemented in the «box» and «column» formatting modes.\n
The «.imposter» command can now provide a read-only imposter table (allowing access to the index data as a table), working with the VACUUM operation and not requiring a launch with the «—unsafe-testing» flag.\n
An «—ifexists» option has been added to the sqlite utility and «.open» command.\n
The maximum string width set by the «.width» command is limited to 30,000 characters. <\/ul>\n
Cs\u00f6kkentett\u00e9k a CPU terhel\u00e9st a csak olvas\u00e1si jogosults\u00e1ggal rendelkez\u0151 tranzakci\u00f3k r\u00f6gz\u00edt\u00e9sekor;\n
Jav\u00edtott\u00e1k az egyes\u00edt\u00e9si (JOIN) m\u0171veletek meghat\u00e1roz\u00e1s\u00e1t, amelyek nem adnak vissza sorokat, mivel az egyik vagy t\u00f6bb t\u00e1bl\u00e1nak nincsenek sorai;\n
Kiz\u00e1rt\u00e1k a sk\u00e1l\u00e1ris alm\u0171veletek v\u00e9grehajt\u00e1s\u00e1t, amelyek nem befoly\u00e1solj\u00e1k az eredm\u00e9nyt;\n
Window function performance has been enhanced in queries with the «BETWEEN \ud83d\ude21 FOLLOWING AND :y FOLLOWING» expression and a very large value of «:y». <\/ul>\n
A pragma «PRAGMA wal_checkpoint=NOOP» and the sqlite3_wal_checkpoint() API function have been added to commit changes to the WAL log.\n
Az API-hoz hozz\u00e1adt\u00e1k az sqlite3_set_errmsg() \u00e9s sqlite3_db_status64() funkci\u00f3kat.\n
A JavaScript\/WASM verzi\u00f3j\u00fa SQLite t\u00e1mogatja a WebAssembly n\u00e9zetben val\u00f3 ford\u00edt\u00e1st 64-bites mutat\u00f3kkal.\n
N\u00f6velt adatb\u00e1zis-v\u00e9delmi ellen\u00e1ll\u00e1s a POSIX z\u00e1rol\u00e1sokat close() h\u00edv\u00e1ssal kezel\u0151 alkalmaz\u00e1sokban.\n