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

uokada id:uokada

dbã«é–¢ã™ã‚‹uokadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (51)

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

æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†æ¦‚å¿µã‚’ã‚¯ãƒ©ã‚¦ãƒ‰ã®æŠ€ã§å†æ§‹ç¯‰ã™ã‚‹ - ã‚†ã†ã†ããƒ–ãƒã‚°
ã‚µãƒ¼ãƒç›£è¦–ã‚µãƒ¼ãƒ“ã‚¹Mackerelã«ãŠã„ã¦é–‹ç™ºä¸ã®ã€é«˜è§£åƒåº¦ãƒ»é•·æœŸé–“ã®ã‚µãƒ¼ãƒãƒ¡ãƒˆãƒªãƒƒã‚¯åŽé›†ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®æ–°ã—ã„æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹Diamondã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å…·ä½“çš„ã«ã¯ã€Amazon ElastiCacheã€Amazon DynamoDBã€Amazon S3ã‚’çµ„ã¿åˆã‚ã›ã€Amazon Kinesis Streamsã¨AWS Lambdaã«ã‚ˆã‚Šã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆé–“ã‚’æŽ¥ç¶šã—ãŸã€éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®è¨è¨ˆã¨å®Ÿè£…ã‚’è§£èª¬ã—ã¾ã™ã€‚ 2018/06/05 è¿½è¨˜: ã“ã®è¨˜äº‹ã®å†…å®¹ã‚’WSAç ”#2ã§ã‚ˆã‚Šä¸€èˆ¬çš„ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãƒ¬ãƒ™ãƒ«ã§ã®è²¢çŒ®ã¨ã—ã¦æ›¸ãç›´ã—ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒãƒ¬ã‚¹æ™‚ä»£ã«ãŠã‘ã‚‹ãƒ˜ãƒ†ãƒã‚¸ãƒ‹ã‚¢ã‚¹æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ - ã‚†ã†ã†ããƒ–ãƒã‚° ã¯ã˜ã‚ã« å…ˆæ—¥é–‹å‚¬ã•ã‚ŒãŸAWS Summit Tokyo 2017ã«ã¦ã€ã€Œæ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†æ¦‚å¿µã‚’ã‚¯ãƒ©ã‚¦ãƒ‰ã®æŠ€ã§å†æ§‹ç¯‰ã™ã‚‹ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ç™»å£‡
uokada 2024/12/08
db

Redis
ãƒªãƒ³ã‚¯
DuckDB as the New jq
Recently, Iâ€™ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats. I work extensively with JSON day to day, and I often reach for jq when exploring document
uokada 2024/11/22
duckdb

jq

sql

db
ãƒªãƒ³ã‚¯
DuckDBã§ãŠæ‰‹è»½ï¼ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚§ãƒ‡ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ - Techtouch Developers Blog
tl;dr ã¯ã˜ã‚ã« DuckDB ã¨ã¯ DuckDB ã§ã¯ä½•ãŒèªã‚ã‚‹ã®ã‹ ä½¿ã£ã¦ã¿ã‚‹ S3 ä¸Šã®JSON ã‚’èªã‚“ã§ã¿ã‚‹ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ä»–ãƒ„ãƒ¼ãƒ«ã§ã¯ãªã DuckDB ã‚’ä½¿ã†ãƒ¡ãƒªãƒƒãƒˆ ã—ãã˜ã‚Šãƒã‚¤ãƒ³ãƒˆ ï¼ˆç‰¹ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã°ã‹ã‚Šã®ï¼‰ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã¯æ°—ã‚’ã¤ã‘ã‚‹ S3 ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæ•°ãŒå¤šã„å ´åˆä¸éƒ½åˆãŒã‚ã‚ŠãŒã¡ ã‚¹ãƒ¬ãƒƒãƒ‰ã®èª¿æ•´ãŒå¿…è¦ãªå ´åˆã‚‚ Redshift ã«ã¯æœªå¯¾å¿œ çµ‚ã‚ã‚Šã« ä»˜éŒ² MySQL ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚€ä¾‹ã® MySQL å´ã®æº–å‚™ tl;dr DuckDB ä¾¿åˆ©ã ã‚ˆã€‚åˆ†æžä»¥å¤–ã§ã‚‚ä½¿ãˆã‚‹ã‚ˆ è‰²ã€…ãªå ´æ‰€ã®ãƒ‡ãƒ¼ã‚¿ã‚’é–²è¦§ãƒ»çµåˆã§ãã‚‹ã‚ˆã€‚æ¨™æº–SQLã‚‚ä½¿ãˆã‚‹ã‚ˆ ãŸã ã—ã€ç´°ã‹ã„è½ã¨ã—ç©´ã¯è‰²ã€…ã‚ã‚‹ã®ã§æ°—ã‚’ã¤ã‘ã¦ã ã¯ã˜ã‚ã«2023å¹´4æœˆã«ãƒ‡ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦å…¥ç¤¾ã—ãŸminï¼ˆ@not_rogueï¼‰ã§ã™ã€‚æš–ã‹ããªã‚‹ã«ã¤ã‚Œã€YouTube ã§è¦‹ãŸå—ä¼Šè±†ãƒãƒ³ã‚°ãƒˆãƒ¬ã‚¤ãƒ« | æ¾å´Žç”ºã«è¡Œãæ©Ÿé‹ãŒ
uokada 2024/05/20
ã‚ã¨ã§èªã‚€

