顯示具有 SQLite 標籤的文章。 顯示所有文章
顯示具有 SQLite 標籤的文章。 顯示所有文章

SQLite3 Create Table 設定欄位預設值為目前時間

標籤：
sql - Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine - Stack Overflow sql - sqlite database default time value 'now' - Stack Overflow

Android sqlite vacuum

標籤： ,
  1. 安裝 SQLite Installer for Root - Google Play Android 應用程式(或下載sqlite3 放置/system/bin/，權限755)
  2. 下載 vacuum.sh
  3. vaccum.sh放置到下列路徑，並設權限755/system/etc/
  4. 執行vaccum.sh
  5. 如無顯示執行結果，請查看下列路徑之Log/data/sqlite.log
[AROMA][MODS][TWEAKS][4.1][4.2] Boost My SL For JellyBean V1 [Alpha4][Alpha5] NEW !!! - xda-developers [SCRIPT] Run init.d scripts once every N days [ZipAlign/SQLite3/others]

整理索引、回收已刪除空間

標籤： , ,
When a large amount of data is deleted from the database file it leaves behind empty space, or "free" database pages. This means the database file might be larger than strictly necessary. Running VACUUM to rebuild the database reclaims this space and reduces the size of the database file.
for %%i in (*.sqlite) do sqlite3 %%i VACUUM | echo %%i
FORFILES /M *.sqlite /S /C "cmd /c sqlite3.exe @file VACUUM | ECHO @file"
SQLite Query Language: VACUUM
Mozilla Links 正體中文版: Firefox 3 日漸肥大的收藏庫：減肥法
Vacuum the Stylish SQLite DB - forum.userstyles.org
訂閱： 文章 ( Atom )