{"id":25066,"date":"2023-07-18T14:53:43","date_gmt":"2023-07-18T05:53:43","guid":{"rendered":"http:\/\/nori.company\/?p=25066"},"modified":"2023-07-18T14:53:43","modified_gmt":"2023-07-18T05:53:43","slug":"kanel-postgressql-%ec%97%90%ec%84%9c-typescript-types-%ec%83%9d%ec%84%b1%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=25066","title":{"rendered":"Kanel &#8211; PostgresSQL \uc5d0\uc11c Typescript types \uc0dd\uc131\ud558\uae30"},"content":{"rendered":"<ul>\n<li>\uc2e4\ud589\uc911\uc778 PostgreSQL DB\uc5d0\uc11c \uc2a4\ud0a4\ub9c8\ub97c \uc77d\uc5b4\uc11c \ud0c0\uc785\uc744 \uc0dd\uc131\ud558\ub294 Reverse ORM \uac19\uc740 \ub3c4\uad6c<\/li>\n<li>ORM\uc744 \uc2eb\uc5b4\ud558\uc9c0\ub9cc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc778\ud154\ub9ac\uc13c\uc2a4 \ubc0f \ud0c0\uc785 \uccb4\ud0b9\uc744 \uc6d0\ud558\ub294 \uc0ac\ub78c\uc744 \uc704\ud55c \uac83<\/li>\n<li>Postgres \uc811\uc18d \uc815\ubcf4\uc640 DB\ub9cc \uc8fc\uba74 \ub3d9\uc791<br \/>\n<code>$ npx kanel -d postgresql:\/\/localhost:5432\/acm...<\/p>\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=9862\" target=\"_blank\" rel=\"noopener\">GeekNews - \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uc2e4\ud589\uc911\uc778 PostgreSQL DB\uc5d0\uc11c \uc2a4\ud0a4\ub9c8\ub97c \uc77d\uc5b4\uc11c \ud0c0\uc785\uc744 \uc0dd\uc131\ud558\ub294 Reverse ORM \uac19\uc740 \ub3c4\uad6c ORM\uc744 \uc2eb\uc5b4\ud558\uc9c0\ub9cc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc778\ud154\ub9ac\uc13c\uc2a4 \ubc0f \ud0c0\uc785&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-25066","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-6wi","jetpack-related-posts":[{"id":28145,"url":"https:\/\/nori.company\/?p=28145","url_meta":{"origin":25066,"position":0},"title":"Lantern &#8211; AI\uc571\uc744 \uc704\ud55c PostgreSQL Vector DB","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 28\uc77c","format":false,"excerpt":"\ubca1\ud130 \ub370\uc774\ud130 \uc800\uc7a5, Embedding \uc0dd\uc131, \ubca1\ud130 \uac80\uc0c9\uc744 \uc9c0\uc6d0\ud558\ub294 PostgreSQL \ud655\uc7a5 CLIP \ubaa8\ub378, Hugging Face \ubaa8\ub378, \ucee4\uc2a4\ud140 \ubaa8\ub378\uc5d0 \ub300\ud55c \uc784\ubca0\ub529 \uc0dd\uc131 \uc9c0\uc6d0 pgvector\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uacfc \uc0c1\ud638 \uc5f0\ub3d9 \uc9c0\uc6d0 \ubcd1\ub82c \uc778\ub371\uc2a4 \uc0dd\uc131 \uac00\ub2a5 - DB \uc678\ubd80 \ubc0f \ub2e4\ub978 \uc778\uc2a4\ud134\uc2a4 \uc548\uc5d0 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud574\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4... \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":28808,"url":"https:\/\/nori.company\/?p=28808","url_meta":{"origin":25066,"position":1},"title":"PostgresJs: Node.js\uc640 Deno\ub97c \uc704\ud55c PostgreSQL \ud074\ub77c\uc774\uc5b8\ud2b8","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 16\uc77c","format":false,"excerpt":"Postgres.js\ub294 \uac04\ub2e8\ud55c API\ub97c \uac00\uc9c4 Node.js\uc640 Deno\uc6a9 PostgreSQL \ud074\ub77c\uc774\uc5b8\ud2b8\uc785\ub2c8\ub2e4. \uc774 \ud074\ub77c\uc774\uc5b8\ud2b8\ub294 ES6 \ud0dc\uadf8 \ud15c\ud50c\ub9bf \ubb38\uc790\uc5f4\uc744 \uc0ac\uc6a9\ud558\uba70 \ub3d9\uc801 \ucffc\ub9ac\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. Gitter\uc5d0\uc11c \ucc44\ud305 \ubc0f \ub3c4\uc6c0\uc744 \uc81c\uacf5\ud558\uba70 npm\uc744 \ud1b5\ud574 \uc124\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Postgres.js\ub294 SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc2a4\ud134\uc2a4 \uc0dd\uc131... \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":29785,"url":"https:\/\/nori.company\/?p=29785","url_meta":{"origin":25066,"position":2},"title":"DoltgreSQL &#8211; \ubc84\uc804 \ucee8\ud2b8\ub864\ub418\ub294 PostgreSQL","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 11\uc6d4 8\uc77c","format":false,"excerpt":"\ubc84\uc804 \ucee8\ud2b8\ub864 \ub418\ub294 SQL DB\uc778 Dolt(\"Git for Data\")\uac00 PostgreSQL \ubc84\uc804\uc744 \uacf5\uac1c Postgres\uc758 \uc2a4\ud0a4\ub9c8\uc640 \ub370\uc774\ud130\uc5d0 \ub300\ud574\uc11c Git \uc2a4\ud0c0\uc77c\uc758 log, diff, branch, merge \ub4f1\uc758 \uae30\ub2a5\uc744 \uc9c0\uc6d0 2019\ub144\ubd80\ud130 \ub9cc\ub4e4\uc5b4\uc9c4 \uae30\uc874 Dolt\ub294 \ub0b4\ubd80\uc560 MySQL\uad00\ub828 \ucf54\ub4dc\ub294 \uc5c6\uc9c0\ub9cc \uadf8\uc5d0 \ub9de\ucdb0\uc838 \uc788\uc5c8\uace0, \uadf8 \uc2dc\uc808\uc5d4 SQL\ucabd... \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":26598,"url":"https:\/\/nori.company\/?p=26598","url_meta":{"origin":25066,"position":3},"title":"Cloud Database Cheat Sheet","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 24\uc77c","format":false,"excerpt":"AWS,Azure,Google \uacfc \uc624\ud508\uc18c\uc2a4\/\uc368\ub4dc\ud30c\ud2f0\uc758 DB \ub4e4\uc744 Type\uc5d0 \ub530\ub77c \ud55c\uac1c\uc758 \ud14c\uc774\ube14\ub85c \uc815\ub9ac Structured Relational : RDS, SQL DB, Cloud SQL, Oracle\/PostgreSQL\/MySQL\/SQL Server Columnar : Redshift, Synapse Analytics, BigQuery, Snowflake\/ClickHouse Semi... \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":24738,"url":"https:\/\/nori.company\/?p=24738","url_meta":{"origin":25066,"position":4},"title":"FerretDB &#8211; MongoDB\uc758 \uc624\ud508\uc18c\uc2a4 \ub300\uccb4\uc81c","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 7\uc6d4 7\uc77c","format":false,"excerpt":"\uc624\ud508\uc18c\uc2a4 \ud504\ub85d\uc2dc\ub85c \ub3d9\uc791 MongoDB 6.0+\uc758 \uc640\uc774\uc5b4 \ud504\ub85c\ud1a0\ucf5c\uc744 \ubcc0\ud658 PostgreSQL \ub610\ub294 SQLite\ub97c DB\uc5d4\uc9c4\uc73c\ub85c \uc0ac\uc6a9 \ubabd\uace0DB\uac00 SSPL\ub85c \uc804\ud658\ud588\uae30 \ub54c\ubb38\uc5d0 \uc624\ud508\uc18c\uc2a4 \ubc0f \ucd08\uae30\ub2e8\uacc4 \uc0c1\uc6a9 \ud504\ub85c\uc81d\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ud558\uae30 \uc5b4\ub824\uc6c0 \ub300\ubd80\ubd84\uc758 MongoDB 6.0+ \uad00\ub828 \ub3c4\uad6c\ub4e4\uacfc \uadf8\ub300\ub85c \ud638\ud658 \uac00\ub2a5... \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":24157,"url":"https:\/\/nori.company\/?p=24157","url_meta":{"origin":25066,"position":5},"title":"tbls &#8211; CI \uce5c\ud654\uc801 DB\ubb38\uc11c\ud654 \ub3c4\uad6c","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 6\uc6d4 18\uc77c","format":false,"excerpt":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubb38\uc11c\ub97c \uc5ec\ub7ec \ud3ec\ub9f7\uc73c\ub85c \uc790\ub3d9 \uc791\uc131 : \ub9c8\ud06c\ub2e4\uc6b4, DOT, PlantUML, Mermaid, \uc774\ubbf8\uc9c0, JSON, YAML, Excel Go\ub85c \uc791\uc131\ub41c \uc2f1\uae00 \ubc14\uc774\ub108\ub9ac\ub85c CI\uc640 \uc27d\uac8c \uc5f0\ub3d9 \ub2e4\uc591\ud55c DB \uc9c0\uc6d0: PostgreSQL, MySQL, MariaDB, SQLite, BigQuery, Cloud Spanner, Redshift, SQL Server, DynamoDB, Snowflake, M... \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\/25066","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=25066"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/25066\/revisions"}],"predecessor-version":[{"id":25067,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/25066\/revisions\/25067"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=25066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=25066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=25066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}