GitHub - litdb/litdb: Lightweight RDBMS agnostic TypeScript/JS abstraction for SQLite, PostgreSQL and MySQLYou signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
OLAPデータベースã«ãŠã‘る高速化ã®æŠ€è¡“ - PLAID engineer blog
ã“ã‚“ã«ã¡ã¯ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®komukomoã§ã™ã€‚フリーランスã¨ã—ã¦ãƒ—レイドã§ãŠä»•äº‹ã•ã›ã¦ã„ãŸã ã„ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¯ç¤¾å†…勉強会をブãƒã‚°åŒ–ã—ãŸã‚‚ã®ã§ã™ã€‚ã“ã®è¨˜äº‹ã§ã¯ã€OLAPデータベースã«ãŠã„ã¦åˆ†æžã‚¯ã‚¨ãƒªã‚’高速化ã™ã‚‹ãŸã‚ã«ä½¿ã‚ã‚Œã¦ã„る技術ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½¿ç”¨è€…ãŒã©ã†ä½¿ã†ã‹ã¨ã„ã†ã‚ˆã‚Šã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è‡ªä½“ã®å†…部ã®è©±ã«ãƒ•ã‚©ãƒ¼ã‚«ã‚¹ã—ã¦ã„ã¾ã™ã€‚ -----------------------
社内勉強会「Modern Data Stack入門ã€ã®å†…容をブãƒã‚°åŒ–ã—ã¾ã—㟠- PLAID engineer blog
プレイドã®ç¤¾å†…å‘ã‘ã«è¡Œã£ãŸModern Data Stack勉強会ã®å†…容ãŒå¥½è©•ã ã£ãŸã®ã§ã€ãƒ‡ãƒ¼ã‚¿åŸºç›¤ã«æºã‚ã‚‹æ–¹ã«å‘ã‘ã¦Modern Data Stackã®æ¦‚è¦ã€ä¸»è¦ã‚µãƒ¼ãƒ“スã€é‡è¦ã ã¨æ€ã†ãƒˆãƒ¬ãƒ³ãƒ‰ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚
実践Immutable Data Model - 紙箱
ランã‚ングå‚åŠ ä¸ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€Immutable Data Modelã¨å‘¼ã°ã‚Œã‚‹è¨è¨ˆæ‰‹æ³•ã‚’ã‚‚ã¨ã«ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹ã€ãƒ†ãƒ¼ãƒ–ルè¨è¨ˆã®è©±ã‚’書ã„ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ä»Šå›žã®å®Ÿè·µã§åˆ©ç”¨ã™ã‚‹ã€åˆ¥ã®è€ƒãˆæ–¹ã®èƒŒæ™¯ã‚’ç†è§£ã™ã‚‹ãŸã‚ã«ã€Out of the tar pitã¨ã„ã†å°è«–æ–‡ã®å†…容ã«ã‚‚言åŠã—ã¾ã™ã€‚ 「状態ã¨ã¯ä½•ã‹ï¼Ÿã€ã¨ã„ã†ã‚„ã‚„ã“ã—ã„話ãŒãŸãã•ã‚“出ã¦ãã¾ã™ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ルè¨è¨ˆã«ã¤ã„ã¦ã®è©±ã§ã‚ã‚‹ã“ã¨ã‹ã‚‰ã€ãŸãã•ã‚“ã®SQLãŒå‡ºã¦ãã¾ã™ã€‚ãªã®ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã¨ã‹çŠ¶æ…‹ç®¡ç†ã¨ã‹ã€ç‰¹ã«SQLã¨ã‹ã«èˆˆå‘³ãŒãªã„人ã«ã¯é¢ç™½ããªã„ã¨æ€ã„ã¾ã™ã€‚ ãã®ã‚ãŸã‚Šã«èˆˆå‘³ã‚ã‚‹æ–¹ã¯ã€èªã‚“ã§ã¿ã¦æ¬²ã—ã„ã§ã™ã€‚ Immutable Data Modelã‚’ã€å®Ÿéš›ã®ã‚¢ãƒ—リケーションã§ä½¿ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¡ç”¨ã™ã‚‹ã«ã‚ãŸã‚Šã€ã©ã†ã„ã†è€ƒãˆæ–¹ã§ã€ã©ã®ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ルを構æˆã—ãŸã‹ã€è‡ªåˆ†ãªã‚Šã®çµŒé¨“を書ã„ã¦ã„ã¾
図解 DB インデックス
DB インデックスã®åŸºç¤ŽçŸ¥è˜ã‚’ã€å›³ã‚’ãŸãã•ã‚“使ã£ã¦æ•´ç†ã—ã¾ã™ã€‚ ã“ã® Book ã¯ã€æš—記をãŠã—ã¾ã„ã«ã—ã¦ã“ã‚“ãªç–‘å•ã‚’自力解決ã§ãるよã†ã«ãªã‚‹ã“ã¨ã‚’目指ã—ã¾ã™ã€‚ 「ã©ã‚“ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä½œã‚Œã°ã„ã„ã‚“ã ã£ã‘？〠「ãªã‚“ã§ä½œã‚Šã™ãŽã¡ã‚ƒã ã‚ãªã‚“ã ã£ã‘？〠「ã“ã®å ´åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã£ã¦åŠ¹ãã£ã‘？〠「インデックスã§ã©ã‚Œãらã„速ããªã‚‹ã®ï¼Ÿã€ ã“ã®æœ¬ã¯ç†è€…ã®ç†è§£ã«é€£å‹•ã—ã¦è¿½è¨˜ä¿®æ£ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚
メダリオンアーã‚テクãƒãƒ£
メダリオンアーã‚テクãƒãƒ£ã¨ã¯ãƒ¡ãƒ€ãƒªã‚ªãƒ³ã‚¢ãƒ¼ã‚テクãƒãƒ£ã¨ã¯ã€ãƒ¬ã‚¤ã‚¯ãƒã‚¦ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’è«–ç†çš„ã«æ•´ç†ã™ã‚‹ãŸã‚ã«ç”¨ã„られるデータè¨è¨ˆã‚’æ„味ã—ã¾ã™ã€‚データãŒã‚¢ãƒ¼ã‚テクãƒãƒ£ã® 3 ã¤ã®ãƒ¬ã‚¤ãƒ¤ãƒ¼ï¼ˆãƒ–ãƒãƒ³ã‚º → シルãƒãƒ¼ → ゴールドã®ãƒ†ãƒ¼ãƒ–ル）をæµã‚Œã‚‹éš›ã«ã€ãƒ‡ãƒ¼ã‚¿ã®æ§‹é€ ã¨å“質を増分的ã‹ã¤æ¼¸æ¬¡çš„ã«å‘上ã•ã›ã‚‹ã“ã¨ã‚’目的ã¨ã—ã¦ã„ã¾ã™ã€‚メダリオンアーã‚テクãƒãƒ£ã¯ã€ã€Œãƒžãƒ«ãƒãƒ›ãƒƒãƒ—ã€ã‚¢ãƒ¼ã‚テクãƒãƒ£ã¨ã‚‚呼ã°ã‚Œã¾ã™ã€‚ レイクãƒã‚¦ã‚¹ã‚¢ãƒ¼ã‚テクãƒãƒ£ã®ãƒ¡ãƒªãƒƒãƒˆã‚·ãƒ³ãƒ—ルãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚ã‹ã‚Šã‚„ã™ãã€å°Žå…¥ãŒå®¹æ˜“増分 ETL ãŒå¯èƒ½æœªåŠ 工データã‹ã‚‰ã®ãƒ†ãƒ¼ãƒ–ルå†ä½œæˆãŒã„ã¤ã§ã‚‚å¯èƒ½ACID トランザクションã€ã‚¿ã‚¤ãƒ トラベルレイクãƒã‚¦ã‚¹ã¨ã¯ãƒ¬ã‚¤ã‚¯ãƒã‚¦ã‚¹ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ¬ã‚¤ã‚¯ã¨ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã®å„ªã‚ŒãŸè¦ç´ ã‚’å–り入れãŸæ–°ã—ã„データプラットフォームアーã‚テクãƒãƒ£ã§ã™ã€‚モダンレイクãƒã‚¦ã‚¹ã¯ã€æ‹¡å¼µæ€§ã¨æ€§èƒ½ã«å„ªã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ—ラットフォームã§ã™ã€‚æœªåŠ å·¥ãƒ‡ãƒ¼ã‚¿ã¨
Apache Druid | Apache® Druid
Sub-second queries at any scaleExecute OLAP queries in milliseconds on high-cardinality and high-dimensional data sets with billions to trillions of rows without pre-defining or caching queries in advance. High concurrency at the lowest cost Build real-time analytics applications that supports 100s to 100,000s queries per second at consistent performance with a highly efficient architecture that u
SurrealDB | The ultimate multi-model database for tomorrow's applications
SurrealDB offers a dynamic and adaptable platform for business. With an integrated suite of cutting-edge database solutions, tools, and services, SurrealDB empowers your workforce to discover innovative answers using products meticulously crafted to meet their requirements. Database, realtime API layer, and security permissions all-in-one SurrealDB combines the database layer, the querying layer,
MySQL UUIDs - Bad For Performance
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Blitz（後編）：リアルタイムユーザー解æžã‚¨ãƒ³ã‚¸ãƒ³ã‚’実ç¾ã™ã‚‹æŠ€è¡“（強整åˆãªè§£æžï¼‰ - PLAID engineer blog
PLAIDã§ã¯Personalizationã«ç‰¹åŒ–ã—ãŸãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ユーザー解æžã‚¨ãƒ³ã‚¸ãƒ³ï¼ˆBlitz）を自分é”ã§é–‹ç™ºã—ã€KARTEã®åŸºç›¤ã¨ã—ã¦ä½¿ã£ã¦ãã¾ã—ãŸã€‚今回新ãŸã«åˆ·æ–°ã—ãŸè§£æžã‚¨ãƒ³ã‚¸ãƒ³ã®ã‚³ã‚¢è¦ç´ ã§ã‚る「強整åˆãªè§£æžã€ã‚’実ç¾ã™ã‚‹å…·ä½“çš„ãªã‚¢ãƒ¼ã‚テクãƒãƒ£ã€æŠ€è¡“é¸å®šã®å†…容を紹介ã—ã¾ã™ã€‚
ホット タブレット  | Bigtable ã®ãƒ‰ã‚ュメント  | Google Cloud
フィードãƒãƒƒã‚¯ã‚’é€ä¿¡ コレクションã§ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’æ•´ç† å¿…è¦ã«å¿œã˜ã¦ã€ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®ä¿å˜ã¨åˆ†é¡žã‚’è¡Œã„ã¾ã™ã€‚ ホット タブレット Bigtable ã«ã¯ã€ãƒ‘フォーマンスã®å•é¡Œã‚’トラブルシューティングã™ã‚‹ãŸã‚ã€ã‚¯ãƒ©ã‚¹ã‚¿å†…ã®ãƒ›ãƒƒãƒˆ タブレットを特定ã—ã¦ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã™ã‚‹æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ã€ãƒ›ãƒƒãƒˆ タブレットã®æ¦‚è¦ã€ãƒ›ãƒƒãƒˆ タブレットã®ãƒªã‚¹ãƒˆã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã€ãƒ›ãƒƒãƒˆ タブレットã®è˜åˆ¥ãŒæœ‰ç›ŠãªçŠ¶æ³ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã“ã®ãƒšãƒ¼ã‚¸ã‚’èªã‚€å‰ã«ã€Bigtable ã®æ¦‚è¦ã‚’ç†è§£ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ホット タブレットã®ãƒªã‚¹ãƒˆã‚’å–å¾—ã™ã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã®åå‰ã¯ã€ä½¿ç”¨ã™ã‚‹è¨€èªžã«ã‚ˆã£ã¦ç•°ãªã‚Šã¾ã™ã€‚ã‚ã‹ã‚Šã‚„ã™ãã™ã‚‹ãŸã‚ã€ã“ã®ãƒ‰ã‚ュメントã§ã¯ RPC Cloud Bigtable Admin API å（ListHotTablets）を使用ã—ã¾ã™ã€‚ホット タブレットã®ãƒªã‚¹ãƒˆã¯ã€ä»¥ä¸‹ã®ã‚‚ã®ã‚’使用ã—ã¦å–å¾—ã§ãã¾ã™ã€‚ Goo
GitHub - instant-dev/instant: JavaScript API framework with ORM, migrations and vectors
instant.dev provides a fast, reliable and battle-tested ORM and migration management system for Postgres 13+ built in JavaScript. For those familiar with Ruby on Rails, instant.dev adds functionality similar to ActiveRecord to the Node.js, Deno and Bun ecosystems. We have been using it since 2016 in production at Autocode where it has managed over 1 billion records in a 4TB AWS Aurora Postgres ins
LINE LIVE クãƒãƒ¼ã‚¸ãƒ³ã‚°é€£è¼‰ Vol.2 - DBã®Replication Delayã¨ã®å¥®é—˜
LINEæ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10月1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ブãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚ LINEヤフー Tech Blog ã“ã‚“ã«ã¡ã¯ã€é–‹ç™º5センター㮠Zhu ã§ã™ã€‚ ç¾åœ¨ã¯Â LINE NEWS 㮠SRE ãƒãƒ¼ãƒ ã«æ‰€å±žã—ã¦ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã€2023å¹´3月末ã«ã‚µãƒ¼ãƒ“スæ供を終了ã—ãŸãƒ©ã‚¤ãƒ–é…信サービス「LINE LIVEã€ã«ãŠã„ã¦ã€ä»Šã¾ã§è¡Œã£ã¦ããŸæ–½ç–ã®ç´¹ä»‹ã‚„大è¦æ¨¡ã‚µãƒ¼ãƒ“スãªã‚‰ã§ã¯ã®ã‚¯ãƒãƒ¼ã‚¸ãƒ³ã‚°ã«é–¢ã‚る話を連載ã™ã‚‹ã‚·ãƒªãƒ¼ã‚ºã®2本目ã®è¨˜äº‹ã§ã™ã€‚ 今回ã®è¨˜äº‹ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã§Â Replication Delay ã«ã‚ˆã£ã¦èµ·ãã¦ã„ãŸå•é¡Œã¨è§£æ±ºã¾ã§ã®çµŒç·¯ã‚„DB構æˆã«ã¤ã„ã¦ã€å›³ã‚’交ãˆã¦ç´¹ä»‹ã—ã¾ã™ã€‚ 背景 LINE LIVE ã§ã¯ã€å¤§è¦æ¨¡ã®ã‚¢ã‚¯ã‚»ã‚¹ã«è€ãˆã‚‹ãŸã‚ã« DB(MySQL) ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯ Read/Write ã§åˆ†é›¢ã—ã¦ã„ã¾ã™ã€‚ã¤ã¾ã‚Šæ›¸ãè¾¼ã¿
Deno KV internals: building a database for the modern web
Deno is designed to streamline web and cloud development with built-in modern tools, direct access to web platform APIs, and the capability to import modules via npm. Web apps very often require some persistent application state. Setting up a database involves numerous configuration steps and the subsequent integration of an ORM or other systems. What if you could access such a database without an
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Atlas: Like Terraform, but for Databases | Atlas | Manage your database schema as code
クラウドサービスセã‚ュリティãƒã‚§ãƒƒã‚¯DB | マãƒãƒ¼ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ Admina
Astro DB
DuckDB: Up and Running
DB Pilot - DuckDB GUI Client
Modern Data Stack - Everything that you need to know ! | Modern Data Stack
{{#tags}}- {{label}}
{{/tags}}