duckdb

sql

db
ãƒªãƒ³ã‚¯
Jdbi 3 Developer Guide
Jdbi provides convenient, idiomatic, access to relational data in Java. Jdbi 3 is the third major release, which introduces enhanced support for modern Java, countless refinements to the design and implementation, and enhanced support for modular development through plugins and extensions. Jdbi is built on top of JDBC. If your data source has a JDBC driver, you can use it with Jdbi. It improves JD
uokada 2024/03/12
java

database

db
ãƒªãƒ³ã‚¯
å±¥æ´ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦ - ä¸€ä¼‘.com Developers Blog
ã“ã®è¨˜äº‹ã¯ä¸€ä¼‘.com ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®25æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ãƒ¬ã‚¹ãƒˆãƒ©ãƒ³äº‹æ¥éƒ¨ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®id:ninjinkunã§ã™ã€‚ ä¸€ä¼‘.comåŠã³ä¸€ä¼‘.comãƒ¬ã‚¹ãƒˆãƒ©ãƒ³ã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼å‘ã‘ã®ã‚·ã‚¹ãƒ†ãƒ ã ã‘ã§ã¯ãªãã€åº—èˆ—ã‚„ä¸€ä¼‘å†…ã®ç®¡ç†è€…å‘ã‘ã®æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã¨ã„ã†æ€§æ ¼ã‚‚æŒã£ã¦ã„ã¾ã™ã€‚ æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ çµŒé¨“ã®ç„¡ã‹ã£ãŸè‡ªåˆ†ãŒä¸€ä¼‘ã«è»¢è·ã—ã¦æœ€åˆã«é©šã„ãŸã®ãŒã€DBã«å±¥æ´ã‚’ä¿æŒã™ã‚‹ãŸã‚ã®å±¥æ´ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå¤§é‡ã«ã‚ã‚‹ã“ã¨ã§ã—ãŸã€‚ ãã“ã‹ã‚‰å±¥æ´ãƒ†ãƒ¼ãƒ–ãƒ«ã®å˜åœ¨ã«èˆˆå‘³ã¨ç–‘å•ã‚’æŒã¡ã€ç¤¾å†…å¤–ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨å±¥æ´ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ã„ã¦è°è«–ã—ã¦ãã¾ã—ãŸã€‚ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ãã‚Œã‚‰ã®è°è«–ã‚’ã¾ã¨ã‚ãŸçµæžœã«ã¤ã„ã¦æ›¸ã„ã¦ã„ãã¾ã™ã€‚ å±¥æ´ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ ã¾ãšä»¥ä¸‹ã®å›³ã‚’ã”è¦§ãã ã•ã„ã€‚ è¾¼ã¿å…¥ã£ãŸå›³ã‹ã¤äº‹ä¾‹ãŒä¸€ä¼‘ç‰¹åŒ–ã§æç¸®ã§ã™ãŒã€å·¦ä¸Šã®èµ·ç‚¹ã‹ã‚‰å§‹ã¾ã£ã¦ã€å³ã®ã‚ªãƒ¬ãƒ³ã‚¸ã®éƒ¨åˆ†ãŒæœ€çµ‚çš„ãªå®Ÿè£…ãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã™ã€‚ å›³ã«ã‚ã‚‹ã¨ãŠã‚Šã€ãŸã„ã¦ã„ã®ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ã§ã¯ä»¥ä¸‹ã®3ãƒ‘ã‚¿ãƒ¼ãƒ³ã®
uokada 2024/03/09
db

