1: 2009-09-12 (Sat) 12:56:46 iseki  |
Cur: 2010-07-03 (Sat) 23:21:00 admin |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ** SQLite [#q1ed9503] | ** SQLite [#q1ed9503] | ||
| + | - http://www.sqlite.org/ | ||
| + | #br | ||
| + | |||
| + | *** Install [#e3a9970d] | ||
| + | zcat sqlite-3.6.21.tar.gz |tar xfv - | ||
| + | mkdir sqlite_build | ||
| + | cd sqlite_build | ||
| + | ../sqlite-3.6.21/configure | ||
| + | make | ||
| + | make install | ||
| + | #br | ||
| + | |||
| + | *** 操作 [#bcacf2b8] | ||
| + | - sqlite3 ～.db | ||
| + | |||
| + | - .database | ||
| + | - .tables | ||
| + | - .quit | ||
| + | - .help | ||
| + | #br | ||
| + | *** Troubleshooting [#k0d69195] | ||
| + | - Monoなどを使用していて，「sqlite3_column_origin_name関数がない」というエラーが出た場合には，コンパイルをやり直す（make にオプションをつける） | ||
| + | make OPTS=-DSQLITE_ENABLE_COLUMN_METADATA=1 | ||
| + | #br | ||
- Backup list of SQLite
- Backup diff of SQLite vs current(No. All)
- 1: 2009-09-12 (Sat) 12:56:46 iseki
- 2: 2009-09-12 (Sat) 12:58:12 iseki
- 3: 2009-12-29 (Tue) 16:22:23 iseki
