[B! sqlite] mapk0yã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mapk0y id:mapk0y

sqliteã«é–¢ã™ã‚‹mapk0yã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (44)

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

SQLiteã‚„DuckDBã§æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ã‚’Vaporettoã‚’çµ„ã¿è¾¼ã‚“ã§å®Ÿç¾ã™ã‚‹ - A Day in the Life
å„ç¨®ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆã®å°é ã«ã‚ˆã‚Šã€ã‚µãƒ¼ãƒãƒ¬ã‚¹ã«å‹•ä½œã—ãƒãƒ¼ã‚«ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ä¿å˜ã§ãã€æ°¸ç¶šåŒ–å¯èƒ½ãªçµ„ã¿è¾¼ã¿ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®SQLiteã‚„DuckDBã¸ã®æ³¨ç›®ã‚’æ„Ÿã˜ã‚‹æ˜¨ä»Šã§ã™ãã€‚ã“ã‚Œã‚‰DBã§ã®å…¨æ–‡æ¤œç´¢(FTS)ã®æ—¥æœ¬èªžå¯¾å¿œã£ã¦ã©ã‚“ãªã‚‚ã®ãªã®ã ã‚ã†ã‹ã¨èª¿ã¹ã‚‹ã¨ã€trigram ã§ã®æ¤œç´¢ã¯ã§ãã‚‹ã‚‚ã®ã®ã€æ—¥æœ¬èªžèªžå½™ã«ç‰¹åŒ–ã—ãŸæ¤œç´¢ã¯æ¨™æº–ã§ããªã„ã‚ˆã†ã§ã—ãŸã€‚ Linderaã‚’ä½¿ã†ã‚¢ãƒ—ãƒãƒ¼ãƒã‚‚ã‚ã‚‹ã‚ˆã†ã§ã™ãŒã€ä»Šå›žã¯ Rust ã§å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹è»½é‡é«˜é€Ÿãªãƒˆãƒ¼ã‚¯ãƒŠã‚¤ã‚¶ã® Vaporetto ã‚’çµ„ã¿è¾¼ã‚“ã§å‹•ãæ‹¡å¼µæ©Ÿèƒ½ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ SQLite + Vaporetto https://github.com/hotchpotch/sqlite-vaporetto DuckDB + Vaporetto https://github.com/hotchpotch/duckdb-vaporetto Vaporetto ã¯
mapk0y 2026/04/27
sqlite
ãƒªãƒ³ã‚¯
SQLite AI - Smart Edge Databases with Cloud Sync and Intelligence
SQLite-AI A powerful, lightweight, and cross-platform AI engine built into SQLite SQLite-Sync Local-first SQLite extension for seamless, conflict-free data sync and real-time collaboration across devices
mapk0y 2025/12/27
AI

