[B! db][data] moritataã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

moritata id:moritata

dbã¨dataã«é–¢ã™ã‚‹moritataã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

PostgreSQL and UUID as primary key
UUIDs are often used as database table primary keys. They are easy to generate, easy to share between distributed systems and guarantee uniqueness. Considering the size of UUID it is questionable if it is a right choice, but often it is not up to us to decide. This article does not focus on "if UUID is the right format for a key", but how to use UUID as a primary key with PostgreSQL efficiently. P
moritata 2024/07/07
key

data

db

database

mysql
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã«ï½œå›³è§£ DB ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹
moritata 2024/01/09
db

database

programming

data
ãƒªãƒ³ã‚¯
Data Engineering Study #20 "Introduction to Data Analytics with SQL" Book
Data Engineering Study #20ã€Œ10å¹´æˆ¦ãˆã‚‹ãƒ‡ãƒ¼ã‚¿åˆ†æžå…¥é–€ã€å›žãƒ»å‰åŠã®ç™ºè¡¨è³‡æ–™ã§ã™ã€‚
moritata 2023/07/03
data

book

db

æ›¸ç±

å‹‰å¼·
ãƒªãƒ³ã‚¯
ã‚¼ãƒã‹ã‚‰ä½œã‚‹æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³
è»½é‡ãªæ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ã‚¹ã‚¯ãƒ©ãƒƒãƒã§é–‹ç™ºã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ã€ã©ã®ã‚ˆã†ã«å®Ÿè£…ã—ãŸã®ã‹ã‚’å¿…è¦çŸ¥è˜ã®è§£èª¬ã‚’äº¤ãˆãªãŒã‚‰ã¾ã¨ã‚ã¦ã„ãã¾ã™ã€‚ å®Ÿè£…ã¯Goè¨€èªžã«ã‚ˆã‚‹ã‚‚ã®ã§ã™ãŒã€æœ¬è¨˜äº‹ã®ã»ã¨ã‚“ã©ã¯è¨€èªžéžä¾å˜ãªå†…å®¹ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ ç†è€…ã¯æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãƒ„ãƒ¼ãƒ«ã‚’ã„ãã¤ã‹é–‹ç™ºã—ã¦ã„ã¾ã™ã€‚ãã®ä¸ã®ä¸€ã¤ã§ã‚ã‚‹Aliã¯è² è·ãƒ†ã‚¹ãƒˆç”¨ã®cliãƒ„ãƒ¼ãƒ«ã§ã€ãƒ¡ãƒˆãƒªã‚¯ã‚¹ã‚’ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã§ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æç”»ã§ãã‚‹ã®ãŒç‰¹å¾´ã§ã™ã€‚ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«ãƒ¬ã‚¤ãƒ†ãƒ³ã‚·ãƒ¼ãªã©ã®è¨ˆæ¸¬çµæžœãŒéš›é™ãªãæ›¸ãè¾¼ã¾ã‚Œã¦ãã‚‹ä¸ã€åŒæ™‚ã«ä¸€å®šã®ã‚¯ã‚¨ãƒªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ±‚ã‚ã‚‰ã‚Œã¾ã™ã€‚ ã“ã‚Œã¯è¨€ã£ã¦ã—ã¾ãˆã°ã€ç°¡æ˜“ã‚¯ã‚¨ãƒªæ©Ÿèƒ½ä»˜ãã®pushåž‹ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ ã‚’å˜ä¸€ãƒ›ã‚¹ãƒˆã§å®Ÿç¾ã™ã‚‹ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ ä»¥å‰ã¾ã§ã®å®Ÿè£…ã§ã¯ãƒ’ãƒ¼ãƒ—ä¸Šã®å¯å¤‰é•·é…åˆ—ã«ãƒ‡ãƒ¼ã‚¿ãƒã‚¤ãƒ³ãƒˆã‚’è¿½åŠ ã—ã¦ã„ãã ã‘ã ã£ãŸã®ã§ã€å½“ç„¶ãªãŒã‚‰æ™‚é–“ã®çµŒéŽã¨ã¨ã‚‚ã«ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ãŒå¢—åŠ ã—ã¦ã„ãå•é¡Œã‚’æŠ±ãˆã¦
moritata 2021/07/02
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ¡ãƒ¢ãƒª

