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

hiroomi id:hiroomi

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (7)

ã‚¿ã‚°ã®çµžã‚Šè¾¼ã¿ã‚’è§£é™¤

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

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

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

SQLite
ãƒªãƒ³ã‚¯
The Querynomicon
Upon first encountering SQL after two decades of Fortran, C, Java, and Python, I thought I had stumbled into hell. I quickly realized that was optimistic: after all, hell has rules. I have since realized that SQL does too, and that they are no more confusing or contradictory than those of most other programming languages. They only appear so because it draws on a tradition unfamiliar to those of u
hiroomi 2024/02/07
â€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ã¾ã™ sqlite3â€

sqlite
ãƒªãƒ³ã‚¯
Power Automate Desktop ã§ Excel ã« SQL ã‚’å®Ÿè¡Œã™ã‚‹ at SE ã®é›‘è¨˜
å…ˆæ—¥é–‹å‚¬ã•ã‚ŒãŸã€ç·Šæ€¥é–‹å‚¬ï¼Windows 10ãªã‚‰ç„¡æ–™ã§å‡ºæ¥ã‚‹Power Automate Desktopå‹‰å¼·ä¼šï¼ ã«å‚åŠ ã•ã›ã¦ã„ãŸã ã„ãŸéš›ã«ã€ãƒãƒ£ãƒƒãƒˆæ¬„ã§ SQL ã‚’ä½¿ç”¨ã—ãŸ Excel ã®æ“ä½œã¨ã„ã†ã‚³ãƒ¡ãƒ³ãƒˆãŒã‚ã‚Šã¾ã—ãŸã€‚ Power Automate Desktop (PAD) ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦ã®æ¬¡ã®ã‚ˆã†ãªã‚¢ã‚¯ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã¾ã™ã€‚ SQL Server ã«å¯¾ã—ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã¯è©¦ã—ã¦ã„ãŸã®ã§ã™ãŒã€ãã‚Œä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã«ã¤ã„ã¦ã¯è©¦ã—ãŸã“ã¨ãŒç„¡ã‹ã£ãŸã®ã§ã€ã“ã®æ©Ÿä¼šã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ãŸ Excel ã®æ“ä½œã«ã¤ã„ã¦è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ PAD ã«ã¯ã€Excel ã‚’æ“ä½œã™ã‚‹ãŸã‚ã®ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ãŒã„ãã¤ã‹æä¾›ã•ã‚Œã¦ãŠã‚Šã€æœ¬æŠ•ç¨¿ã®ã‚ˆã†ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ãªãã¦ã‚‚ Excel ã®æ“ä½œã¯å¯èƒ½ã§ã™ã€‚ Excel ã®æ“ä½œã«ã¤ã„ã¦ã¯ã€Excel ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„
hiroomi 2022/06/25
SQLite
ãƒªãƒ³ã‚¯
PowerAutomateDesktopã§SQLite3ã‚’ä½¿ã†æ–¹æ³•ã‚’ã”ç´¹ä»‹
ã“ã‚“ã«ã¡ã¯ã€‚ ä»Šå›žã¯ã€RPAãƒ„ãƒ¼ãƒ«ã®ã€ŒPowerAutomateDesktopã€ã§SQLiteã‚’ä½¿ç”¨ã™ã‚‹æ–¹æ³•ã‚’è¨˜ã—ã¾ã™ã€‚ è»½é‡ã§ã‚µãƒ¼ãƒä¸è¦ãªSQLiteã¯ãƒŸãƒ‹ãƒžãƒ ãªRPAãƒ•ãƒãƒ¼ã«ã´ã£ãŸã‚Šã§ã™ã€‚ ä¾‹ãˆã°ã€ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ãƒ•ãƒãƒ¼ã®å…±æœ‰ã‚’ã—ãŸã„æ™‚ã€å„ç«¯æœ«ã«ç’°å¢ƒå¤‰æ•°ã‚’è¨ã‘ã‚‹ã‚ˆã‚Šã€ä¸€å…ƒç®¡ç†ã—ãŸæ–¹ãŒæ¥½ã§ã™ã‚ˆãã€‚ãã†ã„ã£ãŸåˆ©ç”¨ãŒæƒ³å®šã•ã‚Œã¾ã™ã€‚ ã§ã¯æ—©é€Ÿã€ã‚„ã‚Šæ–¹ã‚’è¦‹ã¦ã„ãã¾ã™ã€‚ Power Automate Desktopã§SQLiteã‚’ä½¿ã† å‰ææ¡ä»¶ ãƒ»æ—¢ã«Power Automate Desktop ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã‚ã‚‹ç«¯æœ« ãƒ»SQLiteãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ãŠã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ä½œæˆæ¸ˆã¿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã¾ã ä½œæˆã—ã¦ã„ãªã„æ–¹ã¯ä¸‹è¨˜ã®ãƒªãƒ³ã‚¯å…ˆã‚’å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ windows10ã«SQLite3ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³• ä»Šå›žã¯ã€Power Automate Desktopã®ãƒ•ãƒãƒ¼ã‚’ä½œæˆå¾Œã€D
hiroomi 2022/06/25
SQLite
ãƒªãƒ³ã‚¯
PSSQLite 1.1.0
hiroomi 2022/06/23
SQLite
ãƒªãƒ³ã‚¯
PowerShellã§SQLiteã‚’ä½¿ã£ã¦ã¿ã‚‹ : morituriã®ãƒ–ãƒã‚°
PowerShellã§ç°¡å˜ãªDBã‚’ä½¿ã„ãŸã‹ã£ãŸã®ã§ã€SQLiteã‚’ä½¿ã†æ–¹æ³•ã‚’èª¿ã¹ãŸã€‚ è©¦ã—ãŸç’°å¢ƒã¯Windows10ã®PowerShellã€‚ .NETã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ãˆã°PowerShellã‹ã‚‰ç°¡å˜ã«å‘¼ã³å‡ºã›ã‚‹ã®ã§System.Data.SQLiteã‚’ä½¿ã†ã“ã¨ã«ã—ãŸã€‚DLLã¯å…¬å¼ã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki ãŸãã•ã‚“ã‚ã£ã¦ã‚ã‹ã‚Šã«ãã„ãƒšãƒ¼ã‚¸ã ãŒã€ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã¨ã‚ˆã„ã€‚.NET Coreã§ãªã„.NET Frameworkã®æœ€æ–°ç‰ˆã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ã†ã€‚ sqlite-net Fx46-binary-x64-2015-1.0.115.5.zip â€»ä»Šè¦‹ãŸã‚‰(2023/08/16)ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒä¸ŠãŒã£ã¦ã€sqlite-net Fx46-bi
hiroomi 2022/06/23
SQLite
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç ”ä¿®ï¼ˆSQLåŸºç¤Žç·¨ï¼‰ã€ãƒŸã‚¯ã‚·ã‚£22æ–°å’æŠ€è¡“ç ”ä¿®ã€‘
22æ–°å’æŠ€è¡“ç ”ä¿®ã§å®Ÿæ–½ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç ”ä¿®ï¼ˆSQLæ¼”ç¿’ç·¨ï¼‰ã®è¬›ç¾©è³‡æ–™ã§ã™ã€‚ å‹•ç”»ï¼šhttps://youtu.be/dseGQ2MZF1U æ¼”ç¿’ç”¨Colab Notebook https://colab.research.google.com/github/mixigroup/2022Begiâ€¦
hiroomi 2022/06/23
sqlite
ãƒªãƒ³ã‚¯
ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã§ CSV ã«å¯¾ã—ã¦ SQLite ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ - ã‚¢ãƒ«ãƒ‘ã‚«ã®å¾’ç„¶æ–‡
One-liner for running queries against CSV files with SQLite ã¨ã„ã†è¨˜äº‹ã§ç´¹ä»‹ã•ã‚Œã¦ã„ãŸã€ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã‚’ä½¿ã£ã¦ CSV ãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾ã—ã¦ SQL ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹æ–¹æ³•ã€‚ $ sqlite3 :memory: -cmd '.mode csv' -cmd '.import taxi.csv taxi' \ 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' ã‚½ãƒ¼ã‚¹å…ƒã«è¨˜è¿°ã•ã‚Œã¦ã‚‹é€šã‚Šã€taxi.csv ã‚’ GitHub ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦è©¦ã™ã“ã¨ãŒã§ãã‚‹ã€‚7z ã§åœ§ç¸®ã•ã‚Œã¦ã„ã¦è§£å‡ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ SQLite ã¯é€šå¸¸ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ‡ã‚£ã‚¹ã‚¯ï¼ˆSSD ã¨ã‹ï¼‰ä¸Šã«ä¿å˜ã—ã¦åˆ©ç”¨ã™ã‚‹ã®ãŒä¸€èˆ¬çš„ã ãŒã€SQLite å´ã§ç”¨æ„ã•
hiroomi 2022/06/22
sqlite

