{"id":91619,"date":"2020-08-15T13:42:36","date_gmt":"2020-08-15T11:42:36","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-sqlite-3-33"},"modified":"2020-08-15T13:42:36","modified_gmt":"2020-08-15T11:42:36","slug":"reliz-subd-sqlite-3-33","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/news\/reliz-subd-sqlite-3-33","title":{"rendered":"Az SQLite 3.33 megjelen\u00e9se","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/changes.html\">Megjelent<\/a><\/noindex> kiad\u00e1s <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.33.0<\/a><\/noindex>, egy k\u00f6nny\u0171s\u00faly\u00fa adatb\u00e1zis-kezel\u0151 rendszer, amely csatolhat\u00f3 k\u00f6nyvt\u00e1r form\u00e1j\u00e1ban \u00e9rhet\u0151 el. Az SQLite k\u00f3dja k\u00f6zvagyonnak min\u0151s\u00fcl, azaz korl\u00e1toz\u00e1sok n\u00e9lk\u00fcl, ingyenesen felhaszn\u00e1lhat\u00f3 b\u00e1rmilyen c\u00e9lra. Az SQLite fejleszt\u0151inek p\u00e9nz\u00fcgyi t\u00e1mogat\u00e1s\u00e1t egy kifejezetten l\u00e9trehozott konzorcium biztos\u00edtja, amelynek tagjai olyan c\u00e9gek, mint az Adobe, az Oracle, a Mozilla, a Bentley \u00e9s a Bloomberg. <\/p>\n<p>F\u0151 <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_33_0.html\">v\u00e1ltoz\u00e1sok<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Kifejez\u00e9s megval\u00f3s\u00edtva <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_update.html#upfrom\">UPDATE FROM<\/a><\/noindex> az egy m\u00e1sik t\u00e1bl\u00e1b\u00f3l sz\u00e1rmaz\u00f3 lek\u00e9rdez\u00e9s alapj\u00e1n a t\u00e1bl\u00e1zat tartalm\u00e1nak friss\u00edt\u00e9s\u00e9hez. A kifejez\u00e9s a PostgreSQL-nek megfelel\u0151 szintaxist haszn\u00e1lja.\n<li class=\"l\"> Az adatb\u00e1zis maxim\u00e1lis m\u00e9rete 281 TB-ra n\u00f6vekedett.\n<li class=\"l\"> A <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/pragma.html#pragma_integrity_check\">PRAGMA integrity_check<\/a><\/noindex> lehet\u0151v\u00e9 tette egy adott t\u00e1bla \u00e9s a hozz\u00e1 kapcsol\u00f3d\u00f3 indexek szelekt\u00edv ellen\u0151rz\u00e9s\u00e9t (kor\u00e1bban mindig az eg\u00e9sz adatb\u00e1zist ellen\u0151rizt\u00e9k).\n<li class=\"l\"> UINT collating sequence <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/floatingpoint.html#decext\">decimal<\/a><\/noindex> tizedes sz\u00e1m\u00edt\u00e1si funkci\u00f3kkal tetsz\u0151leges pontoss\u00e1ggal.\n<li class=\"l\"> A b\u0151v\u00edtm\u00e9ny  <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/floatingpoint.html#ieee754ext\">ieee754<\/a><\/noindex> fejleszt\u00e9sek t\u00f6rt\u00e9ntek a binary64 sz\u00e1mok t\u00e1mogat\u00e1s\u00e1ra.\n<li class=\"l\"> A parancssori fel\u00fclet (CLI)  <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/cli.html#dotmode\">hozz\u00e1adva<\/a><\/noindex> \u00daj kimeneti form\u00e1z\u00e1si m\u00f3dok: \u00abbox\u00bb, \u00abjson\u00bb, \u00abmarkdown\u00bb \u00e9s \u00abtable\u00bb. A \u00abcolumn\u00bb kimeneti m\u00f3dban automatikusan kib\u0151v\u00fclnek az oszlopok a leghosszabb sor tartalma szerint. A \u00abquote\u00bb kimeneti m\u00f3dban figyelembe veszi a \u00ab.separator\u00bb parancs \u00e1ltal meghat\u00e1rozott elv\u00e1laszt\u00f3 \u00e9rt\u00e9k\u00e9t.\n<li class=\"l\"> A CLI integr\u00e1lja a decimal \u00e9s ieee754 kiterjeszt\u00e9seket.\n<li class=\"l\"> Fejleszt\u00e9sek t\u00f6rt\u00e9ntek a lek\u00e9rdez\u00e9sek \u00fctemez\u0151j\u00e9ben. N\u00f6velt\u00fck a \u00abSELECT min(x) FROM t WHERE y IN (?,?,?)\u00bb lek\u00e9rdez\u00e9sek teljes\u00edtm\u00e9ny\u00e9t a t(x,y) index megl\u00e9te mellett. Megval\u00f3s\u00edtottuk a full-index-scan lek\u00e9rdez\u00e9si terv\u00e9nek lehet\u0151s\u00e9g\u00e9t az \u00abINDEXED BY\u00bb kifejez\u00e9st tartalmaz\u00f3 lek\u00e9rdez\u00e9sekhez.\n<li class=\"l\"> A <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/wal.html\">WAL<\/a><\/noindex> (Write-Ahead Logging) \u00edr\u00e1si m\u0171velet hiba eset\u00e9n, amely adatinkonziszenci\u00e1hoz vezet a shm f\u00e1jlban, a k\u00f6vetkez\u0151 tranzakci\u00f3k mostant\u00f3l helyre\u00e1ll\u00edthatj\u00e1k a shm f\u00e1jl integrit\u00e1s\u00e1t, ha akt\u00edv olvas\u00f3 tranzakci\u00f3k vannak, ahelyett, hogy SQLITE_PROTOCOL hib\u00e1t adna vissza.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Forr\u00e1s: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=53552\">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.33.0, \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: \u0420\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043e \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435 UPDATE FROM [&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-91619","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.33.0, \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.\" \/>\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\/reliz-subd-sqlite-3-33\" \/>\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\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 SQLite 3.33 | 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.33.0, \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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hu\/blog\/news\/reliz-subd-sqlite-3-33\" \/>\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=\"2020-08-15T11:42:36+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-08-15T11:42:36+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\udd47SQLite 3.33 DBMS kiad\u00e1s | ProHoster","description":"Megjelent az SQLite 3.33.0, egy k\u00f6nny\u0171 s\u00faly\u00fa DBMS, amelyet a ProHoster k\u00e9sz\u00edtett.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/reliz-subd-sqlite-3-33","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\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 SQLite 3.33 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.33.0, \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.","og:url":"https:\/\/prohoster.info\/hu\/blog\/news\/reliz-subd-sqlite-3-33","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":"2020-08-15T11:42:36+00:00","article:modified_time":"2020-08-15T11:42:36+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"91619","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 12:24:23","updated":"2022-10-04 01:08:05","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/91619","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=91619"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/91619\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=91619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=91619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=91619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}