[B! database][tutorial] uchiuchiyamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

uchiuchiyama id:uchiuchiyama

databaseã¨tutorialã«é–¢ã™ã‚‹uchiuchiyamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (24)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Next.js + Vercel + Supabase ã‚’ç”¨ã„ãŸé«˜é€Ÿã‚¢ãƒ—ãƒªé–‹ç™º - RAKUS Developers Blog | ãƒ©ã‚¯ã‚¹ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ï¼ãƒ©ã‚¯ã‚¹å…¥ç¤¾ï¼‘å¹´ç›®ã®koki_matsuraã§ã™ã€‚ æœ¬æ—¥ã¯ã€Next.jsã¨Vercelã€Supabaseã‚’ç”¨ã„ã¦ç°¡å˜ãªã‚¢ãƒ—ãƒªã‚’é«˜é€Ÿã§é–‹ç™ºã™ã‚‹æ‰‹é †ã«ã¤ã„ã¦ãŠè©±ã—ã§ãã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ Next.jsã¨ã¯ Reactã¨Next.jsã®é•ã„ Next.jsã®ç‰¹å¾´ Vercelã¨ã¯ Supabaseã¨ã¯ ToDoã‚¢ãƒ—ãƒªä½œæˆ Supabaseã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨æ„ Vercelã§Next.js ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆãƒ»ãƒ‡ãƒ—ãƒã‚¤ãƒ»GitHubé€£æº Vercelã¨Supabaseã®é€£æº GitHubã‹ã‚‰ã‚¯ãƒãƒ¼ãƒ³ Vercelã‹ã‚‰ç’°å¢ƒå¤‰æ•°ã‚’å–å¾— Supabaseã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶š ã‚³ãƒ¼ãƒ‰ç·¨é›† çµ‚ã‚ã‚Šã« å‚è€ƒæ–‡çŒ® Next.jsã¨ã¯ Next.jsã¯Reactãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã§ã™ã€‚ å…¬å¼ã‚µã‚¤ãƒˆã§ã¯Next.jsã¨ã¯Reactã‚’ç”¨ã„ãŸWebã‚¢ãƒ—ãƒªé–‹ç™ºã§ç”Ÿ
uchiuchiyama 2022/10/09
next.js

database

postgresql