sqlite
ãƒªãƒ³ã‚¯
GitHub - QuadrupleA/sqlite-page-explorer: Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them.
You 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
mapk0y 2025/02/09
sqlite
ãƒªãƒ³ã‚¯
SQLite on EFSã¯æ›¸ãè¾¼ã¿ãƒãƒƒã‚¯ã§ãã‚‹
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚ãŒã‚Œã£ã¨ã§ã™ã€‚ å…ˆæ—¥ECSã¨RDSã‚’ã‚„ã‚ã¦ã€AWSã‚³ã‚¹ãƒˆã‚’9å‰²å‰Šæ¸›ã—ã¾ã—ãŸã¨ã„ã†è¨˜äº‹ã‚’æŠ•ç¨¿ã—ãŸã¨ã“ã‚ã€èˆˆå‘³æ·±ã„ã‚³ãƒ¡ãƒ³ãƒˆã‚’è¦‹ã¤ã‘ãŸã®ã§æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸã€‚ çµè«– EFSä¸Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¯é€šå¸¸ã®SQLiteç›¸å½“ã®ãƒãƒƒã‚¯ã‚’è¡Œã†ã“ã¨ãŒã§ãã€SQLiteã®æ›¸ãè¾¼ã¿ãŒç«¶åˆã—ã¦ãƒã‚¤ãƒŠãƒªãƒ•ã‚¡ã‚¤ãƒ«ãŒå£Šã‚Œã‚‹ã¨ã„ã£ãŸã“ã¨ã¯åŸºæœ¬çš„ã«ãªã„ã€‚ æ¤œè¨¼å†…å®¹ SQLiteã¯æ›¸ãè¾¼ã¿ãƒãƒƒã‚¯ã‚’OSã«ã‚ˆã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ãƒãƒƒã‚¯ã‚’ä½¿ç”¨ã—ã¦å®Ÿç¾ã—ã¦ã„ã‚‹ãŸã‚ã€Network File Systemä¸Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾ã—ã¦ã†ã¾ãã„ã‹ãªã„ã¨ã„ã†ã‚³ãƒ¡ãƒ³ãƒˆã‚’ç™ºè¦‹ã—ã¾ã—ãŸã€‚ ãŸã—ã‹ã«ã€SQLiteå…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã‚‚ãã®æ—¨ãŒè¨˜è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãã®ãŸã‚ã€æœ¬å½“ã«EFSä¸Šã®SQLiteã¯æ›¸ãè¾¼ã¿ãŒç«¶åˆã—ã¦å£Šã‚Œã‚‹ã®ã‹ã€æ¤œè¨¼ã—ã¦ã„ãã¾ã™ã€‚ AWS æ§‹æˆå›³ ãƒžã‚¦ãƒ³ãƒˆãƒã‚¤ãƒ³ãƒˆã«ã‚ˆã£ã¦ãƒãƒƒã‚¯ã®ã‹ã‹ã‚Šæ–¹ãŒç•°ãªã‚‹å¯èƒ½æ€§ã‚’å¦å®šã§ããªã‹ã£ãŸãŸã‚ã€å¿µã®ç‚ºã‚¢ãƒ™ã‚¤ãƒ©
mapk0y 2025/01/28
AWS

sqlite
ãƒªãƒ³ã‚¯
GitHub - narumatt/sqlitefs: sqlite as a filesystem
You 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
mapk0y 2024/07/28
sqlite

