Commands tagged sqlite sorted by votes

Commands tagged sqlite (11)

sorted by

Cleanup firefox's database.
This is sample output - yours may be different.
18

find ~/.mozilla/firefox/ -type f -name "*.sqlite" -exec sqlite3 {} VACUUM \;

grokskookum · 2009-09-01 21:45:46 25
Cleanup firefox's database.

Sqlite database keeps collecting cruft as time passes, which can be cleaned by the 'vacuum;' command. This command cleans up the cruft in all sqlite files relating to the user you have logged in as. This command has to be run when firefox is not running, or it will exit displaying the pid of the firefox running.
This is sample output - yours may be different.
11

pgrep -u `id -u` firefox-bin || find ~/.mozilla/firefox -name '*.sqlite'|(while read -e f; do echo 'vacuum;'|sqlite3 "$f" ; done)

kamathln · 2009-08-22 10:36:05 19
Cleanup firefox's database.

For Mac OS X users only
This is sample output - yours may be different.
1

find ~/Library/Application\ Support/Firefox/ -type f -name "*.sqlite" -exec sqlite3 {} VACUUM \;

stanishjohnd · 2009-09-02 23:12:13 3
Transfer sqlite3 data to mysql

Filters out all non-insert SQL operations (we couldn't filter out only lines starting with "INSERT" because inserts can span multiple lines), quotes table names with backticks, saves dump to a file and pipes it straight to mysql. This transfers only data--it expects your schema is already in place. In Ruby on Rails, you can easily recreate the schema in MySQL with "rake db:schema:load RAILS_ENV=production".
This is sample output - yours may be different.
0

sqlite3 mydb.sqlite3 '.dump' | grep -vE '^(BEGIN|COMMIT|CREATE|DELETE)|"sqlite_sequence"' | sed -r 's/"([^"]+)"/`\1`/' | tee mydb.sql | mysql -p mydb

mislav · 2009-10-02 14:40:51 4
Display sqlite results one column per line

Similar output to using MySQL with the \G at the end of a Query. Displays one column per line. Other modes include: -column Query results will be displayed in a table like form, using whitespace characters to separate the columns and align the output. -html Query results will be output as simple HTML tables. -line Query results will be displayed with one value per line, rows separated by a blank line. Designed to be easily parsed by scripts or other programs -list Query results will be displayed with the separator (|, by default) character between each field value. The default. From inside the command line this can be also changed using the mode command: .mode MODE ?TABLE? Set output mode where MODE is one of: csv Comma-separated values column Left-aligned columns. (See .width) html HTML code insert SQL insert statements for TABLE line One value per line list Values delimited by .separator string tabs Tab-separated values tcl TCL list elements Show Sample Output
This is sample output - yours may be different.
```
$ sqlite3 -line blackhatseo.sqlite 
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from auth_user;
          id = 1
    username = blabla
  first_name = 
   last_name = 
       email = blablamailinator.com
    password = blabla
    is_staff = 1
   is_active = 1
is_superuser = 1
  last_login = 2010-10-09 12:48:07.493163
 date_joined = 2010-10-09 12:48:07.493163
```
0

sqlite3 -line database.db

pykler · 2010-10-09 16:10:19 9
Dump your Thunderbird Lightning todo list in CSV format
This is sample output - yours may be different.
0

sqlite3 -csv ~/.thunderbird/*.default/calendar-data/local.sqlite "SELECT CASE WHEN priority IS NULL THEN 5 ELSE priority END AS priority, title FROM cal_todos WHERE ical_status IS NULL ORDER BY priority ASC, last_modified DESC;"

hfs · 2011-01-26 13:27:13 4
get Mother's Day
This is sample output - yours may be different.
0

sqlite> select date('now', 'start of year', '+4 months', 'weekday 0', '+7 days');

kev · 2011-05-23 13:18:55 15
Return Dropbox folder location.

Newer versions of Dropbox let you choose the location for your Dropbox folder. If you use script to put things into your Dropbox folder (todo list, screenshots, torrents etc.) but have the Dropbox folder in different locations on your other computers this lets you use the same script on all systems without having to tell it where the Dropbox folder is. Show Sample Output
This is sample output - yours may be different.
```
/home/user/Dropbox
/media/backup/Dropbox
/really/deep/level/subdirectory/for/some/reason/Dropbox
```
-1

sqlite3 $HOME/.dropbox/config.db "select value from config where key like '%dropbox_path%'"

mobilediesel · 2011-06-05 08:26:02 14
To compact all SQLite databases in your home directory
This is sample output - yours may be different.
-1

find ~ -name '*.sqlite' -exec sqlite3 '{}' 'VACUUM;' \;

kev · 2011-06-29 16:36:05 4
shrink firefox database
This is sample output - yours may be different.
-2

find ~/.mozilla -name '*.sqlite' -exec sqlite3 {} VACUUM \;

kev · 2012-04-26 15:09:54 8
Defragment SQLite databases used by Firefox/Win32 and other software.

This command defragment the SQLite databases found in the home folder of the current Windows user. This is usefull to speed up Firefox startup. The executable sqlite3.exe must be located in PATH or in the current folder. In a script use: for /f "delims==" %%a in (' dir "%USERPROFILE%\*.sqlite" /s/b ') do echo vacuum;|"sqlite3.exe" "%%a" Show Sample Output
This is sample output - yours may be different.
```
C:\>for /F "delims==" %a in (' dir "%USERPROFILE%\*.sqlite" /s/b ') do echo vacuum;  | "sqlite3.exe"  "%a"

C:\>echo vacuum;  | "sqlite3.exe"  "C:\Documents and Settings\vutcovici\Application Data\Mozilla\Firefox\Profiles\3apduvcu.default\content-prefs.sqlite"
```
-3

for /f "delims==" %a in (' dir "%USERPROFILE%\*.sqlite" /s/b ') do echo vacuum;|"sqlite3.exe" "%a"

vutcovici · 2010-01-18 20:56:00 7

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Check These Out

check open ports without netstat or lsof

Geolocate a given IP address

Defines a function to geolocate a given IP address; if none supplied, will default to your external IP address.

list files recursively by size

python - covert image to base64 string for data URI use

useful if you are using lots of data URI's in your css files

Better recursive grep with pretty colors... requires ruby and gems (run: "gem install rak")

Find usb device in realtime

Using this command you can track a moment when usb device was attached.

finding more large files

remove recursively all txt files with number of lines less than 10

Copy ssh keys to user@host to enable password-less ssh logins.

To generate the keys use the command ssh-keygen

Enter parameter if empty (script becomes interactive when parameters are missing)

Can be used for command line parameters too. If you have a more complicated way of entering values (validation, GUI, ...), then write a function i.e. EnterValue() that echoes the value and then you can write: $ param=${param:-$(EnterValue)}

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)
» commands tagged sqlite

Commands tagged sqlite (11) the last day the last week the last month all time sorted by date votes

What's this?

Check These Out

Stay in the loop…

Commands tagged sqlite (11)

sorted by