[B! DB] Tomosugiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Tomosugi id:Tomosugi

DBã«é–¢ã™ã‚‹Tomosugiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (29)

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

DBã®æ£è¦åŒ–ã£ã¦ã©ã“ã¾ã§ã‚¬ãƒã‚¬ãƒã«ã‚„ã‚‹ã¹ãã§ã—ã‚‡ã†ã‹ï¼Ÿ
å›žç” (16ä»¶ä¸ã®1ä»¶ç›®) æ€ã„ã¤ãæ°—å‘³ã«ã€Œè»½ãƒ¼ã„ã€æ°—æŒã¡ã§ãƒã‚¨ãƒ çš„ã«æ›¸ã„ã¡ã‚ƒã„ã¾ã™ãŒãƒ»ãƒ»ãƒ» ç¾å ´ã«è»¸è¶³ã‚’ç½®ã„ãŸç«‹ã¡ä½ç½®ã§ã®ã€Œãã‚‚ãã‚‚è«–ã€ã§èªžã£ã¦ã—ã¾ã†ã¨ã€ãã‚‚ãã‚‚ã€ç¾å ´ã®å•é¡Œè§£æ±ºã‚„è¨è¨ˆã«ãŠã„ã¦ã¯ã€é ã§ã£ã‹ã¡æ°—å‘³ã®ã€Œãƒ»ãƒ»ãƒ»ã‚„ã‚‹ã¹ãã€ã¨ã„ã†è€ƒãˆæ–¹ã¯é©åˆ‡ã§ãªã„æ°—ãŒã—ã¦ã„ã¾ã™ã€‚ ä½•ã‹ã®ã€Œæ•™ç§‘æ›¸ã€ã©ãŠã‚Šã«ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã£ãŸã‹ã‚‰ã¨è¨€ã£ã¦ã€å…ˆç”Ÿã«è¤’ã‚ã‚‰ã‚Œã‚‹ã‚ã‘ã§ã‚‚ãªã„ã‚ã‘ã§ã™ã—ã€ãã‚Œã ã‘ã§ç„¡æ¡ä»¶ã«ä½•ã‹è‰¯ã„ã“ã¨ãŒèµ·ãã‚‹ã‚ã‘ã§ã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ ãŸã ã€ã€Œæ•™ç§‘æ›¸ã€ãªã©ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹æ–¹æ³•è«–ãŒå…¨ãæ„å‘³ãŒãªã„ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚æ–¹æ³•è«–ãŒè§£æ±ºã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹å•é¡ŒãŒã€ã€Œã‚ãªãŸã®ã€ç¾å ´ã«ãƒžãƒƒãƒã—ã¦ã„ã‚‹å ´åˆã¯æœ‰ç”¨ã§ã™ã€‚...
Tomosugi 2023/04/23
DB

è¨è¨ˆ