database
ãƒªãƒ³ã‚¯
å¤‰æ›´å±¥æ´ã‚’æŒã¤ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¨è¨ˆ - Qiita
ã‚ã‚‹æ—¥ã®ã§ãã”ã¨ å°‘ã—å‰ã€ã€Œãƒ–ãƒã‚°ã®è¨˜äº‹ã®ã‚ˆã†ãªã‚‚ã®ã‚’ã€å±¥æ´ã‚’æ®‹ã—ã¤ã¤ç·¨é›†ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã«ã¯ã©ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆãŒè‰¯ã„ã‹ï¼Ÿã€ã¨å°‹ãã‚‰ã‚ŒãŸã“ã¨ãŒã‚ã‚Šã¾ã—ãŸ. ãã®æ™‚, ã¾ãšæ€ã„ã¤ã„ãŸï¼ˆã¨ã„ã†ã‹è¦‹èžãã—ãŸã“ã¨ãŒã‚ã‚‹æ–¹æ³•ï¼‰ã®ã¯ä»¥ä¸‹ã®æ§˜ãª2é€šã‚Šã®æ–¹æ³•ã ã£ãŸ. è¨˜äº‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’æŒãŸã›ã‚‹æ–¹æ³• è¨˜äº‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã¯åˆ¥ã«, ã ã„ãŸã„åŒã˜æ§‹é€ ã®å±¥æ´ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æŒã¤æ–¹æ³• ã“ã‚‰ã‚Œã®æ‰‹æ³•ã®ãƒ¡ãƒªãƒƒãƒˆãƒ»ãƒ‡ãƒ¡ãƒªãƒƒãƒˆã«ã¤ã„ã¦, ã™ã“ã—è€ƒãˆã¦ã„ããŸã„ã¨æ€ã„ã¾ã™. ãã®1 è¨˜äº‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’æŒãŸã›ã‚‹æ–¹æ³• æ¦‚è¦ ã“ã®æ–¹æ³•ã§ã¯, è¨˜äº‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ä¸€ã¤ã ã‘ç”¨æ„ã—, æ›´æ–°ã•ã‚Œã‚‹åº¦ã«æ–°ã—ã„ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿½åŠ ã—ã¦ã„ãã¾ã™. ä¸»ã‚ãƒ¼ã¯idã¨ãªã‚‹ãŒ, ã“ã‚Œã¯ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã§, æœ¬å½“ã®ä¸»ã‚ãƒ¼ã¯ã€Œè¨˜äº‹ã‚°ãƒ«ãƒ¼ãƒ—id + verisonã€ã®è¤‡åˆä¸»ã‚ãƒ¼ã¨ãªã£ã¦ã„ã¾ã™. è¨˜äº‹ã®æœ€çµ‚æ›´æ–°æ—¥æ™‚ã¯, æœ€æ–°Versionã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã®inser
uokada 2024/03/09
ã‚ã¨ã§èªã‚€

db

