divendres, 15 de juny del 2012

Installing task warrior in Ubuntu

Taskwarrior is a command-line todo list manager.

In a world with a lot of virtualized and remotes servers, we need a Post-It alternative ;-)

To install Task Warrior, execute:

sudo add-apt-repository ppa:ultrafredde/ppa
sudo apt-get update
sudo apt-get install task


Quick steps in task:

List tasks
task

Add a task
task add "task to do"

Add a note to a task
task #n annotate "a note"

Done a task
task #n done

There are a lot of commands, you can found them at task warrior wiki


Example:


task
[task next]

ID Project Pri Due A Age Urgency Description
2 4m 0.9 Instal·lar OrientDB
6/15/2012 http://www.orientdb.org
6/15/2012 PHP connector https://github.com/congow/Orient
1 5m 0.8 Instal·lar doophp
6/15/2012 http://doophp.com/

2 tasks



There are plans to release a task warrior server, interesting.

dijous, 14 de juny del 2012

Quick steps with postgres for MySQL admins

Connect (really we are login with postgres user):
su - postgres

show databases:
psql -l
or after connect without a database selected
\l

Connect to database:
psql [database] [username]

Show tables:
\d

Describe table:
\d+ table

Show rows per table:
SELECT schemaname,relname,n_live_tup
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC;


Quit:
\q