{"id":105244,"date":"2022-10-03T21:36:54","date_gmt":"2022-10-03T19:36:55","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql"},"modified":"2022-10-03T21:36:54","modified_gmt":"2022-10-03T19:36:55","slug":"proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/news\/proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql","title":{"rendered":"Postgres WASM projekt on valmistanud brauseris t\u00f6\u00f6tava PostgreSQL andmebaasi keskkonna.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Postgres WASM projekti arendust\u00f6\u00f6d on avatud, luues brauseris t\u00f6\u00f6tava PostgreSQL andmebaasi keskkonna. Projektiga seotud kood on avatud MIT litsentsi alusel. Pakutakse t\u00f6\u00f6riistu brauseris t\u00f6\u00f6tava virtuaalmasina koostamiseks, millel on k\u00e4rbitud Linuxi keskkond, PostgreSQL 14.5 server ja seotud utiliidid (psql, pg_dump). L\u00f5pliku koguse suurus on umbes 30 MB.    <\/p>\n<p>Virtuaalmasina sisu luuakse buildroot skriptide abil ja k\u00e4ivitatakse brauseris v86 emulaatori abil. PostgreSQL utiliidiga brauserist suhtlemiseks on saadaval veebiliidest. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/et\/server\/dts-shicago\/\"   title=\"serveri\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2923\">serveri<\/a> Brauseris t\u00f6\u00f6tava PostgreSQL-le ja v\u00f5rgu p\u00e4ringute t\u00e4itmisele virtuaalmasinast p\u00e4\u00e4seb ligi v\u00f5rgu kaudu proxy, mis suunab liiklust Websocket API abil.      <\/p>\n<p>Peamised funktsioonid Postgres WASM:  <\/p>\n<ul>\n<li class=\"l\"> Andmebaasi olekute salvestamine ja taastaminefailidest v\u00f5i brauseri salvestuses\u00fcsteemist, mis p\u00f5hineb IndexedDB-l.\n<li class=\"l\"> Kiire k\u00e4ivitamine salvestatud olekuga virtuaalmasinast v\u00f5i t\u00e4ielik k\u00e4ivitamine emulaatori taask\u00e4ivitamisega.\n<li class=\"l\"> V\u00f5imalus eraldada <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/et\/vps\/abuzoustojchivye-vps\/\"   title=\"virtuaalses masinas\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"4327\">virtuaalses masinas<\/a> 128 MB kuni 1024 MB m\u00e4lu.\n<li class=\"l\"> Web-terminaali fondi suuruse seadistamine.\n<li class=\"l\"> Failide \u00fcleslaadimise tugi virtuaalsesse keskkonda, sealhulgas andmebaasi dumpide \u00fcleslaadimine.\n<li class=\"l\"> Failide allalaadimise tugi virtuaalsest keskkonnast.\n<li class=\"l\"> Sissetulevate ja v\u00e4ljuvate v\u00f5rgu\u00fchenduste loomine, tunnelite loomine v\u00f5rguporti 5432 suunamiseks.  <\/ul>\n<p>Postgres WASM-i v\u00f5imalike rakendusvaldkondade hulka kuulub demonstreerimise ja koolituss\u00fcsteemide loomine, andmetega t\u00f6\u00f6tamine offline-re\u017eiimis, andmeanal\u00fc\u00fcs offline-re\u017eiimis, PostgreSQL funktsionaalsuse ja konfiguratsioonide testimine, arendaja kohalikku keskkonda loomine, kindla andmebaasi oleku l\u00f5ikude ettevalmistamine teistele arendajatele v\u00f5i tugiteenusele saatmiseks, loogilise replikatsiooni testimine v\u00e4listelt andmebaasidest.    <center><img decoding=\"async\" alt=\"Postgres WASM projekt on valmistanud brauseris t\u00f6\u00f6tava PostgreSQL andmebaasi keskkonna.\" src=\"\/wp-content\/uploads\/2022\/10\/d08317d01f873827d336a45fdcd35255.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/center><br \/>\n<br \/>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=57863\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041e\u0442\u043a\u0440\u044b\u0442\u044b \u043d\u0430\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 Postgres WASM, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435 \u0441 \u0421\u0423\u0411\u0414 PostgreSQL, \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u0435 \u0432\u043d\u0443\u0442\u0440\u0438 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430. \u0421\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0439 \u0441 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u043c \u043a\u043e\u0434 \u043e\u0442\u043a\u0440\u044b\u0442 \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 MIT. \u041f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442\u0441\u044f \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u0434\u043b\u044f \u0441\u0431\u043e\u0440\u043a\u0438 \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u0439 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u044c\u043d\u043e\u0439 \u043c\u0430\u0448\u0438\u043d\u044b c \u0443\u0440\u0435\u0437\u0430\u043d\u043d\u044b\u043c Linux-\u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435\u043c, \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u043c PostgreSQL 14.5 \u0438 \u0441\u043e\u043f\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u043c\u0438 \u0443\u0442\u0438\u043b\u0438\u0442\u0430\u043c\u0438 (psql, pg_dump). \u0420\u0430\u0437\u043c\u0435\u0440 \u0438\u0442\u043e\u0433\u043e\u0432\u043e\u0439 \u0441\u0431\u043e\u0440\u043a\u0438 \u043e\u043a\u043e\u043b\u043e 30 \u041c\u0411. \u041d\u0430\u0447\u0438\u043d\u043a\u0430 \u0432\u0438\u0440\u0442\u0443\u0430\u043b\u044c\u043d\u043e\u0439 \u043c\u0430\u0448\u0438\u043d\u044b \u0444\u043e\u0440\u043c\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u0432 buildroot [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":105245,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-105244","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041e\u0442\u043a\u0440\u044b\u0442\u044b \u043d\u0430\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 Postgres WASM, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435 \u0441 \u0421\u0423\u0411\u0414 PostgreSQL, \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u0435 \u0432\u043d\u0443\u0442\u0440\u0438 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430. \u0421\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0439 \u0441 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u043c \u043a\u043e\u0434 \u043e\u0442\u043a\u0440\u044b\u0442 \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 MIT.\" \/>\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\/et\/blog\/news\/proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\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\u041f\u0440\u043e\u0435\u043a\u0442 Postgres WASM \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043b \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u0435 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435 \u0441 \u0421\u0423\u0411\u0414 PostgreSQL | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041e\u0442\u043a\u0440\u044b\u0442\u044b \u043d\u0430\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 Postgres WASM, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435 \u0441 \u0421\u0423\u0411\u0414 PostgreSQL, \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u0435 \u0432\u043d\u0443\u0442\u0440\u0438 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430. \u0421\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0439 \u0441 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u043c \u043a\u043e\u0434 \u043e\u0442\u043a\u0440\u044b\u0442 \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 MIT.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/news\/proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql\" \/>\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=\"2022-10-03T19:36:55+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-10-03T19:36:55+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\udd47Postgres WASM projekt on valmistanud brauseris t\u00f6\u00f6tava PostgreSQL andmebaasi keskkonna | ProHoster","description":"Postgres WASM projekti arendust\u00f6\u00f6d on avatud, luues brauseris t\u00f6\u00f6tava PostgreSQL andmebaasi keskkonna. Projektiga seotud kood on avatud MIT litsentsi alusel.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\u041f\u0440\u043e\u0435\u043a\u0442 Postgres WASM \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043b \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u0435 \u0432 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0435 \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435 \u0441 \u0421\u0423\u0411\u0414 PostgreSQL | ProHoster","og:description":"\u041e\u0442\u043a\u0440\u044b\u0442\u044b \u043d\u0430\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 Postgres WASM, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435 \u0441 \u0421\u0423\u0411\u0414 PostgreSQL, \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u0435 \u0432\u043d\u0443\u0442\u0440\u0438 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430. \u0421\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0439 \u0441 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u043c \u043a\u043e\u0434 \u043e\u0442\u043a\u0440\u044b\u0442 \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 MIT.","og:url":"https:\/\/prohoster.info\/et\/blog\/news\/proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql","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":"2022-10-03T19:36:55+00:00","article:modified_time":"2022-10-03T19:36:55+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"105244","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-02-09 21:42:04","updated":"2026-02-09 21:42:04","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/105244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=105244"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/105244\/revisions"}],"predecessor-version":[{"id":164202,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/105244\/revisions\/164202"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/105245"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=105244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=105244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=105244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}