csv
ãƒªãƒ³ã‚¯
ä»Šå¹´ã‚‚ãƒŸã‚¯ã‚·ã‚£ã®22æ–°å’æŠ€è¡“ç ”ä¿®ã®è³‡æ–™ã¨å‹•ç”»ã‚’å…¬é–‹ã—ã¦ã„ãã¾ã™ï¼ï¼ˆã‚´ãƒ¼ãƒ«ãƒ‡ãƒ³ã‚¦ã‚£ãƒ¼ã‚¯å‰ç·¨ï¼‰
æ˜¨å¹´åŒæ§˜ãƒŸã‚¯ã‚·ã‚£ã®22æ–°å’æŠ€è¡“ç ”ä¿®ã®è³‡æ–™ã¨å‹•ç”»ã‚’å…¬é–‹ã—ã¦ã„ã£ã¦ã„ã¾ã™ã€‚ã¾ã ç ”ä¿®ä¸ãªã®ã§ã€ä¸€éƒ¨ã®å…¬é–‹ã«ã¯ãªã‚Šã¾ã™ãŒã€ãœã²ã‚´ãƒ¼ãƒ«ãƒ‡ãƒ³ã‚¦ã‚£ãƒ¼ã‚¯ä¸ã®å¦ç¿’ã«ãŠä½¿ã„ãã ã•ã„ã€‚
hiroomi 2022/06/22
sqlite

inbox
ãƒªãƒ³ã‚¯
ãªãœã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§é«˜åº¦ãªãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«SQLiteã‚’ä½¿ã†ã¹ããªã®ã‹ï¼Ÿ ï½ž UNIX/POSIXã‚³ãƒžãƒ³ãƒ‰ã®æ¬ ç‚¹ã‚’SQLã§è§£æ±ºã™ã‚‹
ãªãœã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§é«˜åº¦ãªãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«SQLiteã‚’ä½¿ã†ã¹ããªã®ã‹ï¼Ÿ ï½ž UNIX/POSIXã‚³ãƒžãƒ³ãƒ‰ã®æ¬ ç‚¹ã‚’SQLã§è§£æ±ºã™ã‚‹ShellScriptUNIXSQLitePOSIXQiitadelika ã€Œåˆ©ç”¨è€…ã¯æ•°åå„„äººï¼ï¼Ÿ SQLiteã¯ã©ã“ãŒå‡„ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ãªã®ã‹èª¿ã¹ã¦ã¿ãŸã€ã®ç¶šãã§ã™ã€‚ ã¯ã˜ã‚ã« è¤‡é›‘ãªæ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã®ã§ã‚ã‚Œã°ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚„ Unix (POSIX) ã‚³ãƒžãƒ³ãƒ‰ã§ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã‚’è¡Œã†ã®ã¯é¿ã‘ã‚‹ã¹ãã ã¨æ€ã„ã¾ã™ã€‚è§£æ±ºä¸å¯èƒ½ãªå•é¡ŒãŒå¤šã„ã‹ã‚‰ã§ã™ã€‚ã—ã‹ã—ãã‚Œã§ã‚‚ä½•ã‹ã—ã‚‰ã®ç†ç”±ã§ã‚„ã‚ã†ã¨è€ƒãˆã‚‹ï¼ˆã‚„ã‚‰ãªã‘ã‚Œã°ã„ã‘ãªã„ï¼‰ã®ã§ã‚ã‚Œã° SQLite ã‚’ä½¿ã†ã®ã‚’ãŠã™ã™ã‚ã—ã¾ã™ã€‚ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚„ Unix ã‚³ãƒžãƒ³ãƒ‰ã¯è¡Œå˜ä½ã®å˜ç´”ãªãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã«ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã™ã‚‹ã®ãŒå‰æã¨ãªã£ã¦ãŠã‚Šã€æ”¹è¡Œã‚„ç©ºç™½ãŒå«ã¾ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã‚„è¤‡é›‘ãªæ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿æ‰±ã†ã®ã¯è‹¦æ‰‹ã§ã™ã€‚ã¾ãŸã‚·ã‚§ãƒ«
hiroomi 2022/04/02
ãŠæ°—è»½ã«ã‚³ãƒ¡ãƒ³ãƒˆæ›¸ã‘ã‚‹é‡ã˜ã‚ƒãªã‹ã£ãŸã€‚

