{"id":32210,"date":"2019-10-31T21:45:40","date_gmt":"2019-10-31T18:45:40","guid":{"rendered":"https:\/\/prohoster.info\/blog\/reliz-subd-sqlite-3-28\/"},"modified":"2019-10-31T21:45:40","modified_gmt":"2019-10-31T18:45:40","slug":"reliz-subd-sqlite-3-28","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/reliz-subd-sqlite-3-28","title":{"rendered":"Lansarea SGBD-ului SQLite 3.28","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.mail-archive.com\/sqlite-announce@sqlite.org\/msg00078.html\">Prezentat<\/a><\/noindex> lansare <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.28.0<\/a><\/noindex>, o baz\u0103 de date u\u0219oar\u0103, disponibil\u0103 ca bibliotec\u0103 de conectare. Codul SQLite este distribuit ca domeniu public, adic\u0103 poate fi utilizat f\u0103r\u0103 restric\u021bii \u0219i gratuit \u00een orice scop. Suportul financiar pentru dezvoltatorii SQLite este asigurat de un consor\u021biu creat special, care include companii precum Adobe, Oracle, Mozilla, Bentley \u0219i Bloomberg. <\/p>\n<p>Principalele <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_28_0.html\">modific\u0103ri<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html\">Extinse<\/a><\/noindex>  func\u021bii de fereastr\u0103 (func\u021bii de fereastr\u0103 sau func\u021bii analitice care permit realizarea de calcule pentru fiecare linie a interog\u0103rii, folosind alte linii): s-a ad\u0103ugat suport pentru expresii <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wexcls\">EXCLUDE<\/a><\/noindex>, a ap\u0103rut posibilitatea utiliz\u0103rii <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wchaining\">lan\u021burilor<\/a><\/noindex> func\u021biilor de fereastr\u0103 (o fereastr\u0103 este definit\u0103 \u00een cadrul alteia), asigurate <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#grouptype\">suport pentru<\/a><\/noindex> grup\u0103ri prin intermediul expresiei GROUP, \u0219i au fost implementate restric\u021bii de tip RANGE  <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">PRECEDING<\/a><\/noindex> \u0219i <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">FOLLOWING<\/a><\/noindex>;\n<li class=\"l\"> Implementare \u00eembun\u0103t\u0103\u021bit\u0103 a comenzii &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_vacuum.html#vacuuminto\">VACUUM INTO<\/a><\/noindex>&#171;, care poate fi acum utilizat\u0103 cu baze de date disponibile \u00een modul de doar citire;\n<li class=\"l\"> S-au ad\u0103ugat noi optimiz\u0103ri ale interog\u0103rilor: <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/optoverview.html#like_opt\">Accelerat\u0103<\/a><\/noindex> func\u021bionarea expresiilor LIKE \u00eempreun\u0103 cu cuv\u00e2ntul cheie ESCAPE \u0219i cu modul &#171;PRAGMA case_sensitive_like&#187; activat. \u00cen cazul \u00een care <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/partialindex.html\">unui index par\u021bial<\/a><\/noindex> sunt eliminate verific\u0103rile inutile ale condi\u021biilor \u00eentotdeauna adev\u0103rate, specificate \u00een expresia WHERE;\n<li class=\"l\"> \u00cen interfa\u021ba CLI a fost ad\u0103ugat\u0103 comanda &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/cli.html#param\">.parameter<\/a><\/noindex>&#187; pentru a specifica <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_expr.html#varparam\">substitu\u021bii ata\u0219ate<\/a><\/noindex> (m\u0103\u0219ti, utilizate \u00een orice expresii SQL). \u00cen comanda &#171;.archive&#187; a fost reproiectat\u0103 op\u021biunea &#171;&#8212;update&#187;, care acum omite fi\u0219ierele ne modificate care sunt deja \u00een arhiv\u0103, \u0219i a fost ad\u0103ugat\u0103 op\u021biunea &#171;&#8212;insert&#187; pentru includerea fi\u0219ierelor \u00een arhiv\u0103;\n<li class=\"l\"> A fost ad\u0103ugat un supliment <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/file\/ext\/misc\/fossildelta.c\">fossildelta.c<\/a><\/noindex>, care permite crearea, aplicarea \u0219i analiza <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/fossil\/doc\/trunk\/www\/delta_format.wiki\">formatului<\/a><\/noindex> delta-schimb\u0103rilor Fossil, utilizat \u00een extensia RBU;\n<li class=\"l\"> A fost crescut\u0103 fiabilitatea lucrului cu fi\u0219ierele de baze de date corupte;\n<li class=\"l\"> A fost lansat un mirror al repozitorului proiectului pe <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlite\/sqlite\">GitHub<\/a><\/noindex> (principalul <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\">repository<\/a><\/noindex> este men\u021binut cu utilizarea sistemului de gestionare a versiunilor <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/\">Fossil<\/a><\/noindex>, creat de autorul SQLite).\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Sursa: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=50558\">opennet.ro<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.28.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\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u044b \u043e\u043a\u043e\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 (window-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 [&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-32210","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.\" \/>\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\/ro\/blog\/news\/reliz-subd-sqlite-3-28\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\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.28 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/ro\/blog\/news\/reliz-subd-sqlite-3-28\" \/>\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=\"2019-10-31T18:45:40+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:45:40+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\udd47 Lansarea SGBD SQLite 3.28 | ProHoster","description":"A fost lansat\u0103 versiunea SQLite.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/reliz-subd-sqlite-3-28","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","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.28 | ProHoster","og:description":"\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d \u0440\u0435\u043b\u0438\u0437 SQLite.","og:url":"https:\/\/prohoster.info\/ro\/blog\/news\/reliz-subd-sqlite-3-28","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":"2019-10-31T18:45:40+00:00","article:modified_time":"2019-10-31T18:45:40+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"32210","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":"2026-01-21 09:48:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 03:02:47","updated":"2026-01-21 09:48:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/32210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=32210"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/32210\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=32210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=32210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=32210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}