Quora
ãƒªãƒ³ã‚¯
æœ€è¿‘ã€åœ°æ–¹â†’ä¸å¤®çœåºã®ã¨ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ã‚„ã‚Šã¨ã‚ŠãŒã€Accessãƒ™ãƒ¼ã‚¹ï¼ˆAccessï¼‹Visua..
æœ€è¿‘ã€åœ°æ–¹â†’ä¸å¤®çœåºã®ã¨ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ã‚„ã‚Šã¨ã‚ŠãŒã€Accessãƒ™ãƒ¼ã‚¹ï¼ˆAccessï¼‹VisualBasicï¼‰ã‹ã‚‰Excelãƒ™ãƒ¼ã‚¹ï¼ˆExcelï¼‹ãƒžã‚¯ãƒï¼‰ã«å¤‰ã‚ã£ãŸã‚“ã ãŒâ€¦ã€‚ ã†ã¡ã®çœŒã§ã¯VisualBasicã®ãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã‚’ä½œæ¥ç”¨ï¼°ï¼£ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã ã‘ã§æŠ˜è¡ã«ä¸€å¹´è¶Šã—ã ã£ãŸã‹ã‚‰ã€ä¸€å¿œå¤‰æ›´è‡ªä½“ã¯æ“è¿Žã ã£ãŸã‚“ã ã‘ã‚Œã©ã‚‚ã€ã“ã‚ŒãŒâ€¦ã€‚ ã¡ãªã¿ã«ã€æ‰±ã†ãƒ‡ãƒ¼ã‚¿é‡ã¯ã€ã–ã£ãã‚Šè¨€ã£ã¦ã€ä¸€éƒ½é“åºœçœŒå½“ãŸã‚Šå¹³å‡ã§5000è¡ŒÃ—1000åˆ—ã®è¡¨ãã‚‰ã„ã€‚å¤šã„éƒ½ã‚„åºœãªã‚‰ã€åˆ—ã®æ–¹ãŒã“ã®æ•°å€è¡Œãã ã‚ã†ãªã€‚ã§ã€ã‚ãã¾ã§å€‹äººçš„ãªæ„Ÿæƒ³ã¨ã—ã¦ã€ã©ã‚“ãªæ„Ÿã˜ã‹ã¤ãƒ¼ã¨ã€ (1)ãƒ‡ãƒ¼ã‚¿è§¦ã£ãŸã‚Šé›†è¨ˆã—ãŸã‚Šã—ã«ãããªã£ãŸã€‚ å‰ã®ã‚·ã‚¹ãƒ†ãƒ ã¯ã€ãƒ‡ãƒ¼ã‚¿è‡ªä½“ã¯å˜ãªã‚‹Accessã®ãƒ‡ãƒ¼ã‚¿ã ã£ãŸã®ã§ã€é–“é•ã„ã‚’ä¿®æ£ã—ãŸã‚Šåˆ¥ã®é›†è¨ˆã«ä½¿ç”¨ã—ãŸã‚ŠãŒæ„å¤–ã¨æ°—æ¥½ã«å‡ºæ¥ãŸã€‚ ä»Šåº¦ã¯ã€Excelã‚’ç„¡ç†çŸ¢ç†ãƒžã‚¯ãƒã‚„ã‚‰ã§å‹•ã‹ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—ã¦ã‚‹ã‹ã‚‰ã€Accessã®æ™‚ä»£ã‚ˆã‚Šã‚‚
Tomosugi 2020/04/26
å¢—ç”°

DB

Excel

ã‚·ã‚¹ãƒ†ãƒ
ãƒªãƒ³ã‚¯
æ—¥ä»˜/æ™‚åˆ»ãƒ‡ãƒ¼ã‚¿åž‹
8.5. æ—¥ä»˜/æ™‚åˆ»ãƒ‡ãƒ¼ã‚¿åž‹PostgreSQLã§ã¯ã€è¡¨8-9ã«ç¤ºã•ã‚Œã¦ã„ã‚‹SQLã®æ—¥ä»˜ã¨æ™‚åˆ»ãƒ‡ãƒ¼ã‚¿åž‹ã®ã™ã¹ã¦ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ãƒ‡ãƒ¼ã‚¿åž‹ã§åˆ©ç”¨ã§ãã‚‹æ¼”ç®—åã«ã¤ã„ã¦ã¯é …9.9ã§èª¬æ˜Žã—ã¾ã™ã€‚ ã‚°ãƒ¬ã‚´ãƒªã‚ªæš¦ãŒå°Žå…¥ã•ã‚Œã‚‹å‰ã®å¹´ã§ã‚ã£ã¦ã‚‚ï¼ˆé …B.4å‚ç…§ï¼‰ã€æ—¥ä»˜ã¯ã‚°ãƒ¬ã‚´ãƒªã‚ªæš¦ã«ã—ãŸãŒã£ã¦è¨ˆç®—ã•ã‚Œã¾ã™ã€‚
Tomosugi 2018/07/07
DB