sqlite
ãƒªãƒ³ã‚¯
Hosting SQLite databases on Github Pages - (or IPFS or any static file hoster) - phiresky's blog
Hosting SQLite databases on Github Pages(or IPFS or any static file hoster) Apr 17, 2021 â€¢ Last Update Jun 04, 2023I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to
hiroomi 2021/05/03
sqlite
ãƒªãƒ³ã‚¯
SQLite3ã‚’ç°¡å˜ã«ä½¿ã£ã¦ã¿ã‚‹ - Qiita
SQLiteã¯ï¼Œå°è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚µã‚¯ã£ã¨ä½œã‚ŠãŸã„ã¨ãã«ä½¿ã‚ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã®ã²ã¨ã¤ã§ã™ï¼Ž ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ã‚’ç™»éŒ²ã—ãŸã‚Šï¼Œå‰Šé™¤ã—ãŸã‚Šï¼Œæ¤œç´¢ã—ãŸã‚Šã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®ã“ã¨ï¼Ž å‚ç…§ï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãã»ã‚“ ã„ã¾ã•ã‚‰èžã‘ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç¨®é¡ž MySQL PostgreSQL SQLite Oracle DB ãªã©ãŒã‚ã‚Šã¾ã™ï¼Žï¼ˆå‚ç…§ï¼šMySQLã€PostgreSQLã€SQLiteã€Oracle DBã®æ¯”è¼ƒï¼‰ ä¸ã§ã‚‚ï¼ŒSQLite3ã¯Pythonã®æ¨™æº–ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«æ—¢ã«å…¥ã£ã¦ã„ã¦ï¼Œæ©Ÿèƒ½ãŒå°‘ãªãï¼Œæ‰‹è»½ã«ä½¿ãˆã¾ã™ï¼Ž SQLite3ã®ä½¿ã„æ–¹ pythonã¨ã¯åˆ¥ã«ï¼ŒSQLã‚’æ›¸ãå¿…è¦ãŒã‚ã‚Šã¾ã™ï¼Ž #ã‚¤ãƒ³ãƒãƒ¼ãƒˆ import sqlite3 #ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶š filepath = "test2.sqlite" conn = sqlite3.connec
hiroomi 2020/12/02
sqlite
ãƒªãƒ³ã‚¯
ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚ˆã‚Šã‚‚35ï¼…é«˜é€Ÿã« | POSTD
1. æ¦‚è¦ SQLiteã‚’ä½¿ã†ã¨å°ã•ãªBLOBï¼ˆä¾‹ï¼šã‚µãƒ ãƒã‚¤ãƒ«ç”»åƒãªã©ï¼‰ã‚’èªã¿æ›¸ãã™ã‚‹å ´åˆã€fread()ã‚„fwrite()ã‚’ä½¿ã£ã¦å€‹åˆ¥ã®ãƒ•ã‚¡ã‚¤ãƒ«ä¸Šã«è¨˜éŒ²ã•ã‚ŒãŸBLOBã‚’èªã¿æ›¸ãã™ã‚‹ã‚ˆã‚Šã‚‚35ï¼…ã‚‚é€Ÿã (*1) èªã¿æ›¸ããŒã§ãã¾ã™ã€‚ ã•ã‚‰ã«ã€10ã‚ãƒãƒã‚¤ãƒˆã®BLOBã‚’æ‰±ã†ã‚ˆã†ãªSQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è€ƒãˆãŸå ´åˆã€å€‹åˆ¥ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ãã‚Œãžã‚Œã®BLOBã‚’æ ¼ç´ã™ã‚‹å ´åˆã«æ¯”ã¹ã¦ãƒ‡ã‚£ã‚¹ã‚¯é ˜åŸŸã‚’ç´„20ï¼…ã‚‚ç¯€ç´„å¯èƒ½ã§ã™ã€‚ ã“ã®ã‚ˆã†ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å·®ãŒç”Ÿã˜ã‚‹ç†ç”±ã¯ã€ï¼ˆç§ãŸã¡ã®è€ƒãˆã§ã¯ï¼‰SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å ´åˆã€open()ã‚„close()ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«ãŒå‘¼ã³å‡ºã•ã‚Œã‚‹ã®ãŒ1å›žã ã‘ãªã®ã«å¯¾ã—ã¦ã€å€‹åˆ¥ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹BLOBã‚’ä½¿ç”¨ã™ã‚‹å ´åˆã¯ã€open()ã‚„close()ãŒBLOBã®æ•°ã ã‘å‘¼ã³å‡ºã•ã‚Œã‚‹ãŸã‚ã ã¨æ€ã‚ã‚Œã¾ã™ã€‚ã©ã†ã‚„ã‚‰open()ã¨close()ã‚’å‘¼ã³å‡ºã™ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
hiroomi 2017/08/12
â€œå‘¼ã³å‡ºã™ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ç”¨ã™ã‚‹ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã‚ˆã‚Šã‚‚å¤§ãã„ã‚ˆã†ã§ã™ã€‚â€