filesystem
ãƒªãƒ³ã‚¯
ãªãœSQLiteã¯ãƒã‚¤ãƒˆã‚³ãƒ¼ãƒ‰ã‚’ä½¿ã†ã®ã‹
ä»¥å‰ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è‡ªä½œã—ã‚ˆã†ã¨ã—ã¦ã€SQLiteã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’è¦‹ã¦ã¿ãŸã‚‰VMã ã£ãŸã“ã¨ã«ç–‘å•ã‚’æ„Ÿã˜ã€ãã‚Œã‚’ãƒ„ã‚¤ãƒ¼ãƒˆã—ãŸã¨ã“ã‚ä½œè€…ã‹ã‚‰ãƒªãƒ—ã‚’ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ ä½œè€…ã„ã‚ãã€æ¬¡ã®ã‚ˆã†ãªèƒŒæ™¯ãŒã‚ã£ãŸã¨ã®ã“ã¨ã§ã—ãŸã€‚ SQLiteã‚’ä½œã£ãŸå½“åˆã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã®ã“ã¨ã‚’ã‚ˆãçŸ¥ã‚‰ãªã„ãŒã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ã®ã“ã¨ã‚’ã‚ˆãçŸ¥ã£ã¦ã„ãŸ SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æ›¸ãã¨ã„ã†å•é¡Œã‚’ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©æ§‹ç¯‰ã®å•é¡Œã¨ã—ã¦æ‰±ã†ã®ã¯è‡ªç„¶ãªã“ã¨ã ã£ãŸ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã®ã‚³ã‚¢ã®éƒ¨åˆ†ã‚’VMã«ã™ã‚‹ã¨ã„ã†ç™ºæƒ³ãŒã¾ã£ãŸããªã‹ã£ãŸã®ã§ã€ã©ã‚“ãªãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã®ã‹ï¼Ÿã¨æ°—ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ ãã‚Œã‚’ä½œè€…ã«èžã„ãŸã‚‰ã€è©³ç´°ãªèª¬æ˜Žãƒšãƒ¼ã‚¸ã‚’ä½œã£ã¦ãã‚Œã¾ã—ãŸã€‚ å€‹äººçš„ã«VMã«ã—ãŸã“ã¨ã§ã€è©•ä¾¡&å®Ÿè¡Œã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯å¤šå°‘è‰¯ããªã‚‹ã¨æ€ã†ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ãã‚Œã»ã©å¯„ä¸Žã—ã¦ã„ãªã„ã‚“ã˜ã‚ƒãªã„ã‹ãªï¼Ÿã£ã¦æ€ã£ãŸã‚Šã—ã¾ã—ãŸã€‚ æœ¬è¨˜äº‹ã¯ãã®ãƒšãƒ¼ã‚¸ã«ã¤ã„
mapk0y 2024/05/18
sqlite
ãƒªãƒ³ã‚¯
GitHub - nalgeon/redka: Redis re-implemented with SQL
You 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
mapk0y 2024/04/15
sqlite

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
Screwtape / sqlite-schema-diagram Â· GitLab
GitLab.com
mapk0y 2024/03/25
sqlite
ãƒªãƒ³ã‚¯
Cloud Run + Litestream ã§ RDB ã‚’ä½¿ã„ã¤ã¤è²»ç”¨ã‚’æ ¼å®‰ã«æŠ‘ãˆã‚‹
å‰ã‹ã‚‰æ°—ã«ãªã£ã¦ã„ãŸ Litestream ã‚’ Cloud Run ã§ä½¿ã£ã¦ã¿ãŸã®ã§ã€ãã®ãƒ¡ãƒ¢ã§ã™ã€‚ Litestream ã¨ã¯ï¼Ÿ ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ æ‰‹é † å‹•ä½œç¢ºèªã—ã¦ã¿ã‚‹ åˆ¶é™äº‹é … ãŠã¾ã‘ ã¾ã¨ã‚ å‚è€ƒ Litestream ã¨ã¯ï¼Ÿ Litestream ã¯ã€ SQLite ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ Amazon S3 ã‚„ Google Cloud Storage ãªã©ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ãƒˆã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ä¾‹ãˆã°é€šå¸¸ Cloud Run ã§ DB ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ SQLite ã‚’ä½¿ç”¨ã—ã‚ˆã†ã¨ã—ã¦ã‚‚ã€ã‚³ãƒ³ãƒ†ãƒŠãŒç ´æ£„ã•ã‚Œã‚‹ã¨åŒæ™‚ã«æ¯Žå›ž SQLite ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚æ¶ˆãˆã¦ã—ã¾ã†ãŸã‚ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ°¸ç¶šåŒ–ã™ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“ã€‚ ã—ã‹ã— Litestream ã‚’ä½¿ç”¨ã™ã‚Œã°ã€ SQLite ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«
mapk0y 2024/02/08
GCP

sqlite
ãƒªãƒ³ã‚¯
GitHub - dgllghr/stanchion: A SQLite extension that brings column-oriented tables to SQLite
You 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
mapk0y 2024/02/04
sqlite
ãƒªãƒ³ã‚¯
Rust ã§ SQLite ã‚’å†å®Ÿè£…ã—ãŸ 2023 - kawasin73ã®ãƒ–ãƒã‚°
æ°—åˆã„ã§å®Ÿè£…ã€ã©ã†ã‚‚ã‹ã‚ã—ã‚“ã§ã™ã€‚ ã“ã®è¨˜äº‹ã¯ Rust Advent Calendar 2023 ã®6æ—¥ç›® å…¼ æƒ…å ±æ¤œç´¢ãƒ»æ¤œç´¢æŠ€è¡“ Advent Calendar 2023 ã® 6 æ—¥ç›®ã§ã™ã€‚ Rust ã§ SQLite ã‚’ãƒ•ãƒ«ã‚¹ã‚¯ãƒ©ãƒƒãƒã§å®Ÿè£…ã—ã¦ã„ã¾ã™ã€‚ github.com ãªãœ SQLite ã‚’ Rust ã§å†å®Ÿè£…ã—ã‚ˆã†ã¨æ€ã£ãŸã®ã‹ã«ã¤ã„ã¦ã¯ä»¥å‰ã®è¨˜äº‹ã§ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ä¸€è¨€ã§è¨€ãˆã°ã€èª°ã‚‚ Rust ã§ SQLite ã‚’æ›¸ã„ã¦ã„ã‚‹äººãŒã„ãªã‹ã£ãŸã‹ã‚‰ã‚„ã£ã¦ã¿ãŸã®ã§ã™ãŒã€ãã‚‚ãã‚‚ SQLite ãŒå¼·ã™ãŽã‚‹ã¨ã„ã†ã“ã¨ãŒå†å®Ÿè£…ã—ã¦ã„ã‚‹ã†ã¡ã«ã‚ã‹ã£ã¦ãã¦çµ¶æœ›ã—ã¦ã„ã¾ã™ã€‚ kawasin73.hatena blog.com 4 ãƒ¶æœˆå‰ã«ã“ã®è¨˜äº‹ã‚’æ›¸ã„ãŸã¨ãã¯ç°¡å˜ãª SELECT æ–‡ã—ã‹å®Ÿè¡Œã§ããªã‹ã£ãŸã®ã§ã™ãŒã€ç¾æ™‚ç‚¹ã§ã¯ SELECT, INSERT, DELETE æ–‡ã‚’ã‚µãƒãƒ¼ãƒˆã—ã€express
mapk0y 2023/12/08
sqlite