database
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
åºæ–‡ ç§ã®ä»•äº‹ã¯ã€DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã™ã€‚ã¨ã„ã£ã¦ã‚‚åˆ¥ã«æœ›ã‚“ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã¸ããŸã‚ã‘ã§ã¯ãªãã€å½“åˆã€ç§ã¯ã“ã®åˆ†é‡ŽãŒé¢ç™½ãã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã€ŒWebç³»ã¯èŠ±å½¢ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯æ—¥é™°ã€ã¨ã„ã†è¨€è‘‰ã‚‚å›ã‹ã‚Œã¦ã„ã¾ã—ãŸã€‚ä»Šã§ã‚‚å›ã‹ã‚Œã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã§ã™ãŒã€ã—ã°ã‚‰ããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è§¦ã£ã¦ã„ã‚‹ã†ã¡ã«ã€ç§ã¯ã“ã®ä¸–ç•Œã«ã¨ã¦ã‚‚èˆˆå‘³æ·±ã„ãƒ†ãƒ¼ãƒžãŒå¤šãã‚ã‚‹ã“ã¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ãªãœã‚‚ã£ã¨æ—©ãæ°—ã¥ã‹ãªã‹ã£ãŸã®ã‹ã€å¾Œæ‚”ã™ã‚‹ã“ã¨ã—ãã‚Šã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã€è‡ªåˆ†ã®ä¸æ˜ŽãŒæœ€å¤§ã®åŽŸå› ã§ã™ãŒã€ã“ã®ä¸–ç•Œã«è¶³ã‚’è¸ã¿å…¥ã‚ŒãŸå½“æ™‚ã€å…ˆç”Ÿã‚‚ã€å°Žãã®æ›¸ã¨ãªã‚‹å…¥é–€æ›¸ã‚‚ãªã‹ã£ãŸã“ã¨ã‚‚äº‹å®Ÿã§ã™ã€‚ ä»Šã§ã“ããƒã‚¤ãƒ–ãƒ«ã¨ä»°ãã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã€ã‚‚æ–°å…¥ç¤¾å“¡ã«ã¯æ•·å±…ãŒé«˜ã™ãŽã¾ã—ãŸ (2015å¹´2æœˆè¿½è¨˜ï¼šãã®å¾Œã€è‡ªåˆ†ã§ç¬¬4ç‰ˆã‚’è¨³å‡ºã§ããŸã®ã ã‹ã‚‰ã€ äººç”Ÿã¯ä½•ãŒã‚ã‚‹ã‹åˆ†ã‹ã‚‰ãªã„ã‚‚ã®ã§ã™)ã€‚ ãã“ã§ã€ã§ã™ã€‚ã“ã®ã‚µã‚¤ãƒˆã®ç›®çš„ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã«è¶³ã‚’è¸ã¿
uokada 2024/02/29
ã‚ã¨ã§èªã‚€

sql

database

db
ãƒªãƒ³ã‚¯
Tkrzw: a set of implementations of DBM
In general, if you want a key-value storage with the highest performance, choosing the file hash database is recommended. If you need ordered access of records, choosing the file tree database is recommended. If you need scalability of ordered databases, choosing the file skip database is recommended. If you need extreme performance, the on-memory hash database and the on-memory tree database are
uokada 2024/02/09
database

db

