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

uchiuchiyama id:uchiuchiyama

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

${{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}}

Notion API
Start building with the Notion API Connect Notion pages and databases to the tools you use every day, creating powerful workflows. Get started Building blocks for developers Aggregate data from many sources into your teamâ€™s workspace. Spend less time context switching, and increase visibility across the software and services you rely on. Stay in the loop Twitter Spend more time on Twitter than you
uchiuchiyama 2021/05/14
api

webservice

database

cms

reference
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
Home - Docs-Japanese - 10gen Confluence
æ—¥æœ¬èªžç¿»è¨³ã«é–¢ã—ã¦ ã¾ã å…¨ç„¶çµ‚ã‚ã£ã¦ãªã„ã®ã§ã€ãƒªãƒ³ã‚¯å…ˆã«ã‚ˆã£ã¦è‹±èªžã ã£ãŸã‚Šæ—¥æœ¬èªžã ã£ãŸã‚Šã—ã¾ã™ã€‚å³ã®Navigation Spaceã§ã¯ç¿»è¨³ã•ã‚ŒãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã ã‘ãŒè¡¨ç¤ºã•ã‚Œã¦ã„ã¾ã™ã€‚ç¿»è¨³ã«ã¤ã„ã¦ã¯ã€ ã“ã¡ã‚‰ ã‚’å‚ç…§ãã ã•ã„ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€key-value storeã€RDBMSã€æœ€é«˜ã®æ©Ÿèƒ½ã®çµ„ã¿åˆã‚ã› Mongo DBã¯("humongous"ã‚ˆã‚Š)ã¯ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ã€ãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã€ã‚¹ã‚ãƒ¼ãƒžãƒ•ãƒªãƒ¼ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘ã§ã™ã€‚C++ã§æ›¸ã‹ã‚Œã¦ã„ã¦ã€æ©Ÿèƒ½ã¨ã—ã¦ã¯: ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ (the simplicity and power of JSON-like data schemas) å‹•çš„ãª ã‚¯ã‚¨ãƒªãƒ¼ çµ„ã¿è¾¼ã¿ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨é…åˆ—ã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸå®Œå…¨ãª Index ã®ã‚µãƒãƒ¼ãƒˆã€‚ ã‚¯ã‚¨ãƒªãƒ¼ ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚° é€Ÿã„ in-place ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆ ãƒã‚¤ãƒŠãƒªãƒ‡
uchiuchiyama 2010/08/05
mongodb

reference

database
ãƒªãƒ³ã‚¯
PostGIS Manual
PostGISã¯ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«GIS(Geographic Information Systems)ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ï¼Œæ ¼ç´ã§ãã‚‹ã‚ˆã†ã«ã—ãŸPostgtreSQLã®æ‹¡å¼µã§ã™ï¼ŽPostGISã¯ï¼ŒGiSTãƒ™ãƒ¼ã‚¹ã®R-Treeç©ºé–“ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨åŸºæœ¬çš„ãªGISã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®è§£æžç”¨ã®é–¢æ•°ã®ã‚µãƒãƒ¼ãƒˆã‚’å«ã¿ã¾ã™ï¼Ž (è¨³æ³¨:å…ƒã«ã—ãŸè‹±èªžç‰ˆãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¯2003å¹´1æœˆé ƒã®ã‚‚ã®ã§ã™ã€‚ãŠæ°—ã¥ãã®ç‚¹ãŒã‚ã‚Šã¾ã—ãŸã‚‰ï¼Œãƒ–ãƒã‚°ã®PostGISã®ã‚¨ãƒ³ãƒˆãƒªã«ã‚³ãƒ¡ãƒ³ãƒˆã‚’å…¥ã‚Œã¦ãã ã•ã„)
uchiuchiyama 2008/02/09
database

postgresql

tool

reference

geocoding
ãƒªãƒ³ã‚¯
PostgreSQL 8.2.6æ–‡æ›¸
ç›®æ¬¡ã¯ã˜ã‚ã«PostgreSQLã¨ã¯?PostgreSQLå°å²è¦ç´„ã‚ˆã‚Šé€²ã‚“ã æƒ…å ±ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³I. ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«1ç« ã•ã‚å§‹ã‚ã¾ã—ã‚‡ã†2ç« SQLè¨€èªž3ç« é«˜åº¦ãªè«¸æ©Ÿèƒ½II. SQLè¨€èªž4ç« SQLã®æ§‹æ–‡5ç« ãƒ‡ãƒ¼ã‚¿å®šç¾©6ç« ãƒ‡ãƒ¼ã‚¿æ“ä½œ7ç« å•ã„åˆã‚ã›8ç« ãƒ‡ãƒ¼ã‚¿åž‹9ç« é–¢æ•°ã¨æ¼”ç®—å10ç« åž‹å¤‰æ›11ç« ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹12ç« åŒæ™‚å®Ÿè¡Œåˆ¶å¾¡13ç« æ€§èƒ½ã«é–¢ã™ã‚‹ãƒ’ãƒ³ãƒˆIII. ã‚µãƒ¼ãƒã®ç®¡ç†14ç« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †15ç« Windowsã¸ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ã¿ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«16ç« ã‚ªãƒšãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ ã®ç’°å¢ƒ17ç« ã‚µãƒ¼ãƒã®æ§‹æˆ18ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒ¼ãƒ«ã¨æ¨©é™19ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†20ç« ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼21ç« å¤šè¨€èªžå¯¾å¿œ22ç« å®šå¸¸çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¿å®ˆä½œæ¥23ç« ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢24ç« é«˜å¯ç”¨æ€§ãŠã‚ˆã³è² è·åˆ†æ•£25ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ´»å‹•çŠ¶æ³ã®ç›£è¦–26ç« ãƒ‡ã‚£ã‚¹ã‚¯ä½¿ç”¨é‡ã®ç›£è¦–27ç« ä¿¡é ¼æ€§ã¨ãƒã‚°å…ˆè¡Œæ›¸ãè¾¼ã¿28ç« ãƒªã‚°ãƒ¬ãƒƒã‚·ãƒ§ãƒ³ãƒ†ã‚¹ãƒˆIV
uchiuchiyama 2007/06/20
database