PostgreSQL
ãƒªãƒ³ã‚¯
4ã‚¹ãƒ†ãƒƒãƒ—ã§ä½œæˆã™ã‚‹ã€DBè«–ç†è¨è¨ˆã®æ‰‹é †ã¨ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã¾ã¨ã‚ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã¯ã˜ã‚ã« ã€Œé”äººã«å¦ã¶DBè¨è¨ˆã€ã€ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã‚’èªã‚“ã ã®ã§DBè¨è¨ˆã‚’ã™ã‚‹æµã‚Œã¨ãã®éŽç¨‹ã§ã®ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ä»Šå›žã¯æœ¬ã«è¼‰ã£ã¦ã„ã‚‹ã‚‚ã®ã®ä¸ã§ã‚‚ç‰¹ã«é‡è¦ãã†ãªéƒ¨åˆ†ã«çµžã£ã¦ã¿ã¾ã—ãŸã€‚ ã•ã‚‰ã«è©³ã—ã„ã“ã¨ã‚’çŸ¥ã‚ŠãŸã„æ–¹ã¯æœ¬ã‚’è³¼å…¥ã—ã¦ã¿ã¦ãã ã•ã„ã€‚å€‹äººçš„ã«ã¯é”äººã«å¦ã¶DBè¨è¨ˆå¾¹åº•æŒ‡å—æ›¸ã®ã»ã†ãŒãŠã™ã™ã‚ã§ã™ã€‚ã“ã¡ã‚‰ã ã‘ã‚ã‚Œã°ååˆ†ã ã¨æ€ã„ã¾ã™ã€‚ DBè¨è¨ˆã«ã¯å¤§ããåˆ†ã‘ã¦è«–ç†è¨è¨ˆã¨ç‰©ç†è¨è¨ˆã®äºŒã¤ãŒã‚ã‚Šã¾ã™ãŒã€ä»Šå›žã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã§ãƒ¡ã‚¤ãƒ³ã¨ãªã‚‹è«–ç†è¨è¨ˆã®éƒ¨åˆ†ã«ç„¦ç‚¹ã‚’ã‚ã¦ã¦èª¬æ˜Žã‚’ã—ã¾ã™ã€‚ ä¸€ç•ªæœ€å¾Œã«ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã ã‘ã‚’ã¾
Tomosugi 2018/06/16
DB
ãƒªãƒ³ã‚¯
Railsã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ç”»åƒã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ãƒ»è¡¨ç¤º - Qiita
Tomosugi 2018/05/21
Rails

ç”»åƒ

DB
ãƒªãƒ³ã‚¯
Railsã§ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹
Railsã§ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦publicãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ä¿å˜ã—ãŸã‚ã¨ã«è¡¨ç¤ºã™ã‚‹ Webã‚¢ãƒ—ãƒªãªã‚“ã¦ãƒ†ã‚ã‚¹ãƒˆã¨DBã®IOå‡¦ç†ã ã‘ã§ã€ç”»åƒã‚„ãƒã‚¤ãƒŠãƒªãªã‚“ã¦ã„ã‚‰ãªã„ãœï¼ï¼ â€¦ãã†è€ƒãˆã¦ã„ãŸæ™‚æœŸãŒãŸãã¿ã«ã‚‚ã‚ã‚Šã¾ã—ãŸã€‚ ã¨ã„ã†ã‚ã‘ã§ã€Railsã§ç”»åƒã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ã€ãã®ç”»åƒã‚’è¡¨ç¤ºã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ Rails ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®æº–å‚™ ã¾ãšã¯Railsã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã—ã¾ã™ã€‚ ä»Šå›žã¯ uploader ã¨ã„ã†åå‰ã§ rails new ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ shell
Tomosugi 2018/05/21
Rails

DB

ç”»åƒ
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹æ³•ã®ã¾ã¨ã‚ - Qiita
-- -- PostgreSQL database dump -- ï¼œç•¥ï¼ž -- -- Name: foo; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE foo ( a integer NOT NULL, b text ); ï¼œç•¥ï¼ž -- -- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY foo (a, b) FROM stdin; 1 inserted 2 inserted 3 inserted 4 inserted 5 inserted \. ï¼œç•¥ï¼ž ã¨ã—ã¦ã‚ã’ã‚Œã°OKã§ã™ã€‚ ãªãŠã€pg_dumpã®å‡ºåŠ›å½¢å¼ã‚’ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‹ã‚‰å¤‰æ›´ã—ãŸå ´åˆã«ã¯ã€psqlã§ã¯èªã¿è¾¼ã‚ãªã„ã®ã§pg_
Tomosugi 2018/05/21
PostgreSQL

