[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] grattã®ãƒ

gratt id:gratt

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹grattã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ãƒ¦ãƒ‹ãƒ¼ã‚¯ã‚ãƒ¼ã«UUIDã‚’ä½¿ã†ãƒ¡ãƒªãƒƒãƒˆã¯ä½•ã§ã™ã‹ï¼Ÿé€£ç•ªã‚„ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—ã¾ãŸã¯è¤‡åˆãªã©ã§ã¯ã„ã‘ãªã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿã©ã†ã‚‚è¦–èªæ€§ãŒæ‚ªãä½¿ã„ã«ããæ„Ÿã˜ã¾ã™ã—é€£ç•ªã§ã‚‚è¡çªã—ãªã„æ°—ã‚‚ã—ã¾ã™ã€‚
å›žç” (7ä»¶ä¸ã®1ä»¶ç›®) ã¾ãšã¯UUIDåŠã³ãã®å¯¾æ¡ˆã¨ã—ã¦ç”¨ã„ã‚‰ã‚Œã‚‹é€£ç•ª(è‡ªå‹•æŽ¡ç•ª)ã®ãƒ¡ãƒªãƒƒãƒˆãƒ»ãƒ‡ãƒ¡ãƒªãƒƒãƒˆã‚’æ•´ç†ã—ã¾ã™ã€‚ (ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—ã‚ãƒ¼ã‚„è¤‡åˆã‚ãƒ¼ãªã©ã‚‚ãã®åŠ¹çŽ‡æ€§ã‹ã‚‰è¨è¨ˆä¸Šæœ‰ç”¨ãªã‚·ãƒ¼ãƒ³ã¯ã‚ã‚Šã¾ã™ãŒã€æ¯”è¼ƒã‹ã‚‰é™¤å¤–ã—ã¾ã™ã€‚) * UUIDã‚’ä½¿ã†ã“ã¨ã®ãƒ¡ãƒªãƒƒãƒˆ * * ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«SQLã‚’é€ä¿¡ã™ã‚‹å‰ã‹ã‚‰ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¬ã‚¤ãƒ¤ãƒ¼ã§IDã‚’ç”Ÿæˆã§ãã‚‹ã€‚ * * ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’å®Ÿè£…ã—ã‚„ã™ã„å ´åˆãŒã‚ã‚‹ã€‚ * IDã‚’æŽ¨æ¸¬ã—ã«ãã„ã€‚ãƒªã‚½ãƒ¼ã‚¹ãŒåˆ—æŒ™å¯èƒ½ã§ã¯ãªã„ã€‚ * UUIDã‚’ä½¿ã†ã“ã¨ã®ãƒ‡ãƒ¡ãƒªãƒƒãƒˆ * * ãƒ¬ã‚³ãƒ¼ãƒ‰ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚µã‚¤ã‚ºãŒå¢—åŠ ã™ã‚‹ã€‚ * * ...
gratt 2024/05/16
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

db
ãƒªãƒ³ã‚¯
MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒPostgreSQLã‚’è§¦ã£ã¦ã¿ãŸãƒ¡ãƒ¢ - tmtms ã®ãƒ¡ãƒ¢
æœ€è¿‘ãªãœã‹ MySQL ã‚’ä½¿ã† Ruby ã‚¢ãƒ—ãƒªã‚’ PostgreSQL ã«å¯¾å¿œã™ã‚‹ç¾½ç›®ã«ãªã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ä»Šã¾ã§ã»ã¨ã‚“ã© MySQL ä»¥å¤–ã® RDBMS ã‚’è§¦ã£ã¦ãªã‹ã£ãŸã®ã§ã€è‰²ã€…ãƒãƒžã£ãŸã‚Šã—ãŸã®ã§ãƒ¡ãƒ¢ã£ã¨ãã¾ã™ã€‚ ãªãŠ PostgreSQL æ´ãŒæµ…ã„ã®ã§é–“é•ã£ã¦ã‚‹ã“ã¨æ›¸ã„ã¦ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ API ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ MySQL ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã«ã¯ Ruby/MySQL ã‚’ä½¿ã£ã¦ã„ãŸã®ã§ã™ãŒã€PostgreSQL ç”¨ã® API ã‚’æ–°ãŸã«è¦šãˆã‚‹ã®ã¯é¢å€’ã ã£ãŸã®ã§ã€Sequel ã‚’ä½¿ã£ã¦æ›¸ãç›´ã—ã¾ã—ãŸã€‚ mysql.query("select col1, col2 from table where col3='xxx'") â†“ db[:table].where(col3: 'xxx').select(:col1, :col2) â€¦ã¿ãŸã„ãªæ„Ÿã˜ã§ã™ã€‚ ä»Šã¾ã§ãƒ—ãƒã‚°ãƒ©ãƒ ä¸ã«çªç„¶ SQL ãŒç¾ã‚Œ
gratt 2014/10/26
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

postgresql
ãƒªãƒ³ã‚¯
Entity-Attribute-Value: SQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - ãƒšãƒ³ã‚®ãƒ³ãƒ©ãƒœ Wiki
Bill Karwin â€œSQL Antipatterns: Avoiding the Pitfalls of Database Programmingâ€ ã®èªæ›¸ãƒ¡ãƒ¢ã€‚ Jaywalking ç›®çš„ ã‚ã‚‹å±žæ€§ã«ã¤ã„ã¦ã€è¤‡æ•°ã®å€¤ã‚’æŒãŸã›ã‚‹ã€‚ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ : ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šãƒªã‚¹ãƒˆ ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§è¤‡æ•°ã®å€¤ã‚’ 1 ã¤ã®åˆ—ã«ç´ã‚ã‚‹ã€‚ ä¾‹ã§ã¯ã€ç‰¹å®šã®è£½å“ã«ã¤ã„ã¦ã®æ‹…å½“è€…ã‚’è¤‡æ•°è¨å®šã™ã‚‹ã®ã«ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§ã€æ‹…å½“è€…ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆIDã‚’è¨˜è¿°ã—ã¦ã„ã‚‹ã€‚ create table products ( product_id integer, product_name varchar(1000), acount_id varchar(100), -- comma separated list -- ... ); insert into products (product_id, product_name, accou
gratt 2014/03/09
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

DB
ãƒªãƒ³ã‚¯
AWS News Blog
AWS Week in Review â€“ March 20, 2023 This post is part of our Week in Review series. Check back each week for a quick roundup of interesting news and announcements from AWS! A new week starts, and Spring is almost here! If youâ€™re curious about AWS news from the previous seven days, I got you covered. Last Weekâ€™s Launches Here are the [â€¦] AWS Chatbot Now Integrates With Microsoft Teams I am pleased
gratt 2012/10/21
ã‚ã‚“ã¾ã‚Šawsã®æ©Ÿèƒ½ã«é ¼ã‚‹ã®ã¯ã©ã†ã‹ã®ã†

aws

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹DBã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚
ã¿ãªã•ã‚“ã¯æ™®æ®µãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ERå›³ã‚’æ›¸ãã®ã«ã©ã‚“ãªã‚½ãƒ•ãƒˆã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ä»Šå›žã¯ç„¡å„Ÿã§åˆ©ç”¨å¯èƒ½ãªãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦è‰²ã€…ã¨èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚
gratt 2008/04/02
ãƒ„ãƒ¼ãƒ«

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ¢ãƒ‡ãƒªãƒ³ã‚°
ãƒªãƒ³ã‚¯
1