éžåŒæœŸå‡¦ç†ã«ãŠã„ã¦ãƒ‡ãƒ¼ã‚¿ã®æ•´åˆæ€§ã‚’ä¿ã¤ã‚¢ãƒ¼ã‚テクãƒãƒ£ãƒ‘ターン - inSmartBank
ã“ã®è¨˜äº‹ã¯æ ªå¼ä¼šç¤¾ã‚¹ãƒžãƒ¼ãƒˆãƒãƒ³ã‚¯ Advent Calendar 2024 6日目ã®è¨˜äº‹ã§ã™ã€‚ 昨日㯠kassy ã•ã‚“ã®ã€Œæˆé•·ã™ã‚‹ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—労務ã®é†é†å‘³ã¨æŒ‘戦をUXリサーãƒãƒ£ãƒ¼ãŒèžã„ã¦ã¿ãŸï¼ã€ã¨ã„ã†è¨˜äº‹ã§ã—ãŸã€‚ ã¯ã˜ã‚㫠サーãƒãƒ¼ã‚µã‚¤ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã® mokuo ã§ã™ã€‚普段ã¯ã€ã‚«ãƒ¼ãƒ‰æ±ºæ¸ˆã‚„ã‚ã¨ã°ã‚‰ã„ãƒãƒ£ãƒ¼ã‚¸ã«é–¢é€£ã™ã‚‹æ©Ÿèƒ½ã®é–‹ç™ºã‚„é‹ç”¨ã‚’è¡Œã£ã¦ãŠã‚Šã¾ã™ã€‚ 本日ã¯ã€ã‚µãƒ¼ãƒãƒ¼ã‚µã‚¤ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®è¨˜äº‹ã«ãªã‚Šã¾ã™ã€‚ 本記事ã§ãŠè©±ã—ã™ã‚‹ã“㨠システムã«ã¯æ–続的ã«è¡Œã‚れる一連ã®å‡¦ç†ã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ä¸ã§éžåŒæœŸå‡¦ç†ã‚’è¡Œã†ã“ã¨ã‚‚ã‚ã‚‹ã§ã—ょã†ã€‚ 例) EC サイトã«ãŠã‘る注文処ç†ã®ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã‚’開発・é‹ç”¨ã—ã¦ã„ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚ˆã†ãªèª²é¡Œã«ç›´é¢ã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ 処ç†ã®æµã‚ŒãŒæŠŠæ¡ã—辛ㄠ変更を行ã†ã®ãŒå›°é›£ データã®æ•´åˆæ€§ã‚’æ‹…ä¿ã™ã‚‹ã®ãŒé›£ã—ã„ ã—ã‹ã—ã€é©åˆ‡ã«è¨è¨ˆã‚’è¡Œã†ã“ã¨ã§ã€ã“れらã®èª²
Production query plans without production data
In the previous article we covered how the PostgreSQL planner reads pg_class and pg_statistic to estimate row counts, choose join strategies, and decide whether an index scan is worth it. The message was clear: when statistics are wrong, everything else goes with it. Streaming replication provides bit-to-bit replication, so all replicas share the same statistics with primary server. But there was
RLSを実戦投入ã™ã‚‹ãŸã‚ã®è¨è¨ˆåˆ¤æ–
全体åƒ: リクエストã‹ã‚‰ RLS ãƒãƒªã‚·ãƒ¼è©•ä¾¡ã¾ã§ Acsim ã§ã¯ã€1ã¤ã® HTTP リクエスト㌠RLS ã§ä¿è·ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¾ã§ã«ã€æ¬¡ã®æµã‚Œã‚’辿りã¾ã™ã€‚ �7 �� テナントコンテã‚スト（所属テナントやãƒãƒ¼ãƒ«ãªã©ã®æƒ…å ±ï¼‰ã¯ã€ŒMiddleware → Hono Context → UseCase → PostgreSQLã€ã®é †ã«æµã‚Œã¾ã™ã€‚Middleware ãŒãƒ†ãƒŠãƒ³ãƒˆã‚³ãƒ³ãƒ†ã‚ストをå–得・検証ã—㦠Hono Context ã«æ ¼ç´ã—ã€UseCase ãŒãれをå–り出ã—㦠PostgreSQL ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³å¤‰æ•°ã«æ³¨å…¥ã—ã€RLS ãƒãƒªã‚·ãƒ¼ãŒè©•ä¾¡ã—ã¾ã™ã€‚ ã“ã“ã‹ã‚‰ã¯ã€ã“ã®æ§‹æˆã«è‡³ã‚‹éŽç¨‹ã§ç›´é¢ã—ãŸè¨è¨ˆåˆ¤æ–ã‚’3ã¤æŽ˜ã‚Šä¸‹ã’ã¾ã™ã€‚ è¨è¨ˆåˆ¤æ– 1: テナントコンテã‚ストをã©ã†å–å¾—ã™ã‚‹ã‹ RLS ã«ãƒ†ãƒŠãƒ³ãƒˆã‚³ãƒ³ãƒ†ã‚ストを渡ã™ã«ã¯ã€ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‹ã‚‰ãƒ†ãƒŠãƒ³ãƒˆã‚³ãƒ³ãƒ†ã‚ストをå–å¾—ã—ã¦
LINE Messengerã®æ¬¡ä¸–代ストレージé¸å®š
2026å¹´2月24æ—¥ã«é–‹å‚¬ã•ã‚ŒãŸã€ŒYugabyteDB Japan Meetup #7ã€ã§ã®ç™ºè¡¨è³‡æ–™ã§ã™ã€‚
DB ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’ä¼´ã†å˜ä½“テストã®è€ƒãˆæ–¹ã¨ Go ã«ã‚ˆã‚‹å®Ÿè·µ - Cybozu Inside Out | サイボウズエンジニアã®ãƒ–ãƒã‚°
ã“ã®è¨˜äº‹ã¯ã€CYBOZU SUMMER BLOG FES '25ã®è¨˜äº‹ã§ã™ã€‚ クラウド基盤本部ã®æ–°äº•ã§ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€DB ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’伴ㆠGo ã®å˜ä½“テストã«ã¤ã„ã¦ã®ç§ãŸã¡ã®è€ƒãˆæ–¹ã€ãã—ã¦ãれを実践ã™ã‚‹ãŸã‚ã«é–‹ç™ºãƒ»å…¬é–‹ã—ãŸãƒ©ã‚¤ãƒ–ラリをã”紹介ã—ã¾ã™ã€‚ DB ã®ãƒ¢ãƒƒã‚¯ã¨ãã®å•é¡Œç‚¹ DB ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’伴ㆠGo ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ã©ã®ã‚ˆã†ã«å˜ä½“テストã—ãŸã„ã¨ãã€æœ€åˆã«æ€ã„ã¤ãã®ã¯ go-sqlmock ãªã©ã®ãƒ„ールを使ã£ã¦ DB をモックã™ã‚‹æ–¹æ³•ã§ã™ã€‚ サンプルコードã§ã¯ã€æ¬¡ã®ã‚ˆã†ãªãƒ†ã‚¹ãƒˆã‚’書ã„ã¦ã„ã¾ã™ã€‚ package main import ( "fmt" "testing" "github.com/DATA-DOG/go-sqlmock" ) // a successful case func TestShouldUpdateStats(t *testing.T) { db, mo
SQLã«å¯¾ã™ã‚‹ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®ã‚¢ãƒ—ãƒãƒ¼ãƒæ¯”較ã€ãã—ã¦SafeQLã®ç´¹ä»‹
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚calloc134 ã§ã™ã€‚ ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰é–‹ç™ºã«ãŠã„ã¦ã€DB ã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã“ã¨ã¯ã‚ˆãã‚ã‚‹ã“ã¨ã§ã™ã€‚ DB ã¨æŽ¥ç¶šã—ã¦ãƒ‡ãƒ¼ã‚¿ã®ã‚„ã‚Šå–ã‚Šã‚’è¡Œã†å¿…è¦ãŒã‚ã‚Šã¾ã™ãŒã€çš†ã•ã‚“ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ã¦ã„ã¾ã™ã‹ï¼Ÿ ORM やクエリビルダを利用ã—ãŸã‚Šã€é€†ã« SQL を記述ã—ã¦ã‚³ãƒ¼ãƒ‰ç”Ÿæˆã‚’è¡Œã£ãŸã‚Šã¨ã€æ§˜ã€…ãªæ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ 今回ã¯ã“れらã®ã‚¢ãƒ—ãƒãƒ¼ãƒã«ã¤ã„ã¦æ¯”較ã—ã€æ¯”較的斬新ãªæ–¹é‡ã‚’å–ã£ã¦ã„ã‚‹ã‚‚ã®ã¨ã—㦠SafeQL を紹介ã—ã¾ã™ã€‚ 注æ„点 ã“ã“ã§ã¯ã€TypeScript ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰é–‹ç™ºã¨ã€ãã“ã§åˆ©ç”¨ã•ã‚Œã‚‹ãƒ©ã‚¤ãƒ–ラリをå‰æã¨ã—ã¦è©±ã‚’進ã‚ã¾ã™ã€‚ Go ã‚„ Python ãªã©ä»–ã®è¨€èªžã§ã®åˆ©ç”¨æ–¹æ³•ã«ã¤ã„ã¦ã¯ã€åˆ¥é€”調査ãŒå¿…è¦ã§ã™ã€‚ SQL ã«å¯¾ã™ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒ ã¾ãšã€SQL ã«å¯¾ã™ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã«ã¯å¤§ãã分ã‘㦠2 ã¤ã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ ãã‚Œãžã‚Œã®ãƒ©ã‚¤ãƒ–ラリã®ä½¿ã„方をã€ç°¡å˜ã«è¦‹ã¦ã„ãã¾
Convex | The backend platform that keeps your app in sync
ComponentsIndependent, modular, TypeScript building blocks for your backend.
様々ãªãƒ†ãƒ¼ãƒ–ルã®ãƒ‡ãƒ¼ã‚¿é€£æºæ‰‹æ³•ï½œzono
※ç§ã®å€‹äººçš„æ„見ã¨ã—ã¦ã€CDCã®æ–¹ãŒæ§‹ç¯‰ãƒ»é‹ç”¨è¦³ç‚¹ã§æ¯”較的é¸æŠžã—易ã„ãŸã‚ã€ä»¥é™ã¯CDCをメインã«ç´¹ä»‹ã—ã¾ã™ã€‚ 例ãˆã°ã€TROCCOãªã©ã®ã‚µãƒ¼ãƒ“スã§ã‚‚CDCãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ 1. å±¥æ´ãƒ†ãƒ¼ãƒ–ルã®é€£æºå±¥æ´ãƒ†ãƒ¼ãƒ–ルã¯ã€ŒéŽåŽ»ã‹ã‚‰ç¾åœ¨ã¾ã§ã®ã™ã¹ã¦ã®çŠ¶æ…‹ã‚’ä¿æŒã™ã‚‹ã€ã¨ã„ã†ç‰¹æ€§ãŒã‚ã‚‹ãŸã‚ã€ãã®ã¾ã¾é€£æºã™ã‚Œã°å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã¯é€£æºã•ã‚Œã¾ã™ã€‚レコードã¯åŽŸå‰‡ã¨ã—ã¦è¿½è¨˜ã®ã¿ã§ã‚り更新や削除ãŒç™ºç”Ÿã—ã¾ã›ã‚“。DWH連æºã«é–¢ã—ã¦ã¯æ¯”較的実装ãŒç°¡å˜ã ã¨æ€ã„ã¾ã™ã€‚ 全件連æºï¼ˆãƒ•ãƒ«ãƒãƒ¼ãƒ‰ï¼‰ãƒ‡ãƒ¼ã‚¿é‡ãŒå°‘ãªãã€å†…部監査ç‰ã®ç†ç”±ã§ã€Œä¸€è¡Œã‚‚æ¬ ã‘ã¦ã¯ã„ã‘ãªã„ã€è¦ä»¶ãŒã‚ã‚‹å ´åˆã€å…¨ä»¶é€£æºã¯é©ã—ãŸé¸æŠžè‚¢ã«ãªã‚Šã¾ã™ã€‚ãŸã ã—ã€è¡Œæ•°ãŒã‚る程度（数åƒä¸‡ãªã©ï¼‰ã‚’超ãˆå§‹ã‚ã‚‹ã¨ãƒ¡ãƒ¢ãƒªè² è·ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸èª²é‡‘ãŒä¸ŠãŒã‚‹ãŸã‚ã€å·®åˆ†é€£æºã«ç§»è¡Œã™ã‚‹ãªã©ã‚’考ãˆã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ 差分連æºï¼ˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ã‚¿ãƒ«ãƒãƒ¼ãƒ‰ï¼‰ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ãŒå±¥æ´ãƒ†ãƒ¼ãƒ–ルã§ã‚ã‚‹å ´åˆã€ã€Œå‰å›žå–ã‚Šè¾¼ã¿ä»¥é™
Upstash: Serverless Data Platform
Highly Available, Infinitely Scalable99.99% uptime guaranteeAutomatic scaling to meet your demandsNo server management requiredGlobal Low LatencyLightning-fast response times worldwideMulti-region replication optionsOptimize for your users, wherever they areDurable, Persistent StorageIn-memory speed with disk-like persistenceData safety without sacrificing performanceAutomatic backups
PostgreSQLè¨è¨ˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã®ã”紹介 | フューãƒãƒ£ãƒ¼æŠ€è¡“ブãƒã‚°
ã¯ã˜ã‚ã«ãƒ•ãƒ¥ãƒ¼ãƒãƒ£ãƒ¼ç¤¾å†…ã®æœ‰å¿—メンãƒãƒ¼ã§PostgreSQL DBè¨è¨ˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã‚’作æˆã—ã¾ã—ãŸã€‚ PostgreSQLè¨è¨ˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ | Future Enterprise Arch Guidelines å½¢ã«ãªã£ã¦ã‹ã‚‰æ•°ãƒ¶æœˆå¯ã‹ã›ã¦ãŠã‚Šã€ã‚る程度社内ã®æŒ‡æ‘˜ã‚’å–り込むã“ã¨ãŒã§ããŸã®ã§ã“ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§å‘ŠçŸ¥ã—ã¾ã™ よãã‚ã‚‹DBè¨è¨ˆè¦ç´„ã¨ã®å·®åˆ¥åŒ–ãƒã‚¤ãƒ³ãƒˆå˜ã«DBè¨è¨ˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã¨ã„ã†ã¨ä½•ã‚’今更？感もã‚ã‚‹ã®ã§ã€å‘½åè¦å‰‡ã‚„åž‹æ¡ãªã©ä¸€èˆ¬çš„ãªå†…容ã«åŠ ãˆã€ä»¥ä¸‹ã®ç‚¹ã§ã‚ˆãã‚ã‚‹DBè¨è¨ˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ä¸€æ©è¸ã¿è¾¼ã‚“ã コンテンツã¨ãªã‚‹ã‚ˆã†å¿ƒãŒã‘ã¾ã—ãŸã€‚ è«–ç†è¨è¨ˆã¸ã®è¸ã¿è¾¼ã¿å˜ãªã‚‹ãƒ†ãƒ¼ãƒ–ル定義やデータ型é¸æŠžã«ã¨ã©ã¾ã‚‰ãšã€ã‚ˆã‚Šé«˜åº¦ãªè«–ç†è¨è¨ˆã®åŽŸå‰‡ã«ç„¦ç‚¹ã‚’当ã¦ã¦ã„ã¾ã™ã€‚ マスタ/トラン/ワークデータベースè¨è¨ˆã«ãŠã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ã®ç¨®é¡žã«å¿œã˜ã¦ãƒ†ãƒ¼ãƒ–ルを明確ã«åˆ†é›¢ã™ã‚‹ã“ã¨ã¯è¨è¨ˆåŠ¹çŽ‡ã¨ä¿å®ˆæ€§ã‚’高ã‚る上ã§é‡è¦ã§ã™ãŒã€æ„外ã¨ã
ORM ã¨å‘ãåˆã†
PyCon JP 2024 ※ 資料ä¸ã§çµµæ–‡å—を使用ã—ãŸã‚‰ SpeakerDeck アップãƒãƒ¼ãƒ‰æ™‚ã«ãªã‚“ã‹å¤‰ãªã“ã¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒæ°—ã«ã—ãªã„ã§ãã ã•ã„
DBマイグレーションã®å®‰å…¨æ€§ã‚’高ã‚るガードレールã®å®Ÿè·µ - LayerX エンジニアブãƒã‚°
ã“ã‚“ã«ã¡ã¯ï¼ãƒã‚¯ãƒ©ã‚¯äº‹æ¥éƒ¨ Platform Engineering 部 SRE ãƒãƒ¼ãƒ ã® id:sadayoshi_tadaã§ã™ã€‚趣味ã§ç‹ãƒˆãƒ¬ã‚’ã‚„ã£ã¦ã„ã¦ã“ã‚Œã¾ã§ã»ã¼1人ã§ã‚„ã£ã¦ã„ãŸã®ã§ã™ãŒã€æœ€è¿‘社内ã®äººé”ã¨ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã“ã¨ãŒå¢—ãˆã¦æ¥½ã—ã„今日ã“ã®ã”ã‚ã§ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯SREãƒãƒ¼ãƒ ã§è¡Œã£ã¦ã„ã‚‹ã€DBマイグレーションã«ãŠã‘るガードレールã®å–り組ã¿ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ DBマイグレーションã«ã¾ã¤ã‚る課題ã«ã¤ã„㦠SREãƒãƒ¼ãƒ ã«ã‚ˆã‚‹DBマイグレーション時ã®ãƒ¬ãƒ“ュー ALTER TABLE実行時ã«ALGORITHMを明示ã™ã‚‹CIã‚’è¿½åŠ ä»Šå¾Œã®èª²é¡Œ ã¾ã¨ã‚ 最後㫠DBマイグレーションã«ã¾ã¤ã‚る課題ã«ã¤ã„㦠本題ã«å…¥ã‚‹å‰ã«ã€ãƒã‚¯ãƒ©ã‚¯ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ã‚ーママイグレーション(以é™ã€DBマイグレーションã¨å‘¼ç§°ã—ã¾ã™)ã§èµ·ã“ã£ã¦ã„ãŸèª²é¡Œã«ã¤ã„ã¦ç°¡å˜ã«è§¦ã‚Œã¾ã™ã€‚ ãƒã‚¯ãƒ©ã‚¯ã§ã¯ãƒªãƒªãƒ¼ã‚¹ã«ãŠã„ã¦ã‚¢ãƒ—リケー
Database DevSecOps | Bytebase
Database CI/CDStandardized database schema migrations and data changes with review, linting, and GitOps. Learn more Production AccessJust-in-Time (JIT) IAM-based database permissions with approval flow and audit logging. Learn more Data MaskingRole-based multi-level masking with data classification, custom algorithm, policy-as-code. Learn more
Qdrant - Vector Search Engine
WHY QDRANT?Build for Production-Grade AI SearchEngineered for real-time retrieval with the speed, accuracy, and scale that modern AI demands. Expansive Metadata FiltersStore metadata in JSON and use advanced filters, such as nested, text, geo, has_vector, and more. Learn About Metadata Filters Native Hybrid Search (Dense + Sparse)Blend keyword and vector search in one query – use dense or sparse v
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - amalshaji/dbcooper: A database client for PostgreSQL, SQLite, Redis, and ClickHouse, built with Tauri, React, and TypeScript.
GitHub - clidey/whodb: A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB, Elastic Search, and Clickhouse with Chat interface
The AI-native database developers love | Weaviate
DBngin | All-in-One Database Version Management Tool
2025å¹´ç¾åœ¨ã®NewSQL (最強DB講義 #36 発表資料)
PuppyGraph | Query Your Relational Data As A Graph. No ETL.
{{#tags}}- {{label}}
{{/tags}}