DB
ãƒªãƒ³ã‚¯
backupã¨wheneverã§è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—è¨å®šã®æ–¹æ³• â€“ åœ°æ–¹ã§ãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯
Tomosugi 2018/05/21
MySQL

Rails

DB
ãƒªãƒ³ã‚¯
Backupãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚‚D.R.YåŒ–ã—ã‚ˆã†
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯èŠ³è³€@func09ã§ã™ã€‚ ä½•ã‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ãƒªãƒªãƒ¼ã‚¹ã™ã‚‹æ™‚ã€å¿…ãšã¨ã„ã£ã¦ã„ã„ã»ã©å¿…è¦ãªã®ã¯ãƒ‡ãƒ¼ã‚¿ã®å®šæœŸãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ã™ãã€‚ å¿…ãšã¨ã„ã£ã¦ã„ã„ã»ã©å¿…è¦ãªã®ã«ã€å¿…ãšã¨ã„ã£ã¦ã„ã„ã»ã©å¿˜ã‚ŒãŒã¡ã§ã€å¾Œå›žã—ã«ã•ã‚ŒãŒã¡ã§ã€ ãƒªãƒªãƒ¼ã‚¹å‰ã«ã€Œã‚ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ãƒãƒƒãƒå‡¦ç†æ›¸ã‹ãªãã‚ƒãƒ»ãƒ»ã€ã¿ãŸã„ãªæ„Ÿã˜ã§ã€æ¯Žå›žåŒã˜ã‚ˆã†ãªã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ã„ã¦ã¾ã›ã‚“ã‹ï¼Ÿåƒ•ã¯ãã‚“ãªæ„Ÿã˜ã§ã™ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã ã£ã¦D.R.Yï¼ˆDonâ€™t repeat yourselfï¼‰ã¨ã„ã†ã“ã¨ã§ã€ã‚µã‚¯ã£ã¨åŠ´åŠ›ã‚’ã‹ã‘ãšã«çµ‚ã‚ã‚‰ã›ãŸã„ãªãã¨æ€ã£ã¦ã„ãŸæ™‚ã«è¦‹ã¤ã‘ãŸã®ãŒBackupã¨ã„ã†åå‰ã®Gemã§ã™ã€‚ãã®ã¾ã‚“ã¾ã§ã™ãã€‚ Backup(RubyGem)ã¨ã¯ï¼Ÿ Backupï¼ˆ http://github.com/meskyanichi/backup ï¼‰ã¯Rubyã§æ›¸ã‹ã‚ŒãŸUnixã¨Railsç’°å¢ƒã®ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…
Tomosugi 2018/05/21
Rails

DB
ãƒªãƒ³ã‚¯
http://post.simplie.jp/posts/33
Tomosugi 2018/05/21
Rails

DB

PostgreSQL
ãƒªãƒ³ã‚¯
[rails][mysql]ActiveRecordã§ç¾åœ¨æŽ¥ç¶šã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚’å–å¾—ã™ã‚‹
ActiveRecordã§ç¾åœ¨æŽ¥ç¶šã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚’å–å¾—ã™ã‚‹ã«ã¯ Hoge.connection.current_database # => sample_developmentã§ã§ãã¾ã—ãŸã€‚ MySQLã®ã¿ã®ã‚ˆã†ã§ã™ã€‚ SQLiteã®å ´åˆã¯ä»¥ä¸‹ã§ã§ãã‚‹ãã†ã§ã™ãŒã€ã¡ã‚‡ã£ã¨æ‰‹é–“ã§ã™ãã€‚ Hoge.connection.instance_variable_get(:@config)[:database].split('/').lastå‚è€ƒconnection (ActiveRecord::Base) - APIdock
Tomosugi 2018/05/21
Rails

activerecord

DB

