{"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\/lv\/blog\/news\/reliz-subd-sqlite-3-33","title":{"rendered":"SQLite 3.33 DB rel\u012bze","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/changes.html\">Public\u0113ts<\/a><\/noindex> izlaidums <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.33.0<\/a><\/noindex>, viegli lietojama datub\u0101ze, kas ir pieejama k\u0101 pievienojama bibliot\u0113ka. SQLite kods tiek izplat\u012bts k\u0101 publiskais \u012bpa\u0161ums (public domain), t.i., to var izmantot bez ierobe\u017eojumiem un bez maksas jebkuriem m\u0113r\u0137iem. SQLite izstr\u0101d\u0101t\u0101jus atbalsta speci\u0101li izveidota konsorcijs, kur\u0101 ietilpst t\u0101das komp\u0101nijas k\u0101 Adobe, Oracle, Mozilla, Bentley un Bloomberg. <\/p>\n<p>\u012bpa\u0161\u012bbas <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_33_0.html\">izmai\u0146as<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Izteikums realiz\u0113ts <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_update.html#upfrom\">UPDATE FROM<\/a><\/noindex> lai atjaunin\u0101tu tabulas saturu, pamatojoties uz atlasi no citas tabulas. Izteiksm\u0113 izmantota sintakse, kas atbilst PostgreSQL.\n<li class=\"l\"> Maksim\u0101lais datub\u0101zes izm\u0113rs palielin\u0101ts l\u012bdz 281 TB.\n<li class=\"l\"> No <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/pragma.html#pragma_integrity_check\">PRAGMA integrity_check<\/a><\/noindex> nodro\u0161in\u0101ta iesp\u0113ja veikt selekt\u012bvu p\u0101rbaudi tikai noteiktai tabulai un tai saist\u012btajiem indekiem (iepriek\u0161 vienm\u0113r tika p\u0101rbaud\u012bta visa datub\u0101ze).\n<li class=\"l\"> Pievienots papla\u0161in\u0101jums <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/floatingpoint.html#decext\">decimal<\/a><\/noindex> ar simtiem decim\u0101l\u0101s aritm\u0113tikas funkcij\u0101m ar patva\u013c\u012bgu precizit\u0101ti.\n<li class=\"l\"> Papla\u0161in\u0101jum\u0101  <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/floatingpoint.html#ieee754ext\">ieee754<\/a><\/noindex> iek\u013cauti uzlabojumi atbalstam binary64 skait\u013ciem.\n<li class=\"l\"> Komandu rind\u0101 (CLI)  <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/cli.html#dotmode\">ir pievienotas<\/a><\/noindex> jauni izvades format\u0113\u0161anas re\u017e\u012bmi \u00abbox\u00bb, \u00abjson\u00bb, \u00abmarkdown\u00bb un \u00abtable\u00bb. Izvades re\u017e\u012bm\u0101 \u00abcolumn\u00bb autom\u0101tiski tiek atv\u0113rti kolonnas p\u0113c gar\u0101k\u0101 rindi\u0146as satura. Izvades re\u017e\u012bm\u0101 \u00abquote\u00bb ir \u0146emta v\u0113r\u0101 atdal\u012bt\u0101ja v\u0113rt\u012bba, ko ir noteikusi komanda \u00ab.separator\u00bb.\n<li class=\"l\"> CLI iek\u013cauti papla\u0161in\u0101jumi decimal un ieee754.\n<li class=\"l\"> Ievie\u0161ti uzlabojumi piepras\u012bjumu pl\u0101not\u0101j\u0101. Paaugstin\u0101ta piepras\u012bjumu \u00abSELECT min(x) FROM t WHERE y IN (?,?,?)\u00bb veiktsp\u0113ja, ja ir pieejams indekss t(x,y). Izdar\u012bta iesp\u0113ju noteik\u0161ana izmantot jaut\u0101juma pl\u0101nu full-index-scan piepras\u012bjumiem ar izteiksmi \u00abINDEXED BY\u00bb.\n<li class=\"l\"> Re\u017e\u012bm\u0101 <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/wal.html\">WAL<\/a><\/noindex> (Write-Ahead Logging) gad\u012bjum\u0101, ja ieraksta oper\u0101cijas k\u013c\u016bme, kas izraisa datu konsistences p\u0101rk\u0101pumu fail\u0101 shm, sekojo\u0161\u0101s transakcijas tagad var atjaunot shm faila integrit\u0101ti, ja ir akt\u012bvas las\u012b\u0161anas transakcijas, nevis izraisot k\u013c\u016bdu SQLITE_PROTOCOL.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Avots: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=53552\">opennet.lv<\/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.5 - 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\/lv\/blog\/news\/reliz-subd-sqlite-3-33\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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\/lv\/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 DB rel\u012bze | ProHoster","description":"Public\u0113ta SQLite 3.33.0, viegla DBMS, kas noform\u0113ta.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/reliz-subd-sqlite-3-33","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\/lv\/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\/lv\/wp-json\/wp\/v2\/posts\/91619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=91619"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/91619\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=91619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=91619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=91619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}