{"id":27833,"date":"2023-09-21T10:52:56","date_gmt":"2023-09-21T01:52:56","guid":{"rendered":"http:\/\/nori.company\/?p=27833"},"modified":"2023-09-21T10:52:56","modified_gmt":"2023-09-21T01:52:56","slug":"electricsql-%eb%a1%9c%ec%bb%ac-%ed%8d%bc%ec%8a%a4%ed%8a%b8-%ec%9b%b9-%ec%95%b1%ec%9d%84-%ec%9c%84%ed%95%9c-postgres%ec%97%90%ec%84%9c-sqlite%eb%a1%9c%ec%9d%98-%ec%95%a1%ed%8b%b0%eb%b8%8c-%ec%95%a1","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=27833","title":{"rendered":"ElectricSQL, \ub85c\uceec-\ud37c\uc2a4\ud2b8 \uc6f9\/\uc571\uc744 \uc704\ud55c Postgres\uc5d0\uc11c SQLite\ub85c\uc758 \uc561\ud2f0\ube0c-\uc561\ud2f0\ube0c \ub3d9\uae30\ud654"},"content":{"rendered":"<ul>\n<li>\ud074\ub77c\uc6b0\ub4dc\uc758 Postgres\uc640 \ub85c\uceec SQLite \uae30\ubc18\uc73c\ub85c \ubc18\uc751\ud615(Reactive), \uc2e4\uc2dc\uac04(Realtime), \ub85c\uceec \ud37c\uc2a4\ud2b8 \uc571\uc744 \uac1c\ubc1c\ud558\ub294 \ud50c\ub7ab\ud3fc<\/li>\n<li>Local-First\n<ul>\n<li>\uc571\uc758 \ucf54\ub4dc\ub294 SQLite\ub85c \ub41c \uc784\ubca0\ub514\ub4dc DB\ub791 \uc9c1\uc811 \ud1b5\uc2e0\ud558\uace0, \ub370\uc774\ud130\uac00 \ubc31\uadf8\ub77c\uc6b4\ub4dc\uc5d0\uc11c \ud074\ub77c\uc6b0\ub4dc Postgres \uc640 active-active \ubcf5\uc81c \ubc29\uc2dd\uc73c\ub85c \ub3d9\uc801 \ub3d9\uae30\ud654<\/li>\n<li...\n\n\n\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=10973\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\ud074\ub77c\uc6b0\ub4dc\uc758 Postgres\uc640 \ub85c\uceec SQLite \uae30\ubc18\uc73c\ub85c \ubc18\uc751\ud615(Reactive), \uc2e4\uc2dc\uac04(Realtime), \ub85c\uceec \ud37c\uc2a4\ud2b8 \uc571\uc744 \uac1c\ubc1c\ud558\ub294 \ud50c\ub7ab\ud3fc Local-First \uc571\uc758 \ucf54\ub4dc\ub294 SQLite\ub85c \ub41c \uc784\ubca0\ub514\ub4dc DB\ub791 \uc9c1\uc811&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[138],"tags":[163],"class_list":["post-27833","post","type-post","status-publish","format-standard","hentry","category-it","tag-geeknews-----"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pa3PO4-7eV","jetpack-related-posts":[{"id":29364,"url":"https:\/\/nori.company\/?p=29364","url_meta":{"origin":27833,"position":0},"title":"\ub2f9\uc2e0\uc774 \uc544\ub9c8\ub3c4 SQLite\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uc774\uc720","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 28\uc77c","format":false,"excerpt":"\uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub370\uc774\ud130 \uc800\uc7a5\uc5d0 SQLite \uc0ac\uc6a9\uc758 \uc774\uc810\uc5d0 \ub300\ud55c \uae30\uc0ac, MySQL \ubc0f Postgres\uc640 \uac19\uc740 \ub2e4\ub978 \uc194\ub8e8\uc158\uacfc \ube44\uad50 SQLite\ub294 SQL \uae30\ubc18 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e8\uc77c \ud30c\uc77c\uc5d0 \uc800\uc7a5\ud558\uc5ec \uac04\ub2e8\ud558\uace0 \uace0\uae09 \uc0ac\uc6a9 \uc0ac\ub840 \ubaa8\ub450\uc5d0 \uac04\ub2e8\ud55c \uc194\ub8e8\uc158 \uc81c\uacf5 SQLite\ub294 \ub2e8\uc77c \ud30c\uc77c \uad6c\uc870\ub85c \uc778\ud55c \uc81c\ub85c \uc9c0\uc5f0... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27198,"url":"https:\/\/nori.company\/?p=27198","url_meta":{"origin":27833,"position":1},"title":"PartyKit &#8211; \uc2e4\uc2dc\uac04 \ud611\ub3d9 \uc571\uc744 \ub9cc\ub4e4\uae30 \uc704\ud55c \ud50c\ub7ab\ud3fc","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 6\uc77c","format":false,"excerpt":"AI \uc5d0\uc774\uc804\ud2b8, \uba40\ud2f0\ud50c\ub808\uc774\uc5b4 & \ub85c\uceec-\ud37c\uc2a4\ud2b8 \uc571, \uac8c\uc784, \uc6f9\uc0ac\uc774\ud2b8\ub97c \ubc30\ud3ec \uac00\ub2a5 Y.js, Automerge, Repicache, XState, tldraw \ub4f1\uc758 \ud611\ub3d9 \ud504\ub808\uc784\uc6cc\ud06c\uc640 \uc798 \uc5f0\ub3d9 \ubd84\uc11d, \uc2a4\ud14c\uc774\uc9d5 \ud658\uacbd, \uc2dc\ud06c\ub9bf \uad00\ub9ac, \ub85c\uae45 \ub4f1\uc758 \uae30\ub2a5 \uc81c\uacf5 Vercel, Netlify, AWS, Cloudflare, fly.io \ub4f1\uacfc\ub3c4 \uc798 \uc5f0\ub3d9","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24334,"url":"https:\/\/nori.company\/?p=24334","url_meta":{"origin":27833,"position":2},"title":"undb &#8211; \uc624\ud508\uc18c\uc2a4 \ub178\ucf54\ub4dc \ub370\uc774\ud130\ubca0\uc774\uc2a4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 6\uc6d4 23\uc77c","format":false,"excerpt":"Private first(\uc140\ud504 \ud638\uc2a4\ud2b8 \uac00\ub2a5) SQLite \uc640 \ub85c\uceec \uac1d\uccb4 \uc800\uc7a5\uc18c \uc774\uc6a9\uc73c\ub85c \ucd08\uacbd\ub7c9 \ube60\ub974\uace0 \uc27d\uac8c \ub514\ud50c\ub85c\uc774 \uac00\ub2a5(\ub3c4\ucee4 \ubc0f \uadf8\uc678) OpenAPI, \uc6f9\ud6c5, \uc2e4\uc2dc\uac04 \uad6c\ub3c5, SDK \ub4f1\uc744 \uc81c\uacf5 SvelteKit + Vite & SWC + Tailwind + Nestjs + Domain Driven Design ... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27128,"url":"https:\/\/nori.company\/?p=27128","url_meta":{"origin":27833,"position":3},"title":"Graphweaver &#8211; \uc5ec\ub7ec \ub370\uc774\ud130\uc18c\uc2a4\ub97c \ud558\ub098\uc758 GraphQL API\ub85c \ubb36\uae30","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 5\uc77c","format":false,"excerpt":"Postgres, MySQL, SQLite, REST \ub4f1 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc18c\uc2a4\uc5d0 \uc5f0\uacb0 \uc790\ub3d9 \ucffc\ub9ac\uc640 Mutation\uc73c\ub85c GraphQL API\ub97c \uc190\uc27d\uac8c \uad6c\uc131\ud558\uc5ec \uc6b4\uc601 \uae30\uc874 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c CLI\ub85c \uc190\uc27d\uac8c \uc784\ud3ec\ud2b8 Typescript + Node.js ... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":25561,"url":"https:\/\/nori.company\/?p=25561","url_meta":{"origin":27833,"position":4},"title":"Cozo &#8211; Datalog\ub85c \ucffc\ub9ac \uac00\ub2a5\ud55c \uc784\ubca0\ub354\ube14 GraphDB \uc624\ud508\uc18c\uc2a4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 7\uc6d4 31\uc77c","format":false,"excerpt":"SQLite\ucc98\ub7fc \uac00\ubccd\uace0 \uc0ac\uc6a9\ud558\uae30 \uc26c\uc6b0\uba70, Postgres\ucc98\ub7fc \uac15\ub825\ud558\uace0 \uc131\ub2a5 \uc88b\uc740 GraphDB\uac00 \ubaa9\ud45c Datalog\ub97c \ucffc\ub9ac \uc5b8\uc5b4\ub85c \uc0ac\uc6a9\ud558\ub294 \uad00\uacc4\ud615 DB \uc7ac\uadc0 \ucffc\ub9ac, \ubcf5\uc7a1\ud55c \uadf8\ub798\ud504 \uc624\ud37c\ub808\uc774\uc158\uacfc \uc54c\uace0\ub9ac\ub4ec \ucc98\ub9ac \uac00\ub2a5 \ub2e4\uc591\ud55c \ub0b4\uc7a5 \ud568\uc218 \ubc0f \uc5b4\uadf8\ub9ac\uac8c\uc774\uc158 \uc9c0\uc6d0 \uc784\ubca0\ub4dc \uac00\ub2a5 : Python, ... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27950,"url":"https:\/\/nori.company\/?p=27950","url_meta":{"origin":27833,"position":5},"title":"Postgres\uc5d0\uc11c \ubcc0\ud654\ub97c \ud3ec\ucc29\ud558\ub294 \ubc29\ubc95\ub4e4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 24\uc77c","format":false,"excerpt":"\uae30\uc0ac\ub294 Postgres \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcc0\ud654\ub97c \ud3ec\ucc29\ud558\ub294 \ub2e4\uc591\ud55c \ubc29\ubc95\uc5d0 \ub300\ud574 \ub17c\uc758\ud569\ub2c8\ub2e4. Sequin\uc774\ub77c\ub294 \ud68c\uc0ac\ub294 Salesforce\uc640 HubSpot\uacfc \uac19\uc740 \uc81c3\uc790 API\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \ub3d9\uae30\ud654\ud558\uc5ec \uac1c\ubc1c\uc790\ub4e4\uc774 \uadf8\ub4e4\uc758 Postgres \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec API \ub370\uc774\ud130\ub97c \uad6c\ucd95\ud558\uac8c \ud569\ub2c8\ub2e4. Postgres\ub294 \ud14c\uc774\ube14 \ubcc0\ud654\uc5d0 \uae30... \ucd9c\ucc98 : GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4","rel":"","context":"&quot;IT&quot;\uc5d0\uc11c","block_context":{"text":"IT","link":"https:\/\/nori.company\/?cat=138"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/27833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=27833"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/27833\/revisions"}],"predecessor-version":[{"id":27834,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/27833\/revisions\/27834"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=27833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=27833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=27833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}