[B! SQLite] igrepã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

igrep id:igrep

SQLiteã«é–¢ã™ã‚‹igrepã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (29)

${{author_name}}$

{{author_name}} {{created}}

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

{{#following_bookmarks}}

${{author_name}}$

{{author_name}} {{created}}

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

{{/following_bookmarks}}

{{/is_wiped}}

Notionãƒ–ãƒ©ã‚¦ã‚¶ç‰ˆã€WebAssemblyç‰ˆSQLite3ã§ãƒšãƒ¼ã‚¸é·ç§»é€Ÿåº¦ã‚’20ï¼…æ”¹å–„ã€€å®Ÿè£…æ™‚ã®è‹¦åŠ´ã¨æ•™è¨“ã¨ã¯ï¼Ÿ
ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã®ãƒ¯ãƒ¼ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã€ŒNotionã€ã‚’æä¾›ã™ã‚‹Notion Labsã¯2024å¹´7æœˆ10æ—¥ï¼ˆç±³å›½æ™‚é–“ï¼‰ã«å…¬å¼ãƒ–ãƒã‚°ã§ã€Notionã®ãƒ–ãƒ©ã‚¦ã‚¶ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«WebAssemblyï¼ˆWASMï¼‰å®Ÿè£…ã®ã€ŒSQLite3 WASM/JSã€ï¼ˆä»¥å¾Œã€WASMç‰ˆSQLite3ï¼‰ã‚’æŽ¡ç”¨ã—ãŸäº‹ä¾‹ã‚’ç´¹ä»‹ã™ã‚‹è¨˜äº‹ã‚’å…¬é–‹ã—ãŸã€‚ 2021å¹´ã”ã‚ã€WindowsãŠã‚ˆã³macOSç‰ˆã®Notion ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã‚¢ãƒ—ãƒªã«ãŠã‘ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Šã‚’ç›®çš„ã«SQLiteã‚’æŽ¡ç”¨ã—ãŸåŒç¤¾ã¯ã€ãƒã‚¤ãƒ†ã‚£ãƒ–ã®ãƒ¢ãƒã‚¤ãƒ«ã‚¢ãƒ—ãƒªã§ã‚‚SQLiteã‚’æŽ¡ç”¨ã—ã¦ããŸã€‚ãã—ã¦ã€ãƒ–ãƒ©ã‚¦ã‚¶ç‰ˆã‚¢ãƒ—ãƒªã«ã¯ã€WASMç‰ˆSQLite3ã‚’æŽ¡ç”¨ã—ãŸã¨ã„ã†ã€‚ Notion Labsã¯ã€ŒWASMç‰ˆSQLite3ã‚’æŽ¡ç”¨ã™ã‚‹ã“ã¨ã§ã€å…¨ã¦ã®æœ€æ–°ãƒ–ãƒ©ã‚¦ã‚¶ã§ãƒšãƒ¼ã‚¸é–“ã®é·ç§»ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’20ï¼…æ”¹å–„ã§ããŸã€‚ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆæŽ¥ç¶šãªã©å¤–éƒ¨è¦å› ã«ã‚ˆã‚ŠAPI
igrep 2024/08/16
ã–ãƒ¼ã£ã¨èªã‚“ã æ„Ÿã˜ä¸€ã¤ã®Shared Workerã§å…¨éƒ¨è³„ãˆãªã„ã®ã‹ãªã€ã£ã¦æ°—ã‚‚ã™ã‚‹ã‚“ã ã‘ã©ã€ã“ã“ã¾ã§è¤‡é›‘ã«ã™ã‚‹ã®ã¯ã©ã‚“ãªäº‹æƒ…ãŒã‚ã‚‹ã‚“ã ã‚ã†ã€‚

webassembly

SQLite
ãƒªãƒ³ã‚¯
GitHub - orbitinghail/sqlsync: SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.
SQLSync is a collaborative offline-first wrapper around SQLite designed to synchronize web application state between users, devices, and the edge. Example use cases A web app with a structured file oriented data model like Figma. Each file could be a SQLSync database, enabling real-time local first collaboration and presence Running SQLSync on the edge with high tolerance for unreliable network co
igrep 2023/12/06
SQLite

rust
ãƒªãƒ³ã‚¯
GitHub - vlcn-io/cr-sqlite: Convergent, Replicated SQLite. Multi-writer and CRDT support for 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
igrep 2023/09/24
SQLite

åˆ†æ•£å‡¦ç†
ãƒªãƒ³ã‚¯
Turso â€” SQLite for Production
â€œIn e-commerce, proximity to users is vital. Turso lets us minimize round trip network latency for our global userbase and it makes a huge difference.â€œ â€œTurso enables us to efficiently scale Astro Studioâ€™s database per tenant architecture to as many users as weâ€™ll ever need, on demand. Itâ€™s a game changer.â€œ
igrep 2023/08/15
SQLite

edge computing

cdn
ãƒªãƒ³ã‚¯
GitHub - tursodatabase/libsql: libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
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
igrep 2023/08/12
SQLite
ãƒªãƒ³ã‚¯
GitHub - libsql/sqld: LibSQL with extended capabilities like HTTP protocol, replication, and more.
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
igrep 2023/08/12
PostgreSQL

SQLite

rust
ãƒªãƒ³ã‚¯
SQLiteã€è¤‡æ•°ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®åŒæ™‚æ›¸ãè¾¼ã¿ã‚’å¯èƒ½ã«ã™ã‚‹ã€ŒBEGIN CONCURRENTã€æ–‡ã‚’å®Ÿè£…ã¸
SQLiteã€è¤‡æ•°ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®åŒæ™‚æ›¸ãè¾¼ã¿ã‚’å¯èƒ½ã«ã™ã‚‹ã€ŒBEGIN CONCURRENTã€æ–‡ã‚’å®Ÿè£…ã¸ SQLiteã®é–‹ç™ºãƒãƒ¼ãƒ ã¯ã€è¤‡æ•°ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®åŒæ™‚æ›¸ãè¾¼ã¿ã‚’å¯èƒ½ã«ã™ã‚‹BEGIN CONCURRENTæ–‡ã‚’å®Ÿè£…ã—ã¦ã„ã‚‹ã“ã¨ã‚’æ˜Žã‚‰ã‹ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§SQLiteã§ã¯æ›¸ãè¾¼ã¿ã®åŒæ™‚å®Ÿè¡Œã¯ã§ããšã€ã¤ãã«1ã¤ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã ã‘ãŒæ›¸ãè¾¼ã¿å¯èƒ½ã§ã—ãŸã€‚ åŒæ™‚æ›¸ãè¾¼ã¿å‡¦ç†ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¸ãƒ£ãƒ¼ãƒŠãƒ«ãƒ¢ãƒ¼ãƒ‰ãŒã€Œwalã€ï¼ˆWrite-Ahead-logï¼‰ã‚‚ã—ãã¯walã‚’æ”¹è‰¯ã—ãŸã€Œwal2ã€ã§ã€BEGIN CONCURRENTæ–‡ã‚’å®Ÿè¡Œã—ãŸå ´åˆã«å¯èƒ½ã¨ãªã‚Šã¾ã™ã€‚ ã©ã®ã‚ˆã†ã«åŒæ™‚æ›¸ãè¾¼ã¿å‡¦ç†ãŒè¡Œã‚ã‚Œã‚‹ã®ã‹ã«ã¤ã„ã¦ã¯ã€ä¸Šè¨˜ã®Webãƒšãƒ¼ã‚¸ã®èª¬æ˜Žã‚’å¼•ç”¨ã—ã¾ã—ã‚‡ã†ã€‚ ãƒãƒƒã‚¯ãŒå»¶æœŸã•ã‚Œã‚‹ã“ã¨ã§åŒæ™‚æ›¸ãè¾¼ã¿ãŒå¯èƒ½ã« ã¾ãšã€æ›¸ãè¾¼ã¿æ™‚ã®ãƒãƒƒã‚¯ãŒCOMMITã¾ã§å»¶æœŸã•ã‚Œã‚‹ã“ã¨ã§åŒæ™‚æ›¸ãè¾¼ã¿ãŒå®Ÿç¾ã•ã‚Œã‚‹ã¨èª¬æ˜Žã•ã‚Œã¦
igrep 2023/08/01
SQLite

ä¸¦åˆ—å‡¦ç†
ãƒªãƒ³ã‚¯
GitHub - pocketbase/pocketbase: Open Source realtime backend in 1 file
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
igrep 2023/06/22
golang

sqlite
ãƒªãƒ³ã‚¯
WebAssemblyç‰ˆSQLiteãŒWASIå¯¾å¿œã«ã€‚VMware Wasm Labsãƒãƒ¼ãƒ ãŒæ˜Žã‚‰ã‹ã«
VMware Wasm Labsãƒãƒ¼ãƒ ã¯SQLiteé–‹ç™ºãƒãƒ¼ãƒ ã¨å”åŠ›ã—ã€WebAssembly SQLiteãŒWASIå¯¾å¿œã«ãªã£ãŸã“ã¨ã‚’æ˜Žã‚‰ã‹ã«ã—ã¾ã—ãŸã€‚ SQLiteã¯æ˜¨å¹´11æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³3.40ã‹ã‚‰WebAssemblyç‰ˆã®ã€ŒSQLite3 WASM/JSã€ã¸ã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‚’ã‚µãƒãƒ¼ãƒˆã—ã€é…å¸ƒã•ã‚Œã‚‹å…¬å¼ã®ãƒã‚¤ãƒŠãƒªã«Linuxç‰ˆã€Windowsç‰ˆã€Mac OS Xç‰ˆã€Androidç‰ˆãªã©ã¨å…±ã«WebAssemblyç‰ˆã®ã€ŒSQLite3 WASM/JSã€ãŒå«ã¾ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ å‚è€ƒï¼šã€ŒSQLite3 WASM/JSã€ãƒ‘ãƒ–ãƒªãƒƒã‚¯ãƒ™ãƒ¼ã‚¿å…¬é–‹ã€‚SQLite 3.40ã§ã‚µãƒãƒ¼ãƒˆé–‹å§‹ã€Webãƒ–ãƒ©ã‚¦ã‚¶ãªã©ã§SQLiteãŒå®Ÿè¡Œå¯èƒ½ã« ä»Šå›žã“ã®WebAssemblyç‰ˆSQLiteãŒã€WebAssemblyã§ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚’å¯¾å¿œã™ã‚‹WASIï¼ˆWebAssembly System I
igrep 2023/05/30
WASI

webassembly

SQLite
ãƒªãƒ³ã‚¯
Introducing sqlite-vss: A SQLite Extension for Vector Search
Software engineer, available for freelance work! â€¢ he/him/his
igrep 2023/04/28
AI

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
igrep 2022/10/31
webassembly

sqlite
ãƒªãƒ³ã‚¯
PHPã¨SQLiteã‚’WebAssemblyåŒ–ã—ã€Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§WordPressã‚’å®Ÿè¡Œå¯èƒ½ã«ã—ãŸãƒ‡ãƒ¢ã‚’VMwareãŒå…¬é–‹
VMwareã®Wasm Labsã¯ã€Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§WordPressã‚’å®Ÿè¡Œå¯èƒ½ã«ã—ãŸãƒ‡ãƒ¢ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¢ãƒšãƒ¼ã‚¸ã‚’Webãƒ–ãƒ©ã‚¦ã‚¶ã§é–‹ãã¨ã€å®Ÿéš›ã«Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§WordPressãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚ WordPressã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§é–‹ç™ºã•ã‚Œã¦ã„ã‚‹ä»£è¡¨çš„ãªCMSã§ã™ã€‚PHPã§é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦MySQLãŒä½¿ã‚ã‚Œã‚‹ã“ã¨ãŒä¸€èˆ¬çš„ã§ã™ãŒã€ä»Šå›žã®ãƒ‡ãƒ¢ã§ã¯SQLiteãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚ ä»Šå›žã®ãƒ‡ãƒ¢ã‚’å…¬é–‹ã—ãŸVMwareã®Wasm Labsã¯ã€Cè¨€èªžã‚’WebAssemblyãƒã‚¤ãƒŠãƒªã«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã§ãã‚‹EmScriptenã‚³ãƒ³ãƒ‘ã‚¤ãƒ©ã‚’ç”¨ã„ã¦ã€PHPã¨SQLiteã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ã•ã‚‰ã«ãƒ¡ãƒ¢ãƒªä¸Šã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã—ã€Service Workerã‚’ãƒ—ãƒã‚ã‚·ã¨ã™ã‚‹ãªã©è¿½åŠ ã§WordPressã‚’å®Ÿè¡Œå¯èƒ½ãªç’°å¢ƒã‚’ä½œã‚Šä¸Šã’ã€ãƒ‡ãƒ¢ã‚’ä½œæˆã—ãŸã¨ã®ã“ã¨ã§ã™ã€‚ WebA
igrep 2022/08/22
webassembly

PHP

sqlite

WordPress
ãƒªãƒ³ã‚¯
SQLite3 Fiddle
On a slow internet connection this may take a moment. If this message displays for "a long time", intialization may have failed and the JavaScript console may contain clues as to why.
igrep 2022/05/30
SQLiteã®Wasmç‰ˆãŒãƒ–ãƒ©ã‚¦ã‚¶ãƒ¼ã§ç›´æŽ¥è§¦ã‚Œã‚‹

SQLite

webassembly
ãƒªãƒ³ã‚¯
A future for SQL on the web
I discovered something absurd recently and Iâ€™m very excited to tell you about it. The end result is absurd-sql, and itâ€™s a persistent backend for SQLite on the web. That means it doesnâ€™t have to load the whole db into memory, and writes persist. In this post I will explain the absurdities of the webâ€™s storage APIs (mainly IndexedDB), show how SQLite provides a 10x perf improvement, explain all the
igrep 2021/08/28
IndexedDBã‚’ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã«ä½¿ã£ã¦ã„ã‚‹ã®ã«IndexedDBã‚ˆã‚Šé€Ÿã„ã®ã™ã’ã‡ãªãã€‚é¢ç™½ã„

SQLite

javascript
ãƒªãƒ³ã‚¯
GitHub - jlongster/absurd-sql: sqlite3 in ur indexeddb (hopefully a better backend soon)
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
igrep 2021/08/22
javascript

sql

IndexedDB

SQLite
ãƒªãƒ³ã‚¯
GitHub - lana-k/sqliteviz: Instant offline SQL-powered data visualisation in your browser
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
igrep 2021/05/17
sqlite

JavaScript
ãƒªãƒ³ã‚¯
GitHub - rqlite/rqlite: The lightweight, distributed relational database built on 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
igrep 2020/09/09
â€œThink etcd or Consul, but with relational data modelling also available.â€

golang

SQLite

åˆ†æ•£å‡¦ç†

RDB
ãƒªãƒ³ã‚¯
GitHub - massysett/squeather: Haskell interface to SQLite C library
igrep 2020/02/17
haskell

sqlite
ãƒªãƒ³ã‚¯
DB Fiddle - SQL Database Playground
An online SQL database playground for testing, debugging and sharing SQL snippets.
igrep 2019/12/15
WEBã‚µãƒ¼ãƒ“ã‚¹

rdb

mysql

PostgreSQL

sqlite
ãƒªãƒ³ã‚¯
GitHub - dbcli/litecli: CLI for SQLite Databases with auto-completion and syntax highlighting
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
igrep 2019/01/31
python

sqlite

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

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@HatenaBookmark
ãƒªãƒªãƒ¼ã‚¹ã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“ã‚¹ã®ãŠçŸ¥ã‚‰ã›
@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx