{"id":31243,"date":"2023-12-07T10:52:10","date_gmt":"2023-12-07T01:52:10","guid":{"rendered":"http:\/\/nori.company\/?p=31243"},"modified":"2023-12-07T10:52:10","modified_gmt":"2023-12-07T01:52:10","slug":"sqlite-jsonb-%ec%a7%80%ec%9b%90-%ea%b8%b0%eb%8a%a5-%eb%8f%84%ec%9e%85","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=31243","title":{"rendered":"SQLite, JSONB \uc9c0\uc6d0 \uae30\ub2a5 \ub3c4\uc785"},"content":{"rendered":"<ul>\n<li>SQLite\uc758 \uae30\uc874 JSON \ud568\uc218\ub97c \uc7ac\uc791\uc131. \uc0ac\uc6a9\ud328\ud134\uc5d0 \ub530\ub77c \uba87\ubc30\uae4c\uc9c0 \ub354 \ube60\ub974\uac8c \uc2e4\ud589\ub428<\/li>\n<li>\uc6d0\ub798 JSON \ud568\uc218\ub294 3\ub2e8\uacc4\ub85c \ub3d9\uc791\n<ol>\n<li>JSON\uc744 C\ucf54\ub4dc\uac00 \uc27d\uac8c \ucc98\ub9ac\uac00\ub2a5\ud55c \ub0b4\ubd80\uc6a9 \ubc14\uc774\ub108\ub9ac \ud3ec\ub9f7\uc73c\ub85c \ud30c\uc2f1<\/li>\n<li>\uc694\uccad\ud55c \uc791\uc5c5 \uc218\ud589. \ud2b9\uc815 \ud544\ub4dc\ub97c \ucc3e\uac70\ub098 JSON\uc744 \uc218\uc815\ud558\uac70\ub098 \ud558\ub294 \ub4f1<\/li>\n<li>\uc791\uc5c5\uc774 JSON\uc744 \ubcc0\uacbd\ud588\ub2e4&#8230;\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=12213\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/li>\n<\/ol>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQLite\uc758 \uae30\uc874 JSON \ud568\uc218\ub97c \uc7ac\uc791\uc131. \uc0ac\uc6a9\ud328\ud134\uc5d0 \ub530\ub77c \uba87\ubc30\uae4c\uc9c0 \ub354 \ube60\ub974\uac8c \uc2e4\ud589\ub428 \uc6d0\ub798 JSON \ud568\uc218\ub294 3\ub2e8\uacc4\ub85c \ub3d9\uc791 JSON\uc744 C\ucf54\ub4dc\uac00 \uc27d\uac8c \ucc98\ub9ac\uac00\ub2a5\ud55c&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-31243","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-87V","jetpack-related-posts":[{"id":24221,"url":"https:\/\/nori.company\/?p=24221","url_meta":{"origin":31243,"position":0},"title":"GPT-4\uc758 Native JSON Output \uc0b4\ud3b4\ubcf4\uae30","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 6\uc6d4 20\uc77c","format":false,"excerpt":"\uc0c8\ub85c \ucd94\uac00\ub41c \ud568\uc218\ud638\ucd9c \uae30\ub2a5\uc744 \ud1b5\ud574\uc11c, LLM\uc744 \uc790\uc2e0\uc758 \uc81c\ud488\uc5d0 \uc5f0\uacb0\ud558\uae30\uac00 \ud6e8\uc52c \uc26c\uc6cc\uc9d0 functions \ub85c \ud568\uc218\ub97c JSON \uc2a4\ud0a4\ub9c8\uc640 \ud568\uaed8 \uc0dd\uc131\ud558\uace0, function_call \ub85c \ud568\uc218 \ud638\ucd9c\ud558\uba74 JSON \ucd9c\ub825\uc744 \ub9ac\ud134 \ud504\ub86c\ud504\ud2b8 \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1\uc73c\ub85c\ub3c4 JSON \ucd9c\ub825\uc744 \ub9cc\ub4e4 \uc218\ub294 \uc788\uc9c0\ub9cc, \uc774 \ubc29\ubc95\uc774 \ud6e8\uc52c \uc720\uc6a9 ... \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":28177,"url":"https:\/\/nori.company\/?p=28177","url_meta":{"origin":31243,"position":1},"title":"Neboa &#8211; Type-safe NoSQL for Node.js","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 9\uc6d4 29\uc77c","format":false,"excerpt":"SQLite \uae30\ubc18\uc758 \uac04\ub2e8\ud558\uace0 \uac15\ub825\ud55c Node.js\uc6a9 Type-safe NoSQL DB \ub77c\uc774\ube0c\ub7ec\ub9ac \uc784\ubca0\ub529\ud558\uae30 \uc88b\uc544\uc11c Electron \uc571\uc5d0 \ucd5c\uc801\uc774\uba70, \uc911\uc18c \uaddc\ubaa8\uc758 \ud504\ub85c\uc81d\ud2b8\uc5d0\ub3c4 \uc774\uc6a9 \uac00\ub2a5 JSON \uc73c\ub85c \uc2dc\ub9ac\uc5bc\ub77c\uc774\uc988 \uac00\ub2a5\ud55c \ubaa8\ub4e0 \ub370\uc774\ud130 \uc800\uc7a5 \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":31243,"position":2},"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":[]},{"id":30342,"url":"https:\/\/nori.company\/?p=30342","url_meta":{"origin":31243,"position":3},"title":"GPT Crawler &#8211; \ub098\ub9cc\uc758 GPT\ub97c \ub9cc\ub4e4\uae30 \uc704\ud55c \uc6f9\uc0ac\uc774\ud2b8 \ud06c\ub864\ub7ec","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 11\uc6d4 19\uc77c","format":false,"excerpt":"\uc0ac\uc774\ud2b8 \uc8fc\uc18c\ub97c \ub123\uc73c\uba74 \uc804\uccb4\ub97c \ud06c\ub864\ub9c1\ud574\uc11c JSON\uc73c\ub85c \ucd94\ucd9c\ud574\uc90c(\ud0c0\uc774\ud2c0,\uc8fc\uc18c,HTML) \uc774 JSON\uc744 GPT \ube4c\ub354\uc5d0 \ub123\uace0 \ud574\ub2f9 \ub0b4\uc6a9 \uae30\ubc18\uc73c\ub85c \ub3d9\uc791\ud558\ub294 GPT \uc0dd\uc131 \ubcf8\ubb38 \uc140\ub809\ud130 \ubc0f \ucd5c\ub300 \ud398\uc774\uc9c0 \uc124\uc815 \uac01 \ud398\uc774\uc9c0\ub2f9 \ucee4\uc2a4\ud140 \ud568\uc218 \uc2e4\ud589 \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":26201,"url":"https:\/\/nori.company\/?p=26201","url_meta":{"origin":31243,"position":4},"title":"Show HN: LLMs\uac00 100%\uc758 \uacbd\uc6b0\uc5d0 \uc720\ud6a8\ud55c JSON\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\uc74c","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 8\uc6d4 15\uc77c","format":false,"excerpt":"Outlines\ub294 \uc2e0\uacbd\ub9dd \ud14d\uc2a4\ud2b8 \uc0dd\uc131\uc744 \uc704\ud55c \ub77c\uc774\ube0c\ub7ec\ub9ac\ub85c, transformers \ub77c\uc774\ube0c\ub7ec\ub9ac\uc758 generate \uba54\uc18c\ub4dc\ub97c \ub300\uccb4\ud558\uae30 \uc704\ud574 \ub354 \uc720\uc5f0\ud558\uac8c \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uac1c\ubc1c\uc790\ub4e4\uc774 \uc815\uaddc \ud45c\ud604\uc2dd\uc744 \ub530\ub974\uac70\ub098 JSON \uc2a4\ud0a4\ub9c8\ub97c \ub530\ub974\ub294 \ucd9c\ub825\uc744 \ubcf4\uc7a5\ud558\uba74\uc11c \uacac\uace0\ud55c \uc778\ud130\ud398\uc774\uc2a4\ub97c \uad6c\ucd95\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uc774 \ub77c\uc774\ube0c\ub7ec\ub9ac... \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":22238,"url":"https:\/\/nori.company\/?p=22238","url_meta":{"origin":31243,"position":5},"title":"LangFlow &#8211; LangChain\uc744 \uc704\ud55c GUI","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 4\uc6d4 11\uc77c","format":false,"excerpt":"\ub4dc\ub798\uadf8 \uc564 \ub4dc\ub78d, \ucc44\ud305 \ubc15\uc2a4 \ub4f1\uc73c\ub85c \ube60\ub974\uac8c \ud504\ub85c\ud1a0\ud0c0\uc774\ud551 \ubc0f \uc2e4\ud5d8 LangChain\uc758 \ub2e4\uc591\ud55c LLM, \ud504\ub86c\ud504\ud2b8 \uc2dc\ub9ac\uc5bc\ub77c\uc774\uc800, \uc5d0\uc774\uc804\ud2b8, \uccb4\uc778\uacfc \uac19\uc740 \ucef4\ud3ec\ub10c\ud2b8\ub97c \uc9c0\uc6d0 \uc791\uc131\ud55c flow\ub97c JSON\uc73c\ub85c \uc775\uc2a4\ud3ec\ud2b8\ud560 \uc218 \uc788\uace0, \ud30c\uc774\uc36c \ud658\uacbd\uc5d0\uc11c \ubd88\ub7ec\uc640 \uc0ac\uc6a9 \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":[]}],"_links":{"self":[{"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/31243","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=31243"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/31243\/revisions"}],"predecessor-version":[{"id":31244,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/31243\/revisions\/31244"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}