rust
ãƒªãƒ³ã‚¯
SQLite ã®ãŠã‚‚ã—ã‚ä»•æ§˜ (2) : ãƒ•ã‚¡ã‚¤ãƒ«ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ - kawasin73ã®ãƒ–ãƒã‚°
å¾Œæ–¹äº’æ›æ€§ã£ã¦è¾›ã„ãã€ã©ã†ã‚‚ã‹ã‚ã—ã‚“ã§ã™ã€‚ æœ€è¿‘ Rust ã§ SQLite ã‚’ãƒ•ãƒ«ã‚¹ã‚¯ãƒ©ãƒƒãƒã§å†å®Ÿè£…ã—ã¦ã„ã¾ã™ã€‚ github.com å†å®Ÿè£…ã™ã‚‹ãŸã‚ã« SQLite ã®å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚„ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã¿è¾¼ã‚“ã§ã„ã‚‹ã‚ã‘ã§ã™ãŒã€ãã®éŽç¨‹ã§æ°—ä»˜ã„ãŸãŠã‚‚ã—ã‚ãƒã‚¤ãƒ³ãƒˆã‚’å…±æœ‰ã—ã‚ˆã†ã‹ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯ãã®ç¬¬äºŒå¼¾ã€ãƒ•ã‚¡ã‚¤ãƒ«ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆç·¨ã§ã™ã€‚ç¬¬ä¸€å¼¾ã¯ã“ã¡ã‚‰ï¼šSQLite ã®ãŠã‚‚ã—ã‚ä»•æ§˜ (1) : ãƒ‡ãƒ¼ã‚¿åž‹ - kawasin73ã®ãƒ–ãƒã‚° å‰æçŸ¥è˜ : ãƒšãƒ¼ã‚¸ ã¾ãšã€ã“ã®è¨˜äº‹ã‚’é¢ç™½ã„ã¨æ€ã£ã¦ã‚‚ã‚‰ã†ãŸã‚ã®å‰æçŸ¥è˜ã§ã™ã€‚ å¤§æŠµã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒšãƒ¼ã‚¸ã¨ã„ã†å˜ä½ã§ç®¡ç†ã—ã¾ã™ã€‚SQLite ã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ 1 ãƒšãƒ¼ã‚¸ 4096 ãƒã‚¤ãƒˆã§ã™ã€‚ã“ã‚Œã¯ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¿å˜ã™ã‚‹ãƒ‡ãƒã‚¤ã‚¹ï¼ˆHDD ã‚„ SSD ãªã©ï¼‰ã¨ã—ã¦ãƒ–ãƒãƒƒã‚¯ãƒ‡ãƒã‚¤ã‚¹ã‚’æƒ³å®šã—ã¦ã„ã‚‹ã‹ã‚‰ã§ã™ã€‚ãƒ–ãƒãƒƒã‚¯ãƒ‡ãƒã‚¤ã‚¹ã¨ã¯ãƒ‡ãƒ¼ã‚¿ã®èª
mapk0y 2023/11/14
ã‚ã¨ã§èªã‚€

