| << 2007 | < March | April 2008 | May > | 2009 >> | |||
|---|---|---|---|---|---|---|---|
| Sun | Mon | Tue | Wed | Thu | Fri | Sat | |
| 1 | 2 Update Package List in Apt
Update the package list - do this after you change the source in /etc/apt/sources.list . apt-get update | 3 Document Formats
In FLOSS circles, March 26 is celebrated as the Document Freedom Day. Document Freedom Day (DFD) is a global day for document liberation. It will be a day of grassroots effort to educate the public about the importance of Free Document Formats and Open | 4 Schedule a Download
Start a download at any given time echo 'wget -c www.example.com/files.iso' | at 09:00 | 5 Frees - Hard Disk Drives Free Space Viewer
I am taking a break from the regular MP3 Players Series for a special announcement. The first stable version of Frees has been released. Frees is a GUI tool that shows the Hard Disk space usage. It is written in Python using the GTK2 framework. This will | |||
| 6 | 7 | 8 Database Terms - and their Meanings
Before learning the language you will have to learn some words and their meanings. Basic stuff, but you cannot continue without them.
SQL(Structured Query Language) Tutorial
SQL, or Structured Query Language, is the language used to access and manipulate data within a database. It is very simple and very powerful.
| 9 | 10 Perl Hello Script
This is the next installment of the Hello Script series - Hello Script for Perl. ‘Hello Script’ is a file that contains the most commonly used elements of a programming language so that it can be used as a cheat sheet when working with that l | 11 SELECT Statement
First thing to learn in SQL is the SELECT command. This command is used to get the data from the database. And its used all the time.
| 12 WHERE is the new if
All languages I know use 'if' for conditions - except SQL. It uses | |
| 13 | 14 MPD - Music Player Daemon
MPD is not for everyone. Before continuing into the article, a word of warning. MPD is not for everyone. If you are a casual desktop linux user with zero geek genes, stay away from this player. There are many other simpler players for you. But then agai | 15 Remove all EXE files
Removes all exe files in the current directory tree. Useful to clear virus from flash drives. find . -name "*.exe" -delete | 16 Fish Shell Command History Meme
Use this command if you want to know your command usage stats in the fish shell. grep -v "^#" ".config/fish/fish_history"|awk '{print $1}'|sort|uniq -c|sort -rn|head -n10 | 17 Sorting the Results using ORDER BY
Often getting the data is not enough - you have to sort the data also. This is made easy by the ORDER BY clause.
| 18 Remove Empty Characters at End of Lines
Remove empty characters at the end of each row sed -e 's/ *$//' file.txt | 19 Group Multiple Rows using GROUP BY
Sometimes you have to group together multiple rows in the result and then get an aggregate from the grouped rows - that's the function of GROUP BY.
| 26 |
| 27 Remove Even Lines
This command removes all the even lines from the file given as the argument cat example.txt|awk 'NR%2==1' | 28 | 29 SQL Functions
We had a small preview of SQL functions in the last page about grouping. We saw AVG() in action. Here we are going to see the other available functions. Some of the functions ma | 30 Incremental Backup using dump
Make a incremental backup of directory ‘/home/binnyva’ dump -1aj -f home.bak /home/binnyva/ | ||||