data

database

db

golang

go

é–‹ç™º
ãƒªãƒ³ã‚¯
DynamoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã«æœ€é©ï¼NoSQL Workbenchã®Data modelerã§ä»Šåº¦ã“ãDynamoDBã‚’ä½¿ã„ã“ãªã™ï¼ | DevelopersIO
ã¯ã˜ã‚ã« CXäº‹æ¥æœ¬éƒ¨ã®ä½è—¤æ™ºæ¨¹ã§ã™ã€‚ ä»Šå›žã¯AWSãŒæä¾›ã—ã¦ã„ã‚‹DynamoDBç”¨ã®ã‚¢ãƒ—ãƒªã€ŒNoSQL Workbenchã€ã®æ©Ÿèƒ½ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã™ã‚‹æµã‚Œã‚’è§£èª¬ã—ã¾ã™ã€‚ æœ€è¿‘æ¡ˆä»¶ã§ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’å†æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚ŠNoSQL Workbenchã‚’ä½¿ã£ãŸã¨ã“ã‚ã€ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚ŒãªãŒã‚‰è¨è¨ˆãŒæ£ã—ã„ã‹æ¤œè¨¼ã§ãéžå¸¸ã«ä¾¿åˆ©ã ã£ãŸã®ã§ç´¹ä»‹ã—ã¾ã™ã€‚ ä»–ã®è¨˜äº‹ã§ã‚‚ã‚¢ãƒ—ãƒªã®ç´¹ä»‹ã¯ã‚ã‚Šã¾ã™ãŒæœ¬è¨˜äº‹ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã«çµžã£ã¦è§£èª¬ã‚’è¡Œã„ã¾ã™ã€‚é¡Œæã¨ã—ã¦å¤šå¯¾å¤šã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã—ãªãŒã‚‰è¨è¨ˆã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ æœ¬è¨˜äº‹ã‚’èªã‚ã°ä»Šã¾ã§DynamoDBã®ãƒ‡ãƒ¼ã‚¿è¨è¨ˆã«æ‚©ã‚“ã§ã„ãŸæ–¹ã®æ¤œè¨Žæ™‚é–“ã‚’ã‹ãªã‚Šæ¸›ã‚‰ã™ã“ã¨ãŒã§ãã¾ã™ã€‚è‡ªåˆ†ã‚‚ã‚‚ã£ã¨æ—©ãã€ŒNoSQL Workbenchã®Data modeler ã¯ã“ã†ä½¿ã£ã¦æ¬²ã—ã„ï¼ã€ã¨ã„ã†è¨˜äº‹ãŒã‚ã‚Œã°è‰¯ã‹ã£ãŸãªã‚ã¨æ€ã£ãŸã®ã§è¨˜äº‹ã«ã—ã¾ã—ãŸã€‚ NoSQL Workbench
moritata 2020/11/06
è¨è¨ˆ

data

ãƒ‡ãƒã‚¤ã‚¹

database

aws

ã‚¤ãƒ³ãƒ•ãƒ©

db
ãƒªãƒ³ã‚¯
ä»Šæ”¹ã‚ã¦å¦ã¶ Microsoft Azure åŸºç¤ŽçŸ¥è˜
ä¸€æ©å…ˆè¡Œã Azure Computing ã‚·ãƒªãƒ¼ã‚ºï¼ˆå…¨3å›žï¼‰ ç¬¬2å›ž Azure VM ã©ã‚Œã‚’é¸ã¶ã®ï¼Ÿ Azure VM é›†ä¸è¬›åº§
moritata 2020/06/12
Azure

microsoft

ãƒ¡ãƒ¢ãƒª

db

data
ãƒªãƒ³ã‚¯
1