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

Bell000 id:Bell000

SQLiteã¨Pythonã«é–¢ã™ã‚‹Bell000ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

sqlite3
1. åˆã‚ã« (æ›¸ãã‹ã‘) SQLite ã¯ RDMS (é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ) ã®ä¸€ç¨®ã§ã™ã€‚ é€šå¸¸ã® RDMS ã¨ç•°ãªã‚Šé¢å€’ãªã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒä¸è¦ã§ã€ç°¡å˜ã«åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ é€šå¸¸ã®ãƒ•ã‚¡ã‚¤ãƒ«ä¸¦ã«ç°¡å˜ã«æ‰±ãˆã‚‹ã®ã§ã€ ä»Šã¾ã§ã¯ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã«ä¿å˜ã—ã¦ã„ãŸãƒ‡ãƒ¼ã‚¿ã¯ sqlite ã«ä¿å˜ã™ã‚‹ã‚ˆã†ã«ã™ã‚‹ã¨ä¾¿åˆ©ã§ã™ã€‚ 2. Python ã‹ã‚‰ SQLite ã‚’ä½¿ã† ã‚‚ã¡ã‚ã‚“ã€Python ã‹ã‚‰ã‚‚ SQLite ã‚’åˆ©ç”¨ã§ãã¾ã™ã€‚ Python 2.5 ã‹ã‚‰ sqlite3 ãŒ build-in package ã¨ã—ã¦é…å¸ƒã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ ã™ãã«ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ æ¬¡ã®ä¾‹ã®ã‚ˆã†ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã« connect ã™ã‚‹ã ã‘ã§ã€ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ å˜åœ¨ã—ãªã‘ã‚Œã°è‡ªå‹•çš„ã«ä½œæˆã•ã‚Œã€ å˜åœ¨ã™ã‚Œã°ã€ãã‚ŒãŒé–‹ã‹ã‚Œã¾ã™ã€‚ ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã® co
Bell000 2008/04/13
Python

SQLite

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
debian ã§ mod_python ã¨ sqlite3 ã§ django - mitszoã®æ—¥è¨˜
â– [ãƒ¡ãƒ¢][Django][Linux]debian ã§ mod_python ã¨ sqlite3 ã§ django 11:22 åˆé–“ã«mod_python ã§ Django ã‚’å‹•ã‹ã™ã‚’è¦‹ãªãŒã‚‰ Debianï¼ˆå®Ÿã¯çŽ„ç®±ï¼‰ã§è©¦ã—ã«å‹•ã‹ãã†ã¨ã—ã¦ã¿ãŸã‚‰ãã®ã¾ã¾ã ã¨å‹•ã‹ãªã‹ã£ãŸã€‚ ã€Œunable to open database fileã€ã£ã¦è¡¨ç¤ºã•ã‚Œã‚‹ã®ã§ã€ãªã‚“ã ã€œï¼Ÿã¨æ€ã£ã¦ã‚¢ã‚¯ã‚»ã‚¹æ¨©ã¨ã‹å¤‰ãˆã¦ã¿ãŸã‚Šã—ãŸã‘ã©å‹•ã‹ãªã„ã€‚ çµå±€ settings.py ã® DATABASE_NAME = 'data.db' ã¨æ›¸ã„ã¦ãŸéƒ¨åˆ†ã‚’ãƒ•ãƒ«ãƒ‘ã‚¹ã§ DATABASE_NAME = '/var/xxx/yyy/data.db' BASE_PATH = os.path.dirname(__file__) ... DATABASE_NAME = os.path.join(BASE_PATH, 'data.db')
Bell000 2007/05/18
çŽ„ç®±ã§Django

Python

SQLite