postgresql

reference

documents
ãƒªãƒ³ã‚¯
JavaScriptã®åŸºç¤Žã‹ã‚‰ã¯ã˜ã‚ã‚ˆã† - JavaScriptè¬›åº§
å¤‰æ•°ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«å€¤ã‚’ä»£å…¥ã—ãŸã‚Šå‡ºåŠ›ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ # å¤‰æ•°ã«æ–‡å—åˆ—ã‚’ä»£å…¥ $value = "ãƒ†ã‚¹ãƒˆã§ã™"; # å¤‰æ•°ã‚’å‡ºåŠ› print $value; ã€å‚ç…§ãƒšãƒ¼ã‚¸ã€‘ å¤‰æ•° é…åˆ— è¤‡æ•°ã®å€¤ã‚’1ã¤ã®å¤‰æ•°ã§ç®¡ç†ã—ãŸã„å ´åˆã¯ã€ã€Žé…åˆ—ã€ã¨ã„ã†å¤‰æ•°ãŒæœ€é©ã§ã™ã€‚ é…åˆ—ã‚’åˆæœŸåŒ–ã™ã‚‹å ´åˆã¯ï½¤è¦ç´ ã‚’ã‚«ãƒƒã‚³ã§å›²ã¿ï½¤å„è¦ç´ æ¯Žã«ã‚«ãƒ³ãƒžã§åŒºåˆ‡ã‚Šã¾ã™ï½¡ @week = ('æ—¥æ›œ', 'æœˆæ›œ', 'ç«æ›œ', 'æ°´æ›œ', 'æœ¨æ›œ', 'é‡‘æ›œ', 'åœŸæ›œ'); é…åˆ—ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦å‚ç…§ã—ã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ 0ã‹ã‚‰å§‹ã¾ã‚‹ã®ã§æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ãŸã¨ãˆã°1ç•ªç›®ã®ãƒ‡ãƒ¼ã‚¿ "æ—¥æ›œ" ã‚’å‘¼ã³å‡ºã™ã¨ãã¯ã€$week[0]ã€"æœˆæ›œ"ãªã‚‰ $week[1] ã¨ã—ã¾ã™ã€‚ # é…åˆ— @week ã®1ç•ªç›®ã®è¦ç´ ã‚’è¡¨ç¤º print $week[0], "\n"; > æ—¥æ›œ # é…åˆ— @week ã®2ç•ªç›®ã®è¦ç´ ã‚’è¡¨ç¤º print $
uchiuchiyama 2007/02/26
mysql

database

reference

tips
ãƒªãƒ³ã‚¯
MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
ã“ã®æ–‡æ›¸ã¯ã€osCommerceã§ä½¿ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãŠã‚‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†è€…ã‚ˆã‚Šã‚‚ã€ãƒ¦ãƒ¼ã‚¶ã«å‘ã‘ã¦æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã“ã“ã§ã¯ã€MySQLã‚µãƒ¼ãƒã¯èµ·å‹•ã—ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®æ–‡å—ã«ã¤ã„ã¦ MySQLã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã®å¤§æ–‡å—ã¨å°æ–‡å—ã‚’åŒºåˆ¥ã—ã¦ã„ã¾ã™ã€‚ãã‚Œä»¥å¤–ã¯åŒºåˆ¥ã—ã¾ã›ã‚“ã€‚ MySQLã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«åã«ä½¿ãˆã‚‹æ–‡å—ã¯ã€è‹±æ•°å—ã¨_ï¼ˆã‚¢ãƒ³ãƒ€ãƒ¼ãƒãƒ¼ï¼‰ã€$ã€ã‚µãƒ¼ãƒã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã«ã‚ã‚‹æ–‡å—ã§ã™ã€‚ çŸ¥ã£ã¦ãŠããŸã„ã‚³ãƒžãƒ³ãƒ‰ mysqladminï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆãƒ»å‰Šé™¤ã‚„ã€MySQLã‚µãƒ¼ãƒã®æƒ…å ±ã‚’å¾—ã‚‹ï¼‰ mysqlshowï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’è¡¨ç¤ºã™ã‚‹ï¼‰ mysqlï¼ˆMySQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®èµ·å‹•ï¼‰ mysqldumpï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ€ãƒ³ãƒ—ã™ã‚‹ï¼‰ myisamchkï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«
uchiuchiyama 2007/02/26
mysql

database

reference

tips
ãƒªãƒ³ã‚¯
1