sqlite
ãƒªãƒ³ã‚¯
SQLite ã‚’å†å®Ÿè£…ã™ã‚‹æ™‚ã«å½¹ã«ãŸã¤ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ - kawasin73ã®ãƒ–ãƒã‚°
å›°ã£ãŸæ™‚ã¯ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€ã©ã†ã‚‚ã‹ã‚ã—ã‚“ã§ã™ã€‚æœ€è¿‘ã€è«¸äº‹æƒ…ã§ SQLite ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’èªã‚“ã§ã„ã¾ã™ã€‚ å‰å›žã®è¨˜äº‹ ã§ç´¹ä»‹ã—ãŸé€šã‚Š SQLite ã‚’ Rust ã§å†å®Ÿè£…ã—ã¦ã„ã¾ã™ã€‚ãŠã‹ã’ã•ã¾ã§ 300 ã‚’è¶…ãˆã‚‹ Github Star ã‚‚ã„ãŸã ãå¬‰ã—ã„ã§ã™ã€‚ github.com SQLite ã¯å…¨ã¦ã®ä»•æ§˜ãŒ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ã«ã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã®ã§ã€ãã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¨æœ¬å®¶ã®å®Ÿè£…ã‚’èªã¿æ¯”ã¹ãªãŒã‚‰å®Ÿè£…ã—ã¦ã„ã¾ã™ã€‚ SQLite ã‚’å†å®Ÿè£…ã™ã‚‹ä¸Šã§ç‰¹ã«ä»¥ä¸‹ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯å½¹ã«ãŸã¡ã¾ã™ã€‚ã“ã‚Œã‚‰ã ã‘ã§æœ€å°é™ã® SQLite ã®å®Ÿè£…ã¯ä½œã‚Œã‚‹ã¨æ€ã„ã¾ã™ã€‚ Overview Documents > About SQLite ã„ã‹ã« SQLite ãŒã™ã”ã„ã‹ã‚’è‡ªæ…¢ã—ã¦ã„ã‚‹ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€‚ä½¿ãŠã†ã¨ã—ã¦ã„ã‚‹äººã«ã¯å®‰å¿ƒã‚’ã€å†å®Ÿè£…ã—ã‚ˆã†ã¨ã™ã‚‹äººã«ã¯çµ¶æœ›ã‚’ä¸Žãˆã¦ãã‚Œã¾ã™ã€‚ Programming Interfaces >
mapk0y 2023/09/02
sqlite

rust
ãƒªãƒ³ã‚¯
Rust ã§ SQLite ã‚’å†å®Ÿè£…ã—ã¦ã„ã‚‹ - kawasin73ã®ãƒ–ãƒã‚°
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’ç›¾ã«ä¸€ç‚¹çªç ´ã€‚ã©ã†ã‚‚ã‹ã‚ã—ã‚“ã§ã™ã€‚æœ€è¿‘ Rust ã§ SQLite ã‚’å®Ÿè£…ã—ã¦ã¾ã™ã€‚ ä»¥å‰ã®è¨˜äº‹ã§ HTTP Parser ã‚’ Rust ã§å®Ÿè£…ã—ã‚ˆã†ã¨ã—ãŸã‚‚ã®ã®ã€ã™ã§ã«å®Ÿè£…ã•ã‚Œã¦ã„ãŸã®ã§æ–å¿µã—ã¾ã—ãŸãŒã€ã„ã„é¡Œæã‚’è¦‹ã¤ã‘ã¾ã—ãŸã€‚SQLite ã§ã™ã€‚é–‹ç™ºä¸ã®ãƒªãƒã‚¸ãƒˆãƒªã¯ã“ã‚Œã§ã™ã€‚ github.com ä»Šã®æ™‚ç‚¹ã§ã¯ã€Read Only ã§1ã¤ã® WHERE å¥ã‚’æŒã£ãŸ SELECT æ–‡ã—ã‹å‡¦ç†ã§ããªã„ã§ã™ãŒã€ä»¥ä¸‹ã®æ©Ÿèƒ½ã‚’å®Ÿè£…ã—ã¦ã„ã¾ã™ã€‚ sqlite3 ã§ç”Ÿæˆã•ã‚ŒãŸ database ãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿å–ã‚Š (cursor.rs, btree.rs, record.rs) SQL æ–‡ã®è§£æž (token.rs, parser.rs) ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã®ãƒ‘ãƒ¼ã‚¹ (schema.rs) å‹•çš„ãªãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿è¾¼ã¿ (pager.rs) SQL ã‚¯ã‚¨ãƒªã¨ã‚¹ã‚ãƒ¼ãƒžæƒ…å ±ã‚’å…ƒã«
mapk0y 2023/08/06
sqlite