dbm
ãƒªãƒ³ã‚¯
Incremental View Maintenance - Qiita
ã¯ã˜ã‚ã« ï¼œ ã«ã‚ƒãƒ¼ã‚“ã€€è¶£å‘³ã§ãƒã‚¹ã‚°ãƒ¬ã‚’ã‚„ã£ã¦ã„ã‚‹è€…ã ã¿ãªã•ã‚“ã“ã‚“ã«ã¡ã¯ã€‚NTTãƒ†ã‚¯ãƒŽã‚¯ãƒã‚¹ åŽŸç”°ã§ã™ï¼ˆã„ã¤ã‚‚ã¯nuko_yokohamaåç¾©ã§Qiitaã«æ›¸ã„ã¦ã¾ã™ã€‚æœ€è¿‘ã‚µãƒœã£ã¦ã¾ã—ãŸãŒãƒ»ãƒ»ãƒ»ï¼‰ã€‚ ã“ã‚Œã¯NTTãƒ†ã‚¯ãƒŽã‚¯ãƒã‚¹ Advent Calendar 2019ã®16æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚æ˜¨å¹´ã«å¼•ãç¶šãã€ä»Šå¹´ã‚‚NTTãƒ†ã‚¯ãƒŽã‚¯ãƒã‚¹ç¤¾å“¡ã¨ã—ã¦ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã‚’æ›¸ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ç§ã¯æ™®æ®µã¯PostgreSQLã«é–¢ã™ã‚‹æ¤œè¨¼ãƒ»èª¿æŸ»ã‚„ã€ç¤¾å†…ã§ã®PostgreSQLæ”¯æ´ã€OSSã‚¯ãƒ©ã‚¦ãƒ‰åŸºç›¤ãƒˆãƒ¼ã‚¿ãƒ«ã‚µãƒ¼ãƒ“ã‚¹ã€PGEConsæ´»å‹•ã«é–¢ã‚ã£ã¦ã¾ã™ãŒã€è¶£å‘³ã¨ã—ã¦ã‚‚PostgreSQLã¯ã¡ã‚‡ã“ã¡ã‚‡ã“ä½¿ã£ã¦ã„ã¾ã™ã€‚ ä»Šå›žã®è¨˜äº‹ã‚‚ãã†ã„ã†ã‚ã‘ã§PostgreSQLã«é–¢ã™ã‚‹ã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ å¼Šç¤¾ã®ä»–ã®ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®è¨˜äº‹ã¨æ¯”ã¹ã‚‹ã¨å°ç²’ã§åœ°å‘³ãªæ„Ÿã˜ã§ã™ãŒã€ã‚ˆã‚ã—ããŠããŒã„ã—ã¾ã™ã€‚ ã‚µãƒžãƒª PostgreSQ
uokada 2024/02/08
db

DB

postgresql
ãƒªãƒ³ã‚¯
è‡ªä½œDBMS Advent Calendar 2020 - Adventar
DBMS (ã‚„ DBMS ã£ã½ã„ã‚‚ã®)ã‚’è‡ªä½œã—ã¦ã„ã‚‹äººã€…ãŒè‡ªåˆ†ã®å®Ÿè£…ã‚’è‡ªæ…¢ã—åˆã£ãŸã‚Šè‹¦ã—ã•ã‚’å…±æœ‰ã—ãŸã‚Šã™ã‚‹ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ Disk-Oriented, In-Memory, KVS, RDBMS, OLTP, OLAP, HTAP ãªã‚“ã§ã‚‚ã‚¢ãƒªã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã ã‘ã§ã‚‚ã‚ˆã—ã€å®Ÿè¡Œã‚¨ãƒ³ã‚¸ãƒ³ã ã‘ã§ã‚‚ã‚ˆã—ã€æ—¢å˜ã® DBMS ã®ä¸Šã«ä½•ã‹ã®ã£ã‘ã¦åˆ†æ•£ DBMS ã«ã—ãŸã¨ã‹ã§ã‚‚ã‚ˆã—ã€‚
uokada 2024/02/08
database

db

adventcalendar
ãƒªãƒ³ã‚¯
DB Pilot - DuckDB GUI Client
DuckDB GUI Client DB Pilot is a database GUI client for DuckDB and various other databases. Available for Mac, with Linux and Windows support coming soon. Working with SQL has never been easier - thanks to DB Pilot's integrated AI assistant.
uokada 2024/02/04
db

