xda: [MOD] Extended power menu

labels: ,
http://forum.xda-developers.com/showthread.php?t=2171818

as i couldn't reply to this thread in the xda dev forum, i am posting this here and hoping this might be useful to the developer and/or any users.
Read more »
0 comments

sqlite quickstart

labels:
prefer sqlite3, not sqlite2 or sqlite

$ sqlite3 --help

batch script like so..

$ sqlite3 -header {database}.db '.schema'
$ sqlite3 settings.db delete from system where name like 'lock%'

.. or interactive

$ sqlite3 {database}.db
sqlite> .show
sqlite> .headers on
sqlite> .databases
sqlite> .tables
sqlite> .tables t%
sqlite> .schema {table}
sqlite> select * from test;
sqlite> update {table} set {column1}=99 where {column2}='red';
sqlite> .exit
0 comments

most viewed

  • grub rescue btrfs ubuntu
    to play more seriously with yet another distro, i needed to install it. so i had some fun resizing/moving partitions around to clear some fr...
  • Discovering zram and replacing all tmpfs
    I have just discovered zram [2] :) woohoo... and what a thing that is! I was so sold on tmpfs , that I used it for everything I possibly ...
  • slackware netinstall
    you won't see many docs about minimal netinstall slackware. indeed, you will see many experts saying there is no such thing. and your on...
  • debian stretch kernel compile
    debian kernels contain everything needed by everyone. customising your kernel is easy and highly recommended. i recommend using the same ker...
  • runit openrc gentoo
    I decided to have another go at runit , this time on my gentoo . I had been thinking about this, since I noticed this on
  • multiboot btrfs subvolumes
    this idea has been knocking around in my head for a while. i want to document it, while it is still there and to flush it out later.. i us...
  • openwrt backfire x86 install
    vision: portable internet router, to carry on my travels, or use at home. openwrt on a portable (thin-client/netbook) device. internet sour...
  • gentoo portage
    ref: http://wiki.gentoo.org/wiki/portage Gentoo is Portage. Portage is Gentoo. Getting portage settings right is vitally important. It&#...
  • wpa_supplicant dhcpcd systemd debian
    The leanest cleanest way to connect to wpa/2 networks is wpa_supplicant . Optional wpa_gui provides a GUI and System Tray icon, if need be...
  • How to WiFi: wpa_supplicant + systemd
    I don't prefer systemd , but sometimes you can't avoid demandware . Below is my how to wifi with systemd . This method now works wi...