tutorial
ãƒªãƒ³ã‚¯
Next.js, Prisma2, MySQLç’°å¢ƒã‚’dockerã§ä½œã£ã¦ã„ã
ã¾ãšã¯nvmã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« nodeã¨npmã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³åˆ‡ã‚Šæ›¿ãˆãŒæ¥½ã«ãªã‚‹ã¿ãŸã„ ï¼ˆRubyã§ã„ã†rbenvã¿ãŸã„ãªã‚‚ã®ã‹ï¼‰ export NVM_DIR="$HOME/.nvm" && ( git clone https://github.com/nvm-sh/nvm.git "$NVM_DIR" cd "$NVM_DIR" git checkout `git describe --abbrev=0 --tags --match "v[0-9]*" $(git rev-list --tags --max-count=1)` ) && \. "$NVM_DIR/nvm.sh"
uchiuchiyama 2022/07/26
next.js

database

mysql

tutorial

development

docker
ãƒªãƒ³ã‚¯
microCMS + Next.jsã§Jamstackãƒ–ãƒã‚°ã‚’ä½œã£ã¦ã¿ã‚ˆã†
microCMSã¨Next.jsã‚’çµ„ã¿åˆã‚ã›ã¦ã€Jamstackãªãƒ–ãƒã‚°ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã‚‹ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã§ã™ã€‚ å‰æåˆ©ç”¨ã‚µãƒ¼ãƒ“ã‚¹æœ¬è¨˜äº‹ã§ã¯ä»¥ä¸‹ã®2ã¤ã®ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ã©ã¡ã‚‰ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚‚å€‹äººé–‹ç™ºã«ãŠã„ã¦ã¯ç„¡æ–™ã®ç¯„å›²ã§ååˆ†ãªæ©Ÿèƒ½ã‚’å‚™ãˆã¦ãŠã‚Šã€å®Ÿç¸¾è±Šå¯Œãªã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚æœ€åˆã«ãã‚Œãžã‚Œã®ã‚µã‚¤ãƒˆãƒˆãƒƒãƒ—ã‚ˆã‚Šç™»éŒ²ã‚’æ¸ˆã¾ã›ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ microCMSï¼šç‰¹ã«æ—¥æœ¬ã«ãŠã„ã¦å¸‚å ´ã‚’ãƒªãƒ¼ãƒ‰ã™ã‚‹ãƒ˜ãƒƒãƒ‰ãƒ¬ã‚¹CMSã§ã™ã€‚ãƒ–ãƒã‚°ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ç®¡ç†ã‚’æ‹…ã„ã¾ã™ã€‚Vercelï¼šãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰é–‹ç™ºå‘ã‘ã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ã™ã€‚ã‚µã‚¤ãƒˆå…¬é–‹ã«ãŠã‘ã‚‹ã‚¤ãƒ³ãƒ•ãƒ©ã‚„CI/CDã‚’æ‹…ã„ã¾ã™ã€‚ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒãƒ¼ã‚¸ãƒ§ãƒ³ä¸‹è¨˜ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§é–‹ç™ºã‚’è¡Œãªã£ã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®å·®ç•°ã«ã‚ˆã£ã¦è‹¥å¹²æ©Ÿèƒ½ãŒç•°ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ Next 13.1.1react 18.2.0react-dom 18.2.0microcms-js-sdk 2.3.2
uchiuchiyama 2021/02/16
next.js

vercel

cms

database

api

tutorial
ãƒªãƒ³ã‚¯
Deploy to Vercel | Prisma Documentation
This guide takes you through the steps to set up and deploy a serverless application that uses Prisma to Vercel. Vercel is a cloud platform that hosts static sites, serverless, and edge functions. You can integrate a Vercel project with a GitHub repository to allow you to deploy automatically when you make new commits. We created an example application using Next.js you can use as a reference when
uchiuchiyama 2021/01/01
database

postgresql

serverless

heroku

next.js

tutorial
ãƒªãƒ³ã‚¯
æœ€è¿‘è©±é¡Œã® TS è£½ ORMã€ŒPrisma 2ã€ã§ãƒã‚°ã‚¤ãƒ³å‡¦ç†ã‚’è©¦ã—ã¦ã¿ãŸã‚‰è¶…å¿«é©ã ã£ãŸ
ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã¯ã€Qiita: TypeScript Advent Calendar 2020 24 æ—¥ç›®ã®è¨˜äº‹ã§ã™ ðŸŽ„âœ¨ ä»Šå›žã¯ã€Front-End Study #1ã€ŒCloud Nativeæ™‚ä»£ã®ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã€ - connpass ã§ç´¹ä»‹ã•ã‚Œã¦ã„ãŸ Prisma 2 ã‚’ã€åŒã˜ãç´¹ä»‹ã•ã‚Œã¦ã„ãŸ frourio ã‚’ä½¿ã£ã¦è©¦ã—ã¦ã¿ã¾ã™ã€‚ ç’°å¢ƒæ§‹ç¯‰ frourio ã§ä¸€æ°—ã« ã¾ãšã¯ create-frourio-app ã§ã‚µã‚¯ãƒƒã¨ç’°å¢ƒæ§‹ç¯‰ã—ã¾ã™ã€‚ ä»Šå›žã¯ä»¥ä¸‹ã®æ§‹æˆã§è©¦ã—ã¦ã¿ã¾ã™ã€‚ MySQL ã‚’å»ºã¦ã‚‹ã®ãŒé¢å€’ãªå ´åˆã¯ã€SQLite ã§ã‚‚ã„ã„ã¨æ€ã„ã¾ã™ã€‚ Core framework of frourio : Fastify Frontend framework : Next.js Building mode : Basic HTTP client of aspida : axios
uchiuchiyama 2020/12/24
next.js

database

development

tutorial
ãƒªãƒ³ã‚¯
Next.js + Prisma + NextAuth.js + React Query ã§ä½œã‚‹ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ–°æ™‚ä»£
ã©ã†ã‚‚ã€@yuyaaar ã§ã™ã€‚ æœ€è¿‘ã¯ Next.js ã‚¢ãƒ—ãƒªã‚’è¦‹ã‚‹ã“ã¨ãŒå¤šããªã£ã¦ãã¾ã—ãŸã€‚ã‚‚ã¯ã‚„ JAM ã‚¹ã‚¿ãƒƒã‚¯ã®çŽ‹é“ã€ã¨è¨€ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã§ã™ãŒã€ã‚„ã£ã±ã‚Šãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯ã¨ãªã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„èªè¨¼ãªã©ãŒå¿…è¦ã«ãªã£ã¦ãã¦ã€ãã®è¾ºã®ã‚„ã‚Šæ–¹ãŒã„ã¾ã„ã¡ã‚ˆãã‚ã‹ã‚‰ãªã„ã€ã¨ã„ã†äººã‚‚å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ è‡ªåˆ†ã‚‚ãã®ä¸€äººã§ã—ãŸã€‚ðŸ˜… ã„ã‚ã„ã‚èª¿ã¹ãŸã‚Šä½œã£ãŸã‚Šã—ãŸçµæžœã€ä»Šç¾åœ¨ã‚‚ã£ã¨ã‚‚æœ€å¼·ã‚³ãƒ³ãƒ“ã§ã‚ã‚ã†ã€ Next.jsPrismaNextAuth.jsReact Queryã§ã®ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œã‚Šæ–¹ã‚’ã“ã®è¨˜äº‹ã§ã¯æ›¸ã„ã¦ã„ãã¾ã™ã€‚ ä»Šå›žã¯ã€ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã‚¢ãƒ—ãƒªã§ã‚ˆãã‚ã‚‹ Todo ã‚¢ãƒ—ãƒªã‚’ä½œã£ã¦ã€vercel ã«ãƒ‡ãƒ—ãƒã‚¤ã€ã¨ã„ã†ã®ã‚’ã‚„ã£ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã¯æœ€åˆã« Next.js ãƒœã‚¤ãƒ©ãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆã‚¢ãƒ—ãƒªã‚’ä½œã‚Šã¾ã—ã‚‡ã†ã€‚ ä½œæˆã§ããŸã‚‰ã€ã¾ãšã¯ TypeScr
uchiuchiyama 2020/12/24
next.js

tutorial

database
ãƒªãƒ³ã‚¯
Next.js ã‹ã‚‰ Prisma ORM ã‚’åˆ©ç”¨ã™ã‚‹
Next.js ã« Prisma ORM ã‚’å°Žå…¥ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ Next.js ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®é››å½¢ã‚’ä½œæˆ $ mkdir hello-next-app && cd hello-next-app $ npm init -y $ npm install next react react-dom --save $ npm install typescript @types/node @types/react --save-dev $ code src/index.tsx
uchiuchiyama 2020/12/23
next.js

database

development

tutorial
ãƒªãƒ³ã‚¯
Code Conqueror | Blog
uchiuchiyama 2020/01/15
next.js

database

mongodb

tutorial
ãƒªãƒ³ã‚¯
Dexie.jsã¯IndexedDBã‚’è¶…ã‚·ãƒ³ãƒ—ãƒ«ã«æ‰±ãˆã‚‹ãƒŸãƒ‹ãƒžãƒªã‚¹ãƒˆã®ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒª
ãƒŸãƒ‹ãƒžãƒªã‚¹ãƒˆ()ã«ã‚ªã‚¹ã‚¹ãƒ¡ã®IndexedDBãƒ©ãƒƒãƒ‘ãƒ¼[Dexie.js](http://dexie.org/)ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ–ãƒ©ã‚¦ã‚¶ã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ã¨ãã®æ°¸ç¶šåŒ–å…ˆã¨ã—ã¦IndexedDBã‚’ä½¿ã†ã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ãŒã€IndexedDBã¯å°‘ã—IFãŒè¤‡é›‘ãªã®ãŒãƒãƒƒã‚¯ã€‚ ãã‚Œã‚’ã‚·ãƒ³ãƒ—ãƒ«ã«ã—ã¦ãã‚Œã‚‹ã®ãŒä»Šå›žç´¹ä»‹ã™ã‚‹Dexie.jsã§ã™ã€‚Dexie.jsã¯è¤‡é›‘ãªIndexedDBã®IFã‚’è–„ãåŒ…ã¿è¾¼ã‚“ã§ç°¡æ½”ã«ã—ã¦ãã‚Œã¾ã™ã€‚ ä»¥ä¸‹ã«Dexie.jsã®ã‚¶ãƒƒã‚¯ãƒªã¨ã—ãŸä½¿ã„æ–¹ã‚’è¼‰ã›ã¾ã—ãŸã€‚ (ã»ã¨ã‚“ã©[Quick Reference](https://github.com/dfahlander/Dexie.js/wiki/API-Reference#quick-reference)ã®ç¿»è¨³ã§ã™) - [Dexie.jsã®ãƒãƒ¼ãƒ‰](#loaddexiejs) - [DBå®šç¾©](#declare) - [DBã®ã‚¢ãƒƒ
uchiuchiyama 2018/01/26
database

javascript

reference

tutorial
ãƒªãƒ³ã‚¯
NeDB ã‚’ä½¿ã£ã¦ã¿ãŸ - Qiita
ã¯ã˜ã‚ã« Electron ã‚’ä½¿ã£ã¦ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã‚¢ãƒ—ãƒªã‚’ä½œæˆã—ã‚ˆã†ã¨ã—ã¦ã„ã¾ã™ã€‚ã‚ã‚‹ç¨‹åº¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ãŠã„ã¦æ¤œç´¢ã—ãŸã‚Šã—ãŸã„ã®ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ç”¨ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãŸã ã—ä»Šå›žã¯ã€ã‚¢ãƒ—ãƒªã¨åˆ¥ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã¯é¿ã‘ãŸã„ã¨æ€ã„ã¾ã—ãŸã€‚ Electron ã§ã‚ã‚Œã°ã€Web Storage ã‚„ Indexed DB ãŒä½¿ãˆã‚‹ã‘ã‚Œã©ã€ä½¿ã„å‹æ‰‹ãŒã„ã„ã¨ã¯è¨€ãˆã¾ã›ã‚“ã€‚ ã‚¢ãƒ—ãƒªã«çµ„è¾¼ã§ãã‚‹ã‚¿ã‚¤ãƒ—ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æŽ¢ã—ã¾ã—ãŸã€‚ãã®ä¸ã« NeDB ãŒã‚ã‚Šã¾ã—ãŸã€‚ å‚è€ƒ [Node.jsã§ä½¿ãˆã‚‹ãƒ•ã‚¡ã‚¤ãƒ«DB"NeDB"ã®ã‚¹ã‚¹ãƒ¡] (http://www.slideshare.net/isamusuzuki54/dbne-db) NeDB ã¨ã¯ NeDB ã¯ã€çµ„è¾¼åž‹ã®æ°¸ç¶šçš„ã‚ã‚‹ã„ã¯ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€Node.js ã€NW.js ã€Electron
uchiuchiyama 2017/05/12
database

javascript

node.js

library

tutorial

reference
ãƒªãƒ³ã‚¯
IndexedDbã‚’ActiveRecord+Promiseã£ã½ãæ‰±ãˆã¦JSONSchemaã§ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã§ãã¦nodeã§ã‚‚ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã§å‹•ã„ã¦ãORMã¿ãŸã„ãªä½•ã‹ä½œã£ã¦ã¿ãŸ - Qiita
IndexedDbã‚’ActiveRecord+Promiseã£ã½ãæ‰±ãˆã¦JSONSchemaã§ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã§ãã¦nodeã§ã‚‚ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã§å‹•ã„ã¦ãORMã¿ãŸã„ãªä½•ã‹ä½œã£ã¦ã¿ãŸJavaScriptStoneSkin ã‚¿ã‚¤ãƒˆãƒ«ç››ã‚Šã™ãŽãŸã€‚ mizchi/stone-skin ã§ã™ã€‚ npm install stone-skin ã§å…¥ã‚‹ã‚“ã§browserifyã¨ä¸€ç·’ã«ä½¿ã£ã¦ãã ã•ã„ã€‚ å‘½åã¯ã€æ™‚é–“ãŒã‚ã£ãŸã‚‰FF14ã‚„ã‚‹ã‚“ã ã‘ã©ãªã¨ã„ã†æ°—æŒã¡ã‚’è¾¼ã‚ã¦ã€‚(ãƒŠã‚¤ãƒˆã ã‘Lv50ã«ã—ã¦ã‹ã‚‰1å¹´ä»¥ä¸Šè§¦ã£ã¦ãªã„) ã“ã®å‰ç´¹ä»‹ã—ãŸArdaã¨ä¸€ç·’ã§ã€æœ¬ç•ªç’°å¢ƒã§ãƒ‰ãƒƒã‚°ãƒ•ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã—ã¤ã¤é–‹ç™ºã—ãŸã®ã§ã€ä½¿ã„ç‰©ã«ãªã‚‹ã¯ãšã€‚ä»Šã•ã£ããƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæ›¸ã„ã¦v0.1.0ã«ã—ãŸã®ã§ç´¹ä»‹ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ éžåŒæœŸAPIã¯Promiseã‚’è¿”ã™ã®ã§ã€ã“ã®å‰æ›¸ã„ãŸ JavaScript - Babelã®async/awaitè©¦ã—ã¦ã¿ãŸ(+ä¸
uchiuchiyama 2017/05/12
database

javascript

node.js

library

tutorial
ãƒªãƒ³ã‚¯
Mongoã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ”¹å–„ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ãŸ - Qiita
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é—‡é›²ã«è²¼ã‚Œã°ã„ã„ã¨ã„ã†ç‰©ã§ã¯ãªãã€æ—¢å˜ã®ã‚·ã‚¹ãƒ†ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹ã®ã§ã‚ã‚Œã°èª¿æŸ»ã‹ã‚‰è¡Œã†ã®ãŒå®šçŸ³ã¨ã„ã†ã“ã¨ã§ã€ã¾ãšã¯ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®èª¿æŸ»æ–¹æ³•ã‹ã‚‰ç´¹ä»‹ã—ã¾ã™ã€‚ æ’²æ»…ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒª ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒª # ã¾ãšã¯MongoShellã«ãƒã‚°ã‚¤ãƒ³ã—ã¾ã™ $ mongo # DBã‚’é¸æŠžã—ã¾ã™ use sample # db.setProfilingLevel(level, slowms) # level:1 ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®ã¿å‡ºåŠ› # level:2 ã™ã¹ã¦ # slowms ä»¥ä¸‹ã®ä¾‹ã ã¨20msä»¥ä¸Šã‹ã‹ã£ã¦ã„ã‚‹ã‚¯ã‚¨ãƒªã‚’å‡ºåŠ›ã™ã‚‹ db.setProfilingLevel(1,20) # ã„ãã¤ã‹ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸã‚ã¨ã«å®Ÿè¡Œã—ã¦ã¿ã¾ã™ # forEach(printjson) ã¯è¦‹ã‚„ã™ãæ•´å½¢ã™ã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ db.system.profile.find().forEach(printjson) >
uchiuchiyama 2016/06/14
mongodb

rails

database

tutorial

performance
ãƒªãƒ³ã‚¯
ç¬¬31å›žã€€Rubyistã®ãŸã‚ã®MongoDBå…¥é–€ï¼ˆ1ï¼‰ | gihyo.jp
ã¯ã˜ã‚ã« ã“ã“æœ€è¿‘ã€NoSQLã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ãŒæ³¨ç›®ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ä¸€èˆ¬çš„ã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆï¼ˆã‚µãƒ¼ãƒã®å°æ•°ã‚’å¢—ã‚„ã—ã¦æ€§èƒ½å‘ä¸Šã‚’å›³ã‚‹æ‰‹æ³•ï¼‰ãŒé›£ã—ãã€ç‰¹ã«å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã«ãŠã„ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä¸Šã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šãˆã¾ã™ã€‚ã¾ãŸã€ã‚¿ã‚°ã‚„ã‚°ãƒ©ãƒ•æ§‹é€ ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã¯é–¢ä¿‚ãƒ¢ãƒ‡ãƒ«ã«é¦´æŸ“ã¿ã«ãã„ãŸã‚ã€ãã‚Œã‚‰ã‚’æ‰±ã†éš›ã«ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰ã‚‚ãŽã“ã¡ãªã„ã‚‚ã®ã«ãªã‚ŠãŒã¡ã§ã™ã€‚ ã“ã‚Œã‚‰ã®å•é¡Œã‚’èƒŒæ™¯ã«ã€ä½•ã«ã§ã‚‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†ã®ã§ã¯ãªãã€ç”¨é€”ã«å¿œã˜ã¦KVSãªã©ä»–ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’é¸æŠžã™ã‚‹æµã‚ŒãŒåºƒã¾ã‚Šã¤ã¤ã‚ã‚Šã¾ã™ã€‚ã“ã®ãƒ ãƒ¼ãƒ–ãƒ¡ãƒ³ãƒˆãŒNoSQLï¼ˆNot Only SQLï¼‰ã¨å‘¼ã°ã‚Œã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ ä»Šå›žã¯ã€NoSQLãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®1ã¤ã§ã‚ã‚‹Mongo DBã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ Mongo DBã¨ã¯ Mongo DBã¯é«˜ã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’ç‰¹å¾´ã¨ã™ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘åž‹ãƒ‡ãƒ¼
uchiuchiyama 2010/08/04
ruby

database

mongodb

tutorial
ãƒªãƒ³ã‚¯
MemoPad@uehi - FC2 BLOG ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰èªè¨¼
ãƒ–ãƒã‚° ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰èªè¨¼ é–²è¦§ã™ã‚‹ã«ã¯ç®¡ç†äººãŒè¨å®šã—ãŸ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å…¥åŠ›ãŒå¿…è¦ã§ã™ã€‚ ç®¡ç†äººã‹ã‚‰ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ é–²è¦§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ Copyright Â© since 1999 FC2 inc. All Rights Reserved.
uchiuchiyama 2009/11/15
rails

database

tutorial
ãƒªãƒ³ã‚¯
SQLã‚’ä½¿ã†ãªã‚‰ç†è§£ã—ã¦ãŠããŸã„ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ï¼Ÿ(ã¨ã„ã†ã‹ã€selectæ–‡ã®æ›¸ãæ–¹) - whereãƒ»order byãƒ»joinãƒ»group by - ä½•ã‹ã—ã‚‰ã®è¨€èªžã«ã‚ˆã‚‹è¨˜è¿°ã‚’è§£æžã™ã‚‹æ—¥è¨˜
SQLã®selectæ–‡ã®æ›¸ãæ–¹ã®è¦šæ›¸ã§ã™ã€‚ ãªãŠã€æœ¬æ–‡ä¸ã®å‹•ä½œç¢ºèªã¯ã€Œmysql Ver 5.0.67ã€ã§è¡Œã„ã¾ã—ãŸã€‚ 2009/10/05 13:30 è¿½è¨˜ äºˆæƒ³å¤–ã«å¤šãã®ã‚¢ã‚¯ã‚»ã‚¹ã¨ãƒ–ã‚¯ãƒžã‚’ã„ãŸã ãã€æ£ç›´é©šã„ã¦ãŠã‚Šã¾ã™ã€‚ æœ¬æ–‡ã¯sqlã®å†…éƒ¨å‡¦ç†ã«ã¯ä¸€åˆ‡è§¦ã‚Œã¦ãŠã‚Šã¾ã›ã‚“ã€‚ã”ãæ™®é€šã®sqlã®æ›¸ãæ–¹ã«ã®ã¿è§¦ã‚Œã¦ã„ã¾ã™ã€‚ é‡£ã‚Šã®ã¤ã‚‚ã‚Šã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€é‡£ã‚‰ã‚ŒãŸã¨æ„Ÿã˜ãŸæ–¹ã«ã¯ã”ã‚ã‚“ãªã•ã„ã€‚ ç›®æ¬¡ èª¬æ˜Žã«ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ï¼Ÿ(ã¨ã„ã†ã‹ãƒ†ãƒ¼ãƒ–ãƒ«) æŠ½å‡º(whereå¥) ã‚½ãƒ¼ãƒˆ(order byå¥) ã‚½ãƒ¼ãƒˆã®ä¾‹(æ˜‡é †) ã‚½ãƒ¼ãƒˆã®ä¾‹(é™é †) çµåˆ(joinå¥) é›†è¨ˆ(group byå¥) é–¢é€£è¨˜äº‹ èª¬æ˜Žã«ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ (ã¨ã„ã†ã‹ãƒ†ãƒ¼ãƒ–ãƒ«) selectæ–‡ã®ä½¿ã„æ–¹ã‚’èª¬æ˜Žã™ã‚‹ãŸã‚ã«ã€ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã„ã¾ã™ã€‚ create table countries ( name nvarchar(30), cu
uchiuchiyama 2009/10/05
database

tutorial
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: ãƒ–ãƒ©ã‚¦ã‚¶ã§ERå›³ãŒæã‘ã‚‹ã€ŒWWW SQL Designerã€ç´¹ä»‹
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
uchiuchiyama 2007/10/06
database

design

php

tool

tutorial
ãƒªãƒ³ã‚¯
Senna çµ„ã¿è¾¼ã¿åž‹å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ - Senna2.0ãŒã‚„ã£ã¦ãã‚‹!
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
uchiuchiyama 2007/08/25
search

senna

database

tutorial
ãƒªãƒ³ã‚¯
AIRã¨SQLiteã§å¦ã¶ ãƒãƒ¼ã‚«ãƒ«DBæ“ä½œã®åŸºæœ¬ ï¼ˆ1/3ï¼‰ â”€ ï¼ IT
Apolloæ”¹ã‚AIRãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ï¼ˆ2ï¼‰ AIRã¨SQLiteã§å¦ã¶ ãƒãƒ¼ã‚«ãƒ«DBæ“ä½œã®åŸºæœ¬ ã‚¯ãƒ©ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ æ‰æµ¦ç¯¤å² 2007/8/17 ç·¨é›†éƒ¨æ³¨ï¼šå‰å›žã‚ˆã‚Šã€é€£è¼‰ã€ŒApolloãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ã€ã¯æœ¬é€£è¼‰ã€ŒApolloæ”¹ã‚AIRãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ã“ã®é€£è¼‰ã‚’ã‚ˆã‚Šæ·±ãç†è§£ã™ã‚‹ãŸã‚ã«ã¯ã€é€£è¼‰ã€ŒApolloãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ã€ã‚‚ä½µã›ã¦ã”è¦§ãã ã•ã„ã€‚ ã„ã¾ã•ã‚‰èžã‘ãªã„ã€SQLiteã¨ã¯ï¼Ÿ å‰å›žã¯AIRï¼ˆAdobe Integrated Runtimeï¼‰ãƒ™ãƒ¼ã‚¿ç‰ˆã®æ–°æ©Ÿèƒ½ã¨ã—ã¦ã€ãƒ‰ãƒ©ãƒƒã‚°ï¼†ãƒ‰ãƒãƒƒãƒ—ã«æ³¨ç›®ã—ã¦2ã¤ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’ä½œæˆã—ã¾ã—ãŸã€‚ ä»Šå›žã¯AIRãƒ™ãƒ¼ã‚¿ç‰ˆã‹ã‚‰åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸãƒãƒ¼ã‚«ãƒ«DBã¨ã®é€£æºã«ã¤ã„ã¦ã§ã™ã€‚AIRã«ã¯ã€DBã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦SQLiteãŒå®Ÿè£…ã•ã‚Œã€ActionScriptã‹ã‚‰SQLiteå½¢å¼ã®DBãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ‰±ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ SQLiteã¯M
uchiuchiyama 2007/08/20
air

sqlite

adobe

database

development

tutorial
ãƒªãƒ³ã‚¯
Project Zeroã§ã‚¹ã‚¯ãƒªãƒ—ãƒˆï¼‹Ajaxã®ã‚¢ã‚¸ãƒ£ã‚¤ãƒ«é–‹ç™º
Project Zeroã§ã‚¹ã‚¯ãƒªãƒ—ãƒˆï¼‹Ajaxã®ã‚¢ã‚¸ãƒ£ã‚¤ãƒ«é–‹ç™ºï¼šCoolãªEclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ï¼ˆ19ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ â€œProject Zeroâ€ã¨ã¯ã„ã£ãŸã„ä½•ãªã®ã‹ï¼Ÿ Project Zeroã¨ã¯ã€ŒZero complexity, Zero overhead, Zero obstaclesã€ï¼ˆè¤‡é›‘ã•ã‚¼ãƒã€ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ã‚¼ãƒã€éšœå®³ã‚¼ãƒï¼‰ã‚’ã‚¹ãƒãƒ¼ã‚¬ãƒ³ã¨ã—ã¦æŽ²ã’ãŸIBMã®æ–°ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€æ¬¡ä¸–ä»£ã®å‹•çš„Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¢ã‚¸ãƒ£ã‚¤ãƒ«é–‹ç™ºã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã—ã¦ãŠã‚Šã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã¨Ajaxã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ãŒç‰¹å¾´ã§ã™ã€‚ Project Zeroã¯ã€Javaç‰ˆã€PHPç‰ˆã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ç‰ˆã®3ã¤ã®ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚æœ¬ç¨¿ã§ã¯ã€Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã‚‹Javaç‰ˆã®ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç”¨ã„ã€ãƒ–ãƒã‚°ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆã‚’é€šã—ã¦Project Zeroã®æ¦‚
uchiuchiyama 2007/08/17
java

eclipse

javascript

database

ajax

development

tutorial
ãƒªãƒ³ã‚¯
Edge Components æ¦‚å¿µã€è¨ˆç”»ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« / WebSphere Application Server
IBMÂ® Db2Â® is theÂ cloud-native database built to power low-latency transactions and real-time analytics at scale.Â Built on decades of innovation in data security, scalability and availability, you can use Db2 to keep your applications and analytics protected, highly performant and resilient, anywhere. It provides a single engine for DBAs, enterprise architects and developers to: Run critical applic
uchiuchiyama 2007/07/01
rails

database

db2

business

tutorial
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