mac
ãƒªãƒ³ã‚¯
Postgres ã¨ MySQL ã«ãŠã‘ã‚‹ id, created_at, updated_at ã«é–¢ã™ã‚‹ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹
èªè€…å¯¾è±¡ ã‚ã‚‹ç¨‹åº¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹çŸ¥è˜ã‚’æŒã£ã¦ã„ã‚‹ï¼ŒçµŒé¨“å¹´æ•° 1 å¹´ä»¥ä¸Šã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ ç‰¹å®šã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«ä¾å˜ã™ã‚‹éƒ¨åˆ†ã¯å«ã‚ãªã„ãŸã‚ï¼Œã™ã¹ã¦ã® SQL ä½¿ç”¨è€…ã‚’å¯¾è±¡ã¨ã™ã‚‹ ã¾ãŸï¼Œã‚¼ãƒã‹ã‚‰ã®ä¸å¯§ãªèª¬æ˜Žã¨ã„ã†ã‚ˆã‚Šã¯ï¼Œãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹æ„Ÿè¦šã§ä½¿ãˆã‚‹è¨˜äº‹ã¨ã„ã†å½¢ã«ã¾ã¨ã‚ã‚‹ã€‚ RDBMS ã®å¯¾è±¡ãƒãƒ¼ã‚¸ãƒ§ãƒ³ PostgreSQL: 9.4 ä»¥é™ MySQL: 8.0.28 ä»¥é™ id ï¼ˆãƒ‡ãƒ¼ã‚¿åž‹ã¨ INSERT æ™‚ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆåŸ‹ã‚ï¼‰ å°Žå…¥ ä¸€èˆ¬çš„ã«æŽ¡ç”¨ã•ã‚Œã‚„ã™ã„ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ç”¨ã®å€¤ã¨ã—ã¦ï¼Œä»¥ä¸‹ã‚’è€ƒãˆã‚‹ã€‚ é€£ç•ªæ•´æ•° MySQL ã§ã¯ AUTO_INCREMENTï¼Œ Postgres ã§ã¯ IDENTITY ã‚„ SERIAL ã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã® UUID v1: ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã”ã¨ã«ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªå˜èª¿å¢—åŠ å€¤ UUID v4: ãƒ©ãƒ³ãƒ€ãƒ å€¤ UUID v7ï¼ˆãƒ‰ãƒ©ãƒ•ãƒˆï¼‰: å˜èª¿å¢—åŠ ã§ã‚ã‚‹ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—ã¨ãƒ©
uokada 2023/12/26
mysql

postgresql

db

database
ãƒªãƒ³ã‚¯
Oracle Databaseå…¥é–€ - ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ç·¨
uokada 2023/12/25
database

db
ãƒªãƒ³ã‚¯
DBCopilot: Scaling Natural Language Querying to Massive Databases
uokada 2023/12/12
db

AI
ãƒªãƒ³ã‚¯
T5QL: Taming language models for SQL generation
uokada 2023/12/12
sql

db
ãƒªãƒ³ã‚¯
ArcaDB: A Container-based Disaggregated Query Engine for Heterogenous Computational Environments
uokada 2023/12/12
sql

db
ãƒªãƒ³ã‚¯
Railsã«ãŠã‘ã‚‹ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã®è³‡æ–™ã¾ã¨ã‚
SaaSã‚µãƒ¼ãƒ“ã‚¹ã‚’Railsã§é–‹ç™ºã™ã‚‹ã«ã‚ãŸã‚Šã€ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã«é–¢ã™ã‚‹æƒ…å ±åŽé›†ã‚’ã—ãŸãŸã‚æœ¬ãƒšãƒ¼ã‚¸ã«ã¾ã¨ã‚ã¨ã—ã¦è¨˜éŒ²ã„ãŸã—ã¾ã™ã€‚ DBã®ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆ DBã®ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã«ã‚ãŸã£ã¦ã¯ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ¼ã®ç¢ºä¿ã¨ä¿å®ˆæ€§ãŒæ–¹å¼ã®é¸å®šãƒã‚¤ãƒ³ãƒˆã¨ãªã‚Šã¾ã™ã€‚ ãŸã ã—ã€SaaSã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æˆåŠŸã™ã‚‹ã»ã©ä¿å®ˆã®ã‚³ã‚¹ãƒˆãŒå¢—å¤§ã™ã‚‹ãŸã‚ãƒ—ãƒ¼ãƒ«åž‹ã«ç§»è¡Œã—ã¦ã„ãã‚ˆã†ã§ã™ã€‚ ãƒ–ãƒªãƒƒã‚¸åž‹ã§ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã‚’å®Ÿç¾å¯èƒ½ãªGemã€Œapartmentã€ ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¯å…¨ãƒ†ãƒŠãƒ³ãƒˆã§å…±æœ‰ã™ã‚‹ã‚‚ã®ã®ã€ãƒ†ãƒŠãƒ³ãƒˆã”ã¨ã«ã‚¹ã‚ãƒ¼ãƒžï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ãƒ“ãƒ¥ãƒ¼ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ï¼‰ã‚’åˆ†ã‘ã‚‹æ–¹å¼ã§ã™ã€‚ ã“ã®å®Ÿè£…ã«ã¯Gemã€Œapartmentã€ã®ä½¿ç”¨ãŒæœ‰åã§ã™ã€‚ SmartHRç¤¾ã‚‚å‰µæ¥å½“åˆã¯ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ¼ã‚’é«˜ã‚ã‚‹ãŸã‚ã«apartmentã‚’åˆ©ç”¨ã—ã¦ã„ãŸã‚ˆã†ã§ã™ã€‚ ãŸã ã—ã€å¾Œè¿°ã™ã‚‹ã‚ˆã†ã«ã€ã‚µãƒ¼ãƒ“ã‚¹ã®ç‰¹æ€§ä¸Šã‚«ãƒ©ãƒ æ•°ãŒå¤šãå¥‘ç´„ç¤¾æ•°ã®ä¼¸ã³
uokada 2023/10/19
ruby

