{"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\/sq\/blog\/news\/reliz-subd-sqlite-3-33","title":{"rendered":"L\u00ebshimi i DBMS SQLite 3.33","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/changes.html\">Publikuar<\/a><\/noindex> l\u00ebshimi <noindex><a rel=\"nofollow\" href=\"http:\/\/sqlite.org\/\">SQLite 3.33.0<\/a><\/noindex>, nj\u00eb SGBD i leht\u00eb, e projektuar si nj\u00eb bibliotek\u00eb t\u00eb integruar. Kodi SQLite shp\u00ebrndahet si pron\u00eb publike (public domain), dmth mund t\u00eb p\u00ebrdoret pa kufizime dhe falas p\u00ebr \u00e7do q\u00ebllim. Mb\u00ebshtetje financiare p\u00ebr zhvilluesit e SQLite ofrohet nga nj\u00eb konsorcium i krijuar posa\u00e7\u00ebrisht, i cili p\u00ebrfshin kompani si Adobe, Oracle, Mozilla, Bentley dhe Bloomberg. <\/p>\n<p>Ndryshimet kryesore <noindex><a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_33_0.html\">n\u00eb<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> Implementimi i shprehjes <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/lang_update.html#upfrom\">UPDATE FROM<\/a><\/noindex> p\u00ebr t\u00eb p\u00ebrdit\u00ebsuar p\u00ebrmbajtjen e tabel\u00ebs n\u00eb baz\u00eb t\u00eb nj\u00eb zgjedhjeje nga nj\u00eb tabel\u00eb tjet\u00ebr. N\u00eb shprehje \u00ebsht\u00eb p\u00ebrdorur sintaksa p\u00ebrkat\u00ebse PostgreSQL.\n<li class=\"l\"> Maksimumi i madh\u00ebsis\u00eb s\u00eb DB \u00ebsht\u00eb rritur n\u00eb 281 TB.\n<li class=\"l\"> N\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/pragma.html#pragma_integrity_check\">PRAGMA integrity_check<\/a><\/noindex> siguron mund\u00ebsin\u00eb e kontrollit t\u00eb zgjedhur vet\u00ebm p\u00ebr nj\u00eb tabel\u00eb t\u00eb caktuar dhe indekset e lidhura me t\u00eb (m\u00eb par\u00eb gjithmon\u00eb kontrollohej e gjith\u00eb DB).\n<li class=\"l\"> Shtohet nj\u00eb zgjerim <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/floatingpoint.html#decext\">decimal<\/a><\/noindex> me funksionet e aritmetik\u00ebs dekimale me sakt\u00ebsi t\u00eb rast\u00ebsishme.\n<li class=\"l\"> N\u00eb zgjatimin  <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/floatingpoint.html#ieee754ext\">ieee754<\/a><\/noindex> shtuar p\u00ebrmir\u00ebsime p\u00ebr mb\u00ebshtetje t\u00eb numrave binary64.\n<li class=\"l\"> N\u00eb nd\u00ebrfaqen e linj\u00ebs s\u00eb komandave (CLI)  <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/cli.html#dotmode\">shtuar<\/a><\/noindex> rezime t\u00eb reja t\u00eb formatimit t\u00eb daljes \u00abbox\u00bb, \u00abjson\u00bb, \u00abmarkdown\u00bb dhe \u00abtable\u00bb. N\u00eb modalitetin e daljes \u00abcolumn\u00bb \u00ebsht\u00eb siguruar zgjatja automatike e kolonave sipas p\u00ebrmbajtjes s\u00eb rreshtit m\u00eb t\u00eb gjat\u00eb. N\u00eb modalitetin e daljes \u00abquote\u00bb \u00ebsht\u00eb marr\u00eb parasysh vlera e ndar\u00ebsit, e vendosur nga komanda \u00ab.separator\u00bb.\n<li class=\"l\"> N\u00eb CLI jan\u00eb t\u00eb integruara zgjerimet decimal dhe ieee754.\n<li class=\"l\"> Jan\u00eb b\u00ebr\u00eb p\u00ebrmir\u00ebsime n\u00eb planifikuesin e k\u00ebrkesave. \u00cbsht\u00eb rritur performanca e k\u00ebrkesave \u00abSELECT min(x) FROM t WHERE y IN (?,?,?)\u00bb n\u00eb prani t\u00eb indeksit t(x,y). \u00cbsht\u00eb realizuar p\u00ebrcaktimi i mund\u00ebsis\u00eb s\u00eb p\u00ebrdorimit t\u00eb planit t\u00eb k\u00ebrkes\u00ebs full-index-scan p\u00ebr k\u00ebrkesat me shprehjen \u00abINDEXED BY\u00bb.\n<li class=\"l\"> N\u00eb modin <noindex><a rel=\"nofollow\" href=\"https:\/\/www.sqlite.org\/wal.html\">WAL<\/a><\/noindex> (Write-Ahead Logging) n\u00eb rast t\u00eb d\u00ebshtimit t\u00eb operacionit t\u00eb shkrimit q\u00eb \u00e7on n\u00eb nj\u00eb \u00e7rregullim t\u00eb konsistenc\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb skedarin shm, transaksionet q\u00eb vijn\u00eb tani mund t\u00eb rikuperojn\u00eb integritetin e skedarit shm n\u00eb prani t\u00eb transaksioneve aktive n\u00eb lexim, n\u00eb vend t\u00eb nxjerrjes s\u00eb nj\u00eb gabimi SQLITE_PROTOCOL.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Burimi: <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.0.1 - 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\/sq\/blog\/news\/reliz-subd-sqlite-3-33\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\/sq\/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\udd47L\u00ebshimi i DBMS SQLite 3.33 | ProHoster","description":"\u00cbsht\u00eb publikuar versioni SQLite 3.33.0, nj\u00eb DBMS i leht\u00eb, i dizajnuar p\u00ebr.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/reliz-subd-sqlite-3-33","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/91619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=91619"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/91619\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=91619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=91619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=91619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}