varuolo

Meme Your Favorite Desktop Linux Software

I’ve been tagged by Chimeric. Here are the rules:

1. blog a list with your favorite destktop Linux software (as many or few you want)
2. add links to the software project’s websites
3. post these rules
4. tag three other Linux using bloggers

• wmii My window manager.
• Pidgin IM client (for my yahoo and AOL accounts)
• Firefox Web browser
• g(vim) my editor
• gFTP FTP client
• gnuCash My personal finance management
• Gimp image editing
• Frozen Bubble A game I’m addicted to….not sure if it qualifies as an “app”

• CDavis
• foosel
• linuxchic

gFTP and gVim: making them work together

Recently set up my gFTP client to use gVim as it’s editor. Every time I tried to update a file, it wouldn’t save.

Upon further inspection, I noticed the following in gFTP’s status window:

Successfully transferred index.php at 93.98 KB/s Running program: gvim /tmp/gftp-view.tRJ2CQ.php Child 5261 returned successfully File /tmp/gftp-view.tRJ2CQ.php was not changed Successfully removed /tmp/gftp-view.tRJ2CQ.php

This all happened BEFORE I made any edits to the file in gVim. So gFTP was removing the temp file as soon as gVim was opening.

On the gFTP site, I found the following:

1.11. When using an external editor, gFTP does not detect changes that are being made to the file. Look at the man page for the editor you are using and see if there is a command line argument to have the editor run in the foreground (it won’t fork to detact from the current terminal). If you are using one of the graphical VIM editors, you can add the —nofork argument.

Ah! That explains it.

According to gVim man pages, -f signifies running the editor in the foreground

So in gFTP I changed the editor to gvim -f and it worked.

Finding large tables in PostgreSQL

Quick SQL code to help determine large tables in PostgreSQL

select tablename,pg_size_pretty(pg_relation_size(tablename::name)) from pg_tables where schemaname = 'public' order by pg_relation_size(tablename::name) desc limit 30;