{"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\/hu\/blog\/news\/proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql","title":{"rendered":"A Postgres WASM projekt elk\u00e9sz\u00edtett egy b\u00f6ng\u00e9sz\u0151ben m\u0171k\u00f6d\u0151 k\u00f6rnyezetet a PostgreSQL adatb\u00e1zis-kezel\u0151 rendszerhez.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Megny\u00edltak a Postgres WASM projekt fejleszt\u00e9sei, amely PostgreSQL adatb\u00e1zis-kezel\u0151t m\u0171k\u00f6dtet a b\u00f6ng\u00e9sz\u0151n bel\u00fcl. A projekthez kapcsol\u00f3d\u00f3 k\u00f3d MIT licenc alatt \u00e9rhet\u0151 el. Az eszk\u00f6z\u00f6k k\u00f6z\u00f6tt szerepel egy b\u00f6ng\u00e9sz\u0151ben m\u0171k\u00f6d\u0151 virtu\u00e1lis g\u00e9p fel\u00e1ll\u00edt\u00e1s\u00e1hoz sz\u00fcks\u00e9ges keretrendszer, korl\u00e1tozott Linux k\u00f6rnyezettel, PostgreSQL 14.5 szerverrel \u00e9s kapcsol\u00f3d\u00f3 seg\u00e9dprogramokkal (psql, pg_dump). A v\u00e9gs\u0151 \u00f6sszes\u00edt\u00e9s m\u00e9rete k\u00f6r\u00fclbel\u00fcl 30 MB.    <\/p>\n<p>A virtu\u00e1lis g\u00e9p tartalma buildroot szkriptek seg\u00edts\u00e9g\u00e9vel k\u00e9sz\u00fcl, \u00e9s b\u00f6ng\u00e9sz\u0151ben futtatva, a v86 emul\u00e1tor haszn\u00e1lat\u00e1val indul. A PostgreSQL seg\u00e9dprogramjaival val\u00f3 interakci\u00f3hoz web alap\u00fa fel\u00fclet \u00e1ll rendelkez\u00e9sre. A b\u00f6ng\u00e9sz\u0151ben fut\u00f3 PostgreSQL-hez val\u00f3 kapcsol\u00f3d\u00e1shoz <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/hu\/server\/dts-shicago\/\"   title=\"szerverhez\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2923\">szerverhez<\/a> proxy-t haszn\u00e1lnak, amely Websocket API-n kereszt\u00fcl tov\u00e1bb\u00edtja a forgalmat a virtu\u00e1lis g\u00e9pb\u0151l.      <\/p>\n<p>A Postgres WASM f\u0151bb lehet\u0151s\u00e9gei:  <\/p>\n<ul>\n<li class=\"l\"> Az adatb\u00e1zis-kezel\u0151 \u00e1llapot\u00e1nak ment\u00e9se \u00e9s vissza\u00e1ll\u00edt\u00e1sa f\u00e1jlb\u00f3l vagy IndexedDB alap\u00fa b\u00f6ng\u00e9sz\u0151 t\u00e1rol\u00f3b\u00f3l.\n<li class=\"l\"> Gyors ind\u00edt\u00e1s mentett virtu\u00e1lis g\u00e9p \u00e1llapotf\u00e1jlb\u00f3l vagy teljes ind\u00edt\u00e1s a szimul\u00e1tor \u00fajraind\u00edt\u00e1s\u00e1val.\n<li class=\"l\"> Lehet\u0151s\u00e9g <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/hu\/vps\/abuzoustojchivye-vps\/\"   title=\"virtu\u00e1lis g\u00e9pben\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"4327\">virtu\u00e1lis g\u00e9pben<\/a> 128 \u00e9s 1024 MB k\u00f6z\u00f6tti mem\u00f3ria.\n<li class=\"l\"> A web termin\u00e1l bet\u0171m\u00e9ret\u00e9nek be\u00e1ll\u00edt\u00e1sa.\n<li class=\"l\"> F\u00e1jlok felt\u00f6lt\u00e9s\u00e9nek t\u00e1mogat\u00e1sa a virtu\u00e1lis k\u00f6rnyezetbe, bele\u00e9rtve az adatb\u00e1zis dumpok felt\u00f6lt\u00e9s\u00e9t is.\n<li class=\"l\"> F\u00e1jlok let\u00f6lt\u00e9s\u00e9nek t\u00e1mogat\u00e1sa a virtu\u00e1lis k\u00f6rnyezetb\u0151l.\n<li class=\"l\"> Bej\u00f6v\u0151 \u00e9s kimen\u0151 h\u00e1l\u00f3zati kapcsolatok be\u00e1ll\u00edt\u00e1sa, alag\u00fat l\u00e9trehoz\u00e1sa a 5432-es h\u00e1l\u00f3zati porthoz val\u00f3 hozz\u00e1f\u00e9r\u00e9shez.  <\/ul>\n<p>A Postgres WASM alkalmaz\u00e1si ter\u00fcletei k\u00f6z\u00f6tt szerepel a demonstr\u00e1ci\u00f3s \u00e9s oktat\u00e1si rendszerek l\u00e9trehoz\u00e1sa, offline m\u00f3dban t\u00f6rt\u00e9n\u0151 adatkezel\u00e9s, offline \u00e1llapotban a adatok elemz\u00e9se, PostgreSQL funkci\u00f3k \u00e9s konfigur\u00e1ci\u00f3k tesztel\u00e9se, helyi fejleszt\u0151i k\u00f6rnyezet l\u00e9trehoz\u00e1sa, az adatb\u00e1zis egy adott \u00e1llapot\u00e1nak k\u00fcld\u00e9se m\u00e1s fejleszt\u0151knek vagy a t\u00e1mogat\u00e1si szolg\u00e1ltat\u00e1snak, valamint a logikai replik\u00e1ci\u00f3 tesztel\u00e9se k\u00fcls\u0151 adatb\u00e1zisokkal.    <center><img decoding=\"async\" alt=\"A Postgres WASM projekt elk\u00e9sz\u00edtett egy b\u00f6ng\u00e9sz\u0151ben m\u0171k\u00f6d\u0151 k\u00f6rnyezetet a PostgreSQL adatb\u00e1zis-kezel\u0151 rendszerhez.\" src=\"\/wp-content\/uploads\/2022\/10\/d08317d01f873827d336a45fdcd35255.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/center><br \/>\n<br \/>Forr\u00e1s: <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.3 - 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\/hu\/blog\/news\/proekt-postgres-wasm-podgotovil-rabotayushhee-v-brauzere-okruzhenie-s-subd-postgresql\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\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\/hu\/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\udd47A Postgres WASM projekt k\u00e9sz\u00edtett egy b\u00f6ng\u00e9sz\u0151ben m\u0171k\u00f6d\u0151 k\u00f6rnyezetet PostgreSQL adatb\u00e1zis-kezel\u0151vel | ProHoster","description":"Megny\u00edltak a Postgres WASM projekt fejleszt\u00e9sei, amely PostgreSQL adatb\u00e1zis-kezel\u0151t m\u0171k\u00f6dtet a b\u00f6ng\u00e9sz\u0151n bel\u00fcl. A projekthez kapcsol\u00f3d\u00f3 k\u00f3d MIT licenc alatt \u00e9rhet\u0151 el.","canonical_url":"https:\/\/prohoster.info\/hu\/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":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/105244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=105244"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/105244\/revisions"}],"predecessor-version":[{"id":164202,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/105244\/revisions\/164202"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/105245"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=105244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=105244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=105244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}