{"id":147391,"date":"2025-11-05T17:11:54","date_gmt":"2025-11-05T15:11:54","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-51"},"modified":"2025-11-05T17:11:54","modified_gmt":"2025-11-05T15:11:54","slug":"vypusk-subd-sqlite-3-51","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-sqlite-3-51","title":{"rendered":"L\u00ebshimi i DBMS SQLite 3.51","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Lansohet versioni SQLite 3.51, nj\u00eb DBMS t\u00eb leht\u00eb, e cila ofrohet si nj\u00eb bibliotek\u00eb e integruar. Kodi SQLite distribuohet si pron\u00eb publike, dmth, mund t\u00eb p\u00ebrdoret pa kufizime dhe falas p\u00ebr q\u00ebllime t\u00eb ndryshme. Mb\u00ebshtetja financiare p\u00ebr zhvilluesit e SQLite ofrohet nga nj\u00eb konsorcium i krijuar posa\u00e7\u00ebrisht.     <\/p>\n<p>Ndryshimet kryesore:  <\/p>\n<ul>\n<li class=\"l\"> Jan\u00eb shtuar funksione t\u00eb reja JSON, `jsonb_each()` dhe `jsonb_tree()`, t\u00eb cilat ndryshojn\u00eb nga funksionet e m\u00ebparshme `json_each()` dhe `json_tree()` duke kthyer vler\u00ebn JSONB p\u00ebr t\u00eb dh\u00ebnat me lloj array ose objekt.\n<li class=\"l\"> Kodi i zgjerimeve carray dhe percentile \u00ebsht\u00eb transferuar n\u00eb skedarin themelor &#171;sqlite3.c&#187; me kodin e integruar SQLite. S\u00eb pari, k\u00ebto dodat jan\u00eb t\u00eb \u00e7aktivizuara dhe k\u00ebrkojn\u00eb specifikimin e parametrave &#171;-DSQLITE_ENABLE_CARRAY&#187; dhe &#171;-DSQLITE_ENABLE_PERCENTILE&#187; gjat\u00eb nd\u00ebrtimit.\n<li class=\"l\"> Interfaci p\u00ebr p\u00ebrdorimin e SQLite n\u00eb skriptet Tcl \u00ebsht\u00eb p\u00ebrmir\u00ebsuar. N\u00eb komand\u00ebn &#171;eval&#187; \u00ebsht\u00eb shtuar flaga &#171;-asdict&#187; p\u00ebr t\u00eb kthyer vargjet duke p\u00ebrdorur tipin &#171;dict&#187; n\u00eb vend t\u00eb &#171;array&#187;. \u00cbsht\u00eb shtuar mund\u00ebsia p\u00ebr t\u00eb nd\u00ebrprer\u00eb funksionet e p\u00ebrdoruesit p\u00ebr t\u00eb kthyer vler\u00ebn NULL.\n<li class=\"l\"> Ndryshime n\u00eb nd\u00ebrfaqen e komand\u00ebs:\n<ul>\n<li class=\"l\"> Sakt\u00ebsia e komand\u00ebs &#171;.timer&#187; \u00ebsht\u00eb rritur n\u00eb mikrosekonda;\n<li class=\"l\"> N\u00eb modet e formatimit &#171;box&#187; dhe &#171;column&#187; \u00ebsht\u00eb implementuar mb\u00ebshtetje p\u00ebr karaktere me gjer\u00ebsi t\u00eb dyfisht\u00eb;\n<li class=\"l\"> Komanda &#171;.imposter&#187; tani mund t\u00eb ofroj\u00eb n\u00eb m\u00ebnyr\u00eb leximi skedar\u00eb imposter (t\u00eb cil\u00ebt lejojn\u00eb qasjen n\u00eb t\u00eb dh\u00ebnat n\u00eb indeks si n\u00eb nj\u00eb tabel\u00eb), duke punuar me operacionin VACUUM dhe pa k\u00ebrkuar ekzekutimin me flagun &#171;&#8212;unsafe-testing&#187;;\n<li class=\"l\"> N\u00eb utilitarin sqlite dhe komand\u00ebn &#171;.open&#187; \u00ebsht\u00eb shtuar opsioni &#171;&#8212;ifexists&#187;.\n<li class=\"l\"> Gjer\u00ebsia maksimale e vargjeve e vendosur me komand\u00ebn &#171;.width&#187; \u00ebsht\u00eb kufizuar n\u00eb 30000 karaktere.   <\/ul>\n<li class=\"l\"> Jan\u00eb b\u00ebr\u00eb optimizime t\u00eb performanc\u00ebs:\n<ul>\n<li class=\"l\"> \u00cbsht\u00eb reduktuar ngarkesa mbi CPU gjat\u00eb komitimit t\u00eb transaksioneve t\u00eb kufizuara nga qasja n\u00eb lexim;\n<li class=\"l\"> \u00cbsht\u00eb p\u00ebrmir\u00ebsuar identifikimi i operacioneve t\u00eb bashkimit (JOIN) q\u00eb nuk kthejn\u00eb rreshta p\u00ebr shkak se nj\u00eb ose disa tabela nuk p\u00ebrmbajn\u00eb rreshta;\n<li class=\"l\"> \u00cbsht\u00eb p\u00ebrjashtuar ekzekutimi i n\u00ebnpyetjeve skalar\u00eb q\u00eb nuk ndikojn\u00eb n\u00eb rezultatin;\n<li class=\"l\"> \u00cbsht\u00eb p\u00ebrshpejtuar puna e funksioneve dritare n\u00eb pyetjet me shprehjen &#171;BETWEEN \ud83d\ude21 FOLLOWING AND :y FOLLOWING&#187; dhe nj\u00eb vler\u00eb shum\u00eb t\u00eb madhe p\u00ebr &#171;:y&#187;.   <\/ul>\n<li class=\"l\"> \u00cbsht\u00eb shtuar pragm\u00ebs &#171;PRAGMA wal_checkpoint=NOOP&#187; dhe funksioni API sqlite3_wal_checkpoint() p\u00ebr t\u00eb ruajtur ndryshimet n\u00eb regjistrin WAL.\n<li class=\"l\"> N\u00eb API jan\u00eb shtuar funksionet `sqlite3_set_errmsg()` dhe `sqlite3_db_status64()`.\n<li class=\"l\"> N\u00eb versionin JavaScript\/WASM t\u00eb SQLite \u00ebsht\u00eb realizuar mb\u00ebshtetja p\u00ebr nd\u00ebrtimin n\u00eb formatin WebAssembly me tregues t\u00eb 64-bit.\n<li class=\"l\"> Forcuar stabiliteti ndaj d\u00ebmtimeve t\u00eb BD n\u00eb aplikacionet q\u00eb largojn\u00eb bllokimet POSIX p\u00ebrmes thirrjes close().\n<li class=\"l\"> P\u00ebrmir\u00ebsuar mb\u00ebshtetje p\u00ebr platform\u00ebn VxWorks.      <\/ul>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=64186\">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.51, \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. \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\u044b \u043d\u043e\u0432\u044b\u0435 JSON-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 jsonb_each() \u0438 jsonb_tree(), \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0442\u0441\u044f \u043e\u0442 \u0440\u0430\u043d\u0435\u0435 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 json_each() \u0438 json_tree() \u0442\u0435\u043c, [&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-147391","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - 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.51, \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\/sq\/blog\/news\/vypusk-subd-sqlite-3-51\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 SQLite 3.51 | 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.51, \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\/sq\/blog\/news\/vypusk-subd-sqlite-3-51\" \/>\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=\"2025-11-05T15:11:54+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-11-05T15:11:54+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\udd47Lanzimi i DBMS SQLite 3.51 | ProHoster","description":"Publikuar versioni SQLite 3.51, nj\u00eb DBMS i leht\u00eb, si nj\u00eb bibliotek\u00eb shtes\u00eb. Kodi i SQLite shp\u00ebrndahen si pron\u00eb publike (public domain), dmth.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/vypusk-subd-sqlite-3-51","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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 SQLite 3.51 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.51, \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\/sq\/blog\/news\/vypusk-subd-sqlite-3-51","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":"2025-11-05T15:11:54+00:00","article:modified_time":"2025-11-05T15:11:54+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"147391","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":"2026-01-23 15:46:20","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 15:46:20","updated":"2026-01-23 15:46:20","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\/147391","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=147391"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/147391\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=147391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=147391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=147391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}