sqlite3


Remove an App from Mac OS Launchpad

You may need to remove an application from your launchpad from time to time – an installation that did not work correctly or whatever. Just open a terminal and execute the following commands: sudo sqlite3 ~/Library/Application\ Support/Dock/*.db "DELETE from apps WHERE title='<appname>';" killall Dock Whereas you replace <appname> with the name of your application, for […]


Accessing SQLite with Bash, Perl and Python

Perl: #!/usr/bin/perl -w use DBI; use strict; my $db = DBI->connect("dbi:SQLite:test.db", "", "", {RaiseError => 1, AutoCommit => 1}); $db->do("CREATE TABLE n (id INTEGER PRIMARY KEY, f TEXT, l TEXT)"); $db->do("INSERT INTO n VALUES (NULL, 'john', 'smith')"); my $all = $db->selectall_arrayref("SELECT * FROM n"); foreach my $row (@$all) { my ($id, $first, $last) = @$row; […]