{"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\/sl\/blog\/news\/reliz-subd-sqlite-3-28","title":{"rendered":"Izlazak 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\">\u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d<\/a><\/noindex> izdanje <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.28.0<\/a><\/noindex>, lahka baza podatkov, predstavljena kot dinami\u010dna knji\u017enica. Koda SQLite je na voljo kot javno dobro, kar pomeni, da se lahko uporablja brez omejitev in brezpla\u010dno za vse namene. Razvoj SQLite financira posebni konzorcij, ki vklju\u010duje podjetja, kot so Adobe, Oracle, Mozilla, Bentley in Bloomberg. <\/p>\n<p>Glavne <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_28_0.html\">spremembe<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html\">Raz\u0161irjena<\/a><\/noindex>  okenske funkcije (window-funkcije ali analiti\u010dne funkcije, ki omogo\u010dajo izvajanje izra\u010dunov za vsako vrstico poizvedbe z uporabo drugih vrstic): dodana podpora za izraz <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wexcls\">IZJEMI<\/a><\/noindex>, omogo\u010dena je uporaba <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#wchaining\">verig<\/a><\/noindex> okenskih funkcij (eno okno je definirano z obsegom drugega), zagotovljena <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#grouptype\">podpora<\/a><\/noindex> grupiranja z uporabo izraza GROUP, in implementirana RANGE-omejitve  <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">PRECEDING<\/a><\/noindex> in <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/windowfunctions.html#exprrange\">FOLLOWING<\/a><\/noindex>;\n<li class=\"l\"> Izbolj\u0161ana izvedba ukaza &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_vacuum.html#vacuuminto\">VACUUM INTO<\/a><\/noindex>&#171;, ki se zdaj lahko uporablja z zbirkami podatkov, dostopnimi v na\u010dinu samo za branje;\n<li class=\"l\"> Dodane so nove optimizacije poizvedb: <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/optoverview.html#like_opt\">Pospe\u0161ena<\/a><\/noindex> delovanje izrazov LIKE skupaj s klju\u010dno besedo ESCAPE in pri vklju\u010denem na\u010dinu &#171;PRAGMA case_sensitive_like&#187;. V primeru, da je <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/partialindex.html\">delnega indeksa<\/a><\/noindex> so izklju\u010deni nepotrebni pregledi vnaprej resni\u010dnih pogojev, dolo\u010denih v izrazu WHERE;\n<li class=\"l\"> V CLI vmesnik je dodan ukaz &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/cli.html#param\">.parameter<\/a><\/noindex>&#187; za dolo\u010danje <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/lang_expr.html#varparam\">pripetem nadomestilom<\/a><\/noindex> (mask, ki se uporabljajo v kateremkoli SQL izrazu). V ukazu &#171;.archive&#187; je bila prenovljena mo\u017enost &#171;&#8212;update&#187;, ki zdaj presko\u010di nespremenjene datoteke, ki so \u017ee v arhivu, in dodana mo\u017enost &#171;&#8212;insert&#187; za vklju\u010ditev datotek v arhiv;\n<li class=\"l\"> Dodana je bila nova funkcionalnost <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/file\/ext\/misc\/fossildelta.c\">fossildelta.c<\/a><\/noindex>, ki omogo\u010da ustvarjanje, uporabo in razumevanje <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/fossil\/doc\/trunk\/www\/delta_format.wiki\">format<\/a><\/noindex> delta-sprememb Fossil, ki se uporablja v raz\u0161iritvi RBU;\n<li class=\"l\"> Pove\u010dana zanesljivost pri delu s po\u0161kodovanimi datotekami BDs;\n<li class=\"l\"> Zagnana je bila ogledalo repozitorija projekta na <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/sqlite\/sqlite\">GitHub<\/a><\/noindex> (glavni <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\">repozitorij<\/a><\/noindex> podpira s sistemom za upravljanje razli\u010dic <noindex><a rel=\"nofollow\" href=\"https:\/\/www.fossil-scm.org\/\">Fossil<\/a><\/noindex>, ki ga je ustvaril avtor SQLite).\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Izvor: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=50558\">opennet.ru<\/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.4 - 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\/sl\/blog\/news\/reliz-subd-sqlite-3-28\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sl_SI\" \/>\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\/sl\/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\udd47Izdaja DBMS SQLite 3.28 | ProHoster","description":"Predstavljen je bil izda SQLite.","canonical_url":"https:\/\/prohoster.info\/sl\/blog\/news\/reliz-subd-sqlite-3-28","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sl_SI","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\/sl\/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\/sl\/wp-json\/wp\/v2\/posts\/32210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/comments?post=32210"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/32210\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media?parent=32210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/categories?post=32210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/tags?post=32210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}