CINXE.COM
[B! sql] R2Mのブックマーク
<!DOCTYPE html> <html lang="ja" data-page-scope="User" data-stable-request-url="https://b.hatena.ne.jp/R2M/sql/" data-device-type="PC" data-sentry-environment="production" data-sentry-sample-rate="0.1" data-author-name="R2M" data-page-subtype="tag" data-page-type="user" data-platform="pc" data-search-query="" data-tag-filter="sql" data-visitor-name="ゲスト" > <head> <!-- Google Tag Manager --> <script> (function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-5TDHQX'); </script> <!-- End Google Tag Manager --> <meta charset="UTF-8"> <title>[B! sql] R2Mのブックマーク</title> <script src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/js/v4/bookmark.js" async></script> <link type="text/css" rel="stylesheet" href="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/css/v4/bookmark.css" /> <link type="text/css" rel="stylesheet" href="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/css/v4/bookmark.star.css" /> <link rel="canonical" href="https://b.hatena.ne.jp/R2M/sql/" /> <link rel="next" href="/R2M/sql/?page=2"> <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" /> <meta name="viewport" content="width=device-width"> <link rel="search" type="application/opensearchdescription+xml" title="はてなブックマーク検索" href="/opensearch.xml" /> <link rel="search" type="application/opensearchdescription+xml" title="R2M のブックマーク内検索" href="/R2M/opensearch.xml"> <link rel="apple-touch-icon-precomposed" href="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/apple-touch-icon-precomposed.png" /> <link rel="mask-icon" href="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/safari-pinned-tab-icon.svg" color="#00A4DE" /> <meta name="msapplication-navbutton-color" content="#2C6EBD" /> <meta name="msapplication-task" content="name=はてなブックマーク; action-uri=/; icon-uri=https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/icons/bookmark.ico" /> <meta name="msapplication-task" content="name=マイブックマーク; action-uri=/my; icon-uri=https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/icons/my-bookmark.ico" /> <meta name="msapplication-task" content="name=お気に入りのブックマーク; action-uri=/my/favorite; icon-uri=https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/icons/favorite-bookmark.ico" /> <meta name="msapplication-task" content="name=人気エントリー; action-uri=/hotentry; icon-uri=https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/icons/hotentry.ico" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="referrer" content="always"> <link rel="author" href="http://www.hatena.ne.jp/R2M/" /> <link rel="alternate" type="application/rss+xml" href="/R2M/bookmark.rss?tag=sql" /> <script> function isMobile() { const html = document.documentElement; const deviceType = html.dataset.deviceType || ''; if (deviceType.length > 0) { return deviceType === 'MOBILE'; } else { const maxMobileWidth = 480; const windowWidth = window.innerWidth; return maxMobileWidth >= windowWidth; } } </script> </head> <body class="page-centerarticle fixed-header"> <!-- Google Tag Manager (noscript) --> <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-5TDHQX" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript> <!-- End Google Tag Manager (noscript) --> <div class="link-app-banner js-dynamic-link-app-banner is-hidden"> <button class="link-app-banner-btn-close js-dynamic-link-app-banner-close-button"><span>close</span></button> <a class="link-app-banner-btn" href="https://hatenabookmark.page.link/app"> <div class="link-app-banner-btn-detail"> <div class="link-app-banner-icon"><img src="/images/v4/public/app/ic-ios.svg" alt="はてなブックマークアプリ"></div> <p class="link-app-banner-text">サクサク読めて、<br class="link-app-banner-text-newline">アプリ限定の機能も多数!</p> </div> <div class="link-app-banner-btn-open">アプリで開く</div> </a> </div> <header id="global-header" data-portal-static-origin="//cdn.www.st-hatena.com"> <div id="header" class="global-header-inner js-global-header-inner"> <h2 id="gh-logo"><a href="/" data-gtm-label="gh-blogo"><span>はてなブックマーク</span></a></h2> <div class="is-guest js-guest is-hidden"> <input id="gh-search-icon-check" type="checkbox" checked="checked" /> <label class="gh-search-icon" for="gh-search-icon-check" aria-label="検索を閉じる"><span>閉じる</span></label> <form class="gh-searchbox" method="get" action="/search_dwim" role="search"> <input value="" name="q" type="search" class="gh-inputtext" placeholder="キーワード・URLを検索" size="40" /> <input value="" type="submit" class="gh-search-button" /> </form> <ul class="gh-service-menu"> <li><a href="/guide" data-gtm-label="gh-guest-guide">はてなブックマークって?</a></li> <li><a href="/guide/tools" data-gtm-label="gh-guest-tools">アプリ・拡張の紹介</a></li> <li><a href="https://www.hatena.ne.jp/register?location=https%3A%2F%2Fb.hatena.ne.jp%2F%3Fregistered_from%3Dglobal-header&via=201037" class="gh-guest-register" data-gtm-label="gh-guest-register">ユーザー登録</a></li> <li><a href="https://www.hatena.ne.jp/login?location=https%3A%2F%2Fb.hatena.ne.jp%2FR2M%2Fsql%2F" rel="nofollow" class="gh-guest-login" data-gtm-label="gh-guest-login">ログイン</a></li> <li class="gh-hatena-logo"><a href="http://www.hatena.ne.jp/"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/logo/logo-global-white.svg" alt="Hatena" width="74px" height="13px"/></a></li> </ul> </div> <noscript> <ul class="gh-service-menu"> <li><a href="https://www.hatena.ne.jp/logout?location=https%3A%2F%2Fb.hatena.ne.jp%2F">ログアウト</a></li> </ul> </noscript> <script type="text/x-template" id="template-menu-hatena-user"> <form class="gh-searchbox" method="get" action="/search_dwim" role="search"> <input value="" name="q" type="search" class="gh-inputtext" placeholder="キーワード・URLを検索" size="40" /> <input value="" type="submit" class="gh-search-button" /> </form> <ul class="gh-service-menu"> <li><a class="hotentry" data-gtm-label="gh-mypage" href="{{hotentry_url}}"><img src="{{user_image_url}}" class="header-profile-icon" width="16" height="16" alt="{{username}}" /></a><a class="hotentry" data-gtm-label="gh-mypage" href="{{hotentry_url}}">マイページ</a></li> <li><a class="bookmark" data-gtm-label="gh-bookmark" href="{{bookmark_url}}">ブックマーク</a></li> <li><a class="unread_bookmark" data-gtm-label="gh-ril" href="{{bookmark_stock_url}}">あとで読む</a></li> <li><a class="add" data-gtm-label="gh-add" href="{{add_bookmark_url}}">追加</a></li> <li><a class="tools" data-gtm-label="gh-tools" href="/guide/tools">ツール</a></li> <li><a class="config" data-gtm-label="gh-config" href="/-/my/config/profile">設定</a></li> <li><a class="feedback" data-gtm-label="gh-feedback" href="/-/feedback/hatena_bookmark" target="_blank">フィードバック</a></li> <li id="header-username" class="gh-dropdown-services" data-gtm-label="gh-services" title="利用中のサービス" data-name="{{username}}"> <span class="header-dropdown gh-dropdown" tabindex="0"> <img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/usermenu-wh.svg" alt="利用中のサービス" width="24" height="24" /> </span> <dl class="header-window" id="username-window"></dl> </li> <li id="header-notify" data-gtm-label="gh-notify" class="gh-dropdown-notify" title="あなたへのお知らせ"> <span class="header-dropdown gh-dropdown" tabindex="0"> <img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/notify-wh.svg" alt="あなたへのお知らせ" width="25" height="25" /> <span class="notify-count"></span> </span> <div id="notify-window" class="header-window header-notify"></div> </li> <li class="gh-hatena-logo"><a href="http://www.hatena.ne.jp/"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/logo/logo-global-white.svg" alt="Hatena" width="74px" height="13px"/></a></li> </ul> </script> </div> </header> <div id="info-header"><div id="info-header-message"></div><span></span></div> <div class="global-notification is-hidden js-global-notification"></div> <div id="container" class="js-user-page-container" data-author-name="R2M" > <div class="centerarticle-wrapper"> <div class="left-container"> <div class="js-user-info" data-user-name="R2M"> <div class="centerarticle-profile"> <a href="http://profile.hatena.ne.jp/R2M/"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" class="centerarticle-profile-image"/> </a> <div class="centerarticle-profile-main"> <a href="http://profile.hatena.ne.jp/R2M/" class="centerarticle-profile-nickname js-user-info-nickname" target="_blank" rel="noopener">R2M</a> <a href="/R2M/bookmark" class="centerarticle-profile-username">id:R2M</a> </div> </div> <ul class="userprofile-status"> <li> <a href="/R2M/bookmark" class="userprofile-status-link" data-gtm-click-label="user-count-bookmark"> <span class="userprofile-status-count">37,614</span> <span class="userprofile-status-text">ブックマーク</span> </a> </li> <li> <a href="/R2M/follow" class="userprofile-status-link" data-gtm-click-label="user-count-follow"> <span class="userprofile-status-count js-total-followings">-</span> <span class="userprofile-status-text">お気に入り</span> </a> </li> <li> <a href="/R2M/follower" class="userprofile-status-link" data-gtm-click-label="user-count-follower"> <span class="userprofile-status-count js-total-followers">-</span> <span class="userprofile-status-text">お気に入られ</span> </a> </li> </ul> </div> <div class="centerarticle-mainNavi"> </div> <div class="centerarticle-sidebar-menu js-user-tags"> <h3 class="centerarticle-aside-title">タグ</h3> <ul class="centerarticle-sub-navi"> <li><a href="/R2M/bookmark" data-gtm-click-label="user-tags-all">すべて</a></li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%20%E3%83%8D%E3%82%BF/" data-gtm-click-label="user-tags"> ネタ <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/.net/" data-gtm-click-label="user-tags"> .net <span class="count">(113)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/2ch/" data-gtm-click-label="user-tags"> 2ch <span class="count">(497)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/3D/" data-gtm-click-label="user-tags"> 3D <span class="count">(142)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/3DCG/" data-gtm-click-label="user-tags"> 3DCG <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/3D%E3%83%97%E3%83%AA%E3%83%B3%E3%82%BF/" data-gtm-click-label="user-tags"> 3Dプリンタ <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/API/" data-gtm-click-label="user-tags"> API <span class="count">(119)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/AR/" data-gtm-click-label="user-tags"> AR <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/AV/" data-gtm-click-label="user-tags"> AV <span class="count">(109)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Amazon/" data-gtm-click-label="user-tags"> Amazon <span class="count">(78)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Arduino/" data-gtm-click-label="user-tags"> Arduino <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/C++/" data-gtm-click-label="user-tags"> C++ <span class="count">(47)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/CI/" data-gtm-click-label="user-tags"> CI <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/COVID-19/" data-gtm-click-label="user-tags"> COVID-19 <span class="count">(284)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/CPU/" data-gtm-click-label="user-tags"> CPU <span class="count">(109)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Chrome/" data-gtm-click-label="user-tags"> Chrome <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/DIY/" data-gtm-click-label="user-tags"> DIY <span class="count">(30)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/DirectX/" data-gtm-click-label="user-tags"> DirectX <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Dropbox/" data-gtm-click-label="user-tags"> Dropbox <span class="count">(8)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/EU/" data-gtm-click-label="user-tags"> EU <span class="count">(216)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Excel/" data-gtm-click-label="user-tags"> Excel <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/FPGA/" data-gtm-click-label="user-tags"> FPGA <span class="count">(52)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Firefox/" data-gtm-click-label="user-tags"> Firefox <span class="count">(8)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Framework/" data-gtm-click-label="user-tags"> Framework <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/GPGPU/" data-gtm-click-label="user-tags"> GPGPU <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/GPU/" data-gtm-click-label="user-tags"> GPU <span class="count">(64)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/GitHub/" data-gtm-click-label="user-tags"> GitHub <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Google/" data-gtm-click-label="user-tags"> Google <span class="count">(164)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Google%20App%20Engine/" data-gtm-click-label="user-tags"> Google App Engine <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/GraphQL/" data-gtm-click-label="user-tags"> GraphQL <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/HMD/" data-gtm-click-label="user-tags"> HMD <span class="count">(58)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/HPC/" data-gtm-click-label="user-tags"> HPC <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/HTML/" data-gtm-click-label="user-tags"> HTML <span class="count">(42)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/HTML5/" data-gtm-click-label="user-tags"> HTML5 <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/IMF/" data-gtm-click-label="user-tags"> IMF <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/ISIS/" data-gtm-click-label="user-tags"> ISIS <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/IT/" data-gtm-click-label="user-tags"> IT <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/LL/" data-gtm-click-label="user-tags"> LL <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/LLM/" data-gtm-click-label="user-tags"> LLM <span class="count">(44)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/LLVM/" data-gtm-click-label="user-tags"> LLVM <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/MVC/" data-gtm-click-label="user-tags"> MVC <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/MVNO/" data-gtm-click-label="user-tags"> MVNO <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/NHK/" data-gtm-click-label="user-tags"> NHK <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/OSS/" data-gtm-click-label="user-tags"> OSS <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Oculus%20Rift/" data-gtm-click-label="user-tags"> Oculus Rift <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/OculusRift/" data-gtm-click-label="user-tags"> OculusRift <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/OpenCV/" data-gtm-click-label="user-tags"> OpenCV <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/P2P/" data-gtm-click-label="user-tags"> P2P <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/PC/" data-gtm-click-label="user-tags"> PC <span class="count">(185)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/PC%E3%83%91%E3%83%BC%E3%83%84/" data-gtm-click-label="user-tags"> PCパーツ <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/PC%E5%91%A8%E8%BE%BA%E6%A9%9F%E5%99%A8/" data-gtm-click-label="user-tags"> PC周辺機器 <span class="count">(104)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Raspberry%20Pi/" data-gtm-click-label="user-tags"> Raspberry Pi <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Ruby/" data-gtm-click-label="user-tags"> Ruby <span class="count">(124)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/SF/" data-gtm-click-label="user-tags"> SF <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/SRE/" data-gtm-click-label="user-tags"> SRE <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/TPP/" data-gtm-click-label="user-tags"> TPP <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/TV/" data-gtm-click-label="user-tags"> TV <span class="count">(124)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Tensorflow/" data-gtm-click-label="user-tags"> Tensorflow <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Togetter/" data-gtm-click-label="user-tags"> Togetter <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/TypeScript/" data-gtm-click-label="user-tags"> TypeScript <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/UI/" data-gtm-click-label="user-tags"> UI <span class="count">(62)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/UML/" data-gtm-click-label="user-tags"> UML <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/USB/" data-gtm-click-label="user-tags"> USB <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Unix/" data-gtm-click-label="user-tags"> Unix <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/VR/" data-gtm-click-label="user-tags"> VR <span class="count">(165)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Visual%20Studio/" data-gtm-click-label="user-tags"> Visual Studio <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Vue.js/" data-gtm-click-label="user-tags"> Vue.js <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/WebAssembly/" data-gtm-click-label="user-tags"> WebAssembly <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/YouTube/" data-gtm-click-label="user-tags"> YouTube <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/android/" data-gtm-click-label="user-tags"> android <span class="count">(418)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/art/" data-gtm-click-label="user-tags"> art <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/aws/" data-gtm-click-label="user-tags"> aws <span class="count">(138)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/azure/" data-gtm-click-label="user-tags"> azure <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/bash/" data-gtm-click-label="user-tags"> bash <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/bitcoin/" data-gtm-click-label="user-tags"> bitcoin <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/bluetooth/" data-gtm-click-label="user-tags"> bluetooth <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/business/" data-gtm-click-label="user-tags"> business <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/c%23/" data-gtm-click-label="user-tags"> c# <span class="count">(51)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/css/" data-gtm-click-label="user-tags"> css <span class="count">(72)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/database/" data-gtm-click-label="user-tags"> database <span class="count">(316)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/deep%20learning/" data-gtm-click-label="user-tags"> deep learning <span class="count">(61)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/docker/" data-gtm-click-label="user-tags"> docker <span class="count">(82)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/driver/" data-gtm-click-label="user-tags"> driver <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/electron/" data-gtm-click-label="user-tags"> electron <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/filesystem/" data-gtm-click-label="user-tags"> filesystem <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/git/" data-gtm-click-label="user-tags"> git <span class="count">(64)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/go/" data-gtm-click-label="user-tags"> go <span class="count">(45)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/hardware/" data-gtm-click-label="user-tags"> hardware <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/http/" data-gtm-click-label="user-tags"> http <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/ingress/" data-gtm-click-label="user-tags"> ingress <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/ios/" data-gtm-click-label="user-tags"> ios <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/iot/" data-gtm-click-label="user-tags"> iot <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/iphone/" data-gtm-click-label="user-tags"> iphone <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/ipv6/" data-gtm-click-label="user-tags"> ipv6 <span class="count">(8)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/jQuery/" data-gtm-click-label="user-tags"> jQuery <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/java/" data-gtm-click-label="user-tags"> java <span class="count">(69)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/javascript/" data-gtm-click-label="user-tags"> javascript <span class="count">(291)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/kernel/" data-gtm-click-label="user-tags"> kernel <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/kinect/" data-gtm-click-label="user-tags"> kinect <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/kubernetes/" data-gtm-click-label="user-tags"> kubernetes <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/library/" data-gtm-click-label="user-tags"> library <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/linux/" data-gtm-click-label="user-tags"> linux <span class="count">(222)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/markdown/" data-gtm-click-label="user-tags"> markdown <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/microservice/" data-gtm-click-label="user-tags"> microservice <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/microsoft/" data-gtm-click-label="user-tags"> microsoft <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/music/" data-gtm-click-label="user-tags"> music <span class="count">(88)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/mysql/" data-gtm-click-label="user-tags"> mysql <span class="count">(85)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/network/" data-gtm-click-label="user-tags"> network <span class="count">(144)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/node.js/" data-gtm-click-label="user-tags"> node.js <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/os/" data-gtm-click-label="user-tags"> os <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/php/" data-gtm-click-label="user-tags"> php <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/programming/" data-gtm-click-label="user-tags"> programming <span class="count">(126)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/python/" data-gtm-click-label="user-tags"> python <span class="count">(99)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/rails/" data-gtm-click-label="user-tags"> rails <span class="count">(55)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/react/" data-gtm-click-label="user-tags"> react <span class="count">(172)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/redmine/" data-gtm-click-label="user-tags"> redmine <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/rust/" data-gtm-click-label="user-tags"> rust <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/rx/" data-gtm-click-label="user-tags"> rx <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/science/" data-gtm-click-label="user-tags"> science <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/security/" data-gtm-click-label="user-tags"> security <span class="count">(121)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/serverless/" data-gtm-click-label="user-tags"> serverless <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/shop/" data-gtm-click-label="user-tags"> shop <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/software/" data-gtm-click-label="user-tags"> software <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/sql/" class="is-current" data-gtm-click-label="user-tags"> sql <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/sqlserver/" data-gtm-click-label="user-tags"> sqlserver <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/tool/" data-gtm-click-label="user-tags"> tool <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/twitter/" data-gtm-click-label="user-tags"> twitter <span class="count">(37)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/unity/" data-gtm-click-label="user-tags"> unity <span class="count">(46)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/web/" data-gtm-click-label="user-tags"> web <span class="count">(182)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/web%E3%82%B5%E3%83%BC%E3%83%93%E3%82%B9/" data-gtm-click-label="user-tags"> webサービス <span class="count">(320)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/web%E3%83%87%E3%82%B6%E3%82%A4%E3%83%B3/" data-gtm-click-label="user-tags"> webデザイン <span class="count">(55)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/web%E6%BC%AB%E7%94%BB/" data-gtm-click-label="user-tags"> web漫画 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/windows/" data-gtm-click-label="user-tags"> windows <span class="count">(242)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/x86/" data-gtm-click-label="user-tags"> x86 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%82%E3%81%A8%E3%81%A7%E8%AA%AD%E3%82%80/" data-gtm-click-label="user-tags"> あとで読む <span class="count">(315)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%84%E3%81%98%E3%82%81/" data-gtm-click-label="user-tags"> いじめ <span class="count">(29)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%91%E3%81%97%E3%81%8B%E3%82%89%E3%82%93/" data-gtm-click-label="user-tags"> けしからん <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%93%E3%82%8C%E3%81%AF%E3%81%99%E3%81%94%E3%81%84/" data-gtm-click-label="user-tags"> これはすごい <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%93%E3%82%8C%E3%81%AF%E3%81%B2%E3%81%A9%E3%81%84/" data-gtm-click-label="user-tags"> これはひどい <span class="count">(74)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%AF%E3%81%A6%E3%81%AA/" data-gtm-click-label="user-tags"> はてな <span class="count">(40)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%AF%E3%81%A6%E3%83%96/" data-gtm-click-label="user-tags"> はてブ <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%BE%E3%81%A8%E3%82%81/" data-gtm-click-label="user-tags"> まとめ <span class="count">(66)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%8B%E3%83%A1/" data-gtm-click-label="user-tags"> アニメ <span class="count">(257)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%95%E3%83%AA%E3%82%AB/" data-gtm-click-label="user-tags"> アフリカ <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%97%E3%83%AA/" data-gtm-click-label="user-tags"> アプリ <span class="count">(50)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%A1%E3%83%AA%E3%82%AB/" data-gtm-click-label="user-tags"> アメリカ <span class="count">(241)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%AB%E3%82%B4%E3%83%AA%E3%82%BA%E3%83%A0/" data-gtm-click-label="user-tags"> アルゴリズム <span class="count">(64)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%BC%E3%82%AD%E3%83%86%E3%82%AF%E3%83%81%E3%83%A3/" data-gtm-click-label="user-tags"> アーキテクチャ <span class="count">(58)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%BC%E3%83%88/" data-gtm-click-label="user-tags"> アート <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%82%AE%E3%83%AA%E3%82%B9/" data-gtm-click-label="user-tags"> イギリス <span class="count">(58)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%82%B9%E3%83%A9%E3%83%A0/" data-gtm-click-label="user-tags"> イスラム <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%82%BF%E3%83%AA%E3%82%A2/" data-gtm-click-label="user-tags"> イタリア <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%99%E3%83%B3%E3%83%88/" data-gtm-click-label="user-tags"> イベント <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%A9%E3%82%B9%E3%83%88/" data-gtm-click-label="user-tags"> イラスト <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%93%E3%83%A5%E3%83%BC/" data-gtm-click-label="user-tags"> インタビュー <span class="count">(91)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%BC%E3%83%8D%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> インターネット <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%B3%E3%83%89/" data-gtm-click-label="user-tags"> インド <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%B3%E3%83%95%E3%83%A9/" data-gtm-click-label="user-tags"> インフラ <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A6%E3%82%AF%E3%83%A9%E3%82%A4%E3%83%8A/" data-gtm-click-label="user-tags"> ウクライナ <span class="count">(250)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A8%E3%83%87%E3%82%A3%E3%82%BF/" data-gtm-click-label="user-tags"> エディタ <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A8%E3%83%8D%E3%83%AB%E3%82%AE%E3%83%BC/" data-gtm-click-label="user-tags"> エネルギー <span class="count">(550)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2/" data-gtm-click-label="user-tags"> エンジニア <span class="count">(115)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%B3/" data-gtm-click-label="user-tags"> エンジン <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AA%E3%83%AA%E3%83%B3%E3%83%94%E3%83%83%E3%82%AF/" data-gtm-click-label="user-tags"> オリンピック <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AA%E3%83%BC%E3%82%B9%E3%83%88%E3%83%A9%E3%83%AA%E3%82%A2/" data-gtm-click-label="user-tags"> オーストラリア <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AA%E3%83%BC%E3%83%97%E3%83%B3%E3%82%BD%E3%83%BC%E3%82%B9/" data-gtm-click-label="user-tags"> オープンソース <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AB%E3%83%A1%E3%83%A9/" data-gtm-click-label="user-tags"> カメラ <span class="count">(56)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AB%E3%83%AB%E3%83%88/" data-gtm-click-label="user-tags"> カルト <span class="count">(184)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AC%E3%82%B8%E3%82%A7%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> ガジェット <span class="count">(77)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AE%E3%83%AA%E3%82%B7%E3%83%A3/" data-gtm-click-label="user-tags"> ギリシャ <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AF%E3%83%A9%E3%82%A6%E3%83%89/" data-gtm-click-label="user-tags"> クラウド <span class="count">(75)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AF%E3%83%AC%E3%82%B8%E3%83%83%E3%83%88%E3%82%AB%E3%83%BC%E3%83%89/" data-gtm-click-label="user-tags"> クレジットカード <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B2%E3%83%BC%E3%83%A0/" data-gtm-click-label="user-tags"> ゲーム <span class="count">(653)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%82%B1%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3/" data-gtm-click-label="user-tags"> コミュニケーション <span class="count">(106)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B3%E3%83%B3%E3%83%86%E3%83%8A/" data-gtm-click-label="user-tags"> コンテナ <span class="count">(57)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B3%E3%83%B3%E3%83%91%E3%82%A4%E3%83%A9/" data-gtm-click-label="user-tags"> コンパイラ <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B5%E3%83%83%E3%82%AB%E3%83%BC/" data-gtm-click-label="user-tags"> サッカー <span class="count">(98)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B5%E3%83%BC%E3%83%90%E3%83%BC/" data-gtm-click-label="user-tags"> サーバー <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B5%E3%83%BC%E3%83%93%E3%82%B9/" data-gtm-click-label="user-tags"> サービス <span class="count">(63)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B7%E3%82%B9%E3%83%86%E3%83%A0/" data-gtm-click-label="user-tags"> システム <span class="count">(204)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B7%E3%82%B9%E3%83%86%E3%83%A0%E9%96%8B%E7%99%BA/" data-gtm-click-label="user-tags"> システム開発 <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B7%E3%83%AA%E3%82%A2/" data-gtm-click-label="user-tags"> シリア <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B9%E3%82%A6%E3%82%A7%E3%83%BC%E3%83%87%E3%83%B3/" data-gtm-click-label="user-tags"> スウェーデン <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B9%E3%83%9D%E3%83%BC%E3%83%84/" data-gtm-click-label="user-tags"> スポーツ <span class="count">(152)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B9%E3%83%9E%E3%83%9B/" data-gtm-click-label="user-tags"> スマホ <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B9%E3%83%9E%E3%83%BC%E3%83%88%E3%83%95%E3%82%A9%E3%83%B3/" data-gtm-click-label="user-tags"> スマートフォン <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%BB%E3%82%AD%E3%83%A5%E3%83%AA%E3%83%86%E3%82%A3/" data-gtm-click-label="user-tags"> セキュリティ <span class="count">(128)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%BD%E3%83%95%E3%83%88%E3%82%A6%E3%82%A7%E3%82%A2/" data-gtm-click-label="user-tags"> ソフトウェア <span class="count">(63)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%81%E3%83%99%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> チベット <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%84%E3%83%BC%E3%83%AB/" data-gtm-click-label="user-tags"> ツール <span class="count">(74)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%86%E3%82%B9%E3%83%88/" data-gtm-click-label="user-tags"> テスト <span class="count">(106)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%86%E3%83%AC%E3%83%93/" data-gtm-click-label="user-tags"> テレビ <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%86%E3%83%AD/" data-gtm-click-label="user-tags"> テロ <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%82%A3%E3%82%B9%E3%83%97%E3%83%AC%E3%82%A4/" data-gtm-click-label="user-tags"> ディスプレイ <span class="count">(40)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%82%B6%E3%82%A4%E3%83%B3/" data-gtm-click-label="user-tags"> デザイン <span class="count">(84)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%83%90%E3%82%A4%E3%82%B9/" data-gtm-click-label="user-tags"> デバイス <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF/" data-gtm-click-label="user-tags"> データ <span class="count">(125)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9/" data-gtm-click-label="user-tags"> データベース <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF%E5%88%86%E6%9E%90/" data-gtm-click-label="user-tags"> データ分析 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%88%E3%83%A9%E3%83%96%E3%83%AB/" data-gtm-click-label="user-tags"> トラブル <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%88%E3%83%AB%E3%82%B3/" data-gtm-click-label="user-tags"> トルコ <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%88%E3%83%B3%E3%83%87%E3%83%A2/" data-gtm-click-label="user-tags"> トンデモ <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%89%E3%82%A4%E3%83%84/" data-gtm-click-label="user-tags"> ドイツ <span class="count">(139)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%89%E3%83%A9%E3%83%9E/" data-gtm-click-label="user-tags"> ドラマ <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8B%E3%82%B3%E3%83%8B%E3%82%B3%E5%8B%95%E7%94%BB/" data-gtm-click-label="user-tags"> ニコニコ動画 <span class="count">(157)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8B%E3%82%BB%E5%8C%BB%E7%99%82/" data-gtm-click-label="user-tags"> ニセ医療 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8B%E3%82%BB%E7%A7%91%E5%AD%A6/" data-gtm-click-label="user-tags"> ニセ科学 <span class="count">(52)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8B%E3%83%A5%E3%83%BC%E3%82%B9/" data-gtm-click-label="user-tags"> ニュース <span class="count">(21)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8D%E3%82%BF/" data-gtm-click-label="user-tags"> ネタ <span class="count">(890)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8D%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> ネット <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8D%E3%83%83%E3%83%88%E3%83%AF%E3%83%BC%E3%82%AF/" data-gtm-click-label="user-tags"> ネットワーク <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8F%E3%83%BC%E3%83%89%E3%82%A6%E3%82%A7%E3%82%A2/" data-gtm-click-label="user-tags"> ハードウェア <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%90%E3%83%83%E3%83%86%E3%83%AA%E3%83%BC/" data-gtm-click-label="user-tags"> バッテリー <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-tags"> パフォーマンス <span class="count">(44)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%93%E3%82%B8%E3%83%8D%E3%82%B9/" data-gtm-click-label="user-tags"> ビジネス <span class="count">(496)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%82%A1%E3%83%83%E3%82%B7%E3%83%A7%E3%83%B3/" data-gtm-click-label="user-tags"> ファッション <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%82%A9%E3%83%B3%E3%83%88/" data-gtm-click-label="user-tags"> フォント <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%A9%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-tags"> フランス <span class="count">(55)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%AA%E3%83%BC%E3%82%BD%E3%83%95%E3%83%88/" data-gtm-click-label="user-tags"> フリーソフト <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%AA%E3%83%BC%E3%83%A9%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-tags"> フリーランス <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%AC%E3%83%BC%E3%83%A0%E3%83%AF%E3%83%BC%E3%82%AF/" data-gtm-click-label="user-tags"> フレームワーク <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%AD%E3%83%B3%E3%83%88%E3%82%A8%E3%83%B3%E3%83%89/" data-gtm-click-label="user-tags"> フロントエンド <span class="count">(46)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%96%E3%83%A9%E3%82%A6%E3%82%B6/" data-gtm-click-label="user-tags"> ブラウザ <span class="count">(52)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%96%E3%83%A9%E3%83%83%E3%82%AF/" data-gtm-click-label="user-tags"> ブラック <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%96%E3%83%A9%E3%83%83%E3%82%AF%E4%BC%81%E6%A5%AD/" data-gtm-click-label="user-tags"> ブラック企業 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%96%E3%83%AD%E3%83%83%E3%82%AF%E3%83%81%E3%82%A7%E3%83%BC%E3%83%B3/" data-gtm-click-label="user-tags"> ブロックチェーン <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B0%E3%83%A9%E3%83%9F%E3%83%B3%E3%82%B0/" data-gtm-click-label="user-tags"> プログラミング <span class="count">(271)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B0%E3%83%A9%E3%83%9F%E3%83%B3%E3%82%B0%E8%A8%80%E8%AA%9E/" data-gtm-click-label="user-tags"> プログラミング言語 <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88/" data-gtm-click-label="user-tags"> プロジェクト <span class="count">(42)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88%E7%AE%A1%E7%90%86/" data-gtm-click-label="user-tags"> プロジェクト管理 <span class="count">(42)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%83%AC%E3%82%B9/" data-gtm-click-label="user-tags"> プロレス <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%99%E3%83%88%E3%83%8A%E3%83%A0/" data-gtm-click-label="user-tags"> ベトナム <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%99%E3%83%B3%E3%83%81%E3%83%A3%E3%83%BC/" data-gtm-click-label="user-tags"> ベンチャー <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9B%E3%83%A1%E3%82%AA%E3%83%91%E3%82%B7%E3%83%BC/" data-gtm-click-label="user-tags"> ホメオパシー <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9E%E3%82%A4%E3%83%8A%E3%83%B3%E3%83%90%E3%83%BC/" data-gtm-click-label="user-tags"> マイナンバー <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9E%E3%82%B9%E3%82%B3%E3%83%9F/" data-gtm-click-label="user-tags"> マスコミ <span class="count">(138)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9E%E3%83%8D%E3%82%B8%E3%83%A1%E3%83%B3%E3%83%88/" data-gtm-click-label="user-tags"> マネジメント <span class="count">(53)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9E%E3%83%B3%E3%82%AC/" data-gtm-click-label="user-tags"> マンガ <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A1%E3%83%87%E3%82%A3%E3%82%A2/" data-gtm-click-label="user-tags"> メディア <span class="count">(130)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A1%E3%83%B3%E3%82%BF%E3%83%AB/" data-gtm-click-label="user-tags"> メンタル <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A1%E3%83%B3%E3%82%BF%E3%83%AB%E3%83%98%E3%83%AB%E3%82%B9/" data-gtm-click-label="user-tags"> メンタルヘルス <span class="count">(45)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A2%E3%83%90%E3%82%A4%E3%83%AB/" data-gtm-click-label="user-tags"> モバイル <span class="count">(56)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A9%E3%82%A4%E3%83%88%E3%83%8E%E3%83%99%E3%83%AB/" data-gtm-click-label="user-tags"> ライトノベル <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A9%E3%82%A4%E3%83%96%E3%83%A9%E3%83%AA/" data-gtm-click-label="user-tags"> ライブラリ <span class="count">(54)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%AC%E3%82%B7%E3%83%94/" data-gtm-click-label="user-tags"> レシピ <span class="count">(262)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%AC%E3%83%93%E3%83%A5%E3%83%BC/" data-gtm-click-label="user-tags"> レビュー <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%AD%E3%82%B7%E3%82%A2/" data-gtm-click-label="user-tags"> ロシア <span class="count">(406)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%AD%E3%83%9C%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> ロボット <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%B8%8D%E5%8B%95%E7%94%A3/" data-gtm-click-label="user-tags"> 不動産 <span class="count">(231)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%B8%AD%E5%9B%BD/" data-gtm-click-label="user-tags"> 中国 <span class="count">(748)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%B8%AD%E5%A4%AE%E9%8A%80%E8%A1%8C/" data-gtm-click-label="user-tags"> 中央銀行 <span class="count">(163)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%B8%AD%E6%9D%B1/" data-gtm-click-label="user-tags"> 中東 <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%8B%E4%BB%B6/" data-gtm-click-label="user-tags"> 事件 <span class="count">(561)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%8B%E6%95%85/" data-gtm-click-label="user-tags"> 事故 <span class="count">(146)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%8B%E6%A5%AD/" data-gtm-click-label="user-tags"> 事業 <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%A4%E9%80%9A/" data-gtm-click-label="user-tags"> 交通 <span class="count">(129)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E4%BA%8B/" data-gtm-click-label="user-tags"> 人事 <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E5%8F%A3/" data-gtm-click-label="user-tags"> 人口 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E5%B7%A5%E7%9F%A5%E8%83%BD/" data-gtm-click-label="user-tags"> 人工知能 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E6%9D%90/" data-gtm-click-label="user-tags"> 人材 <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E6%A8%A9/" data-gtm-click-label="user-tags"> 人権 <span class="count">(150)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E7%89%A9/" data-gtm-click-label="user-tags"> 人物 <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E7%94%9F/" data-gtm-click-label="user-tags"> 人生 <span class="count">(271)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BB%8B%E8%AD%B7/" data-gtm-click-label="user-tags"> 介護 <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BB%8F%E6%95%99/" data-gtm-click-label="user-tags"> 仏教 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BB%95%E4%BA%8B/" data-gtm-click-label="user-tags"> 仕事 <span class="count">(514)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BB%AE%E6%83%B3%E9%80%9A%E8%B2%A8/" data-gtm-click-label="user-tags"> 仮想通貨 <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BC%81%E6%A5%AD/" data-gtm-click-label="user-tags"> 企業 <span class="count">(252)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BC%9A%E7%A4%BE/" data-gtm-click-label="user-tags"> 会社 <span class="count">(78)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BC%9A%E8%A8%88/" data-gtm-click-label="user-tags"> 会計 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BD%8F%E5%AE%85/" data-gtm-click-label="user-tags"> 住宅 <span class="count">(96)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BF%9D%E9%99%BA/" data-gtm-click-label="user-tags"> 保険 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%81%A5%E5%BA%B7/" data-gtm-click-label="user-tags"> 健康 <span class="count">(135)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%86%99%E7%9C%9F/" data-gtm-click-label="user-tags"> 写真 <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%87%BA%E7%89%88/" data-gtm-click-label="user-tags"> 出版 <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8A%B4%E5%83%8D/" data-gtm-click-label="user-tags"> 労働 <span class="count">(1064)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8A%B4%E5%83%8D%E7%B5%84%E5%90%88/" data-gtm-click-label="user-tags"> 労働組合 <span class="count">(39)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8B%95%E7%89%A9/" data-gtm-click-label="user-tags"> 動物 <span class="count">(83)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8B%95%E7%94%BB/" data-gtm-click-label="user-tags"> 動画 <span class="count">(64)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8C%96%E5%AD%A6/" data-gtm-click-label="user-tags"> 化学 <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8C%97%E6%9C%9D%E9%AE%AE/" data-gtm-click-label="user-tags"> 北朝鮮 <span class="count">(74)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8C%BB%E7%99%82/" data-gtm-click-label="user-tags"> 医療 <span class="count">(924)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8D%8A%E5%B0%8E%E4%BD%93/" data-gtm-click-label="user-tags"> 半導体 <span class="count">(112)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8E%9F%E5%AD%90%E5%8A%9B/" data-gtm-click-label="user-tags"> 原子力 <span class="count">(80)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8E%9F%E7%99%BA/" data-gtm-click-label="user-tags"> 原発 <span class="count">(552)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8F%B0%E6%B9%BE/" data-gtm-click-label="user-tags"> 台湾 <span class="count">(51)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8F%B8%E6%B3%95/" data-gtm-click-label="user-tags"> 司法 <span class="count">(140)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%90%8C%E4%BA%BA/" data-gtm-click-label="user-tags"> 同人 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%95%86%E5%93%81/" data-gtm-click-label="user-tags"> 商品 <span class="count">(58)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%96%B6%E6%A5%AD/" data-gtm-click-label="user-tags"> 営業 <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9B%B3%E6%9B%B8%E9%A4%A8/" data-gtm-click-label="user-tags"> 図書館 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9B%BD%E5%82%B5/" data-gtm-click-label="user-tags"> 国債 <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9B%BD%E9%9A%9B/" data-gtm-click-label="user-tags"> 国際 <span class="count">(600)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E4%B8%AD%E7%86%B1/" data-gtm-click-label="user-tags"> 地中熱 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E5%9B%B3/" data-gtm-click-label="user-tags"> 地図 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E6%96%B9/" data-gtm-click-label="user-tags"> 地方 <span class="count">(147)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E7%86%B1/" data-gtm-click-label="user-tags"> 地熱 <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E7%86%B1%E7%99%BA%E9%9B%BB/" data-gtm-click-label="user-tags"> 地熱発電 <span class="count">(104)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E7%90%86/" data-gtm-click-label="user-tags"> 地理 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E9%9C%87/" data-gtm-click-label="user-tags"> 地震 <span class="count">(40)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A0%B1%E9%81%93/" data-gtm-click-label="user-tags"> 報道 <span class="count">(61)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A2%97%E7%94%B0/" data-gtm-click-label="user-tags"> 増田 <span class="count">(550)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A4%96%E4%BA%A4/" data-gtm-click-label="user-tags"> 外交 <span class="count">(266)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A4%A7%E5%AD%A6/" data-gtm-click-label="user-tags"> 大学 <span class="count">(145)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A4%A7%E9%98%AA/" data-gtm-click-label="user-tags"> 大阪 <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A4%AA%E9%99%BD%E5%85%89%E7%99%BA%E9%9B%BB/" data-gtm-click-label="user-tags"> 太陽光発電 <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A5%91%E7%B4%84/" data-gtm-click-label="user-tags"> 契約 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AD%90%E3%81%A9%E3%82%82/" data-gtm-click-label="user-tags"> 子ども <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AD%90%E4%BE%9B/" data-gtm-click-label="user-tags"> 子供 <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AD%90%E8%82%B2%E3%81%A6/" data-gtm-click-label="user-tags"> 子育て <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AD%A6%E7%BF%92/" data-gtm-click-label="user-tags"> 学習 <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%87%E5%AE%99/" data-gtm-click-label="user-tags"> 宇宙 <span class="count">(68)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%87%E5%AE%99%E9%96%8B%E7%99%BA/" data-gtm-click-label="user-tags"> 宇宙開発 <span class="count">(29)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%89%E5%85%A8%E4%BF%9D%E9%9A%9C/" data-gtm-click-label="user-tags"> 安全保障 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%97%E6%95%99/" data-gtm-click-label="user-tags"> 宗教 <span class="count">(197)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%9F%E9%A8%93/" data-gtm-click-label="user-tags"> 実験 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%B6%E5%BA%AD/" data-gtm-click-label="user-tags"> 家庭 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%B6%E6%97%8F/" data-gtm-click-label="user-tags"> 家族 <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%B6%E9%9B%BB/" data-gtm-click-label="user-tags"> 家電 <span class="count">(126)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B0%86%E6%A3%8B/" data-gtm-click-label="user-tags"> 将棋 <span class="count">(37)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B0%8F%E8%AA%AC/" data-gtm-click-label="user-tags"> 小説 <span class="count">(54)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B0%91%E5%AD%90%E5%8C%96/" data-gtm-click-label="user-tags"> 少子化 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B1%B1%E5%BD%A2/" data-gtm-click-label="user-tags"> 山形 <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B7%AE%E5%88%A5/" data-gtm-click-label="user-tags"> 差別 <span class="count">(134)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B9%B4%E9%87%91/" data-gtm-click-label="user-tags"> 年金 <span class="count">(67)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BA%83%E5%91%8A/" data-gtm-click-label="user-tags"> 広告 <span class="count">(37)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BB%BA%E7%AF%89/" data-gtm-click-label="user-tags"> 建築 <span class="count">(102)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BB%BA%E8%A8%AD/" data-gtm-click-label="user-tags"> 建設 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BE%8C%E3%81%A7/" data-gtm-click-label="user-tags"> 後で <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BE%93%E8%BB%8D%E6%85%B0%E5%AE%89%E5%A9%A6/" data-gtm-click-label="user-tags"> 従軍慰安婦 <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BF%83%E7%90%86/" data-gtm-click-label="user-tags"> 心理 <span class="count">(109)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%80%9D%E6%83%B3/" data-gtm-click-label="user-tags"> 思想 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%80%A7/" data-gtm-click-label="user-tags"> 性 <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%83%85%E5%A0%B1/" data-gtm-click-label="user-tags"> 情報 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%85%B0%E5%AE%89%E5%A9%A6%E5%95%8F%E9%A1%8C/" data-gtm-click-label="user-tags"> 慰安婦問題 <span class="count">(57)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%86%B2%E6%B3%95/" data-gtm-click-label="user-tags"> 憲法 <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%88%A6%E4%BA%89/" data-gtm-click-label="user-tags"> 戦争 <span class="count">(252)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%8A%80%E8%A1%93/" data-gtm-click-label="user-tags"> 技術 <span class="count">(223)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%8A%95%E8%B3%87/" data-gtm-click-label="user-tags"> 投資 <span class="count">(168)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%8E%A1%E7%94%A8/" data-gtm-click-label="user-tags"> 採用 <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%8F%89%E3%82%81%E4%BA%8B/" data-gtm-click-label="user-tags"> 揉め事 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%90%BA%E5%B8%AF/" data-gtm-click-label="user-tags"> 携帯 <span class="count">(89)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BE%E5%B0%84%E8%83%BD/" data-gtm-click-label="user-tags"> 放射能 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BE%E9%80%81/" data-gtm-click-label="user-tags"> 放送 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BF%E5%BA%9C/" data-gtm-click-label="user-tags"> 政府 <span class="count">(39)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BF%E6%B2%BB/" data-gtm-click-label="user-tags"> 政治 <span class="count">(2269)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BF%E7%AD%96/" data-gtm-click-label="user-tags"> 政策 <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%95%99%E8%82%B2/" data-gtm-click-label="user-tags"> 教育 <span class="count">(498)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%95%B0%E5%AD%A6/" data-gtm-click-label="user-tags"> 数学 <span class="count">(116)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%87%E5%8C%96/" data-gtm-click-label="user-tags"> 文化 <span class="count">(168)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%87%E5%AD%A6/" data-gtm-click-label="user-tags"> 文学 <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%87%E6%88%BF%E5%85%B7/" data-gtm-click-label="user-tags"> 文房具 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%87%E7%AB%A0/" data-gtm-click-label="user-tags"> 文章 <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%99%E7%90%86/" data-gtm-click-label="user-tags"> 料理 <span class="count">(219)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%97%85/" data-gtm-click-label="user-tags"> 旅 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%97%85%E8%A1%8C/" data-gtm-click-label="user-tags"> 旅行 <span class="count">(86)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%97%A5%E6%9C%AC/" data-gtm-click-label="user-tags"> 日本 <span class="count">(204)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%97%A5%E9%8A%80/" data-gtm-click-label="user-tags"> 日銀 <span class="count">(324)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%98%A0%E5%83%8F/" data-gtm-click-label="user-tags"> 映像 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%98%A0%E7%94%BB/" data-gtm-click-label="user-tags"> 映画 <span class="count">(250)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9B%B8%E7%B1%8D/" data-gtm-click-label="user-tags"> 書籍 <span class="count">(103)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9B%B8%E8%A9%95/" data-gtm-click-label="user-tags"> 書評 <span class="count">(122)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9C%80%E9%81%A9%E5%8C%96/" data-gtm-click-label="user-tags"> 最適化 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9C%AC/" data-gtm-click-label="user-tags"> 本 <span class="count">(62)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9D%B1%E6%97%A5%E6%9C%AC%E5%A4%A7%E9%9C%87%E7%81%BD/" data-gtm-click-label="user-tags"> 東日本大震災 <span class="count">(44)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9D%B1%E9%9B%BB/" data-gtm-click-label="user-tags"> 東電 <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9E%97%E6%A5%AD/" data-gtm-click-label="user-tags"> 林業 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%A0%BC%E5%B7%AE/" data-gtm-click-label="user-tags"> 格差 <span class="count">(29)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%A8%AA%E6%B5%9C/" data-gtm-click-label="user-tags"> 横浜 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%A9%9F%E6%A2%B0%E5%AD%A6%E7%BF%92/" data-gtm-click-label="user-tags"> 機械学習 <span class="count">(309)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AC%A7%E5%B7%9E/" data-gtm-click-label="user-tags"> 欧州 <span class="count">(69)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AD%A3%E8%A6%8F%E8%A1%A8%E7%8F%BE/" data-gtm-click-label="user-tags"> 正規表現 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AD%AF%E7%A7%91/" data-gtm-click-label="user-tags"> 歯科 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AD%B4%E5%8F%B2/" data-gtm-click-label="user-tags"> 歴史 <span class="count">(524)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AD%B4%E5%8F%B2%E4%BF%AE%E6%AD%A3%E4%B8%BB%E7%BE%A9/" data-gtm-click-label="user-tags"> 歴史修正主義 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B0%97%E8%B1%A1/" data-gtm-click-label="user-tags"> 気象 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B1%BA%E6%B8%88/" data-gtm-click-label="user-tags"> 決済 <span class="count">(100)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B2%96%E7%B8%84/" data-gtm-click-label="user-tags"> 沖縄 <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B3%95%E5%BE%8B/" data-gtm-click-label="user-tags"> 法律 <span class="count">(76)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B5%B7%E5%A4%96/" data-gtm-click-label="user-tags"> 海外 <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B5%B7%E5%A4%96%E3%81%AE%E5%8F%8D%E5%BF%9C/" data-gtm-click-label="user-tags"> 海外の反応 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B7%B1%E5%B1%A4%E5%AD%A6%E7%BF%92/" data-gtm-click-label="user-tags"> 深層学習 <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%BC%81%E6%A5%AD/" data-gtm-click-label="user-tags"> 漁業 <span class="count">(69)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%BC%AB%E7%94%BB/" data-gtm-click-label="user-tags"> 漫画 <span class="count">(351)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%81%BD%E5%AE%B3/" data-gtm-click-label="user-tags"> 災害 <span class="count">(96)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%82%8E%E4%B8%8A/" data-gtm-click-label="user-tags"> 炎上 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%82%BA%E6%9B%BF/" data-gtm-click-label="user-tags"> 為替 <span class="count">(92)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%84%A1%E7%B7%9A/" data-gtm-click-label="user-tags"> 無線 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%89%A9%E6%B5%81/" data-gtm-click-label="user-tags"> 物流 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%89%A9%E7%90%86/" data-gtm-click-label="user-tags"> 物理 <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%89%B9%E8%A8%B1/" data-gtm-click-label="user-tags"> 特許 <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%8A%AF%E7%BD%AA/" data-gtm-click-label="user-tags"> 犯罪 <span class="count">(143)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%8C%AB/" data-gtm-click-label="user-tags"> 猫 <span class="count">(21)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%92%B0%E5%A2%83/" data-gtm-click-label="user-tags"> 環境 <span class="count">(170)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%9F%E6%B4%BB/" data-gtm-click-label="user-tags"> 生活 <span class="count">(213)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%9F%E7%89%A9/" data-gtm-click-label="user-tags"> 生物 <span class="count">(63)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%9F%E7%94%A3%E6%80%A7/" data-gtm-click-label="user-tags"> 生産性 <span class="count">(21)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%A3%E6%A5%AD/" data-gtm-click-label="user-tags"> 産業 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%BB%E5%83%8F/" data-gtm-click-label="user-tags"> 画像 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%BB%E5%83%8F%E5%87%A6%E7%90%86/" data-gtm-click-label="user-tags"> 画像処理 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%9A%87%E5%AE%A4/" data-gtm-click-label="user-tags"> 皇室 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%9B%A3%E8%A6%96/" data-gtm-click-label="user-tags"> 監視 <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A0%94%E7%A9%B6/" data-gtm-click-label="user-tags"> 研究 <span class="count">(402)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A4%BE%E4%BC%9A/" data-gtm-click-label="user-tags"> 社会 <span class="count">(1921)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A4%BE%E4%BC%9A%E4%BF%9D%E9%9A%9C/" data-gtm-click-label="user-tags"> 社会保障 <span class="count">(48)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A6%8F%E7%A5%89/" data-gtm-click-label="user-tags"> 福祉 <span class="count">(100)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A7%91%E5%AD%A6/" data-gtm-click-label="user-tags"> 科学 <span class="count">(212)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A8%8E/" data-gtm-click-label="user-tags"> 税 <span class="count">(117)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A8%8E%E5%88%B6/" data-gtm-click-label="user-tags"> 税制 <span class="count">(194)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A8%8E%E9%87%91/" data-gtm-click-label="user-tags"> 税金 <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%AE%A1%E7%90%86/" data-gtm-click-label="user-tags"> 管理 <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B1%B3%E5%9B%BD/" data-gtm-click-label="user-tags"> 米国 <span class="count">(214)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B2%BE%E7%A5%9E/" data-gtm-click-label="user-tags"> 精神 <span class="count">(59)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B4%A0%E6%9D%90/" data-gtm-click-label="user-tags"> 素材 <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%84%E3%81%BF%E8%BE%BC%E3%81%BF/" data-gtm-click-label="user-tags"> 組み込み <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%84%E7%B9%94/" data-gtm-click-label="user-tags"> 組織 <span class="count">(46)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%8C%E5%96%B6/" data-gtm-click-label="user-tags"> 経営 <span class="count">(91)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%8C%E6%B8%88/" data-gtm-click-label="user-tags"> 経済 <span class="count">(1993)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%8C%E6%B8%88%E5%AD%A6/" data-gtm-click-label="user-tags"> 経済学 <span class="count">(364)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%B1%E8%A8%88/" data-gtm-click-label="user-tags"> 統計 <span class="count">(131)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%B1%E8%A8%88%E5%AD%A6/" data-gtm-click-label="user-tags"> 統計学 <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%82%B2%E5%85%90/" data-gtm-click-label="user-tags"> 育児 <span class="count">(75)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%84%B3/" data-gtm-click-label="user-tags"> 脳 <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E5%8B%95%E8%BB%8A/" data-gtm-click-label="user-tags"> 自動車 <span class="count">(213)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E5%8B%95%E9%81%8B%E8%BB%A2/" data-gtm-click-label="user-tags"> 自動運転 <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E6%B2%BB%E4%BD%93/" data-gtm-click-label="user-tags"> 自治体 <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E7%84%B6%E8%A8%80%E8%AA%9E%E5%87%A6%E7%90%86/" data-gtm-click-label="user-tags"> 自然言語処理 <span class="count">(44)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E8%A1%9B%E9%9A%8A/" data-gtm-click-label="user-tags"> 自衛隊 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%88%AA%E7%A9%BA/" data-gtm-click-label="user-tags"> 航空 <span class="count">(39)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%88%B9/" data-gtm-click-label="user-tags"> 船 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%8A%B8%E8%83%BD/" data-gtm-click-label="user-tags"> 芸能 <span class="count">(211)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%8A%B8%E8%A1%93/" data-gtm-click-label="user-tags"> 芸術 <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%8B%B1%E5%9B%BD/" data-gtm-click-label="user-tags"> 英国 <span class="count">(46)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%8B%B1%E8%AA%9E/" data-gtm-click-label="user-tags"> 英語 <span class="count">(73)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%91%97%E4%BD%9C%E6%A8%A9/" data-gtm-click-label="user-tags"> 著作権 <span class="count">(68)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%99%90%E6%AE%BA/" data-gtm-click-label="user-tags"> 虐殺 <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A1%8C%E6%94%BF/" data-gtm-click-label="user-tags"> 行政 <span class="count">(838)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A1%A8%E7%8F%BE/" data-gtm-click-label="user-tags"> 表現 <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A3%81%E5%88%A4/" data-gtm-click-label="user-tags"> 裁判 <span class="count">(73)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A3%BD%E5%93%81/" data-gtm-click-label="user-tags"> 製品 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A3%BD%E9%80%A0/" data-gtm-click-label="user-tags"> 製造 <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A6%8F%E5%88%B6/" data-gtm-click-label="user-tags"> 規制 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A6%8F%E6%A0%BC/" data-gtm-click-label="user-tags"> 規格 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A6%B3%E5%85%89/" data-gtm-click-label="user-tags"> 観光 <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A8%80%E8%91%89/" data-gtm-click-label="user-tags"> 言葉 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A8%80%E8%AA%9E/" data-gtm-click-label="user-tags"> 言語 <span class="count">(60)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A8%AD%E8%A8%88/" data-gtm-click-label="user-tags"> 設計 <span class="count">(200)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A8%B4%E8%A8%9F/" data-gtm-click-label="user-tags"> 訴訟 <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AA%8D%E8%A8%BC/" data-gtm-click-label="user-tags"> 認証 <span class="count">(96)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AA%AD%E3%81%BF%E7%89%A9/" data-gtm-click-label="user-tags"> 読み物 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AA%BF%E6%9F%BB/" data-gtm-click-label="user-tags"> 調査 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AB%96%E6%96%87/" data-gtm-click-label="user-tags"> 論文 <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AB%9C%E5%A0%B1/" data-gtm-click-label="user-tags"> 諜報 <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AD%A6%E5%AF%9F/" data-gtm-click-label="user-tags"> 警察 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AD%B0%E8%AB%96/" data-gtm-click-label="user-tags"> 議論 <span class="count">(50)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B2%A1%E6%94%BF/" data-gtm-click-label="user-tags"> 財政 <span class="count">(99)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B2%A7%E5%9B%B0/" data-gtm-click-label="user-tags"> 貧困 <span class="count">(66)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B2%BF%E6%98%93/" data-gtm-click-label="user-tags"> 貿易 <span class="count">(93)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B3%87%E6%96%99/" data-gtm-click-label="user-tags"> 資料 <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B3%87%E6%BA%90/" data-gtm-click-label="user-tags"> 資源 <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%BB%8A/" data-gtm-click-label="user-tags"> 車 <span class="count">(85)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%BB%8D%E4%BA%8B/" data-gtm-click-label="user-tags"> 軍事 <span class="count">(502)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%BE%B2%E6%A5%AD/" data-gtm-click-label="user-tags"> 農業 <span class="count">(195)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%80%9A%E4%BF%A1/" data-gtm-click-label="user-tags"> 通信 <span class="count">(97)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%80%9A%E8%B2%A8/" data-gtm-click-label="user-tags"> 通貨 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%81%8B%E7%94%A8/" data-gtm-click-label="user-tags"> 運用 <span class="count">(93)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%81%93%E5%85%B7/" data-gtm-click-label="user-tags"> 道具 <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%81%B8%E6%8C%99/" data-gtm-click-label="user-tags"> 選挙 <span class="count">(172)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%83%B5%E6%94%BF/" data-gtm-click-label="user-tags"> 郵政 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%83%BD%E5%B8%82/" data-gtm-click-label="user-tags"> 都市 <span class="count">(56)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%85%92/" data-gtm-click-label="user-tags"> 酒 <span class="count">(77)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%87%8E%E7%90%83/" data-gtm-click-label="user-tags"> 野球 <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%87%91%E8%9E%8D/" data-gtm-click-label="user-tags"> 金融 <span class="count">(558)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%87%91%E8%9E%8D%E6%94%BF%E7%AD%96/" data-gtm-click-label="user-tags"> 金融政策 <span class="count">(184)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%89%84%E9%81%93/" data-gtm-click-label="user-tags"> 鉄道 <span class="count">(63)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%8A%80%E8%A1%8C/" data-gtm-click-label="user-tags"> 銀行 <span class="count">(74)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%96%8B%E7%99%BA/" data-gtm-click-label="user-tags"> 開発 <span class="count">(491)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9A%9C%E5%AE%B3/" data-gtm-click-label="user-tags"> 障害 <span class="count">(100)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%87%E7%94%A8/" data-gtm-click-label="user-tags"> 雇用 <span class="count">(106)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%A3%E6%B0%91/" data-gtm-click-label="user-tags"> 難民 <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%8A%9B/" data-gtm-click-label="user-tags"> 電力 <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%8A%9B%E4%BC%9A%E7%A4%BE/" data-gtm-click-label="user-tags"> 電力会社 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%AD%90/" data-gtm-click-label="user-tags"> 電子 <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%AD%90%E5%B7%A5%E4%BD%9C/" data-gtm-click-label="user-tags"> 電子工作 <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%AD%90%E6%9B%B8%E7%B1%8D/" data-gtm-click-label="user-tags"> 電子書籍 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E6%B0%97/" data-gtm-click-label="user-tags"> 電気 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E8%A9%B1/" data-gtm-click-label="user-tags"> 電話 <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9F%93%E5%9B%BD/" data-gtm-click-label="user-tags"> 韓国 <span class="count">(186)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9F%B3%E6%A5%BD/" data-gtm-click-label="user-tags"> 音楽 <span class="count">(173)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%A0%98%E5%9C%9F/" data-gtm-click-label="user-tags"> 領土 <span class="count">(70)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%A3%9F/" data-gtm-click-label="user-tags"> 食 <span class="count">(625)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%A3%9F%E5%93%81/" data-gtm-click-label="user-tags"> 食品 <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%A6%99%E6%B8%AF/" data-gtm-click-label="user-tags"> 香港 <span class="count">(18)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E6%94%BF%E6%B2%BB/" data-gtm-click-label="user-tags"> 政治 <span class="count">(2269)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E7%B5%8C%E6%B8%88/" data-gtm-click-label="user-tags"> 経済 <span class="count">(1993)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E7%A4%BE%E4%BC%9A/" data-gtm-click-label="user-tags"> 社会 <span class="count">(1921)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E5%8A%B4%E5%83%8D/" data-gtm-click-label="user-tags"> 労働 <span class="count">(1064)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E5%8C%BB%E7%99%82/" data-gtm-click-label="user-tags"> 医療 <span class="count">(924)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E3%83%8D%E3%82%BF/" data-gtm-click-label="user-tags"> ネタ <span class="count">(890)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E8%A1%8C%E6%94%BF/" data-gtm-click-label="user-tags"> 行政 <span class="count">(838)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E4%B8%AD%E5%9B%BD/" data-gtm-click-label="user-tags"> 中国 <span class="count">(748)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E3%82%B2%E3%83%BC%E3%83%A0/" data-gtm-click-label="user-tags"> ゲーム <span class="count">(653)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E9%A3%9F/" data-gtm-click-label="user-tags"> 食 <span class="count">(625)</span> </a> </li> </ul> <p class="centerarticle-sub-navi-more"> <button type="button" class="js-display-all-tags" data-gtm-click-label="user-tags-show-all">タグをすべて表示</button> </p> </div> <div class="centerarticle-sidebar-menu"> <h3 class="centerarticle-aside-title">関連タグで絞り込む (23)</h3> <ul class="centerarticle-sub-navi"> <li> <a href="/R2M/sql/azure/" > azure </a> </li> <li> <a href="/R2M/sql/BigQuery/" > BigQuery </a> </li> <li> <a href="/R2M/sql/database/" > database </a> </li> <li> <a href="/R2M/sql/DWH/" > DWH </a> </li> <li> <a href="/R2M/sql/google/" > google </a> </li> <li> <a href="/R2M/sql/GPU/" > GPU </a> </li> <li> <a href="/R2M/sql/Linux/" > Linux </a> </li> <li> <a href="/R2M/sql/orm/" > orm </a> </li> <li> <a href="/R2M/sql/programming/" > programming </a> </li> <li> <a href="/R2M/sql/SQL/" > SQL </a> </li> <li> <a href="/R2M/sql/tool/" > tool </a> </li> <li> <a href="/R2M/sql/TypeScript/" > TypeScript </a> </li> <li> <a href="/R2M/sql/%E3%82%A2%E3%83%B3%E3%83%81%E3%83%91%E3%82%BF%E3%83%BC%E3%83%B3/" > アンチパターン </a> </li> <li> <a href="/R2M/sql/%E3%82%A8%E3%83%87%E3%82%A3%E3%82%BF/" > エディタ </a> </li> <li> <a href="/R2M/sql/%E3%83%81%E3%83%A5%E3%83%BC%E3%83%8B%E3%83%B3%E3%82%B0/" > チューニング </a> </li> <li> <a href="/R2M/sql/%E3%83%87%E3%83%BC%E3%82%BF/" > データ </a> </li> <li> <a href="/R2M/sql/%E3%83%87%E3%83%BC%E3%82%BF%E5%88%86%E6%9E%90/" > データ分析 </a> </li> <li> <a href="/R2M/sql/%E3%83%97%E3%83%AD%E3%82%B0%E3%83%A9%E3%83%9F%E3%83%B3%E3%82%B0/" > プログラミング </a> </li> <li> <a href="/R2M/sql/%E5%AD%A6%E7%BF%92/" > 学習 </a> </li> <li> <a href="/R2M/sql/%E6%9B%B8%E8%A9%95/" > 書評 </a> </li> <li> <a href="/R2M/sql/%E6%A9%9F%E6%A2%B0%E5%AD%A6%E7%BF%92/" > 機械学習 </a> </li> <li> <a href="/R2M/sql/%E8%A8%80%E8%AA%9E/" > 言語 </a> </li> <li> <a href="/R2M/sql/%E8%A8%AD%E8%A8%88/" > 設計 </a> </li> </ul> <p class="centerarticle-sub-navi-more"> <a href="/R2M/bookmark">タグの絞り込みを解除</a> </p> </div> </div> <div class="center-container"> <div class="centerarticle-title-container"> <h2 class="centerarticle-title"> sqlに関するR2Mのブックマーク (36) </h2> </div> <div class="js-user-bookmark-item-autoload-container" data-next-page-path="/R2M/sql/?page=2" data-next-xhr-path="/api/users/R2M/bookmarks?tag=sql&page=2" data-next-label="次のページ" > <script type="text/x-template" id="template-short-url-click"> {{#tweet_url}} <a href="{{tweet_url}}" target="_blank" rel="noopener noreferrer" data-gtm-click-label="reaction-twitter-clicks"><span>{{count}} clicks</span></a> {{/tweet_url}} {{^tweet_url}} <span>{{count}} clicks</span> {{/tweet_url}} </script> <script type="text/x-template" id="template-bookmark-item"> {{^is_wiped}} <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="{{url}}"> <div class="centerarticle-entry {{#has_image}}is-image-entry-unit{{/has_image}}"> <h3 class="centerarticle-entry-title"> <a href="{{url}}" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener{{#noreferrer}} noreferrer{{/noreferrer}}" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="{{favicon_url}}" alt="">{{title}}</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="{{page_url}}" class="js-keyboard-entry-page-openable" title="{{title}} ({{total_bookmarks}}ブックマーク)" data-gtm-click-label="user-bookmark-users">{{total_bookmarks_with_user_postfix}}</a> </span> </li> <li> <a href="/R2M/{{url_query}}" title="『{{root_title}}』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> {{root_title}} </a> </li> {{#is_categorized}} <li><a href="{{category_path}}" data-gtm-click-label="user-bookmark-category">{{category_title}}</a></li> {{/is_categorized}} </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">{{{summary_with_keyword_links}}}</p> {{#has_image}} <a href="{{canonical_url}}" class="centerarticle-entry-image" target="_blank" rel="noopener{{#noreferrer}} noreferrer{{/noreferrer}}" data-gtm-click-label="user-bookmark-thumb"> <img src="{{image_url}}" alt="{{title}}"> </a> {{/has_image}} </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-{{location_id}}"> <div class="centerarticle-reaction-comment js-user-bookmark-comment {{badge_icon}}" data-url="{{url}}" data-user-name="{{author_name}}"> <a href="{{top_page_path}}" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="{{profile_icon_url}}" alt="{{author_name}}" title="{{author_name}}" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="{{anchor_url}}" class="js-anchor-path" data-gtm-click-label="user-reaction-username">{{author_name}}</a></span> <span class="centerarticle-reaction-timestamp">{{created}}</span> <span class="js-private-icon status {{#is_public}}is-hidden{{/is_public}}"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment">{{{comment_expanded}}}</span> <ul class="centerarticle-reaction-tags js-tag-text"> {{#tags}} <li><a href="/{{author_name}}/{{escaped_label}}/" data-gtm-click-label="user-reaction-tag">{{label}}</a></li> {{/tags}} </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="{{#is_bookmark}}comment-permalink{{/is_bookmark}}{{^is_bookmark}}original-permalink{{/is_bookmark}} js-comment-permalink"> <a href="{{comment_page_path}}" data-gtm-click-label="user-reaction-permalink" rel="{{#should_nofollow}}nofollow{{/should_nofollow}}">{{#is_bookmark}}リスト{{/is_bookmark}}{{^is_bookmark}}リンク{{/is_bookmark}}</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> {{#following_bookmarks}} <li> <a href="{{anchor_url}}" class="following-bookmark-link" data-gtm-click-label="user-bookmark-following-bookmarker-icon"> <img src="{{profile_icon_url}}" alt="{{author_name}}" class="following-bookmark-icon" > </a> <span class="following-bookmark-popup"> <span class="following-bookmark-username">{{author_name}}</span><span class="following-bookmark-timestamp">{{created}}</span> <span class="following-bookmark-text"> {{ #comment }}<span class="following-bookmark-comment">{{ comment }}</span>{{ /comment }} <ul class="following-bookmark-tags"> {{ #tags }}<li>{{ label }}</li>{{ /tags }} </ul> </span> </span> </li> {{/following_bookmarks}} {{#following_bookmarks.length}} <li class="centerarticle-reaction-following-more"><button type="button" class="js-show-all-following-bookmarks" data-gtm-click-label="user-bookmark-showall-following-bookmarks">すべて表示</button></li> {{/following_bookmarks.length}} </ul> <div class="js-user-following-bookmarks-detail is-hidden"> {{#following_bookmarks}} <div class="centerarticle-reaction-comment js-user-bookmark-comment {{badge_icon}}" data-url="{{url}}" data-user-name="{{author_name}}"> <a href="{{top_page_path}}" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="{{profile_icon_url}}" alt="{{author_name}}" title="{{author_name}}" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="{{anchor_url}}" class="js-anchor-path" data-gtm-click-label="user-reaction-username">{{author_name}}</a></span> <span class="centerarticle-reaction-timestamp">{{created}}</span> <span class="js-private-icon status {{#is_public}}is-hidden{{/is_public}}"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment">{{{comment_expanded}}}</span> <ul class="centerarticle-reaction-tags js-tag-text"> {{#tags}} <li><a href="/{{author_name}}/{{escaped_label}}/" data-gtm-click-label="user-reaction-tag">{{label}}</a></li> {{/tags}} </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="{{#is_bookmark}}comment-permalink{{/is_bookmark}}{{^is_bookmark}}original-permalink{{/is_bookmark}} js-comment-permalink"> <a href="{{comment_page_path}}" data-gtm-click-label="user-reaction-permalink" rel="{{#should_nofollow}}nofollow{{/should_nofollow}}">{{#is_bookmark}}リスト{{/is_bookmark}}{{^is_bookmark}}リンク{{/is_bookmark}}</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> {{/following_bookmarks}} </div> </li> {{/is_wiped}} </script> <script type="text/x-template" id="template-following-bookmarker-icon"> <li> <a href="{{anchor_url}}" class="following-bookmark-link" data-gtm-click-label="user-bookmark-following-bookmarker-icon"> <img src="{{profile_icon_url}}" alt="{{author_name}}" class="following-bookmark-icon" > </a> <span class="following-bookmark-popup"> <span class="following-bookmark-username">{{author_name}}</span><span class="following-bookmark-timestamp">{{created}}</span> <span class="following-bookmark-text"> {{ #comment }}<span class="following-bookmark-comment">{{ comment }}</span>{{ /comment }} <ul class="following-bookmark-tags"> {{ #tags }}<li>{{ label }}</li>{{ /tags }} </ul> </span> </span> </li> </script> <script type="text/x-template" id="template-bookmark-item-editor"> <div class="centerarticle-entry {{#has_image}}is-image-entry-unit{{/has_image}}"> <h3 class="centerarticle-entry-title"> <a href="{{url}}" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener{{#noreferrer}} noreferrer{{/noreferrer}}" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="{{favicon_url}}" alt="">{{title}}</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="{{page_url}}" class="js-keyboard-entry-page-openable" title="{{title}} ({{total_bookmarks}}ブックマーク)" data-gtm-click-label="user-bookmark-users">{{total_bookmarks_with_user_postfix}}</a> </span> </li> <li> <a href="/R2M/{{url_query}}" title="『{{root_title}}』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> {{root_title}} </a> </li> {{#is_categorized}} <li><a href="{{category_path}}" data-gtm-click-label="user-bookmark-category">{{category_title}}</a></li> {{/is_categorized}} </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">{{{summary_with_keyword_links}}}</p> {{#has_image}} <a href="{{canonical_url}}" class="centerarticle-entry-image" target="_blank" rel="noopener{{#noreferrer}} noreferrer{{/noreferrer}}" data-gtm-click-label="user-bookmark-thumb"> <img src="{{image_url}}" alt="{{title}}"> </a> {{/has_image}} </div> </div> </script> <script type="text/x-template" id="template-bookmark-pager"> <li> <div class="centerarticle-pager"> <span class="centerarticle-waiting js-read-more-waiting is-hidden"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/loading@2x.gif" alt="残りのブックマークを読み込んでいます" width="16" height="16" /></span> {{#previous}} <a href="{{page_path}}">{{label}}</a> {{/previous}} {{#pages}} {{#page_path}} <span><a href="{{page_path}}">{{label}}</a></span> {{/page_path}} {{^page_path}} <span>{{label}}</span> {{/page_path}} {{/pages}} {{#next}} <a href="{{page_path}}">{{label}}</a> {{/next}} </div> </li> </script> <ul class="js-user-bookmark-item-list js-keyboard-controllable-container"> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://github.com/lovasoa/SQLpage"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://github.com/lovasoa/SQLpage" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fgithub.com%2Flovasoa%2FSQLpage" alt="">GitHub - lovasoa/SQLpage: Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/github.com/lovasoa/SQLpage" class="js-keyboard-entry-page-openable" title="GitHub - lovasoa/SQLpage: Fast SQL-only data application builder. Automatically build a UI on top of SQL queries. (5ブックマーク)" data-gtm-click-label="user-bookmark-users">5 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fgithub.com%2Flovasoa" title="『github.com/lovasoa』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> github.com/lovasoa </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">You signed in w<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>h another tab or window. Reload to refresh your <a data-gtm-click-label="entry-summary-keyword" href="/q/session">session</a>. You signed out in another tab or window. Reload to refresh your <a data-gtm-click-label="entry-summary-keyword" href="/q/session">session</a>. You <a data-gtm-click-label="entry-summary-keyword" href="/q/Switch">switch</a>ed accounts on another tab or window. Reload to refresh your <a data-gtm-click-label="entry-summary-keyword" href="/q/session">session</a>. Dismiss alert</p> <a href="https://github.com/lovasoa/SQLpage" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/450a6938c83f84e462479597e5aec80ff6c18c66/height=288;version=1;width=512/https%3A%2F%2Frepository-images.githubusercontent.com%2F519912039%2F32be5f4d-6a55-49b5-a317-b14f2cea82a6" alt="GitHub - lovasoa/SQLpage: Fast SQL-only data application builder. Automatically build a UI on top of SQL queries."> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4757366873405396000"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://github.com/lovasoa/SQLpage" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240901#bookmark-4757366873405396000" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/09/01</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4757366873405396000/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://www.publickey1.jp/blog/24/googlecommon_expression_languagecel.html"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://www.publickey1.jp/blog/24/googlecommon_expression_languagecel.html" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fwww.publickey1.jp%2Fblog%2F24%2Fgooglecommon_expression_languagecel.html" alt="">Google、超高速に評価可能でポータブルな式言語「Common Expression Language」(CEL)発表</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/www.publickey1.jp/blog/24/googlecommon_expression_languagecel.html" class="js-keyboard-entry-page-openable" title="Google、超高速に評価可能でポータブルな式言語「Common Expression Language」(CEL)発表 (146ブックマーク)" data-gtm-click-label="user-bookmark-users">146 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fwww.publickey1.jp%2F" title="『www.publickey1.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> www.publickey1.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"><a data-gtm-click-label="entry-summary-keyword" href="/q/google">Google</a>、超高速に評価可能でポータブルな式言語「Co<a data-gtm-click-label="entry-summary-keyword" href="/q/MMO">mmo</a>n Expression Language」(CEL)発表 式言語とは一般に、プログラミング言語の一部やネットワークなどの構成ファイル、テンプレートファイルなどの中で、簡易な式やロジック、ポリシーなどを記述する際に使われる言語のことです。 こうした用途では、さまざまなプラットフォームに対応する移植性、起動時やプログラムの実行中に評価されることがあることから高速に評価が完了すること、安全に評価が実行できること、用途に応じて拡張しやすいこと、などが求められます。 CELは超高速に評価、ポータブル、サブセットサポート CELは正にこうした要件に対応した式言語となっており、<a data-gtm-click-label="entry-summary-keyword" href="/q/google">Google</a>は次のような特徴があるとしています。 ナノ秒からマイクロ秒程度の高速な評価に最適化されている <a data-gtm-click-label="entry-summary-keyword" href="/q/c%2B%2B">C++</a>、<a data-gtm-click-label="entry-summary-keyword" href="/q/Java">Java</a>、<a data-gtm-click-label="entry-summary-keyword" href="/q/go">Go</a>でサポートされるスタックによるポータブ</p> <a href="https://www.publickey1.jp/blog/24/googlecommon_expression_languagecel.html" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/1b268f279318706262db2adb7d89961193744a2c/height=288;version=1;width=512/https%3A%2F%2Fwww.publickey1.jp%2F2024%2Fgoogle-cel-la.png" alt="Google、超高速に評価可能でポータブルな式言語「Common Expression Language」(CEL)発表"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4755185615586902336"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://www.publickey1.jp/blog/24/googlecommon_expression_languagecel.html" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240621#bookmark-4755185615586902336" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/06/21</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment">「SQLにシームレスに変換」</span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/%E8%A8%80%E8%AA%9E/" data-gtm-click-label="user-reaction-tag">言語</a></li> <li><a href="/R2M/google/" data-gtm-click-label="user-reaction-tag">google</a></li> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4755185615586902336/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://zenn.dev/shiguredo/articles/sqlc-gen-typescript"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://zenn.dev/shiguredo/articles/sqlc-gen-typescript" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fzenn.dev%2Fshiguredo%2Farticles%2Fsqlc-gen-typescript" alt="">sqlc を TypeScript で利用する</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/zenn.dev/shiguredo/articles/sqlc-gen-typescript" class="js-keyboard-entry-page-openable" title="sqlc を TypeScript で利用する (59ブックマーク)" data-gtm-click-label="user-bookmark-users">59 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fzenn.dev%2Fshiguredo" title="『zenn.dev/shiguredo』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> zenn.dev/shiguredo </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">まとめ <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c-gen-<a data-gtm-click-label="entry-summary-keyword" href="/q/TypeScript">typescript</a> かなり良い 自分が <a data-gtm-click-label="entry-summary-keyword" href="/q/TypeScript">TypeScript</a> でウェブアプリを利用するなら間違いなく <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c を選択する <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> は共通言語という点で<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>当に偉大 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c とは <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c とは <a data-gtm-click-label="entry-summary-keyword" href="/q/go">Go</a> で書かれた <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> を元にコードを生成するツール。 なぜ <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c ? 結局、それぞれの <a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">ORM</a> 固有の<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%8A%80%E8%A1%93">技術</a>を覚えるくらいなら <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> を覚えた方が早い 拡張に <a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">ORM</a> が対応していようがいまいが関係ない <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> パーサーが pg_query_<a data-gtm-click-label="entry-summary-keyword" href="/q/go">go</a> を利用しているので信頼できる <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c は Po<a data-gtm-click-label="entry-summary-keyword" href="/q/stg">stg</a>re<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> だけなの? <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c は <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> や <a data-gtm-click-label="entry-summary-keyword" href="/q/SQLite">SQLite</a> にも対応している。 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c は <a data-gtm-click-label="entry-summary-keyword" href="/q/go">Go</a> だけなの? <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>c は <a data-gtm-click-label="entry-summary-keyword" href="/q/wasm">Wasm</a> でプラグインが書けるようになってきており、つい最近 <a data-gtm-click-label="entry-summary-keyword" href="/q/TypeScript">TypeScript</a> 版がリリースされた。 現時点では、 Po<a data-gtm-click-label="entry-summary-keyword" href="/q/stg">stg</a>r</p> <a href="https://zenn.dev/shiguredo/articles/sqlc-gen-typescript" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/ef1c6102d013ee1a559eeb54bb79e31f374928c3/height=288;version=1;width=512/https%3A%2F%2Fres.cloudinary.com%2Fzenn%2Fimage%2Fupload%2Fs--k9kaeOyx--%2Fc_fit%252Cg_north_west%252Cl_text%3Anotosansjp-medium.otf_55%3Asqlc%252520%2525E3%252582%252592%252520TypeScript%252520%2525E3%252581%2525A7%2525E5%252588%2525A9%2525E7%252594%2525A8%2525E3%252581%252599%2525E3%252582%25258B%252Cw_1010%252Cx_90%252Cy_100%2Fg_south_west%252Cl_text%3Anotosansjp-medium.otf_34%3Avoluntas%252Cx_220%252Cy_108%2Fbo_3px_solid_rgb%3Ad6e3ed%252Cg_south_west%252Ch_90%252Cl_fetch%3AaHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL3plbm4tdXNlci11cGxvYWQvYXZhdGFyLzAwYzA1YTI0OWUuanBlZw%3D%3D%252Cr_20%252Cw_90%252Cx_92%252Cy_102%2Fco_rgb%3A6e7b85%252Cg_south_west%252Cl_text%3Anotosansjp-medium.otf_30%3A%2525E6%252599%252582%2525E9%25259B%2525A8%2525E5%2525A0%252582%2525E3%252583%25258E%2525E3%252583%2525BC%2525E3%252583%252588%252Cx_220%252Cy_160%2Fbo_4px_solid_white%252Cg_south_west%252Ch_50%252Cl_fetch%3AaHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL3plbm4tdXNlci11cGxvYWQvYXZhdGFyL2RkMTU4OGE4NzUuanBlZw%3D%3D%252Cr_max%252Cw_50%252Cx_139%252Cy_84%2Fv1627283836%2Fdefault%2Fog-base-w1200-v2.png" alt="sqlc を TypeScript で利用する"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4746908351091867919"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://zenn.dev/shiguredo/articles/sqlc-gen-typescript" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240505#bookmark-4746908351091867919" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/05/05</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/TypeScript/" data-gtm-click-label="user-reaction-tag">TypeScript</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4746908351091867919/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://qiita.com/zackey2/items/883616dff71e51bf6563"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://qiita.com/zackey2/items/883616dff71e51bf6563" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fqiita.com%2Fzackey2%2Fitems%2F883616dff71e51bf6563" alt="">リーダブルSQL[より良いSQLを書くためのシンプルで実践的なテクニック] - Qiita</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/qiita.com/zackey2/items/883616dff71e51bf6563" class="js-keyboard-entry-page-openable" title="リーダブルSQL[より良いSQLを書くためのシンプルで実践的なテクニック] - Qiita (350ブックマーク)" data-gtm-click-label="user-bookmark-users">350 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fqiita.com%2Fzackey2" title="『qiita.com/zackey2』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> qiita.com/zackey2 </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">はじめに 最近<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a>界隈では「<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%AA%E3%83%BC%E3%83%80%E3%83%96%E3%83%AB%E3%82%B3%E3%83%BC%E3%83%89">リーダブルコード</a>」が話題なっていますね。 <a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%AA%E3%83%BC%E3%83%80%E3%83%96%E3%83%AB%E3%82%B3%E3%83%BC%E3%83%89">リーダブルコード</a>では、このような定理が紹介されています。 「コードは他の人が最短時間で理解できるように書かなければいけない。」 Dustin Boswell <a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%AA%E3%83%BC%E3%83%80%E3%83%96%E3%83%AB%E3%82%B3%E3%83%BC%E3%83%89">リーダブルコード</a> P.3 より引用 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>でも同じことが言えそうです。 リーダブルな<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>を書いてないと<a data-gtm-click-label="entry-summary-keyword" href="/q/%E7%B5%90%E5%A9%9A">結婚</a>できない時代が今まさに到来しようとしています。 皆さん、クソ<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>1を読んだことがありますね? クソ<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>を書いたことがありますね? 僕は、あります。 そこで、<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>記事ではどうしたらリーダブルな<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>が書けるかというアイデアを紹介します。 処理の流れの順に上から読めるようにする 人間のメンタルモデルは、問題やタスクを小さなステップに分割し、それぞれを順番に実行することに適しています。 サブクエリを使った<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>では、処理の流れは上から下ではなく、ネストされた</p> <a href="https://qiita.com/zackey2/items/883616dff71e51bf6563" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/ed45a5389a83a997b046607726d58308cc2b6de3/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-412672c5f0600ab9a64263b751f1bc81.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk3MiZoPTM3OCZ0eHQ9JUUzJTgzJUFBJUUzJTgzJUJDJUUzJTgzJTgwJUUzJTgzJTk2JUUzJTgzJUFCU1FMJTVCJUUzJTgyJTg4JUUzJTgyJThBJUU4JTg5JUFGJUUzJTgxJTg0U1FMJUUzJTgyJTkyJUU2JTlCJUI4JUUzJTgxJThGJUUzJTgxJTlGJUUzJTgyJTgxJUUzJTgxJUFFJUUzJTgyJUI3JUUzJTgzJUIzJUUzJTgzJTk3JUUzJTgzJUFCJUUzJTgxJUE3JUU1JUFFJTlGJUU4JUI3JUI1JUU3JTlBJTg0JUUzJTgxJUFBJUUzJTgzJTg2JUUzJTgyJUFGJUUzJTgzJThCJUUzJTgzJTgzJUUzJTgyJUFGJTVEJnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnR4dC1jb2xvcj0lMjMxRTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9NTYmcz04ZmIzNTI3YjdmZjZkMGQ4ZDlkNDU5ZDE3YTgwOTE2ZA%26mark-x%3D142%26mark-y%3D57%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZoPTc2Jnc9NzcwJnR4dD0lNDB6YWNrZXkyJnR4dC1jb2xvcj0lMjMxRTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9MzYmdHh0LWFsaWduPWxlZnQlMkN0b3Amcz0xNWQ5ZDE5ODRhODljY2JhMGNmYWMzYmQxNmUxMzdkOA%26blend-x%3D142%26blend-y%3D436%26blend-mode%3Dnormal%26txt64%3DaW4g5qCq5byP5Lya56S-TSZB44Kv44Op44Km44OJ%26txt-width%3D770%26txt-clip%3Dend%252Cellipsis%26txt-color%3D%25231E2121%26txt-font%3DHiragino%2520Sans%2520W6%26txt-size%3D36%26txt-x%3D156%26txt-y%3D536%26s%3D0e7b4ec63f049a7d65fb81ad515337b0" alt="リーダブルSQL[より良いSQLを書くためのシンプルで実践的なテクニック] - Qiita"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4742125366337687983"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://qiita.com/zackey2/items/883616dff71e51bf6563" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20230916#bookmark-4742125366337687983" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2023/09/16</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment">CTEは制約が厳しすぎて使いづらい…</span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4742125366337687983/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://tech.andpad.co.jp/entry/2023/01/12/100000"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://tech.andpad.co.jp/entry/2023/01/12/100000" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Ftech.andpad.co.jp%2Fentry%2F2023%2F01%2F12%2F100000" alt="">あなたの遅延はどこから? SQLから! 〜患部に止まってすぐ効くSQLレビューチェックリスト 年初め特大サービス号〜 - ANDPAD Tech Blog</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/tech.andpad.co.jp/entry/2023/01/12/100000" class="js-keyboard-entry-page-openable" title="あなたの遅延はどこから? SQLから! 〜患部に止まってすぐ効くSQLレビューチェックリスト 年初め特大サービス号〜 - ANDPAD Tech Blog (473ブックマーク)" data-gtm-click-label="user-bookmark-users">473 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Ftech.andpad.co.jp%2F" title="『tech.andpad.co.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> tech.andpad.co.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">あけましておめでとうございます! 今年は異世界放浪メシのアニメが放送されるらしいので楽しみなバックエンドの原田 (tomtwinkle)です。 内部で運用している<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>レビューチェックリストの一部を抽出し思いつきで追記して行った結果、結構な分量になってしまいました。 暇な時でも流し読みして頂けるとありがたいです。 Motivation <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>レビュー観点 大きく<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>が変更される修正の際にはEXPL<a data-gtm-click-label="entry-summary-keyword" href="/q/ai">AI</a>Nをレビュー内容に加える 検索のキーにINDEXを使用しているか <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>発行回数がN+1(1+N)の構造になっていないか サブクエリを利用した<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>はパフォーマンス要チェック Viewの利用は基<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>的に禁止 C<a data-gtm-click-label="entry-summary-keyword" href="/q/ROS">ROS</a>S <a data-gtm-click-label="entry-summary-keyword" href="/q/JOIN">JOIN</a>は禁止 WHERE句で十分に絞った検索をしているか 必要なcolumnだけSELECTしているか レコード数だけ必要な場合にCOUNT用の<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>を発行しているか 集計関</p> <a href="https://tech.andpad.co.jp/entry/2023/01/12/100000" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/89b39c6e3bf2f52d5fa4a3ac4c7efe9e46b6f56a/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2Fa%2Farm4%2F20230111%2F20230111231842.png" alt="あなたの遅延はどこから? SQLから! 〜患部に止まってすぐ効くSQLレビューチェックリスト 年初め特大サービス号〜 - ANDPAD Tech Blog"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4730807024538447908"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://tech.andpad.co.jp/entry/2023/01/12/100000" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20230113#bookmark-4730807024538447908" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2023/01/13</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4730807024538447908/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://bliki-ja.github.io/DomainLogicAndSQL/"> <div class="centerarticle-entry "> <h3 class="centerarticle-entry-title"> <a href="https://bliki-ja.github.io/DomainLogicAndSQL/" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fbliki-ja.github.io%2FDomainLogicAndSQL%2F" alt="">ドメインロジックとSQL - Martin Fowler's Bliki (ja)</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/bliki-ja.github.io/DomainLogicAndSQL/" class="js-keyboard-entry-page-openable" title="ドメインロジックとSQL - Martin Fowler's Bliki (ja) (316ブックマーク)" data-gtm-click-label="user-bookmark-users">316 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fbliki-ja.github.io%2F" title="『bliki-ja.github.io』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> bliki-ja.github.io </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">以下の文章は、Martin Fowler による <a data-gtm-click-label="entry-summary-keyword" href="/q/domain">Domain</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/log">Log</a>ic and <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>の日<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>語訳である。 データベース指向ソフトウェア開発者とメモリ上(in-m<a data-gtm-click-label="entry-summary-keyword" href="/q/EM">em</a>ory)アプリケーションソフトウェア開発者との間のギャップは、ここ数十年、徐々に広がってきている。このギャップが原因で、データベースの機能(<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>やストアドプロシージャ)をどのように扱えばよいのかという議論が数多く巻き起こっている。ここでは、ビジネスロジックを <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> に置くべきか、それともメモリ上のコードに置くべきかといった問題について、主にパフォーマンスと更新性の観点から考察を行う。考察には簡単な例を使うが、<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> クエリはしっかりとしたもの(rich <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> queries)を用いるので悪しからず。 エンタープライズアプリケーション(訳注:以下、EA)構築に関する<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>(私の近著『P of EAA』など)を読むと、ロジック</p> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4670464534276700226"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://bliki-ja.github.io/DomainLogicAndSQL/" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20220606#bookmark-4670464534276700226" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2022/06/06</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4670464534276700226/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://yuzutas0.hatenablog.com/entry/2022/01/04/123000"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://yuzutas0.hatenablog.com/entry/2022/01/04/123000" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fyuzutas0.hatenablog.com%2Fentry%2F2022%2F01%2F04%2F123000" alt="">BigQueryでSaaSのjsonデータを処理するSQLサンプル集 - 下町柚子黄昏記 by @yuzutas0</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/yuzutas0.hatenablog.com/entry/2022/01/04/123000" class="js-keyboard-entry-page-openable" title="BigQueryでSaaSのjsonデータを処理するSQLサンプル集 - 下町柚子黄昏記 by @yuzutas0 (57ブックマーク)" data-gtm-click-label="user-bookmark-users">57 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fyuzutas0.hatenablog.com%2F" title="『yuzutas0.hatenablog.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> yuzutas0.hatenablog.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">この記事の概要 SaaSのデータをBigQueryに統合することで業務改善を促進できる。 しかし、SaaSのデータの中身を見ると、BigQueryの関数では対応しにくい形式になっていることがある。 そこで、<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>稿では「こういうデータ形式だったらこういう<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>を書く」というサンプル集を掲載する。 目次 この記事の概要 目次 宣伝 実現したいこと SaaSデータの処理方法 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>サンプル1: 純粋な配列だけのケース <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>サンプル2: 配列内にハッシュマップがあるケース <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>サンプル3: 配列宣言ナシでカンマ区切りのハッシュマップが突如始まるケース <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>サンプル4: 配列とハッシュが入り乱れるケース <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>サンプル5: JSONの中に親子構造があるケース <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>サンプル6: Objectを定義したくなるケース 最強のJSONパースの関数は作れるか jsonデータの処理をどこで行うか 最後に</p> <a href="https://yuzutas0.hatenablog.com/entry/2022/01/04/123000" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/4800415d439b31105bcbb79f58ac27247577e8bc/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2Fy%2Fyuzutas0%2F20220104%2F20220104121205.png" alt="BigQueryでSaaSのjsonデータを処理するSQLサンプル集 - 下町柚子黄昏記 by @yuzutas0"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4713510976411122082"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://yuzutas0.hatenablog.com/entry/2022/01/04/123000" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20220105#bookmark-4713510976411122082" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2022/01/05</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF%E5%88%86%E6%9E%90/" data-gtm-click-label="user-reaction-tag">データ分析</a></li> <li><a href="/R2M/DWH/" data-gtm-click-label="user-reaction-tag">DWH</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4713510976411122082/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://engineers.ntt.com/entry/2021/12/22/180853"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://engineers.ntt.com/entry/2021/12/22/180853" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fengineers.ntt.com%2Fentry%2F2021%2F12%2F22%2F180853" alt="">高性能分散SQLエンジン「Trino」最速ガイド - NTT Communications Engineers' Blog</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/engineers.ntt.com/entry/2021/12/22/180853" class="js-keyboard-entry-page-openable" title="高性能分散SQLエンジン「Trino」最速ガイド - NTT Communications Engineers' Blog (123ブックマーク)" data-gtm-click-label="user-bookmark-users">123 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fengineers.ntt.com%2F" title="『engineers.ntt.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> engineers.ntt.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">こんにちは。なんの因果か<a data-gtm-click-label="entry-summary-keyword" href="/q/NTT">NTT</a>コミュニケーションズのエバンジェリストをやっている西塚です。 この記事は、<a data-gtm-click-label="entry-summary-keyword" href="/q/NTT">NTT</a> Communications Advent Calendar 2021 22日目の記事です。 5分でわかる「Trino」 「Trino」は、異なるデータソースに対しても高速でインタラクティブに分析ができる高性能分散<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>エンジンです。 以下の特徴を持っており、ビッグ<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%87%E3%83%BC%E3%82%BF%E5%88%86%E6%9E%90">データ分析</a>を支える重要なOSS(オープンソースソフトウェア)の1つです。 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>-on-Anything: Hadoopだけでなく従来の<a data-gtm-click-label="entry-summary-keyword" href="/q/RDBMS">RDBMS</a>(リレーショナルデータベース)やNo<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>まで、標準<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>(ANSI <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>)に準拠したアクセスをワンストップに提供 並列処理でビッグデータに対して容易にスケールアップ しかも高速(hiveの数十倍) <a data-gtm-click-label="entry-summary-keyword" href="/q/Netflix">Netflix</a>, LinkedIn, <a data-gtm-click-label="entry-summary-keyword" href="/q/Salesforce">Salesforce</a>, Shopif</p> <a href="https://engineers.ntt.com/entry/2021/12/22/180853" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/c6e571f243a6735c95ac4b42e9e52b28f4211c80/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2FN%2FNTTCom%2F20211222%2F20211222164836.png" alt="高性能分散SQLエンジン「Trino」最速ガイド - NTT Communications Engineers' Blog"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4712918422544108450"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://engineers.ntt.com/entry/2021/12/22/180853" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20211223#bookmark-4712918422544108450" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2021/12/23</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4712918422544108450/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://kaigai.hatenablog.com/entry/2021/07/05/182217"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://kaigai.hatenablog.com/entry/2021/07/05/182217" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fkaigai.hatenablog.com%2Fentry%2F2021%2F07%2F05%2F182217" alt="">GPUDirect SQL on NFS-over-RDMAを試す - KaiGaiの俺メモ</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/kaigai.hatenablog.com/entry/2021/07/05/182217" class="js-keyboard-entry-page-openable" title="GPUDirect SQL on NFS-over-RDMAを試す - KaiGaiの俺メモ (48ブックマーク)" data-gtm-click-label="user-bookmark-users">48 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fkaigai.hatenablog.com%2F" title="『kaigai.hatenablog.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> kaigai.hatenablog.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">タイトルでほぼほぼ出オチですが、先日、NVIDIAからCUDA Toolk<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a> 11.4と共にリリースされた新機能<a data-gtm-click-label="entry-summary-keyword" href="/q/gpu">GPU</a>Direct Storage 1.0のドキュメントを読んでいると、面白い記述を見つけた。 曰く、MOFEDドライバ5.3以降と、Mellanox Con<a data-gtm-click-label="entry-summary-keyword" href="/q/NEC">nec</a>t-X4/5の組み合わせで、NFS-over-RDMAと<a data-gtm-click-label="entry-summary-keyword" href="/q/gpu">GPU</a>Direct Storageを組み合わせ、リモートのNFS区画からローカルの<a data-gtm-click-label="entry-summary-keyword" href="/q/gpu">GPU</a>へと直接のデータ転送を行う事ができるようになる、と。 14.10. NFS Support w<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>h <a data-gtm-click-label="entry-summary-keyword" href="/q/gpu">GPU</a>Direct Storage This section provides inf<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">orm</a>ation about NFS support w<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>h GDS. 14.10.2. Install <a data-gtm-click-label="entry-summary-keyword" href="/q/gpu">GPU</a>Direct Storage Support for the NFS Cli</p> <a href="https://kaigai.hatenablog.com/entry/2021/07/05/182217" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/836021dbd9ff33f2da2e8cfc3ec962c8a34602d8/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2Fk%2Fkaigai%2F20210705%2F20210705144110.png" alt="GPUDirect SQL on NFS-over-RDMAを試す - KaiGaiの俺メモ"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4705033041061899874"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://kaigai.hatenablog.com/entry/2021/07/05/182217" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20210706#bookmark-4705033041061899874" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2021/07/06</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/GPU/" data-gtm-click-label="user-reaction-tag">GPU</a></li> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4705033041061899874/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://zenn.dev/koji_mats/scraps/81edc33b8b9e5d"> <div class="centerarticle-entry "> <h3 class="centerarticle-entry-title"> <a href="https://zenn.dev/koji_mats/scraps/81edc33b8b9e5d" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fzenn.dev%2Fkoji_mats%2Fscraps%2F81edc33b8b9e5d" alt="">論理プログラミング言語Logicaでデータサイエンス100本ノック</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/zenn.dev/koji_mats/scraps/81edc33b8b9e5d" class="js-keyboard-entry-page-openable" title="論理プログラミング言語Logicaでデータサイエンス100本ノック (267ブックマーク)" data-gtm-click-label="user-bookmark-users">267 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fzenn.dev%2Fkoji_mats" title="『zenn.dev/koji_mats』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> zenn.dev/koji_mats </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"><a data-gtm-click-label="entry-summary-keyword" href="/q/google">Google</a>が発表したOSS<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88">プロジェクト</a>である論理プログラミング言語<a data-gtm-click-label="entry-summary-keyword" href="/q/log">Log</a>icaを使って、データサイエンス100<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>ノック(構造化データ加工編)の設問を解きながらどのような言語かを確認していく。 (BigQueryのクエリとして実行していく) 最初に、プログラミング言語<a data-gtm-click-label="entry-summary-keyword" href="/q/log">Log</a>icaの特徴を纏めておく。 論理型プログラミング言語: このカテゴリではPro<a data-gtm-click-label="entry-summary-keyword" href="/q/log">log</a>が有名 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>にコンパイルされる: 現状BigQueryとPo<a data-gtm-click-label="entry-summary-keyword" href="/q/stg">stg</a>re<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>に対応 モジュール機構がある: <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>と比較した強み コンパイラは<a data-gtm-click-label="entry-summary-keyword" href="/q/Python">Python</a>で書かれている: Jupyter <a data-gtm-click-label="entry-summary-keyword" href="/q/note">Note</a>bookや<a data-gtm-click-label="entry-summary-keyword" href="/q/google">Google</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/colab">Colab</a>ですぐ始められる <a data-gtm-click-label="entry-summary-keyword" href="/q/colab">Colab</a>でチュートリアルが用意されているので、まずこちらからやると良いと思う。 コードの見た目は関係論理の記述に似ている。 事前に、データサイエンス100<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>ノックのテーブルデータをBigQu</p> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4704567273638367298"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://zenn.dev/koji_mats/scraps/81edc33b8b9e5d" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20210626#bookmark-4704567273638367298" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2021/06/26</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B0%E3%83%A9%E3%83%9F%E3%83%B3%E3%82%B0/" data-gtm-click-label="user-reaction-tag">プログラミング</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4704567273638367298/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://techblog.gmo-ap.jp/2021/06/24/sql-antipattern-2/"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://techblog.gmo-ap.jp/2021/06/24/sql-antipattern-2/" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Ftechblog.gmo-ap.jp%2F2021%2F06%2F24%2Fsql-antipattern-2%2F" alt="">業務でどれだけSQL力がつくのか ~SQLアンチパターンを用いて確認~ 後編</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/techblog.gmo-ap.jp/2021/06/24/sql-antipattern-2/" class="js-keyboard-entry-page-openable" title="業務でどれだけSQL力がつくのか ~SQLアンチパターンを用いて確認~ 後編 (88ブックマーク)" data-gtm-click-label="user-bookmark-users">88 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Ftechblog.gmo-ap.jp%2F" title="『techblog.gmo-ap.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> techblog.gmo-ap.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">はじめにこんにちは。<a data-gtm-click-label="entry-summary-keyword" href="/q/GMO">GMO</a>アドマーケティングのKONCEです。新卒で入社し、数年経ちました。日々の業務で学ぶことは多いですが、今年度は<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%8A%80%E8%A1%93">技術</a>の深堀りをテーマにやっていきたいと思っています。今回は入社して<a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>や<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>に関しては業務内で学ぶことが多く、特別訓練をしていたわけではなかったのですが、「<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>アンチパターン」を用いて学びながら、改めて自分の現状を見つめ直していけたらと思います。今回は学習を行う側面と自分自身のレベルについて見直していきたいので 知っていた → ○ 部分的に知っていた → △ 知らなかった → ... 今回は後編です。 今回も 知っていた → ○ 部分的に知っていた → △ 知らなかった → × を付けてみようと思います。 目次 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>アンチパターンについて Ⅲ部 クエリのアンチパターン 2-1. [△]13章 フェア・オブ・ジ・アンノウン(恐怖のunknown) 2-2</p> <a href="https://techblog.gmo-ap.jp/2021/06/24/sql-antipattern-2/" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/4fd0d4ab63759cc5518bf41c635ff353ac930832/height=288;version=1;width=512/https%3A%2F%2Ftechblog.gmo-ap.jp%2Fwp-content%2Fuploads%2F2022%2F04%2Fogpimage001.png" alt="業務でどれだけSQL力がつくのか ~SQLアンチパターンを用いて確認~ 後編"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4704507599331326658"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://techblog.gmo-ap.jp/2021/06/24/sql-antipattern-2/" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20210624#bookmark-4704507599331326658" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2021/06/24</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4704507599331326658/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://www.metabase.com/learn/building-analytics/sql-templates/sql-best-practices"> <div class="centerarticle-entry "> <h3 class="centerarticle-entry-title"> <a href="https://www.metabase.com/learn/building-analytics/sql-templates/sql-best-practices" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fwww.metabase.com%2Flearn%2Fgrow-your-data-skills%2Flearn-sql%2Fworking-with-sql%2Fsql-best-practices" alt="">Best practices for writing SQL queries</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/www.metabase.com/learn/grow-your-data-skills/learn-sql/working-with-sql/sql-best-practices" class="js-keyboard-entry-page-openable" title="Best practices for writing SQL queries (4ブックマーク)" data-gtm-click-label="user-bookmark-users">4 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fwww.metabase.com%2F" title="『www.metabase.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> www.metabase.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">Watch a 5-minute d<a data-gtm-click-label="entry-summary-keyword" href="/q/EM">em</a>o to see how to set up and pu<a data-gtm-click-label="entry-summary-keyword" href="/q/BL">bl</a>ish a dashboard</p> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4701060972743416802"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://www.metabase.com/learn/building-analytics/sql-templates/sql-best-practices" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20210413#bookmark-4701060972743416802" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2021/04/13</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment">何かと思えばメタベースの奴か</span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4701060972743416802/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://labs.septeni.co.jp/entry/2021/04/01/130000"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://labs.septeni.co.jp/entry/2021/04/01/130000" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Flabs.septeni.co.jp%2Fentry%2F2021%2F04%2F01%2F130000" alt="">SQL パイプライン開発に便利な Dataform 7つのお気に入りポイント - FLINTERS Engineer's Blog</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/labs.septeni.co.jp/entry/2021/04/01/130000" class="js-keyboard-entry-page-openable" title="SQL パイプライン開発に便利な Dataform 7つのお気に入りポイント - FLINTERS Engineer's Blog (67ブックマーク)" data-gtm-click-label="user-bookmark-users">67 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Flabs.septeni.co.jp%2F" title="『labs.septeni.co.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> labs.septeni.co.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">こんにちは。河内です。 最近はデータ基盤の構築も取り組んでいたりします。 社内では他の DWH が使われている事例がありますが、今回の基盤ではデータソースとの親和性や価格面などを考慮し BigQuery で行くことにしました。 BigQuery 上で多くのデータを順次変換してデータを生成するために何らかのワークフローエンジンが必要でした。 社内の他のシステムではワークフローエンジンとして Digdag を採用している例が多いですが、このシステムでは <a data-gtm-click-label="entry-summary-keyword" href="/q/Kubernetes">Kubernetes</a> 上でサービスを運用しているため、当初(2020年12月)は Ar<a data-gtm-click-label="entry-summary-keyword" href="/q/go">go</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/workflow">Workflow</a> 上でクエリを順次実行することを構想していました。構想中に Dataf<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">orm</a> が <a data-gtm-click-label="entry-summary-keyword" href="/q/google">Google</a> に買収され、無料で使えるようになったというニュースが飛び込んできたため、触って感触が良いことを確かめた後、Dataf<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">orm</a> を使っていくことに</p> <a href="https://labs.septeni.co.jp/entry/2021/04/01/130000" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/8007ed7241429b9d75a910c1fb6118b5d5c9bdbf/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2Ft%2Ft_kawachi%2F20210331%2F20210331220925.png" alt="SQL パイプライン開発に便利な Dataform 7つのお気に入りポイント - FLINTERS Engineer's Blog"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4700756173278338114"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://labs.septeni.co.jp/entry/2021/04/01/130000" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20210405#bookmark-4700756173278338114" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2021/04/05</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF/" data-gtm-click-label="user-reaction-tag">データ</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4700756173278338114/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://tech.classi.jp/entry/2021/02/05/121144"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://tech.classi.jp/entry/2021/02/05/121144" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Ftech.classi.jp%2Fentry%2F2021%2F02%2F05%2F121144" alt="">SQL勉強会を通して痛感したデータ民主化への長い道のり - Classi開発者ブログ</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/tech.classi.jp/entry/2021/02/05/121144" class="js-keyboard-entry-page-openable" title="SQL勉強会を通して痛感したデータ民主化への長い道のり - Classi開発者ブログ (61ブックマーク)" data-gtm-click-label="user-bookmark-users">61 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Ftech.classi.jp%2F" title="『tech.classi.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> tech.classi.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">こんにちは、Classiデータ<a data-gtm-click-label="entry-summary-keyword" href="/q/ai">AI</a>部の石井です。 私は2019年4月にソフトバンクからClassiに出向し、マーケティング部を経て、現在データ<a data-gtm-click-label="entry-summary-keyword" href="/q/ai">AI</a>部でデータ<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a>として分析基盤の構築を担当しています。今回は私が現部署で最初に担当した<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>勉強会についてご紹介します。 背景 2020年春頃から、新型コロナウイルスの影響による休校や<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%95%99%E8%82%B2">教育</a>現場の急激な状況変化に対応するため、Classiサービスの詳細な利用状況把握の必要性が高まっています。 Classiは弊社の強みともいえる膨大な<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%95%99%E8%82%B2">教育</a>データを蓄積していますが、残念なことに全社的には貴重な<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%95%99%E8%82%B2">教育</a>データを活用しきれていないことが課題でした。 2020年夏に全社で行った「データ<a data-gtm-click-label="entry-summary-keyword" href="/q/ai">AI</a>部に期待すること」に関するアンケートでも、「基礎的なデータ活用方法を教えてほしい」という回答が多く寄せられました。 この状況をふまえ、データ活用のための知識の底上げを行い、</p> <a href="https://tech.classi.jp/entry/2021/02/05/121144" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/d8f8847658aeca33fb6f1e4214cef1f539014eb9/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2Fy%2Fyaya-data%2F20210127%2F20210127184727.png" alt="SQL勉強会を通して痛感したデータ民主化への長い道のり - Classi開発者ブログ"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4698066005837446786"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://tech.classi.jp/entry/2021/02/05/121144" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20210207#bookmark-4698066005837446786" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2021/02/07</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF/" data-gtm-click-label="user-reaction-tag">データ</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4698066005837446786/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://tech.appbrew.io/entry/2020/11/11/110000"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://tech.appbrew.io/entry/2020/11/11/110000" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Ftech.appbrew.io%2Fentry%2F2020%2F11%2F11%2F110000" alt="">SQL学習モチベを爆上げする「SQLテスト制度」を導入している話 - AppBrew Tech Blog</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/tech.appbrew.io/entry/2020/11/11/110000" class="js-keyboard-entry-page-openable" title="SQL学習モチベを爆上げする「SQLテスト制度」を導入している話 - AppBrew Tech Blog (387ブックマーク)" data-gtm-click-label="user-bookmark-users">387 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Ftech.appbrew.io%2F" title="『tech.appbrew.io』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> tech.appbrew.io </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">こんにちは、最近はアプリグロースを担当しているabeshi(@abeshi_official)です。 美容のプラットフォーム「LIPS」を運営するAppBrewでは非開発職の<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>習得に力を入れています。誰でもRe:dashやログを触れる状態になっているし、それぞれの<a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>に何がどう入っているかを共有するためのドキュメントも存在しています。 「非開発職も<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>書けるように頑張ろう!」と掲げたところで、当の<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>人たちは毎日<a data-gtm-click-label="entry-summary-keyword" href="/q/%E4%BB%95%E4%BA%8B">仕事</a>が忙しくなかなか時間も取れない上に明確な目標がないといまいち学習モチベーションを保つことができません。そこで弊社が導入したのが「<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>テスト制度」です。 ✍️<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>テスト制度とは <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>の学習到達度によってレベルごとに分けたテストで、合格すると給与が上がります。 *1現在は二つレベルが存在していて、 【レベル2】... 初学者向けでwhere・<a data-gtm-click-label="entry-summary-keyword" href="/q/JOIN">join</a>など基<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>的な文法が使え</p> <a href="https://tech.appbrew.io/entry/2020/11/11/110000" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/cd4374da9fca9164e8104b182d76ab070a0349f8/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2Fa%2Fabeshiiiii%2F20201111%2F20201111112500.png" alt="SQL学習モチベを爆上げする「SQLテスト制度」を導入している話 - AppBrew Tech Blog"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4694071008860702722"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://tech.appbrew.io/entry/2020/11/11/110000" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20201111#bookmark-4694071008860702722" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2020/11/11</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/%E5%AD%A6%E7%BF%92/" data-gtm-click-label="user-reaction-tag">学習</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4694071008860702722/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://qiita.com/lighttiger2505/items/5782debc59ae163a4d81"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://qiita.com/lighttiger2505/items/5782debc59ae163a4d81" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fqiita.com%2Flighttiger2505%2Fitems%2F5782debc59ae163a4d81" alt="">すべてのエディタでSQLの自動補完をするためにSQL Language Server(sqls)を作った - Qiita</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/qiita.com/lighttiger2505/items/5782debc59ae163a4d81" class="js-keyboard-entry-page-openable" title="すべてのエディタでSQLの自動補完をするためにSQL Language Server(sqls)を作った - Qiita (379ブックマーク)" data-gtm-click-label="user-bookmark-users">379 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fqiita.com%2Flighttiger2505" title="『qiita.com/lighttiger2505』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> qiita.com/lighttiger2505 </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"><a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>sとは <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">sql</a>sとは、いま私が開発中の<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>用Language Serverです。<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>をエディタで編集するときの支援機能を実装したサーバとなっており、主な特徴は以下です。 Language ServerなのでLSクライアントが存在するエディタであればどんなエディタでも利用可能 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>編集支援機能 自動補完(テーブル名、カラム名など) 定義参照 <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>実行 複数のRDSMSに対応 <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> Po<a data-gtm-click-label="entry-summary-keyword" href="/q/stg">stg</a>re<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/SQLite">SQLite</a>3 Language Serverとは Language Server(あるいはLanguage Server Protocol)とは、プログラム言語の開発支援機能をエディタに提供するサーバ、およびその通信内容を規定したプロトコルです。ただしサーバといってもほとんどの場合ローカル内にホスティングしてローカルのエディタと通信をします。 ここでは主題ではないので詳し</p> <a href="https://qiita.com/lighttiger2505/items/5782debc59ae163a4d81" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/fcb1ef4455543fa45287321c6c5c6481b472835f/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-412672c5f0600ab9a64263b751f1bc81.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk3MiZoPTM3OCZ0eHQ9JUUzJTgxJTk5JUUzJTgxJUI5JUUzJTgxJUE2JUUzJTgxJUFFJUUzJTgyJUE4JUUzJTgzJTg3JUUzJTgyJUEzJUUzJTgyJUJGJUUzJTgxJUE3U1FMJUUzJTgxJUFFJUU4JTg3JUFBJUU1JThCJTk1JUU4JUEzJTlDJUU1JUFFJThDJUUzJTgyJTkyJUUzJTgxJTk5JUUzJTgyJThCJUUzJTgxJTlGJUUzJTgyJTgxJUUzJTgxJUFCU1FMJTIwTGFuZ3VhZ2UlMjBTZXJ2ZXIlMjhzcWxzJTI5JUUzJTgyJTkyJUU0JUJEJTlDJUUzJTgxJUEzJUUzJTgxJTlGJnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnR4dC1jb2xvcj0lMjMxRTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9NTYmcz03NzhjNjcxZDdkYTRjMTg0OWNkNjhmYmJhMWMyNDY4OA%26mark-x%3D142%26mark-y%3D57%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZoPTc2Jnc9NzcwJnR4dD0lNDBsaWdodHRpZ2VyMjUwNSZ0eHQtY29sb3I9JTIzMUUyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9YTk1MWMzOTBiMTFhOGEyOGVlYzczOTVjZDcwMmU0YmU%26blend-x%3D142%26blend-y%3D486%26blend-mode%3Dnormal%26s%3D006e3411880702337b30bc662f9c0299" alt="すべてのエディタでSQLの自動補完をするためにSQL Language Server(sqls)を作った - Qiita"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4685756110107089666"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://qiita.com/lighttiger2505/items/5782debc59ae163a4d81" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20200516#bookmark-4685756110107089666" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2020/05/16</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4685756110107089666/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://speakerdeck.com/nrslib/sql-tutorial"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://speakerdeck.com/nrslib/sql-tutorial" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fspeakerdeck.com%2Fnrslib%2Fsql-tutorial" alt="">SQL Tutorial</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/speakerdeck.com/nrslib/sql-tutorial" class="js-keyboard-entry-page-openable" title="SQL Tutorial (246ブックマーク)" data-gtm-click-label="user-bookmark-users">246 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fspeakerdeck.com%2Fnrslib" title="『speakerdeck.com/nrslib』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> speakerdeck.com/nrslib </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">グループ合同の新卒研修で行った <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> 入門向けの解説 + ワークショップです。 基<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>的な部分の解説のみで、一部触れていない構文もございます。 ご了承ください。 KKK: 価格, TNK: 単価, MST: マスタ, I<a data-gtm-click-label="entry-summary-keyword" href="/q/dx">DX</a>: インデックス # URL HomePage: https…</p> <a href="https://speakerdeck.com/nrslib/sql-tutorial" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/37ff7454f8db2752fd9ba890eef33cabbbf093e1/height=288;version=1;width=512/https%3A%2F%2Ffiles.speakerdeck.com%2Fpresentations%2Ffea4b1ea07704ab4a598c5d9606454ff%2Fslide_0.jpg%3F12812253" alt="SQL Tutorial"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4683793447773438242"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://speakerdeck.com/nrslib/sql-tutorial" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20200404#bookmark-4683793447773438242" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2020/04/04</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4683793447773438242/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://speakerdeck.com/takahashiikki/pgcon19j-t4"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://speakerdeck.com/takahashiikki/pgcon19j-t4" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fspeakerdeck.com%2Ftakahashiikki%2Fpgcon19j-t4" alt="">SQLチューニング_理論と改善の実例_/pgcon19j_t4</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/speakerdeck.com/takahashiikki/pgcon19j-t4" class="js-keyboard-entry-page-openable" title="SQLチューニング_理論と改善の実例_/pgcon19j_t4 (109ブックマーク)" data-gtm-click-label="user-bookmark-users">109 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fspeakerdeck.com%2Ftakahashiikki" title="『speakerdeck.com/takahashiikki』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> speakerdeck.com/takahashiikki </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"># <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>チューニング 理論と改善の実例 - 2019-11-15 開催のPo<a data-gtm-click-label="entry-summary-keyword" href="/q/stg">stg</a>re<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> Conference Japan 2019 の発表スライドです</p> <a href="https://speakerdeck.com/takahashiikki/pgcon19j-t4" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/fb65910dc23e0fba837944f012672fbb7a45c8b0/height=288;version=1;width=512/https%3A%2F%2Ffiles.speakerdeck.com%2Fpresentations%2F1fb1bf726f1a4be4b9627f173f96832c%2Fslide_0.jpg%3F14170098" alt="SQLチューニング_理論と改善の実例_/pgcon19j_t4"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4677289236589958498"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://speakerdeck.com/takahashiikki/pgcon19j-t4" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20191117#bookmark-4677289236589958498" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2019/11/17</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/%E3%83%81%E3%83%A5%E3%83%BC%E3%83%8B%E3%83%B3%E3%82%B0/" data-gtm-click-label="user-reaction-tag">チューニング</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4677289236589958498/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://www.publickey1.jp/blog/19/azure_synapsebigqueryignite_2019.html"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://www.publickey1.jp/blog/19/azure_synapsebigqueryignite_2019.html" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fwww.publickey1.jp%2Fblog%2F19%2Fazure_synapsebigqueryignite_2019.html" alt="">[速報]マイクロソフト、「Azure Synapse」発表。BigQuery対抗の大規模並列データ処理サービス。Ignite 2019</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/www.publickey1.jp/blog/19/azure_synapsebigqueryignite_2019.html" class="js-keyboard-entry-page-openable" title="[速報]マイクロソフト、「Azure Synapse」発表。BigQuery対抗の大規模並列データ処理サービス。Ignite 2019 (144ブックマーク)" data-gtm-click-label="user-bookmark-users">144 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fwww.publickey1.jp%2F" title="『www.publickey1.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> www.publickey1.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">フロリダ州オーランドで開催中のマイクロソフトのイベント「<a data-gtm-click-label="entry-summary-keyword" href="/q/Microsoft">Microsoft</a> Ign<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>e 2019」が開催中です。 その基調講演において同社<a data-gtm-click-label="entry-summary-keyword" href="/q/CEO">CEO</a>のサティア・ナデラ氏は、大規模並列<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%87%E3%83%BC%E3%82%BF%E5%88%86%E6%9E%90">データ分析</a>サービス「Azure Synapse Analytics」を発表しました。 同社は現在、大規模データウェアハウス向けのサービスとして「Azure <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> Data Warehouse」を提供していますが、「Azure Synapse」はそれをさらに発展させたもの。 データウェアハウス、ビッグ<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%87%E3%83%BC%E3%82%BF%E5%88%86%E6%9E%90">データ分析</a>、データ統合などを1つのサービスとして統合し、事実上データ容量に上限がなく、ペタバイトクラスのデータでも高速に処理できる性能を提供します。 リレーショナルデータベースのような構造化されたデータおよび非構造化データのいずれにも対応し、<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>によって分析可能です。 そのために「Azure Synapse」では最</p> <a href="https://www.publickey1.jp/blog/19/azure_synapsebigqueryignite_2019.html" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/42f1749409b9c822640dabad63a6eb58cef53a71/height=288;version=1;width=512/https%3A%2F%2Fwww.publickey1.jp%2F2019%2Fmsignite201904.gif" alt="[速報]マイクロソフト、「Azure Synapse」発表。BigQuery対抗の大規模並列データ処理サービス。Ignite 2019"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4676806895798994530"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://www.publickey1.jp/blog/19/azure_synapsebigqueryignite_2019.html" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20191105#bookmark-4676806895798994530" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2019/11/05</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/azure/" data-gtm-click-label="user-reaction-tag">azure</a></li> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4676806895798994530/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://use-the-index-luke.com/ja"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://use-the-index-luke.com/ja" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fuse-the-index-luke.com%2Fja" alt="">SQLのインデックスとそのチューニングについてのオンラインブック</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/use-the-index-luke.com/ja" class="js-keyboard-entry-page-openable" title="SQLのインデックスとそのチューニングについてのオンラインブック (646ブックマーク)" data-gtm-click-label="user-bookmark-users">646 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fuse-the-index-luke.com%2F" title="『use-the-index-luke.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> use-the-index-luke.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">開発者向けの<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>インデックス解説サイト、管理についての間違いない知識を提供します。 インデックスは開発時には忘れられがちである一方で、非常に効果的な<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>のチューニング方法です。Use The Index, Lukeでは、Hibernateなどの<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">ORM</a>ツールの解説にとどまらず、<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>のインデックスについて基礎から説明します。 Use The Index, Lukeは<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>パフォーマンス詳解のWeb上の無料版です。サイトを気に入って頂けたら、ぜひ書籍も購入してみて下さい。また、このサイトの運営をサポートする様々なグッズも販売しています。 <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>、<a data-gtm-click-label="entry-summary-keyword" href="/q/oracle">Oracle</a>、<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> Serverなどにおける<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>のインデックスUse The Index, Lukeでは、ベンダにとらわれないインデックスの説明を心がけています。製品特有の事柄については、以下のような表示をしています。 <a data-gtm-click-label="entry-summary-keyword" href="/q/DB">Db</a>2 (LUW)U</p> <a href="https://use-the-index-luke.com/ja" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/b5dc1b986d0491a7f56531a11754450af3f0424a/height=288;version=1;width=512/https%3A%2F%2Fuse-the-index-luke.com%2Fstatic%2Futil_squirrel.og.fMeqdSQq.png" alt="SQLのインデックスとそのチューニングについてのオンラインブック"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-280129107"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://use-the-index-luke.com/ja" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20191003#bookmark-280129107" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2019/10/03</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/sql/" data-gtm-click-label="user-reaction-tag">sql</a></li> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/280129107/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li> <div class="centerarticle-pager"> <span class="centerarticle-waiting js-read-more-waiting is-hidden"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/loading@2x.gif" alt="残りのブックマークを読み込んでいます" width="16" height="16" /></span> <span>1</span> <span><a href="/R2M/sql/?page=2">2</a></span> <span class="centerarticle-pager-next"><a href="/R2M/sql/?page=2">次のページ</a></span> </div> </li> </ul> </div> </div> <script type="text/javascript"> // ---------------- dfp section ---------------- var valve = valve || []; valve.push(function(v) { v.defineDFPSlot({ unit: '/4374287/b_pc_o_18_3025_0_no', sizes: [[300,250]], slotId: 'user-sidebar-ad-top' }); v.defineDFPSlot({ unit: '/4374287/b_pc_o_19_3060_0_no', sizes: [[300,600],[300,250]], slotId: 'user-sidebar-ad-bottom' }); v.sealDFPSlots(); }); </script> <script> var valve = window.valve || []; valve.push(function(v) { var pageKeyValues = {}; if (document.cookie.split(';').some(function(item) { return item.indexOf('202011_guest_status=register_incomplete') >= 0})) { pageKeyValues.bookmark_status = 'register_incomplete'; } v.config({ pageKeyValues: pageKeyValues, content: { result: "ng" }, service: 'bookmark' }); }); </script> <script src="https://cdn.pool.st-hatena.com/valve/valve.js" async></script> <div class="right-container"> <div id="user-sidebar-ad-top" class="centerarticle-aside-ad"></div> <section class="centerarticle-aside-section"> <div class="centerarticle-aside-info"> <h3 class="centerarticle-aside-info-title">お知らせ</h3> <ul class="centerarticle-aside-info-list"> <li class="centerarticle-aside-info-item"> <a href="https://bookmark.hatenastaff.com/entry/transparencyreport_251q?utm_source=user_page_side_column&utm_medium=official_announcement&utm_campaign=transparencyreport_251q" target="_blank"> <p class="centerarticle-aside-info-category">透明性レポート</p> <h4 class="centerarticle-aside-info-item-title">はてなブックマーク透明性レポート(2024年8月~2024年10月)</h4> <time class="centerarticle-aside-info-item-time">2024/11/22</time> </a> </li> <li class="centerarticle-aside-info-item"> <a href="https://bookmark.hatenastaff.com/entry/transparencyreport_244q?utm_source=user_page_side_column&utm_medium=official_announcement&utm_campaign=transparencyreport_244q" target="_blank"> <p class="centerarticle-aside-info-category">透明性レポート</p> <h4 class="centerarticle-aside-info-item-title">はてなブックマーク透明性レポート(2024年5月~2024年7月)</h4> <time class="centerarticle-aside-info-item-time">2024/11/22</time> </a> </li> <li class="centerarticle-aside-info-item"> <a href="https://bookmark.hatenastaff.com/entry/2024/11/19/120854?utm_source=user_page_side_column&utm_medium=official_announcement&utm_campaign=2024%2F11%2F19%2F120854" target="_blank"> <p class="centerarticle-aside-info-category">ランキング</p> <h4 class="centerarticle-aside-info-item-title">今週のはてなブックマーク数ランキング(2024年11月第3週)</h4> <time class="centerarticle-aside-info-item-time">2024/11/19</time> </a> </li> </ul> <div class="enterarticle-aside-info-readmore"> <a href="https://bookmark.hatenastaff.com/?utm_source=user_page_side_column&utm_medium=official_announcement&utm_campaign=readmore" class="enterarticle-aside-info-readmore-button" target="_blank">もっと読む</a> </div> </div> </section> <section class="centerarticle-aside-section"> <h3 class="centerarticle-aside-title">公式Twitter</h3> <ul class="centerarticle-aside-twitter"> <li><a href="https://twitter.com/HatenaBookmark" target="_blank" rel="noopener" data-gtm-click-label="user-officialTwitter-name">@HatenaBookmark</a><p>リリース、障害情報などのサービスのお知らせ</p></li> <li><a href="https://twitter.com/hatebu" target="_blank" rel="noopener" data-gtm-click-label="user-hotentryTwitter-name">@hatebu</a><p>最新の人気エントリーの配信</p></li> </ul> </section> <div id="user-sidebar-ad-bottom" class="centerarticle-aside-ad"></div> </div> </div> </div> <div class="progress-modal is-hidden js-progress-modal"> <div class="progress-modal-spiner"></div> <div class="progress-modal-message"> <p class="progress-modal-message-text js-progress-message">処理を実行中です</p> <button class="progress-modal-cancel js-cancel-button">中止</button> </div> </div> <div class="message-modal js-message-modal is-hidden auto-hide"> <div class="message-modal-message"> <p class="message-modal-message-text js-message-modal-message-text"></p> <button class="message-modal-btn js-message-modal-close-button">閉じる</button> </div> </div> <div id="keyboard-shortcut-help" class="shortcut-help is-hidden"> <h3 class="shortcut-help-title">キーボードショートカット一覧</h3> <p><span class="shortcut-help-key">j</span>次のブックマーク</p> <p><span class="shortcut-help-key">k</span>前のブックマーク</p> <p><span class="shortcut-help-key">l</span>あとで読む</p> <p><span class="shortcut-help-key">e</span>コメント一覧を開く</p> <p><span class="shortcut-help-key">o</span>ページを開く</p> <button tyle="button" class="shortcut-help-close js-close-button">✕</button> </div> <div class="footer"> <div class="footer-inner"> <div class="footer-inner-group footer-bookmark"> <h2 class="footer-title"><a href="/" data-gtm-label="footer-btop">はてなブックマーク</a></h2> <div class="footer-list-wrapper"> <ul class="footer-list footer-list--pc"> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/all" class="hotentry js-keyboard-openable" data-gtm-label="footerCategories-hotentry">総合</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/general" class="general js-keyboard-openable" data-gtm-label="footerCategories-general">一般</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/social" class="cat-social js-keyboard-openable" data-gtm-label="footerCategories-social">世の中</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/economics" class="cat-economics js-keyboard-openable" data-gtm-label="footerCategories-economics">政治と経済</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/life" class="cat-life js-keyboard-openable" data-gtm-label="footerCategories-life">暮らし</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/knowledge" class="cat-knowledge js-keyboard-openable" data-gtm-label="footerCategories-knowledge">学び</a></li> </ul> <ul class="footer-list footer-list--pc"> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/it" class="cat-it js-keyboard-openable" data-gtm-label="footerCategories-it">テクノロジー</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/entertainment" class="cat-entertainment js-keyboard-openable" data-gtm-label="footerCategories-entertainment">エンタメ</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/game" class="cat-game js-keyboard-openable" data-gtm-label="footerCategories-game">アニメとゲーム</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/fun" class="cat-fun js-keyboard-openable" data-gtm-label="footerCategories-fun">おもしろ</a></li> </ul> <ul class="footer-list"> <li class="footer-list-item"><a href="/guide/tools">アプリ・拡張機能</a></li> <li class="footer-list-item"><a href="https://bookmark.hatenastaff.com/">開発ブログ</a></li> <li class="footer-list-item"><a href="/help/">ヘルプ</a></li> <li class="footer-list-item"><a href="https://hatena.zendesk.com/hc/ja/categories/900000153166">お問い合わせ</a></li> <li class="footer-list-item footer-list-item--sp"><a href="/guide/guideline">ガイドライン</a></li> <li class="footer-list-item footer-list-item--sp"><a href="https://policies.hatena.ne.jp/rule">利用規約</a></li> <li class="footer-list-item footer-list-item--sp"><a href="https://policies.hatena.ne.jp/privacypolicy-ja">プライバシーポリシー</a></li> <li class="footer-list-item footer-list-item--sp"><a href="https://policies.hatena.ne.jp/cookie-policy">利用者情報の外部送信について</a></li> </ul> <ul class="footer-list footer-list--pc"> <li class="footer-list-item footer-list-item--pc"><a href="/guide/guideline">ガイドライン</a></li> <li class="footer-list-item footer-list-item--pc"><a href="https://policies.hatena.ne.jp/rule">利用規約</a></li> <li class="footer-list-item footer-list-item--pc"><a href="https://policies.hatena.ne.jp/privacypolicy-ja">プライバシーポリシー</a></li> <li class="footer-list-item footer-list-item--pc"><a href="https://policies.hatena.ne.jp/cookie-policy">利用者情報の外部送信について</a></li> </ul> </div> </div> <div class="footer-inner-group footer-bookmark-sns"> <h2 class="footer-title">公式Twitter</h2> <div class="footer-bookmark-list"> <ul class="footer-list"> <li class="footer-list-item"><a href="https://twitter.com/HatenaBookmark" target="_blank" rel="noopener" data-gtm-click-label="footer-officialTwitter-name">公式アカウント</a></li> <li class="footer-list-item"><a href="https://twitter.com/hatebu" target="_blank" rel="noopener" data-gtm-click-label="footer-hotentryTwitter-name">ホットエントリー</a></li> </ul> </div> </div> <div class="footer-inner-group footer-hatena"> <h2 class="footer-title">はてなのサービス</h2> <ul class="footer-list"> <li class="footer-list-item"><a href="https://hatenablog.com/" data-gtm-label="footerServices-blog">はてなブログ</a></li> <li class="footer-list-item"><a href="https://hatenablog.com/guide/pro?plus_via=hatenabookmark_footer&utm_source=hatenabookmark&utm_medium=referral&utm_campaign=hatenabookmark_to_hatenablog_pro&utm_content=hatenabookmark_footer" data-gtm-label="footerServices-blog-pro">はてなブログPro</a></li> <li class="footer-list-item"><a href="https://q.hatena.ne.jp/" data-gtm-label="footerServices-question">人力検索はてな</a></li> <li class="footer-list-item"><a href="http://d.hatena.ne.jp/" data-gtm-label="footerServices-keyword">はてなブログ タグ</a></li> <li class="footer-list-item"><a href="http://hatenanews.com/" data-gtm-label="footerServices-hatenanews">はてなニュース</a></li> <li class="footer-list-item"><a href="https://soredoko.jp/" data-gtm-label="footerServices-soredoko">ソレドコ</a></li> </ul> </div> </div> <div class="footer-bottom"> <div class="footer-app"> <ul> <li class="footer-list-item"><a href="https://apps.apple.com/jp/app/hatenabukkumaku/id354976659?mt=8" target="_blank" rel="noopener" data-gtm-click-label="footer-app-ios"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/dl-button/appstore@2x.png" alt="App Storeからダウンロード"></a></li> <li class="footer-list-item"><a href="https://play.google.com/store/apps/details?id=com.hatena.android.bookmark&referrer=utm_source%3Dbookmark_sp%26utm_campaign%3Dbookmark_sp_user&hl=ja" target="_blank" rel="noopener" data-gtm-click-label="footer-app-android"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/dl-button/googleplay@2x.png" alt="Google Playで手に入れよう"></a></li> </ul> </div> <div class="copyright">Copyright © 2005-2024 <a href="http://www.hatena.ne.jp/">Hatena</a>. All Rights Reserved.</div> </div> </div> <div class="modal-overlay"></div> <script type="text/javascript" src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/js/v4/bookmark.star.js" async></script> <div class="js-head-notify is-hidden">設定を変更しました<span class="js-head-notify-close-button">x</span></div> </body> </html>