MySQL
ãƒªãƒ³ã‚¯
Macã§PostgreSQL - ä¸€æ©å‰é€²
MacPortsçµŒç”±ã§Macã«PostgreSQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¨ãã®ãƒ¡ãƒ¢ã§ã™ã€‚ã“ã“ã§ã¯ã€ã‚µãƒ¼ãƒé‹ç”¨ã¯è€ƒæ…®ã›ãšã€ã‚·ãƒ³ã‚°ãƒ«ãƒ¦ãƒ¼ã‚¶ã§ã®åˆ©ç”¨ã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚ é€šå¸¸ãƒ¦ãƒ¼ã‚¶ã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’%ã€postgresãƒ¦ãƒ¼ã‚¶ã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’postgres$ã§ç¤ºã—ã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« % sudo port install postgresql93 +universal % sudo port install postgresql93-server ãƒ¦ãƒ¼ã‚¶ç’°å¢ƒã®è¨å®š postgresãƒ¦ãƒ¼ã‚¶ã®è¨å®š PostgreSQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨postgresã¨ã„ã†ãƒ¦ãƒ¼ã‚¶ãŒè‡ªå‹•çš„ã«ä½œæˆã•ã‚Œã¾ã™ã€‚ postgresãƒ¦ãƒ¼ã‚¶ã‚’æœ‰åŠ¹åŒ–ã›ãšã«ã€su - postgres -c ã‚³ãƒžãƒ³ãƒ‰ã«ã‚ˆã£ã¦é–“æŽ¥çš„ã«postgresãƒ¦ãƒ¼ã‚¶ã¨ã—ã¦ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹æ–¹æ³•ã‚‚ã‚ã‚‹ã®ã§ã™ãŒã€é »ç¹ã«ç®¡ç†ä½œæ¥ã‚’è¡Œã†å ´åˆã¯ã‚³ãƒžãƒ³ãƒ‰ãŒç…©é›‘ã«ãªã‚‹ãŸã‚ã€post
Tomosugi 2018/05/21
PostgreSQL

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–ç†è¨è¨ˆã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - å¤œã¯å¯ã‚‹
ãŠã¯ã“ã‚“ã°ã‚“ã¡ã¯ã€‚ ãŒã‚“ã°ã£ã¦ãƒ–ãƒã‚°ã‚’æ›¸ããŸã„ã®ã§ã€ã¡ã‚‡ã†ã©ã„ã¾èªã‚“ã§ã„ã‚‹SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¨ã„ã†æœ¬ã‚’ã€å™›ã¿ç •ã„ã¦é›¢ä¹³é£Ÿãã‚‰ã„ã®æŸ”ã‚‰ã‹ã•ã«ã—ã¦æ™’ã—ã¦ã¿ã¾ã™ã€‚ã™ã§ã«èªã‚“ã äººã¯ã„ã¾ã™ããã£é–‰ã˜ã€ã¾ã èªã‚“ã§ãªã„äººã¯ã€ã“ã¡ã‚‰ã‚‚åŒæ§˜ã«ãã£é–‰ã˜ã—ã¦ãŠé¢¨å‘‚ã«å…¥ã£ã¦ã™ãå¯ã¾ã—ã‚‡ã†ã€‚ SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ ä½œè€…: Bill Karwin,å’Œç”°å“äºº,å’Œç”°çœäºŒ,å…å³¶ä¿®å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ç™ºå£²æ—¥: 2013/01/26ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬è³¼å…¥: 9äºº ã‚¯ãƒªãƒƒã‚¯: 698å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (45ä»¶) ã‚’è¦‹ã‚‹ ã‹ãªã‚Šåœ§å€’çš„ã«å½“ãŸã‚Šå‰ã®ã“ã¨ã—ã‹æ›¸ã„ã¦ãªã„ã‚“ã§ã™ã‘ã©ã€ãã†ã„ã†æœ¬ã“ããŒè‰¯æ›¸ã ã£ã¦ãŠã˜ã„ã¡ã‚ƒã‚“ã®æ¯åã®æ¯åãŒè¨€ã£ã¦ãŸæ°—ãŒã—ã¾ã™ã€‚ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ãŒå…¨éƒ¨ã§25å€‹ã€ï½¶ï½¯ï¾ï½®ï½²ï½²ã‚¿ã‚¤ãƒˆãƒ«ã¨ã¨ã‚‚ã«ç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ã€Œç›®çš„ã€ã€Œã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã€Œè§£æ±ºç–ã€ã‚’ãã‚Œãžã‚Œç¤ºã—ã¾ã™ã€‚æœ¬æ›¸ã ã¨ã€ã€Œã‚¢ãƒ³ã¨ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’
Tomosugi 2018/05/14
DB

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