rust
ãƒªãƒ³ã‚¯
SQLiteã€è¤‡æ•°ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®åŒæ™‚æ›¸ãè¾¼ã¿ã‚’å¯èƒ½ã«ã™ã‚‹ã€ŒBEGIN CONCURRENTã€æ–‡ã‚’å®Ÿè£…ã¸
SQLiteã€è¤‡æ•°ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®åŒæ™‚æ›¸ãè¾¼ã¿ã‚’å¯èƒ½ã«ã™ã‚‹ã€ŒBEGIN CONCURRENTã€æ–‡ã‚’å®Ÿè£…ã¸ SQLiteã®é–‹ç™ºãƒãƒ¼ãƒ ã¯ã€è¤‡æ•°ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®åŒæ™‚æ›¸ãè¾¼ã¿ã‚’å¯èƒ½ã«ã™ã‚‹BEGIN CONCURRENTæ–‡ã‚’å®Ÿè£…ã—ã¦ã„ã‚‹ã“ã¨ã‚’æ˜Žã‚‰ã‹ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§SQLiteã§ã¯æ›¸ãè¾¼ã¿ã®åŒæ™‚å®Ÿè¡Œã¯ã§ããšã€ã¤ãã«1ã¤ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã ã‘ãŒæ›¸ãè¾¼ã¿å¯èƒ½ã§ã—ãŸã€‚ åŒæ™‚æ›¸ãè¾¼ã¿å‡¦ç†ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¸ãƒ£ãƒ¼ãƒŠãƒ«ãƒ¢ãƒ¼ãƒ‰ãŒã€Œwalã€ï¼ˆWrite-Ahead-logï¼‰ã‚‚ã—ãã¯walã‚’æ”¹è‰¯ã—ãŸã€Œwal2ã€ã§ã€BEGIN CONCURRENTæ–‡ã‚’å®Ÿè¡Œã—ãŸå ´åˆã«å¯èƒ½ã¨ãªã‚Šã¾ã™ã€‚ ã©ã®ã‚ˆã†ã«åŒæ™‚æ›¸ãè¾¼ã¿å‡¦ç†ãŒè¡Œã‚ã‚Œã‚‹ã®ã‹ã«ã¤ã„ã¦ã¯ã€ä¸Šè¨˜ã®Webãƒšãƒ¼ã‚¸ã®èª¬æ˜Žã‚’å¼•ç”¨ã—ã¾ã—ã‚‡ã†ã€‚ ãƒãƒƒã‚¯ãŒå»¶æœŸã•ã‚Œã‚‹ã“ã¨ã§åŒæ™‚æ›¸ãè¾¼ã¿ãŒå¯èƒ½ã« ã¾ãšã€æ›¸ãè¾¼ã¿æ™‚ã®ãƒãƒƒã‚¯ãŒCOMMITã¾ã§å»¶æœŸã•ã‚Œã‚‹ã“ã¨ã§åŒæ™‚æ›¸ãè¾¼ã¿ãŒå®Ÿç¾ã•ã‚Œã‚‹ã¨èª¬æ˜Žã•ã‚Œã¦
mapk0y 2023/08/01
sqlite
ãƒªãƒ³ã‚¯
åˆ†æ•£SQLiteã‚’å®Ÿç¾ã™ã‚‹ã€ŒLiteFSã€ã«ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ©Ÿèƒ½ã«ã‚ˆã‚‹ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªã‚’æä¾›ã™ã‚‹ã€ŒLiteFS Cloudã€ã€Fly.ioãŒç™ºè¡¨
åˆ†æ•£SQLiteã‚’å®Ÿç¾ã™ã‚‹ã€ŒLiteFSã€ã«ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆæ©Ÿèƒ½ã«ã‚ˆã‚‹ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªã‚’æä¾›ã™ã‚‹ã€ŒLiteFS Cloudã€ã€Fly.ioãŒç™ºè¡¨ ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã‚’ã‚°ãƒãƒ¼ãƒãƒ«å±•é–‹ã—ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹Fly.ioã¯ã€åˆ†æ•£SQLiteã‚’å®Ÿç¾ã™ã‚‹LiteFSã®ä»˜åŠ æ©Ÿèƒ½ã¨ã—ã¦ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã€ãƒªã‚«ãƒãƒªæ©Ÿèƒ½ãªã©ã‚’ãƒžãƒãƒ¼ã‚¸ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦æä¾›ã™ã‚‹ã€ŒLiteFS Cloudã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ LiteFS Cloud: now in preview. We love SQLite for distributed web apps! Introducing managed backups for LiteFS. Read more from Darla Shockley and @benbjohnson.https://t.co/nQxitx5x7d
mapk0y 2023/07/11
sqlite
ãƒªãƒ³ã‚¯
GitHub - asg017/sqlite-vss: A SQLite extension for efficient vector search, based on Faiss!
You 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
mapk0y 2023/05/31
sqlite
ãƒªãƒ³ã‚¯
Denoã€JavaScript/TypeScriptã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã€ŒDeno KVã€ç™ºè¡¨ã€‚Denoæœ¬ä½“ã«SQLiteã‚’çµ±åˆã€åˆ†æ•£ç’°å¢ƒã§ã¯å¼·ã„ä¸€è²«æ€§ã‚‚æä¾›
Denoã€JavaScript/TypeScriptã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã€ŒDeno KVã€ç™ºè¡¨ã€‚Deno æœ¬ä½“ã«SQLiteã‚’çµ±åˆã€åˆ†æ•£ç’°å¢ƒã§ã¯å¼·ã„ä¸€è²«æ€§ã‚‚æä¾› ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚„ã‚¨ãƒƒã‚¸ã§ã®JavaScriptãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã‚’æä¾›ã™ã‚‹Denoã¯ã€Deno æœ¬ä½“ã«çµ±åˆã—ãŸJavaScript/TypeScriptã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã€ŒDeno KVã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§Denoã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é–‹ç™ºã—å®Ÿè¡Œã™ã‚‹éš›ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒç”¨æ„ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã€‚ Deno KVã¯Denoã«çµ±åˆã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¨ã—ã¦ã€JavaScriptã®å¤‰æ•°ã‚„é…åˆ—å¤‰æ•°ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãªã©ã®ã‚ã‚‰ã‚†ã‚‹æ§‹é€ åŒ–ã•ã‚ŒãŸå€¤ãŒä¿å˜å¯èƒ½ãªã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æä¾›ã•ã‚Œã‚‹ãŸã‚ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨æ„ã—ãªãã¦ã‚ˆããªã‚Šã¾ã™ã€‚ Announcing Deno KV: A Global Dat
mapk0y 2023/05/09
sqlite

