Megjelent az SQLite 3.45, egy k\u00f6nny\u0171 s\u00faly\u00fa adatb\u00e1zis-kezel\u0151 rendszer, amely dinamikusan csatolhat\u00f3 k\u00f6nyvt\u00e1r form\u00e1j\u00e1ban \u00e9rhet\u0151 el. Az SQLite k\u00f3dja k\u00f6zkincs (public domain), azaz korl\u00e1toz\u00e1sok n\u00e9lk\u00fcl \u00e9s ingyenesen felhaszn\u00e1lhat\u00f3 b\u00e1rmilyen c\u00e9lra. Az SQLite fejleszt\u0151it egy k\u00fcl\u00f6n l\u00e9trehozott konzorcium t\u00e1mogatja, amelynek tagjai k\u00f6z\u00f6tt olyan v\u00e1llalatok tal\u00e1lhat\u00f3k, mint a Bentley, Bloomberg, Expensify \u00e9s a Navigation Data Standard. <\/p>\n
F\u0151bb v\u00e1ltoz\u00e1sok: <\/p>\n
Tov\u00e1bbi megjegyz\u00e9s, hogy a SQLite k\u00eds\u00e9rleti kiad\u00e1saiban \u00faj tranzakci\u00f3s napl\u00f3z\u00e1si m\u00f3d \u2014 a WAL2 («PRAGMA journal_mode = wal2») \u2014 ker\u00fclt bevezet\u00e9sre, amely k\u00e9t wal-f\u00e1jlt haszn\u00e1l («database-wal» \u00e9s «database-wal2») egy helyett. Az adatb\u00e1zisba \u00edrt adatok eset\u00e9n az \u00faj adatok els\u0151 wal-f\u00e1jlba ker\u00fclnek. Ha az els\u0151 wal-f\u00e1jl el\u00e9r egy el\u00e9g nagy m\u00e9retet, \u00e1t\u00e1ll\u00e1s t\u00f6rt\u00e9nik a m\u00e1sodik f\u00e1jlra. Miut\u00e1n \u00e1tkapcsoltunk a m\u00e1sodik wal-f\u00e1jlra, az els\u0151 rendelkez\u00e9sre \u00e1ll a v\u00e1ltoz\u00e1sok r\u00f6gz\u00edt\u00e9s\u00e9re (checkpoint) \u00e9s fel\u00fcl\u00edr\u00e1s\u00e1ra. Ennek megfelel\u0151en, amikor a m\u00e1sodik wal-f\u00e1jl el\u00e9ri a nagy m\u00e9retet, \u00e1tkapcsol\u00e1s t\u00f6rt\u00e9nik az els\u0151re, \u00e9s \u00edgy tov\u00e1bb, ami megoldja a probl\u00e9m\u00e1t a wal-f\u00e1jl ellen\u0151rizhetetlen n\u00f6veked\u00e9s\u00e9vel kapcsolatban olyan helyzetekben, amikor a tranzakci\u00f3k hosszabb ideig nem r\u00f6gz\u00fclnek, vagy hossz\u00fa olvas\u00e1si folyamatokat hajtanak v\u00e9gre. \u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.45, \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 Bentley, Bloomberg, Expensify \u0438 Navigation Data Standard. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0412\u0441\u0435 SQL-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f […]<\/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-113031","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47SQLite 3.45 kiad\u00e1s | ProHoster","description":"Megjelent az SQLite 3.45, egy k\u00f6nny\u0171s\u00faly\u00fa adatb\u00e1zis-kezel\u0151, amely dinamikus k\u00f6nyvt\u00e1r form\u00e1j\u00e1ban \u00e9rhet\u0151 el. Az SQLite k\u00f3dja k\u00f6zter\u00fcletre (public domain) ker\u00fcl, azaz.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/vypusk-subd-sqlite-3-45","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.45 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.45, \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-45","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":"2024-01-21T15:28:02+00:00","article:modified_time":"2024-01-21T15:28:02+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\/113031","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=113031"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/113031\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=113031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=113031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=113031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
Forr\u00e1s: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"