{"id":113031,"date":"2024-01-21T17:28:02","date_gmt":"2024-01-21T15:28:02","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-45"},"modified":"2024-01-21T17:28:02","modified_gmt":"2024-01-21T15:28:02","slug":"vypusk-subd-sqlite-3-45","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-45","title":{"rendered":"L\u00ebshimi i SGBD SQLite 3.45","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u00cbsht\u00eb publikuar versioni SQLite 3.45, nj\u00eb SGBD e leht\u00eb, e konceptuar si nj\u00eb bibliotek\u00eb e integrueshme. Kodi SQLite shp\u00ebrndahet si pron\u00eb publike (public domain), dmth mund t\u00eb p\u00ebrdoret pa kufizime dhe pa pages\u00eb p\u00ebr \u00e7do q\u00ebllim. Mb\u00ebshtetja financiare p\u00ebr zhvilluesit e SQLite sigurohet nga nj\u00eb konsorcium i krijuar posa\u00e7\u00ebrisht, i cili p\u00ebrfshin kompani si Bentley, Bloomberg, Expensify dhe Navigation Data Standard.    <\/p>\n<p>Ndryshimet kryesore:  <\/p>\n<ul>\n<li class=\"l\"> T\u00eb gjitha funksionet SQL p\u00ebr t\u00eb punuar me formatin JSON jan\u00eb rishkruar dhe p\u00ebrkthyer n\u00eb nj\u00eb format t\u00eb ri t\u00eb brendsh\u00ebm t\u00eb pem\u00ebs s\u00eb analiz\u00ebs JSONB, i cili serializohet dhe mund t\u00eb ruhet n\u00eb DB p\u00ebr t\u00eb shmangur rishikimin e p\u00ebrs\u00ebritur kur p\u00ebrdoren vlera JSON. Versionet e reja t\u00eb funksioneve q\u00eb formojn\u00eb JSON tani gjenerojn\u00eb formatin binar JSONB n\u00eb vend t\u00eb atij tekstual. Funkioni json_valid() ka shtuar nj\u00eb argument t\u00eb dyt\u00eb opsional, p\u00ebrmes t\u00eb cilit mund t\u00eb caktohet nj\u00eb mask\u00eb bitore, e cila p\u00ebrcakton karakteristikat e sakt\u00eb t\u00eb JSON (p\u00ebr shembull, me caktimin 0x04 do t\u00eb pranohet si i sakt\u00eb blob-i JSONB, me caktimin 0x01 JSON-i tekstual n\u00eb formatin RFC-8259, dhe me caktimin 0x05 t\u00eb dy variantet).\n<li class=\"l\"> N\u00eb tabel\u00ebn virtuale FTS5, e cila p\u00ebrdoret p\u00ebr k\u00ebrkimin me tekst t\u00eb plot\u00eb, \u00ebsht\u00eb shtuar opsioni tokendata, q\u00eb lejon p\u00ebrdorimin e tokenizuesve t\u00eb vet.\n<li class=\"l\"> Optimizimi SQLITE_DIRECT_OVERFLOW_READ \u00ebsht\u00eb aktivizuar si standart, ku faqet overflow, t\u00eb cilat kan\u00eb madh\u00ebsi m\u00eb t\u00eb madhe se madh\u00ebsia standarde e faqes b-tree, lexohen direkt nga skedari, duke anashkaluar cache-n. P\u00ebr t\u00eb \u00e7aktivizuar k\u00ebt\u00eb gjat\u00eb nd\u00ebrtimit, mund t\u00eb p\u00ebrdorni opsionin &#171;-DSQLITE_DIRECT_OVERFLOW_READ=0&#187;.\n<li class=\"l\"> N\u00eb planifikuesin e k\u00ebrkesave \u00ebsht\u00eb rritur efikasiteti i optimizimit t\u00eb kufijve transitive dhe \u00ebsht\u00eb p\u00ebrmir\u00ebsuar injorimi i indekseve q\u00eb jan\u00eb t\u00eb njohura si t\u00eb cil\u00ebsis\u00eb t\u00eb ul\u00ebt gjat\u00eb ekzekutimit t\u00eb operacionit ANALYZE.\n<li class=\"l\"> N\u00eb nd\u00ebrfaqen e komand\u00ebs, \u00ebsht\u00eb p\u00ebrmir\u00ebsuar shfaqja e p\u00ebrmbajtjes n\u00eb kodimin UTF-8 n\u00eb platform\u00ebn Windows. \u00cbsht\u00eb siguruar identifikimi automatik i p\u00ebrdorimit t\u00eb nd\u00ebrfaqes CLI gjat\u00eb riprodhimit t\u00eb skripteve &#171;.dump&#187; dhe realizimi i ndryshimeve p\u00ebrkat\u00ebse n\u00eb konfigurime, si &#171;.dbconfig defensive off&#187; dhe &#171;.dbconfig dqs_dll on&#187;.\n<li class=\"l\"> N\u00eb funksionet SQL t\u00eb p\u00ebrcaktuara nga aplikacioni \u00ebsht\u00eb shtuar pron\u00ebsia SQLITE_RESULT_SUBTYPE, e cila lejon thirrjen nga funksioni sqlite3_result_subtype() p\u00ebr t\u00eb inspektuar n\u00ebnklasat e argumenteve.      <\/ul>\n<p>N\u00eb p\u00ebrmbledhjet eksperimentale t\u00eb SQLite, \u00ebsht\u00eb zhvilluar nj\u00eb modalitet i ri p\u00ebr regjistrimin e transaksioneve \u2014 WAL2 (&#171;PRAGMA journal_mode = wal2&#187;), ku p\u00ebrdoren dy skedare wal (&#171;database-wal&#187; dhe &#171;database-wal2&#187;) n\u00eb vend t\u00eb nj\u00ebrit. Kur shkruhen t\u00eb dh\u00ebna n\u00eb DB, shtohen t\u00eb dh\u00ebna t\u00eb reja n\u00eb skedarin e par\u00eb wal. N\u00ebse skedari i par\u00eb wal arrin nj\u00eb madh\u00ebsi t\u00eb konsiderueshme, ndodhi kalimi n\u00eb shkrimin n\u00eb skedarin e dyt\u00eb. Pasi t\u00eb kaloni n\u00eb skedarin e dyt\u00eb wal, i pari b\u00ebhet i disponuesh\u00ebm p\u00ebr regjistrimin e ndryshimeve (checkpoint) dhe rip\u00ebrt\u00ebritjen. P\u00ebrkat\u00ebsisht, kur skedari i dyt\u00eb wal arrin nj\u00eb madh\u00ebsi t\u00eb madhe, ndodhi kalimi n\u00eb t\u00eb parin dhe etj., duke zgjidhur problemin e rritjes s\u00eb pakontrolluar t\u00eb skedarit wal n\u00eb situatat kur transaksioni nuk regjistrohet p\u00ebr nj\u00eb koh\u00eb t\u00eb gjat\u00eb ose kur kryhen procese t\u00eb zgjatura leximi.<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=60460\">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.45, \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 Bentley, Bloomberg, Expensify \u0438 Navigation Data Standard. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0412\u0441\u0435 SQL-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f [&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-113031","post","type-post","status-publish","format-standard","hentry","category-novosti-interneta"],"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.45, \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 Bentley, Bloomberg, Expensify \u0438 Navigation Data Standard. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0412\u0441\u0435 SQL-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f\" \/>\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\/novosti-interneta\/vypusk-subd-sqlite-3-45\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 SQLite 3.45 | 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.45, \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 Bentley, Bloomberg, Expensify \u0438 Navigation Data Standard. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0412\u0441\u0435 SQL-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-45\" \/>\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=\"2024-01-21T15:28:02+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-21T15:28:02+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.45 | ProHoster","description":"\u00cbdhe i l\u00ebshuar SQLite 3.45, nj\u00eb DBMS e leht\u00eb, e formuluar si nj\u00eb bibliotek\u00eb e pranueshme. Kodi SQLite shp\u00ebrndahet si pron\u00eb publike (public domain), dmth mund t\u00eb p\u00ebrdoret pa kufizime dhe falas p\u00ebr \u00e7far\u00ebdo q\u00ebllimi. Ndihma financiare p\u00ebr zhvilluesit e SQLite ofrohet nga nj\u00eb konsorcium i krijuar posa\u00e7\u00ebrisht, i cili p\u00ebrfshin kompani si Bentley, Bloomberg, Expensify dhe Navigation Data Standard. Ndryshimet kryesore: T\u00eb gjitha funksionet SQL p\u00ebr","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-45","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.45 | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u0440\u0435\u043b\u0438\u0437 SQLite 3.45, \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 Bentley, Bloomberg, Expensify \u0438 Navigation Data Standard. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f: \u0412\u0441\u0435 SQL-\u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f","og:url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-subd-sqlite-3-45","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":"2024-01-21T15:28:02+00:00","article:modified_time":"2024-01-21T15:28:02+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/113031","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=113031"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/113031\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=113031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=113031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=113031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}