è¨è¨ˆ

SQL
ãƒªãƒ³ã‚¯
Railsã§PostgreSQLã®æƒ…å ±ã‚’ç¢ºèªã™ã‚‹ - æ°—è»½ã«æ¥½ã—ããƒ—ãƒã‚°ãƒ©ãƒ ã¨éŠã¶
Railsã§DBæŽ¥ç¶šã™ã‚‹ config/database.ymlã«è¨å®šã—ãŸæŽ¥ç¶šæƒ…å ±ã‚’å…ƒã«æŽ¥ç¶š $ rails dbconsole db_name=> postgresã®ã‚³ãƒžãƒ³ãƒ‰ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸€è¦§ db_name=> \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -------------+----------+----------+-------------+-------------+------------------- db_name | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | user_name | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/user_na
Tomosugi 2018/05/14
PostgreSQL

DB

Rails
ãƒªãƒ³ã‚¯
doruby.jp
Tomosugi 2018/05/14
PostgreSQL

DB
ãƒªãƒ³ã‚¯
ã€Railsã€‘çµ¶å¯¾ã«æŠ‘ãˆãŸã„Transactionã®ãƒã‚¤ãƒ³ãƒˆã‚’ä¸‰ã¤ã«ã¾ã¨ã‚ã¦ã¿ãŸã€‚ã€å¿…é ˆã€‘ - Qiita
â€»Railså…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‹ã‚‰ã€å¹³æ˜“ãªæ—¥æœ¬èªžã§ãƒã‚¤ãƒ³ãƒˆã¨ãƒ—ãƒ©ã‚¹Î±ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚(å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ: http://api.rubyonrails.org/classes/ActiveRecord/Transactions/ClassMethods.html) Transaction - å¤±æ•—â†’Saveå‰ Transactionã¯ã€è¤‡æ•°ã®SQLæ–‡ã‚’å›²ã‚“ã§ã€ãã®SQLãã‚Œãžã‚ŒãŒæˆåŠŸã—ãŸå ´åˆã®ã¿ã«ã€ã™ã¹ã¦ã®SQLã®å¤‰æ›´ã‚’åæ˜ ã™ã‚‹ã‚ˆã¨ã„ã†ã‚‚ã®ã€‚å…¸åž‹çš„ãªä¾‹ã¯éŠ€è¡Œå£åº§ã®ä¾‹ã§ã€ç‰‡æ–¹ã®å£åº§ã‹ã‚‰ã®å¼•ãè½ã¨ã—ã«æˆåŠŸã—ãŸæ™‚ã®ã¿ã€ã‚‚ã†ç‰‡æ–¹ã®å£åº§ã«ãŠé‡‘ãŒãƒ—ãƒ©ã‚¹ã•ã‚Œã‚‹ã‚ˆã€ã¿ãŸã„ãªãã€‚ ã“ã‚“ãªæ„Ÿã˜ã§ã€Transactionã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çµ±ä¸€æ€§ã‚’ãƒ—ãƒã‚°ãƒ©ãƒ ã‚„dbã®ã‚¨ãƒ©ãƒ¼ã‹ã‚‰å®ˆã‚‹ã‚‚ã®ã€‚ä¸€ç·’ã«å‡¦ç†ã•ã‚Œãªãã‚ƒã„ã‘ãªã„å‡¦ç†ã®å¡Šã‚’æŒã£ã¦ã‚‹æ™‚ã¯çµ¶å¯¾ã«ä½¿ã‚ãªãã‚ƒã„ã‘ãªã„ã€‚ ä¾‹ãˆã°ã€ä»¥ä¸‹ã®ä¾‹ã§ã¯kevinã®å£åº§ã‹ã‚‰ã®å¼•ãè½ã¨ã—ã«æˆ
Tomosugi 2018/04/29
qiita

Rails

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¸ã®é“
æœ¬é€£è¼‰ã¯ã€ITã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®ç¾å ´ã§ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚„SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¡Œã£ã¦ã„ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨è€…ï¼‰ãŒã€ãƒ‡ãƒ¼ã‚¿ç®¡ç†è€…ï¼ˆDAï¼‰ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ï¼ˆDBAï¼‰ã¸ã‚¹ãƒ†ãƒƒãƒ—ã‚¢ãƒƒãƒ—ã™ã‚‹ãŸã‚ã®ç¬¬ä¸€æ©ã¨ã—ã¦æœ‰åŠ¹ãªåŸºç¤ŽçŸ¥è˜ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ï¼ˆç·¨é›†å±€ï¼‰
Tomosugi 2018/04/27
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB
ãƒªãƒ³ã‚¯
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼ŸÂ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã‚ˆãæ¯”è¼ƒã•ã‚Œã‚‹PostgreSQLã¨MySQLã€‚ã©ã‚“ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ï¼ŸÂ ãã‚Œãžã‚Œã®å°‚é–€å®¶ã«ã‚ˆã‚‹å¯¾è«‡ã§æ˜Žã‚‰ã‹ã«ã—ã¾ã™ã€‚ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒã„ã¦ã„ã‚‹ã¨å¿…ãšç›´é¢ã™ã‚‹æ‚©ã¿ã€‚ãã‚Œã¯ã€ã€Œã©ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€RDBï¼‰ã‚’é¸ã¶ã®ãŒæœ€å–„ãªã®ã‹ï¼Ÿã€ã§ã™ã€‚ RDBã”ã¨ã«é•·æ‰€ã¨çŸæ‰€ã¯ç•°ãªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚è‡ªç¤¾ã‚µãƒ¼ãƒ“ã‚¹ã«ãƒžãƒƒãƒã—ãªã„RDBã‚’é¸ã‚“ã§ã—ã¾ã†ã¨ã€ãã‚ŒãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šé–‹ç™ºãƒ»é‹ç”¨ã«ãƒˆãƒ©ãƒ–ãƒ«ãŒç”Ÿã˜ã‚‹ã‚±ãƒ¼ã‚¹ã¯å°‘ãªãã‚ã‚Šã¾ã›ã‚“ã€‚ ãªã‹ã§ã‚‚ã‚ˆãæ¯”è¼ƒæ¤œè¨Žã•ã‚Œã‚‹ã®ãŒã€PostgreSQLã¨MySQLã€‚ã¨ã‚‚ã«ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹RDBã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã‚ã‚Šã€é«˜ã„æ€§èƒ½ã¨æ•°å¤šãã®æ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ã§ã¯ã€ä¸¡è€…ã¯å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ã
Tomosugi 2018/04/17
PostgreSQL

DB
ãƒªãƒ³ã‚¯
ã‚·ã‚¹ãƒ†ãƒ ã®å¯¿å‘½ã¯ã‚³ãƒ¼ãƒ‰ã§æ±ºã¾ã‚‹ï¼ï¼ˆ1/3ï¼‰ â€• ï¼ IT
ã‚³ãƒ¼ãƒ‰ã¯ã‚·ã‚¹ãƒ†ãƒ ã®å¯¿å‘½ã«å¤§ããªå½±éŸ¿ã‚’ä¸Žãˆã¾ã™ã€‚ä»Šå›žã¯ã€ã‚³ãƒ¼ãƒ‰ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®é–¢ä¿‚ã‚’é€šã—ã¦ã“ã®ã“ã¨ã‚’è§£èª¬ã—ã¾ã™ã€‚ã“ã“ã§ã„ã†ã‚³ãƒ¼ãƒ‰ã¨ã¯ã€é¡§å®¢IDã€å—æ³¨ä¼ç¥¨ç•ªå·ãªã©ã€æ¥å‹™ä¸Šåˆ©ç”¨ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’è˜åˆ¥ãƒ»åˆ†é¡žã™ã‚‹ãŸã‚ã€å„ãƒ‡ãƒ¼ã‚¿ã®æœ¬æ¥ã®åå‰ã¨ã¯åˆ¥ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚Œã‚‹è¨˜å·ã®ã“ã¨ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¯ãƒ‡ãƒ¼ã‚¿è¨è¨ˆã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®2ã¤ã®å½¹å‰²ãŒã‚ã‚Šã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¯ãƒ‡ãƒ¼ã‚¿è¨è¨ˆã®ä¸€ç’°ã¨ã—ã¦å®‰å®šã—ãŸã‚³ãƒ¼ãƒ‰ä½“ç³»ã‚’è¨è¨ˆã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚³ãƒ¼ãƒ‰ä½“ç³»ã«ä¾å˜ã—ãªã„ã‚ˆã†ã«è¨è¨ˆã™ã‚‹ã“ã¨ãŒæ±‚ã‚ã‚‰ã‚Œã¾ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ ã‚’é•·ãä½¿ã„ç¶šã‘ã‚‹ãŸã‚ã«ã¯ã€ ã‚³ãƒ¼ãƒ‰ä½“ç³»ã‚’é•·æœŸã«ã‚ãŸã‚Šå¤‰æ›´ã›ãšåˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã“ã¨ ã‚³ãƒ¼ãƒ‰ä½“ç³»ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¨ã®çµåˆåº¦ã‚’å°ã•ãã™ã‚‹ã“ã¨ ãŒé‡è¦ã§ã™ã€‚ãªãœãªã‚‰ã€ã‚³ãƒ¼ãƒ‰ã®ã‘ãŸãŒè¶³ã‚Šãªããªã£ãŸã‚Šã€ã‚³ãƒ¼ãƒ‰ã®åˆ†é¡žãŒæ¥å‹™ã«ããã‚ãªããªã£ãŸã‚Šã—ã¦ã€ã‚³ãƒ¼ãƒ‰ä½“ç³»ã®è¦‹ç›´ã—ã‚’è¡Œã†ã“ã¨ã«ãªã‚‹ã¨ã€æ¥å‹™ãƒ»
Tomosugi 2018/04/07
ã‚³ãƒ¼ãƒ‰

è¨è¨ˆ

ã‚·ã‚¹ãƒ†ãƒ

ã‚³ãƒ¼ãƒ‰è¨è¨ˆ

DB
ãƒªãƒ³ã‚¯
1æ—¥ã«100ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰å¢—ãˆã‚‹å ´åˆã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ
MySQLï¼ˆãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ï¼‰ã¯ã€TCX DataKonsultABç¤¾ãªã©ãŒé–‹ç™ºã™ã‚‹RDBMSï¼ˆãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ )ã§ã™ã€‚ä¸–ç•Œã§æœ€ã‚‚äººæ°—ã®é«˜ã„ã‚·ã‚¹ãƒ†ãƒ ã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã¯ã€é«˜é€Ÿæ€§ã¨ä¿¡é ¼æ€§ãŒã‚ã‚Šã€Linuxã€UNIXã€Windowsãªã©ã®è¤‡æ•°ã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ PHPã¯ã€Webã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ç‰¹åŒ–ã—ã¦é–‹ç™ºã•ã‚ŒãŸãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚å¤§ããªç‰¹å¾´ã®ã²ã¨ã¤ã¯ã€HTMLã«ç›´æŽ¥ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’åŸ‹ã‚è¾¼ã‚€ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ç‚¹ã§ã™ã€‚PHPã‚’ç”¨ã„ã‚‹ã“ã¨ã§ã€HTMLã‚’å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¨ã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚HTMLãŒãã®ã¾ã¾ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ã®ã«å¯¾ã—ã€PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã‚µãƒ¼ãƒå´ã§å®Ÿè¡Œã•ã‚ŒãŸçµæžœãŒãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã•ã‚Œã‚‹ãŸã‚ã€PHPã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ã€Œã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆã€ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚
Tomosugi 2018/03/30
SQL

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