db
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ å¹»ã®ç¬¬26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 26ç« ã€Œã¨ã‚Šã‚ãˆãšå‰Šé™¤ãƒ•ãƒ©ã‚°ã€ 2015/08/31 @ GMO Yours #ronsakucasual https://atnd.org/events/68902Read less
uokada 2023/09/21
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

db
ãƒªãƒ³ã‚¯
GeoNames
The GeoNames geographical database covers all countries and contains over eleven million placenames that are available for download free of charge. [advanced search] enter a location, ex: "Paris", "Mount Everest","New York","47 9" (lat lng)
uokada 2023/07/10
database

db
ãƒªãƒ³ã‚¯
Fate/Grand Orderã«ãŠã‘ã‚‹ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œã¨è² è·è©¦é¨“.pdf
Copyright 2019 DELiGHTWORKS Inc. All Rights Reserved. Fate/Grand Orderã«ãŠã‘ã‚‹ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œã¨è² è·è©¦é¨“ 2019å¹´6æœˆ14æ—¥ ä»Šäº• å®ˆç”Ÿ Copyright 2019 DELiGHTWORKS Inc. All Rights Reserved. è³‡æ–™ã¯å…¬é–‹äºˆå®šã§ã™ æœ¬ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ä»¥ä¸‹ã®å†…å®¹ã‚’ãŠè©±ã—ã¾ã™ AWS Database Migration Serviceã‚’ä½¿ã£ãŸå¤§è¦æ¨¡ãªDBç§»è¡Œäº‹ä¾‹ï¼ˆåž‚ç›´åˆ†å‰²â†’æ°´å¹³åˆ†å‰²ï¼‰ ç§»è¡Œå¾Œã«æƒ³å®šãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’æŒã‘ã‚‹ã“ã¨ã‚’æ¤œè¨¼ã™ã‚‹ãŸã‚ã®è² è·è©¦é¨“æ‰‹æ³• å¼Šç¤¾ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒéŽåŽ»ã«2å›žã€DBç§»è¡Œã‚’ä¸»ãªãƒˆãƒ”ãƒƒã‚¯ã¨ã—ãŸè¬›æ¼”ã‚’è¡Œã£ã¦ã„ã¾ã™ ã®ã§ã“ã¡ã‚‰ã‚‚ã”å‚ç…§ãã ã•ã„ ã“ã‚Œã§æ€–ããªã„ï¼ï¼Ÿå¤§è¦æ¨¡ç’°å¢ƒã§ä½“é¨“ã™ã‚‹DBè² è·å¯¾ç–ï½žåž‚ç›´ã‹ã‚‰æ°´å¹³ã®å½¼æ–¹ã¸ï½ž /ç”² https://www.slideshare.n
uokada 2023/07/08
db

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