javascript
ãƒªãƒ³ã‚¯
GitHub - asg017/sqlite-http: A SQLite extension for making HTTP requests purely in SQL
You 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
mapk0y 2023/02/07
sqlite
ãƒªãƒ³ã‚¯
SQLiteã®æ£å¼ãªWebAssemblyç‰ˆã€ŒSQLite3 WASM/JSã€ãŒç™»å ´
SQLiteã®å…¬å¼Webã‚µã‚¤ãƒˆã«ã€SQLite3ã‚’WebAssemblyåŒ–ã—ãŸã€ŒSQLite3 WASM/JSã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ãƒšãƒ¼ã‚¸ãŒå…¬é–‹ã•ã‚Œã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã•ã¾ã–ã¾ãªWebAssemblyç‰ˆSQLiteã®è©¦ã¿ãŒè¡Œã‚ã‚Œã¦ããŸãªã‹ã§ã€åˆã‚ã¦SQLiteã®æ£å¼ãªã‚µãƒ–ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦é–‹ç™ºã•ã‚Œã‚‹WebAssemblyç‰ˆSQLiteã«ãªã‚Šã¾ã™ã€‚ ä¸‹è¨˜ã¯ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€ŒAbout the sqlite3 WASM/JS Subprojectã€ã‹ã‚‰ã®å¼•ç”¨ã§ã™ã€‚ this subproject is the first effort "officially" associated with the SQLite project, created with the goal of making WASM builds of the library first-class members of the fa
mapk0y 2022/10/31
sqlite

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