Django
ãƒªãƒ³ã‚¯
Python2.5ã§SQLite3ã‚’ä½¿ã£ã¦ã¿ã‚‹ã€‚ - seraphyã®æ—¥è¨˜
SQLiteã¨ã¯ Python2.5ã«ã¯ã€æ¨™æº–ã§SQLiteã¨ã„ã†è»½é‡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå«ã¾ã‚Œã¦ã„ã‚‹ã€‚ SQLiteã¯ã€JAVAã§ã„ã†ã¨ã“ã‚ã®HSQL DBã‚„Apache Derbyã®ã‚ˆã†ãªæ„Ÿã˜ã®ã‚ˆã†ã§ã‚ã‚‹ã€‚ SQLLiteã¯ãƒ‡ãƒ¼ãƒ¢ãƒ³ã‚„ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ãªãã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§ã®ã¿å‹•ä½œã™ã‚‹ã€‚ï¼ˆDerbyã‚„HSQL DBã¯çµ„ã¿è¾¼ã¿ãƒ¢ãƒ¼ãƒ‰ã¨ã‚µãƒ¼ãƒãƒ¼ãƒ¢ãƒ¼ãƒ‰ã®ä¸¡æ–¹ã‚’ã‚‚ã¤ãŒã€‚ï¼‰ ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¹ãƒˆã‚¢ã‚‚ãƒ‡ã‚£ã‚¹ã‚¯ä¸Šã®å˜ä¸€ãƒ•ã‚¡ã‚¤ãƒ«ã«ãªã‚‹ã€‚ Windowsã§ã„ã†ã¨ã“ã‚ã®ã€ACCESS95ã€œ2000ã§ä½¿ã‚ã‚Œã¦ã„ãŸã€JETãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã®MDBãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã‚ã‚ã†ã‹ã€‚ è¦ã™ã‚‹ã«å˜ãªã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã‚ã‚‹ã€‚ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯ã€ãªã‚“ã¨ãƒ‘ãƒ–ãƒªãƒƒã‚¯ãƒ‰ãƒ¡ã‚¤ãƒ³ï¼ˆè‘—ä½œæ¨©æ”¾æ£„ï¼‰ã§ã‚ã‚‹ã€‚ ãã®ãŸã‚ã€Pythonã«é™ã‚‰ãšã€C/C++ã€Perlã€PHPãªã©ã«åºƒãçµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã‚‹ã€‚ Python2.4ã¾ã§ã¯ã‚¢ãƒ‰ã‚ªãƒ³ã¨ã—ã¦åˆ¥é€”ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™
Bell000 2006/11/15
Python

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

SQLite
ãƒªãƒ³ã‚¯
TkSQLite - mynote
Downloadâ€ Old versions Tcl script http://reddog.s35.xrea.com/software/tksqlite-0.3.2.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.1.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.2.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.3.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.4.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.5.zip http://reddog.s35.xrea.com/software/
Bell000 2006/08/31
Tcl/Tkã§åˆ¶ä½œã•ã‚ŒãŸSQLiteç”¨ã®ã‚°ãƒ©ãƒ•ã‚£ã‚«ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ£?

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

Python
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

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

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

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

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

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

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

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

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

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

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

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

SQLiteã¨Pythonã«é–¢ã™ã‚‹Bell000ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

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

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

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

SQLiteã¨Pythonã«é–¢ã™ã‚‹Bell000ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

sqlite3

debian ã§ mod_python ã¨ sqlite3 ã§ django - mitszoã®æ—¥è¨˜

Python2.5ã§SQLite3ã‚’ä½¿ã£ã¦ã¿ã‚‹ã€‚ - seraphyã®æ—¥è¨˜

TkSQLite - mynote

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

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

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

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

SQLiteã¨Pythonã«é–¢ã™ã‚‹Bell000ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

debian ã§ mod_python ã¨ sqlite3 ã§ django - mitszoã®æ—¥è¨˜

Python2.5ã§SQLite3ã‚’ä½¿ã£ã¦ã¿ã‚‹ã€‚ - seraphyã®æ—¥è¨˜

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

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

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