{"id":23788,"date":"2023-06-05T12:47:35","date_gmt":"2023-06-05T03:47:35","guid":{"rendered":"http:\/\/nori.company\/?p=23788"},"modified":"2023-06-05T12:47:35","modified_gmt":"2023-06-05T03:47:35","slug":"sql2023-%eb%a6%b4%eb%a6%ac%ec%a6%88","status":"publish","type":"post","link":"https:\/\/nori.company\/?p=23788","title":{"rendered":"SQL:2023 \ub9b4\ub9ac\uc988"},"content":{"rendered":"<ul>\n<li>2023-06-01\uc77c\uc790, ISO\/IEC 9075-2:2023 \uc73c\ub85c \ucd5c\uc885 \uc2b9\uc778\ud558\uc5ec \ubc1c\ud589<\/li>\n<li>\uc8fc\uc694 \ubcc0\uacbd\uc810\uc740\n<ul>\n<li>SQL\/PGQ: Graph \ucffc\ub9ac \uc5b8\uc5b4 \ucd94\uac00<\/li>\n<li>JSON \ub370\uc774\ud130 \ud0c0\uc785 \ubc0f \ub2e4\uc591\ud55c \uc0c8 \uae30\ub2a5\ub4e4 \ucd94\uac00<\/li>\n<li>\uae30\uc874 SQL \uc5b8\uc5b4\uc758 \ud5a5\uc0c1 \ubc0f \ubcc0\uacbd<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&#8230;<\/p>\n<p>\ucd9c\ucc98 : <a href=\"https:\/\/news.hada.io\/topic?id=9328\" target=\"_blank\" rel=\"noopener\">GeekNews &#8211; \uac1c\ubc1c\/\uae30\uc220\/\uc2a4\ud0c0\ud2b8\uc5c5 \ub274\uc2a4 \uc11c\ube44\uc2a4 <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>2023-06-01\uc77c\uc790, ISO\/IEC 9075-2:2023 \uc73c\ub85c \ucd5c\uc885 \uc2b9\uc778\ud558\uc5ec \ubc1c\ud589 \uc8fc\uc694 \ubcc0\uacbd\uc810\uc740 SQL\/PGQ: Graph \ucffc\ub9ac \uc5b8\uc5b4 \ucd94\uac00 JSON \ub370\uc774\ud130 \ud0c0\uc785 \ubc0f \ub2e4\uc591\ud55c \uc0c8&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-23788","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-6bG","jetpack-related-posts":[{"id":22411,"url":"https:\/\/nori.company\/?p=22411","url_meta":{"origin":23788,"position":0},"title":"SQL:2023\uc5d0 \uc0c8\ub85c \ucd94\uac00\ub418\ub294 \uac83\ub4e4","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 4\uc6d4 17\uc77c","format":false,"excerpt":"\uc6cc\ud0b9\uadf8\ub8f9\uc774 \ucd5c\uc885\ubcf8\uc744 ISO\uc5d0 \uc804\ub2ec\ud588\uace0, \uc2b9\uc778 \ub300\uae30\uc911 \uae30\uc874 SQL \uc5b8\uc5b4\uc758 \ubcc0\uacbd UNIQUE \uc758 NULL \ucc98\ub9ac \uba85\uc2dc GROUP\ub41c \ud14c\uc774\ube14\uc5d0\uc11c SELECT \ud558\uc9c0 \uc54a\uc740 \ud544\ub4dc\ub85c ORDER BY \uac00\ub2a5 GREATEST, LEAST \ud568\uc218 \ucd94\uac00 LPAD, RPAD \ud568\uc218 \ucd94\uac00 \uba40\ud2f0 \uce90\ub9ad\ud130 TRIM \ud568\uc218\ub4e4(L... \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":31343,"url":"https:\/\/nori.company\/?p=31343","url_meta":{"origin":23788,"position":1},"title":"Kagi Search \u2013 \uc720\ub8cc \ubcbd \uae30\uc0ac \ud45c\uc2dc\uae30 \ubc0f \uac1c\uc120\ub41c \ub0a0\uc528 \uc704\uc82f","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 12\uc6d4 9\uc77c","format":false,"excerpt":"\ucd5c\uc2e0 \uc5c5\ub370\uc774\ud2b8 \uc694\uc57d \uac80\uc0c9 \uacb0\uacfc\uc5d0\uc11c \uc720\ub8cc \uae30\uc0ac \ud45c\uc2dc \uae30\ub2a5 \ucd94\uac00 \uae30\ubcf8 \ub2e8\uc704 \uc124\uc815 \uae30\ub2a5 \ucd94\uac00 \ub0a0\uc528 \uc704\uc82f \uac1c\uc120 \ubc84\uadf8 \uc218\uc815 \ubc0f \uac1c\uc120 \uc0ac\ud56d \ud30c\uc774\uc5b4\ud3ed\uc2a4 \ubc0f \ud06c\ub86c\uc6a9 Kagi \uac80\uc0c9 \ud655\uc7a5 \ud504\ub85c\uadf8\ub7a8 \uc5c5\ub370\uc774\ud2b8 \uc694\uc57d\uae30 \ud14d\uc2a4\ud2b8 \ud3ec\ub9f7\ud305 \ubc0f \ubcf5\uc0ac \ubc84\ud2bc \ucd94\uac00 ... \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":24030,"url":"https:\/\/nori.company\/?p=24030","url_meta":{"origin":23788,"position":2},"title":"OpenAI \ud568\uc218 \ud638\ucd9c \uae30\ub2a5 \ucd94\uac00 GPT \ubaa8\ub378\ub4e4 \uc5c5\ub370\uc774\ud2b8 \ubc0f \uac00\uaca9 \uc778\ud558","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 6\uc6d4 14\uc77c","format":false,"excerpt":"\ud568\uc218 \ud638\ucd9c \uae30\ub2a5 \ucd94\uac00 \uac1c\ubc1c\uc790\uac00 \ud568\uc218\ub97c \uc120\uc5b8\ud558\uba74, gpt\uac00 \uc0ac\uc6a9\uc790 \uc785\ub825\uc5d0 \ub530\ub77c \uc5b4\ub5a4 \ud568\uc218\uac00 \ud638\ucd9c\ub418\uc5b4\uc57c \ud560\uc9c0 \uc778\uc2dd\ud55c \ud6c4 \ud638\ucd9c\ud558\uace0, JSON\uc73c\ub85c \uacb0\uacfc\ub97c \ub9ac\ud134 \ubaa8\ub378 \uc5c5\ub370\uc774\ud2b8 gpt-4-0613, gpt-4-32k-01613 \uc73c\ub85c \uc5c5\ub370\uc774\ud2b8 \ubc0f \ud568\uc218 \ud638\ucd9c \uae30\ub2a5 \ucd94\uac00 gpt-3.5-turbo-0613 \uc5c5... \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":28442,"url":"https:\/\/nori.company\/?p=28442","url_meta":{"origin":23788,"position":3},"title":"Paperless-ngx &#8211; \uc624\ud508 \uc18c\uc2a4 \ubb38\uc11c \uad00\ub9ac \uc2dc\uc2a4\ud15c","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 10\uc6d4 8\uc77c","format":false,"excerpt":"\ubb38\uc11c\ub97c \uc2a4\uce94, \uc778\ub371\uc2a4, \ubcf4\uad00\ud558\uc5ec \uac80\uc0c9\uac00\ub2a5\ud55c \uc628\ub77c\uc778 \uc544\uce74\uc774\ube0c\ub85c \ub9cc\ub4e4\uc5b4\uc8fc\ub294 \uc624\ud508\uc18c\uc2a4 \uc720\uc9c0\ubcf4\uc218\uac00 \uc911\ub2e8\ub41c paperless-ng \ub97c \ud3ec\ud06c\ud558\uc5ec \uacc4\uc18d \uc5c5\uadf8\ub808\uc774\ub4dc \ubc0f \uc720\uc9c0\ubcf4\uc218 \ubb38\uc11c OCR \ud558\uc5ec \uac80\uc0c9 \uac00\ub2a5\ud55c \ud14d\uc2a4\ud2b8\ub97c \ucd94\uac00, \ud0dc\uae45 \ubc0f \ud0c0\uc785\uc744 \ucd94\uac00 PDF , \uc774\ubbf8\uc9c0, \ud50c\ub808\uc778 \ud14d\uc2a4\ud2b8, \uc624\ud53c\uc2a4 \ubb38\uc11c(\uc6cc\ub4dc, \uc5d1\uc140... \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":22578,"url":"https:\/\/nori.company\/?p=22578","url_meta":{"origin":23788,"position":4},"title":"SQLite-gui &#8211; \uc708\ub3c4\uc6b0\uc6a9 \uacbd\ub7c9 SQLite \ud3b8\uc9d1\uae30","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 4\uc6d4 21\uc77c","format":false,"excerpt":"\uc124\uce58 \ud544\uc694 \uc5c6\uc74c. \uacbd\ub7c9, \ube60\ub974\uace0, \uac04\ub2e8\ud55c SQLite DB \ud3b8\uc9d1\uae30 SQL \uad6c\ubb38 \uac15\uc870 \ud45c\uc2dc \ubc0f \ucf54\ub4dc \uc644\uc131 \ub3d9\uc2dc\uc5d0 \uc5ec\ub7ec\uac1c \ud14c\uc774\ube14 \ud3b8\uc9d1 \uceec\ub7ec\ud654\ub41c \ub370\uc774\ud130 \uadf8\ub9ac\ub4dc \uc2e4\ud589 \uae30\ub85d \ubc0f \uc0ac\uc6a9\uc790 \uc2a4\ud06c\ub9bd\ud2b8 \uc800\uc7a5 \ub370\uc774\ud130 \uc784\ud3ec\ud2b8\/\uc775\uc2a4\ud3ec\ud2b8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub2e4\uc774\uc5b4\uadf8\ub7a8 \ub370\uc774\ud130\ubca0\uc774... \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":23538,"url":"https:\/\/nori.company\/?p=23538","url_meta":{"origin":23788,"position":5},"title":"DB-GPT &#8211; \ub85c\uceecGPT\ub85c \ub370\uc774\ud130\uc5d0 \ub300\ud574 \uc9c8\ubb38\ud558\uace0 \ub2f5\ubcc0 \ubc1b\uae30","author":"\ub178\ub9ac\ucef4\ud37c\ub2c8","date":"2023\ub144 5\uc6d4 25\uc77c","format":false,"excerpt":"Private LLM\uc744 \uad6c\ucd95\ud574\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ubc18 \uc2dc\ub098\ub9ac\uc624\ub97c \ucc98\ub9ac\ud558\ub294 \uc624\ud508\uc18c\uc2a4 \ud504\ub85c\uc81d\ud2b8 SQL \uc5b8\uc5b4 \uc0dd\uc131 \ubc0f \ubd84\uc11d \ube44\uacf5\uac1c \ub3c4\uba54\uc778 Q&A \ubc0f \ub370\uc774\ud130 \ucc98\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc9c0\uc2dd Q&A \ud50c\ub7ec\uadf8\uc778 \uae30\ub2a5 \uc81c\uacf5 Auto-GPT \ud50c\ub7ec\uadf8\uc778\uc744 \ub124\uc774\ud2f0\ube0c\ud558\uac8c \uc9c0\uc6d0\ud574\uc11c \uadf8\ub300\ub85c \uc2e4\ud589 ... \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\/23788","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=23788"}],"version-history":[{"count":1,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/23788\/revisions"}],"predecessor-version":[{"id":23789,"href":"https:\/\/nori.company\/index.php?rest_route=\/wp\/v2\/posts\/23788\/revisions\/23789"}],"wp:attachment":[{"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nori.company\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}