$ wget https://copr.fedorainfracloud.org/coprs/robert/gcj/repo/epel-7/robert-gcj-epel-7.repo $ wget https://copr.fedorainfracloud.org/coprs/robert/pdftk/repo/epel-7/robert-pdftk-epel-7.repo
$ vim robert-*.repo
# mv robert-*.repo /etc/yum.repos.d
# yum --enablerepo=robert-gcj,robert-pdftk install pdftk (省略) https://copr-be.cloud.fedoraproject.org/results/robert/pdftk/pubkey.gpg から鍵を取得中です。 Importing GPG key 0xA907600B: Userid : "robert_pdftk (None)" Fingerprint: 06bb eb8a 39b9 3a25 e247 3b4e 054f e3bf a907 600b From : https://copr-be.cloud.fedoraproject.org/results/robert/pdftk/pubkey.gpg 上記の処理を行います。よろしいでしょうか? [y/N]y https://copr-be.cloud.fedoraproject.org/results/robert/gcj/pubkey.gpg から鍵を取得中です。 Importing GPG key 0xE0106A6F: Userid : "robert_gcj (None) " Fingerprint: 6dd3 1ddd 8e76 52eb cd53 fa16 bc7d 08c6 e010 6a6f From : https://copr-be.cloud.fedoraproject.org/results/robert/gcj/pubkey.gpg 上記の処理を行います。よろしいでしょうか? [y/N]y (省略)
勝ち抜く力 なぜ「チームニッポン」は五輪を招致できたのか (PHPビジネス新書)
$ rpm -q sqlite sqlite-3.3.6-6
-rw-r--r-- 1 myname myname 589824 1月 23 08:34 addons.sqlite -rw-r--r-- 1 myname myname 262144 1月 22 08:26 chromeappsstore.sqlite -rw-r--r-- 1 myname myname 229376 1月 21 08:43 content-prefs.sqlite -rw-r--r-- 1 myname myname 524288 12月 12 17:20 cookies.sqlite -rw-r--r-- 1 myname myname 65536 1月 23 08:30 downloads.sqlite -rw-r--r-- 1 myname myname 163840 1月 23 08:38 evernote_webclipper.sqlite -rw-r--r-- 1 myname myname 524288 1月 23 08:38 extensions.sqlite -rw-r--r-- 1 myname myname 851968 1月 23 08:49 formhistory.sqlite -rw-r--r-- 1 myname myname 163840 1月 23 08:51 permissions.sqlite -rw-r--r-- 1 myname myname 10485760 1月 23 08:49 places.sqlite -rw-r--r-- 1 myname myname 65536 8月 27 17:36 search.sqlite -rw-r--r-- 1 myname myname 327680 9月 6 10:27 signons.sqlite -rw-r--r-- 1 myname myname 57671680 11月 21 10:23 urlclassifier3.sqlite -rw-r--r-- 1 myname myname 98304 11月 29 2011 webappsstore.sqlite
2013/02/13 09:35 589,824 addons.sqlite 2013/01/17 08:23 262,144 chromeappsstore.sqlite 2012/12/12 10:38 229,376 content-prefs.sqlite 2013/01/21 13:00 524,288 cookies.sqlite 2013/02/04 10:47 65,536 downloads.sqlite 2013/02/12 08:31 98,304 evernote_webclipper.sqlite 2013/02/12 08:31 524,288 extensions.sqlite 2013/02/13 08:50 4,751,360 formhistory.sqlite 2013/02/13 09:43 65,536 permissions.sqlite 2013/02/13 09:43 10,485,760 places.sqlite 2012/06/22 08:30 65,536 search.sqlite 2012/09/06 10:17 327,680 signons.sqlite 2012/11/20 11:05 98,304 webappsstore.sqlite
$ cat optimize_sqlite.sh #!/bin/sh while [ "x$1" != "x" ] do database=$1 backupfile=$database.backup if [ ! -e $backupfile ] then cp -p $database $backupfile sqlite3 $database "vacuum;reindex;" fi shift done
@echo off for %%d in (%1) do cmd/c "optimize_sqlite_exec.bat %%d"
@echo off if "x%1" == "x" goto label_noargs set database=%1 set backupfile=%database%.backup if exist %backupfile% goto label_backup_exist copy /b /v %database% %backupfile% sqlite3 %database% "vacuum;reindex;" goto label_exit :label_noargs echo usage: optimize_sqlite_exec sqlite-databse-file goto label_exit :label_backup_exist echo %backupfile% is found, ignored goto label_exit :label_exit
$ sh optimize_sqlite.sh *.sqlite
C:\(省略)> optimize_sqlite *.sqlite