{"id":103443,"date":"2022-02-27T15:36:52","date_gmt":"2022-02-27T13:36:52","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-38-i-nabora-utilit-sqlite-utils-3-24"},"modified":"2022-02-27T15:36:52","modified_gmt":"2022-02-27T13:36:52","slug":"vypusk-subd-sqlite-3-38-i-nabora-utilit-sqlite-utils-3-24","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/news\/vypusk-subd-sqlite-3-38-i-nabora-utilit-sqlite-utils-3-24","title":{"rendered":"Az SQLite 3.38 adatb\u00e1zis-kezel\u0151 \u00e9s az sqlite-utils 3.24 eszk\u00f6zk\u00e9szlet kiad\u00e1sa","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Megjelent az SQLite 3.38, a k\u00f6nny\u0171s\u00faly\u00fa DBMS, amely csatolt k\u00f6nyvt\u00e1r form\u00e1j\u00e1ban van kialak\u00edtva. Az SQLite k\u00f3dja k\u00f6zkincs, azaz 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 speci\u00e1lisan l\u00e9trehozott konzorcium biztos\u00edtja, amely olyan c\u00e9gekb\u0151l \u00e1ll, mint az Adobe, Oracle, Mozilla, Bentley \u00e9s Bloomberg.     <\/p>\n<p>F\u0151bb v\u00e1ltoz\u00e1sok:  <\/p>\n<ul>\n<li class=\"l\"> Hozz\u00e1adva a -&gt; \u00e9s -&gt;&gt; oper\u00e1torok t\u00e1mogat\u00e1sa, amelyek egyszer\u0171s\u00edtik az adatok kinyer\u00e9s\u00e9t JSON form\u00e1tumban. Az \u00faj oper\u00e1torok szintaxisa kompatibilis a MySQL \u00e9s a PostgreSQL rendszerekkel.\n<li class=\"l\"> A f\u0151 \u00f6sszetev\u0151 tartalmazza a JSON form\u00e1tumban val\u00f3 adatkezel\u00e9shez sz\u00fcks\u00e9ges funkci\u00f3kat, amelyek kor\u00e1bban a &#171;-DSQLITE_ENABLE_JSON1&#187; kapcsol\u00f3val val\u00f3 \u00f6ssze\u00e1ll\u00edt\u00e1st ig\u00e9nyelt\u00e9k. A JSON t\u00e1mogat\u00e1s\u00e1nak letilt\u00e1s\u00e1hoz hozz\u00e1adott\u00e1k a &#171;-DSQLITE_OMIT_JSON&#187; kapcsol\u00f3t.\n<li class=\"l\"> Hozz\u00e1adva a unixepoch() funkci\u00f3, amely visszaadja az epoch id\u0151t (m\u00e1sodpercek sz\u00e1ma 1970. janu\u00e1r 1. \u00f3ta).\n<li class=\"l\"> Az id\u0151kezel\u0151 funkci\u00f3khoz az &#171;auto&#187; \u00e9s az &#171;julianday&#187; m\u00f3dos\u00edt\u00f3k lettek megval\u00f3s\u00edtva.\n<li class=\"l\"> Az SQL printf() f\u00fcggv\u00e9ny \u00e1tnevez\u00e9sre ker\u00fclt format()-ra a m\u00e1s DBMS-ekkel val\u00f3 jobb kompatibilit\u00e1s \u00e9rdek\u00e9ben (a r\u00e9gi n\u00e9v t\u00e1mogat\u00e1sa megmaradt).\n<li class=\"l\"> Hozz\u00e1adva a sqlite3_error_offset() fel\u00fclet a lek\u00e9rdez\u00e9sekben el\u0151fordul\u00f3 hib\u00e1k hely\u00e9nek egyszer\u0171bb meghat\u00e1roz\u00e1sa \u00e9rdek\u00e9ben.\n<li class=\"l\"> A virtu\u00e1lis t\u00e1bl\u00e1k megval\u00f3s\u00edt\u00e1s\u00e1hoz \u00faj programoz\u00e1si interf\u00e9szek ker\u00fcltek bevezet\u00e9sre: sqlite3_vtab_distinct(), sqlite3_vtab_rhs_value() \u00e9s sqlite3_vtab_in(), valamint \u00faj oper\u00e1tor t\u00edpusok: SQLITE_INDEX_CONSTRAINT_LIMIT \u00e9s SQLITE_INDEX_CONSTRAINT_OFFSET.\n<li class=\"l\"> A parancssori fel\u00fcleten biztos\u00edtva van a tabul\u00e1tor \u00e9s \u00faj sor karakterek helyes kezel\u00e9se a sz\u00f6vegben, amely t\u00f6bb oszlopos m\u00f3dban jelenik meg. Hozz\u00e1adt\u00e1k a &#171;&#8212;wrap N&#187;, &#171;&#8212;wordwrap on&#187; \u00e9s &#171;&#8212;quote&#187; opci\u00f3k haszn\u00e1lat\u00e1nak t\u00e1mogat\u00e1s\u00e1t t\u00f6bboszlopos kimenet eset\u00e9n. Az .import parancs eset\u00e9n a oszlopnevek pontos\u00edt\u00e1sa is biztos\u00edtva van.\n<li class=\"l\"> A lek\u00e9rdez\u00e9stervez\u0151ben a nagy elemz\u00e9si lek\u00e9rdez\u00e9sek v\u00e9grehajt\u00e1s\u00e1nak felgyors\u00edt\u00e1sa \u00e9rdek\u00e9ben val\u00f3sz\u00edn\u0171s\u00e9gi strukt\u00far\u00e1t haszn\u00e1lnak bloom filter form\u00e1j\u00e1ban, amely a k\u00e9szletben l\u00e9v\u0151 elemek megl\u00e9t\u00e9nek meghat\u00e1roz\u00e1s\u00e1ra szolg\u00e1l. Az UNION \u00e9s UNION ALL blokkok feldolgoz\u00e1s\u00e1nak optimaliz\u00e1l\u00e1s\u00e1ra, amelyek SELECT kifejez\u00e9seket tartalmaznak ORDER BY szakaszokkal, kiegyens\u00falyozott \u00f6sszeolvad\u00f3 fa ker\u00fclt alkalmaz\u00e1sra.  <\/ul>\n<p>Tov\u00e1bb\u00e1 megeml\u00edthetj\u00fck az sqlite-utils 3.24 verzi\u00f3 kiad\u00e1s\u00e1t, amely olyan seg\u00e9dprogramokat \u00e9s k\u00f6nyvt\u00e1rat tartalmaz, amelyek lehet\u0151v\u00e9 teszik az SQLite adatb\u00e1zis f\u00e1jlokkal v\u00e9gzett manipul\u00e1ci\u00f3t. T\u00e1mogatott m\u0171veletek k\u00f6z\u00e9 tartozik az adatok k\u00f6zvetlen bet\u00f6lt\u00e9se JSON, CSV vagy TSV f\u00e1jlokb\u00f3l az adatb\u00e1zis f\u00e1jlba, a sz\u00fcks\u00e9ges t\u00e1rol\u00e1si s\u00e9ma automatikus l\u00e9trehoz\u00e1s\u00e1val, SQL lek\u00e9rdez\u00e9sek v\u00e9grehajt\u00e1sa CSV, TSV \u00e9s JSON f\u00e1jlokon, teljes sz\u00f6veg keres\u00e9s az adatb\u00e1zisban, az adatok \u00e9s a t\u00e1rol\u00e1si s\u00e9ma \u00e1talak\u00edt\u00e1sa olyan helyzetekben, amikor az ALTER TABLE nem alkalmazhat\u00f3 (p\u00e9ld\u00e1ul oszlop t\u00edpus\u00e1nak megv\u00e1ltoztat\u00e1sakor), oszlopok kinyer\u00e9se k\u00fcl\u00f6n t\u00e1bl\u00e1kba.<br \/>\n<br \/>Forr\u00e1s: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=56769\">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.38, \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\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043e\u0432 -&gt; [&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-103443","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.38, \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-38-i-nabora-utilit-sqlite-utils-3-24\" \/>\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.38 \u0438 \u043d\u0430\u0431\u043e\u0440\u0430 \u0443\u0442\u0438\u043b\u0438\u0442 sqlite-utils 3.24 | 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.38, \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-38-i-nabora-utilit-sqlite-utils-3-24\" \/>\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=\"2022-02-27T13:36:52+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-02-27T13:36:52+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.38 \u00e9s az sqlite-utils 3.24 seg\u00e9dprogramcsomag kiad\u00e1sa | ProHoster","description":"Megjelent a 3.38-as SQLite, egy k\u00f6nny\u0171s\u00faly\u00fa DBMS, amely dinamikus k\u00f6nyvt\u00e1r form\u00e1j\u00e1ban k\u00e9sz\u00fclt. Az SQLite k\u00f3dja k\u00f6zter\u00fcletk\u00e9nt van terjesztve, azaz.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/vypusk-subd-sqlite-3-38-i-nabora-utilit-sqlite-utils-3-24","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.38 \u0438 \u043d\u0430\u0431\u043e\u0440\u0430 \u0443\u0442\u0438\u043b\u0438\u0442 sqlite-utils 3.24 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.38, \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-38-i-nabora-utilit-sqlite-utils-3-24","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":"2022-02-27T13:36:52+00:00","article:modified_time":"2022-02-27T13:36:52+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"103443","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":"default","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":"2022-02-27 13:38:00","updated":"2022-09-28 10:09:00","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\/103443","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=103443"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/103443\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=103443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=103443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=103443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}