SQLite
ãƒªãƒ³ã‚¯
sqlite3 1ä¸‡ä»¶ã‚’è¶…ãˆã‚‹ãªã‚‰UPDATE/DELETEã¯ä½¿ã£ã¡ã‚ƒãƒ€ãƒ¡
PHPï¼‹PDOã§sqlite3ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†ã“ã¨ãŒã‚ã‚Šã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ã¯ã€ï¼‘æ—¥ï¼‘ï¼ï¼ï¼ä»¶ãã‚‰ã„å¢—ãˆã‚‹æ„Ÿã˜ã§ã€ï¼‘ä¸‡ä»¶ã€ï¼•ä¸‡ä»¶ã€10ä¸‡ä»¶ã¨å¢—ãˆã¦ã„ãã¾ã™ã€‚ å½“ç„¶è¿½åŠ (INSERT)ã™ã‚‹éš›ã¯ã€PK(å®Ÿéš›ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã—ï¼‰ã®å˜åœ¨ã‚’ç¢ºèªã—ã¦Insert Or Updateãªå‡¦ç†ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ä»¶æ•°ãŒå¤šããªã‚‹ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯å¿…é ˆã§ã™ã€‚ ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã¯ã€ï¼•ä¸‡ä»¶è¶…ãˆã®ã‚‚ã®ã§ç¢ºèªã—ã¦ã„ã¾ã™ã€‚ ä½•ã‚‚è€ƒãˆãšã«ã€select pk from tbl where pk=?çš„ãªSQLã§æ¤œç´¢ã—ã¦ã€å˜åœ¨ã—ãªã‘ã‚Œã°Insertã€å˜åœ¨ã™ã‚Œã°Updateã¨ã„ã†å‡¦ç†ã«ã™ã‚‹ã¨ ï¼ˆä»¥ä¸‹ã€msec=ãƒŸãƒªç§’ã§ã™ã€‚ï¼‰ selectç™ºè¡Œã‚³ã‚¹ãƒˆã¯ã€ï¼‘ä»¶ã‚ãŸã‚Š0.001sec(1msec)ã¨ã”ãã‚ãšã‹ãªæ™‚é–“ã§ã—ãŸã€‚ãŒã€ UPDATEç™ºè¡Œã‚³ã‚¹ãƒˆã¯ã€ï¼‘ä»¶ã‚ãŸã‚Š0.06sec(60msec)ã‚‚ã‹ã‹ã‚Šã¾ã™ã€‚ ï¼‘ï¼ä»¶ã§ã€600msec
hiroomi 2017/04/11
SQLite
ãƒªãƒ³ã‚¯
SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãŸã ã—ã€Vacuumå‡¦ç†ãŒå®Œäº†ã™ã‚‹ã¾ã§ã«ã¯å¤šå°‘ã®æ™‚é–“ã‚’è¦ã™ã‚‹ã€‚ãã®ãŸã‚ã€å®Ÿè¡Œã‚¿ã‚¤ãƒŸãƒ³ã‚°ã«ã¯æ°—ã‚’ä½¿ã†å¿…è¦ãŒã‚ã‚‹ã€‚ã§ãã‚‹ã“ã¨ãªã‚‰ã°ã€åˆ¥ã‚¹ãƒ¬ãƒƒãƒ‰ã§è¡Œã†ã“ã¨ãŒæœ›ã¾ã—ã„ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‡¦ç†é€Ÿåº¦ã®å‘ä¸Šï¼ˆ1ï¼‰ï¼šãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ä½¿ç”¨ SQLiteã¯ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«å¯¾å¿œã—ã¦ã„ã‚‹ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿æ“ä½œã‚’ã²ã¨ã¾ã¨ã‚ã«ã—ã¦å–ã‚Šæ‰±ã£ãŸã‚Šã€é€£ç¶šã—ãŸãƒ‡ãƒ¼ã‚¿æ“ä½œå‡¦ç†ã®é€”ä¸ã«ãŠã‘ã‚‹ä¸æ•´åˆã®ç™ºç”Ÿã‚’é˜²ã„ã ã‚Šã€ä¸€é€£ã®ãƒ‡ãƒ¼ã‚¿æ“ä½œã‚’ã¾ã¨ã‚ã¦å·»ãæˆ»ã—ãŸã‚Šï¼ˆå…ƒã«æˆ»ã—ãŸã‚Šï¼‰ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ã•ã‚‰ã«ã€ãƒ‡ãƒ¼ã‚¿ã®æ›´æ–°å‡¦ç†ã‚’é€£ç¶šã—ã¦è¡Œã†ã‚ˆã†ãªå ´åˆã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹ã¨å¤§å¹…ã«å‡¦ç†é€Ÿåº¦ãŒå‘ä¸Šã™ã‚‹ã€‚ ã¾ãšã¯ã€é€šå¸¸ã®å‡¦ç†ã€‚ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ã€1000ä»¶ã®ãƒ©ãƒ³ãƒ€ãƒ ãªåå‰ãƒ‡ãƒ¼ã‚¿ã‚’ã²ãŸã™ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŒ¿å…¥ã™ã‚‹ã‚±ãƒ¼ã‚¹ã‚’è€ƒãˆã¦ã¿ã‚ˆã†ã€‚ // åå—20ç¨® private static final String[] FAMILY
hiroomi 2017/04/11
SQLite
ãƒªãƒ³ã‚¯
Excelã‹ã‚‰ODBCãªã—ã§SQLiteã‚’æ“ä½œã™ã‚‹(è¨å®šç·¨ï¼‰ - Qiita
æ‰‹é † SQLiteForExcel-0.9.zipã‚’è§£å‡ ä¸èº«ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‘ã‚¹ï¼šSQLiteForExcel\Distribution ãƒ‘ã‚¹ï¼šSQLiteForExcel\Source\SQLite3VBAModules\ ãã®ä»–ã«ã‚‚SQLite3_StdCall.dllã®ã‚½ãƒ¼ã‚¹ã¨ã‹å…¥ã£ã¦ã¾ã™ã‘ã©ã€å‰²æ„›ã—ã¾ã™ã€‚ sqlite3.dllã‚‚å…¥ã£ã¦ã¾ã™ãŒã€ä»Šå›žã¯DLã—ã¦ããŸæœ€æ–°ç‰ˆã‚’ä½¿ã„ã¾ã™ã€‚ ãªã®ã§ç”¨ã™ã‚‹ã®ã¯ä»¥ä¸‹ã®4ã¤ã€‚ SQLite3_StdCall.dll Sqlite3_64.bas Sqlite3Demo_64.bas SQLiteForExcel_64.xlsmï¼ˆã‚µãƒ³ãƒ—ãƒ«Exelï¼‰ ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é›†ç´„ ä¸Šè¨˜ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’1ç®‡æ‰€ã«ã¾ã¨ã‚ã¾ã™ã€‚ãã“ã«DLã—ã¦ããŸ32bitã®SQLiteã‚’è¿½åŠ ã—ã¾ã™ã€‚ ãªã‚“ã§ã€Excelã¨ã‹ã¯64bitã£ã¦æ›¸ã„ã¦ã‚ã‚‹ã®ä½¿ã†ã®ã‹ã£ã¦ã¨ã“ã‚ãªã‚“ã§ã™ãŒã€ 32
hiroomi 2017/02/07
excel

VBA

SQLite
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¿½æ±‚ã™ã‚‹ãŸã‚ã®SQLiteè¨å®š
ãƒ‘ã‚½ã‚³ãƒ³é–¢é€£ã®è¦šæ›¸ãã€‚ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£(ãƒ—ãƒã‚»ãƒƒã‚µãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£),æ©Ÿæ¢°å¦ç¿’(äººå·¥çŸ¥èƒ½),é‡‘èžå·¥å¦ãŒå°‚é–€ã€‚ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹(Computer Science)ã‚’å¦éƒ¨ã¨é™¢ã§å°‚æ”»ã—ãŸå¦ç”Ÿã«ã¨ã£ã¦ã¯å¦è¡“çš„ã«å¸¸è˜ãªã“ã¨ã‚’è¨˜è¼‰ã—ã¦ã„ã¾ã™ã€‚ã“ã®åˆ†é‡Žã®åè‘—Hennessyï¼†Pattersonæ›¸ã¨ã€ç±³å›½å¦ä¼šACM,IEEEã®è«–æ–‡ã‚’è«–æ‹ ã¨ã—ã¦ã„ã¾ã™ã€‚æ±äº¬å¤§å¦å¤§å¦é™¢æƒ…å ±ç†å·¥å¦ç³»ç ”ç©¶ç§‘ä¿®å£«(ç†ä¸€ï¼†å·¥å¦å£«)ã€‚ ç§ã¯VisualStudioã§æ‰±ã†C#ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãªã‚‹ã¹ãé«˜é€Ÿã«ä½¿ã†ã“ã¨ã‚’ç›®çš„ã¨ã—ã¦ã‚µãƒ¼ãƒ™ã‚¤ã‚’ã—ã¦ãã¾ã—ãŸã€‚ çµè«–ã‹ã‚‰ã„ã†ã¨ã€MySQLã‚„SQL Serverã‚ˆã‚ŠSQLiteãŒåˆ¥æ ¼ã§é«˜é€Ÿã§ã™ã€‚SQLiteã®æ¬ ç‚¹ã¯ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ©Ÿèƒ½ãŒãªã„ã“ã¨ã€‚ã¤ã¾ã‚Šãƒã‚°ã‚¤ãƒ³æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã›ã‚“ã€‚è¤‡æ•°ã®ã‚¢ã‚¯ã‚»ã‚¹ä¸»ä½“ã«å¯¾ã—ã¦æ¨©é™ä»˜ä¸Žã‚„ã‚¢ã‚¯ã‚»ã‚¹åˆ¶å¾¡ã‚’ã™ã‚‹ç”¨é€”ã§ã¯SQLiteã¯ä¸å‘ãã§ã™ã€‚ ã§ã™ãŒç§ã®ã‚ˆã†ã«ã€æ™‚ç³»
hiroomi 2017/01/16
SQLite
ãƒªãƒ³ã‚¯
ã€SQLite3ã€‘ ãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ã‚‹ãŸã‚ã«è¦šãˆã¦ãŠãã¹ãã“ã¨
Tweet Tweetï¼ˆã“ã®è¨˜äº‹ã¯æ—§ãƒ–ãƒã‚°ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚ï¼‰ ã€Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ä»˜ã„ã¦ã„ã‚‹ã¯ãšãªã®ã«æ¤œç´¢é€Ÿåº¦ãŒé…ã„ï¼ã€ ã¨ã„ã†ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿã‚ãŸã—ã¯è¦‹äº‹ã«ãƒãƒžã‚Šã¾ã—ãŸã€‚ ç§ã®å ´åˆã€å€‹äººä½¿ã„ãŒã»ã¨ã‚“ã©ã§ã‚·ãƒ“ã‚¢ãªæ€§èƒ½ãŒè¦æ±‚ã•ã‚Œã‚‹ web ã‚¢ãƒ—ãƒªãªã©ã‚’ä½œã£ã¦ã„ã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãã‚“ãªã“ã¨ã‚‚ã‚ã£ã¦ã€ã‚ã¾ã‚Šç´°ã‹ã„ã“ã¨ã¯æ°—ã«ã›ãš ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¤œç´¢ã®éš›ã®ã‚ãƒ¼ã¨ãªã‚‹ã‚«ãƒ©ãƒ ã«ã¯é©å½“ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ã¦ãŠã‘ã°ã„ã„ã‚ˆãªãƒ¼ã€ ç¨‹åº¦ã«è€ƒãˆã¦ CREATE INDEX ï½ž ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚ ã¨ã“ã‚ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã¤ã‘ã‹ãŸã«ã¯ã„ãã¤ã‹ã®æŠ‘ãˆã¦ãŠãã¹ãç‚¹ãŒã‚ã£ãŸã®ã§ã™ã€‚ ã“ã“ã§ã¯ã„ã‚ã„ã‚å®Ÿé¨“ã—ã¦ã¿ã¦ã‚ã‹ã£ãŸã“ã¨ã‚’æ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ä¾‹é¡Œ 2000Ã—2000ã®ãƒ©ãƒ³ãƒ€ãƒ ãªè¡Œåˆ—ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã—ã€è¦ç´ ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚ˆã†ãªç°¡å˜ãªä¾‹é¡Œã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ tbl ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚‚ã¡ã€tbl
hiroomi 2017/01/16
sqlite
ãƒªãƒ³ã‚¯
ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã§SQLæ–‡ã‚„ã‚³ãƒžãƒ³ãƒ‰ã®å…¥åŠ›æ–¹æ³•
SQLite ã§ã¯ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ãŸã‚Šãƒ‡ãƒ¼ã‚¿ã®å–å¾—ã¨ã„ã£ãŸã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ã“ã“ã§ã¯ SQLite ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã™ã‚‹ã¨ãã«ã©ã®ã‚ˆã†ã«å…¥åŠ›ã™ã‚Œã°ã„ã„ã®ã‹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚
hiroomi 2017/01/16
SQLite
ãƒªãƒ³ã‚¯
MySQLite: SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’èªã¿æ›¸ãã™ã‚‹MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³
hiroomi 2014/02/18
mysql

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