MotherDuck: Ducking Simple Data Warehouse based on DuckDB*New* The MotherDuck Native Integration is Live on Vercel Marketplace for Embedded Analytics and Data AppsLearn more
S3ã«ã‚ã‚‹ALBãƒã‚°ã®èª¿æŸ»ã¯AthenaよりDuckDBã®ã»ã†ãŒç°¡å˜ - road288ã®æ—¥è¨˜
AWSã®ALB(Application Load Balancer)ã®ãƒã‚°ã¯S3ã«ç½®ã‹ã‚Œã‚‹ãŒã€ã“ã®ä¸èº«ã‚’サクッã¨èª¿ã¹ãŸã„ã¨ãã€Athenaを使ã†æ–¹æ³•ãŒæ¨™æº–çš„ã§ã€ä¸‹è¨˜ã§æ¡ˆå†…ã•ã‚Œã¦ã„るよã†ã«ãƒ‘ーティション射影(Partition Projection)ã§ãƒ†ãƒ¼ãƒ–ルを作ã£ã¦Athenaã‹ã‚‰ã‚¯ã‚¨ãƒªã™ã‚‹ã€‚ パーティション射影を使用ã—㦠Athena 㧠ALB アクセスãƒã‚°ç”¨ãƒ†ãƒ¼ãƒ–ルを作æˆã™ã‚‹ - Amazon Athena ç§ã‚‚従æ¥ã¯ãã®æ–¹æ³•ã‚’使ã£ã¦ã„ãŸãŒã€Athenaã¯ãƒ–ラウザã‹ã‚‰ä½¿ã†ã¨å‹•ä½œãŒã‚‚ã£ã•ã‚Šã—ã¦ã„ã‚‹ã—ã€æ±ºã¾ã£ãŸã‚¯ã‚¨ãƒªã‚’1回ãり実行ã—ã¦çµæžœã‚’å–å¾—ã—ãŸã„ã ã‘ã®ã¨ããªã‚‰ã¾ã ã—ã‚‚ã€æŽ¢ç´¢çš„ã«ã‚¯ã‚¨ãƒªã‚’何発も実行ã—ãŸã„ã¨ãã«ã¯ä½¿ã„å‹æ‰‹ãŒæ‚ªã„。 最近他ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§DuckDBを使ã†ã‚ˆã†ã«ãªã£ã¦ã€ä½¿ã„å‹æ‰‹ã®è‰¯ã•ã«æ„Ÿå‹•ã—ã¦ã„ãŸãŒã€DuckDBã¯ALBã®ãƒã‚°ã‚’探索的ã«èª¿ã¹ãŸã„ã¨ãã«ã‚‚ã‚ã£ã¡ã‚ƒä½¿ãˆã‚‹ã¨æ€ã£ãŸ
An in-process SQL OLAP database management system
Simple DuckDB is easy to install and deploy. It has zero external dependencies and runs in-process in its host application or as a single binary. Read more Portable DuckDB runs on Linux, macOS, Windows, and all popular hardware architectures. It has idiomatic client APIs for major programming languages. Read more Feature-rich DuckDB offers a rich SQL dialect. It can read and write file formats suc
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
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}