Archive for the 'shell' Category

Convert SQL Server database to PostgreSQL via CSV

December 2nd, 2011

Needed to convert a client Microsoft SQLSERVER database to our PostgreSQL database server.
Lots of tables, severall Gigabytes of data.

In Windows:

open the SQL Server administration console for the databae and do a DIR > tables.txt to get a file with all the table names;
remove all the tables you will not be needing from the file;
now to […]


blog with Vim script

April 10th, 2008

… after severall exchanged emails between me and Andrei Thorp about the Vim blogging ruby script, we made some changes. So instead of the initial test for Vim compiled with +ruby message s:ErrMsg, we now have an echo.
Andrei’s git (yep, they are git fans too, git rocks!) commit was calling another Vim from his machine. […]


Edit remote scipts on local VIM under SSH generated RSA keys

September 28th, 2007

Passphrases, when used the good way, present a higher level of security over passwords, but what if you are editing scripts on a remote server using a local Vim ? For every open, write, explore, you are asked for it. After a certain amount of times, it starts making no sense, and you’ll end up […]


Blogging from Vim

May 11th, 2007

… i finally set up the page for the download of the vimblog.vim vim-ruby script. It will allow you to manage your blog posts from *the* editor VIM, very easilly. Learn one single command and, at maximum, seven simple parameters. So go ahead and blog with vim.


Linux recovers XP boot sector(s)

March 16th, 2007

Well, a post about Windows… who’d say about that…
The thing is: is have a HP desktop that after a good BIOS update, got its motherboard dead. Good BIOS update. Pretty much dead motherboard. Not only happened to me. There are foruns about these HP BIOS updates for this motherboard series that gave lot’s of problems. […]


Vi blogging bundle

February 21st, 2007

… well the name reminds Brad Choate’s Textmate blogging bundle Brad is an excellent developer and like me, was once a Delphi (Borland great product) developer. I based this on his Textmate work. I’m coding a Vi / ViM / GViM script for a plugin that has some nice results already, exclusively for […]


Wordpress XMLRPC::Client.new()

February 18th, 2007

… when coding switter, using lot’s of command line, vim, bash, i felt the need to blog from vim. Some readings (quite a few availlable, actually) later, i was testing Wordpress xmlrpc using MovableType (Six Apart) calls to it. Vim allows ruby scripts (when compiled with that directive) use to create new commands, just like […]


switter on rubyforge.org

February 12th, 2007

…now, switter was accepted on rubyforge.org. I’ll try to put source and some docs there (rdoc does wonders) soon. Meanwhile, and with threahds now working for continuous message post/get, it just needs some tickles on the readline method.
switter on a maximized shell window receiving public timelines
switter on a normal sized shell window receiving public timelines


switter as a remote controller

February 8th, 2007

Had a new idea for the switter (twitter shell client) client.
What if you had a switch that enabled you to secretly send commands to the shell via twitter service ? Now, that can be (is) dangerous. But what if you defined an hash with predefined actions, and “secret” (remember, unsafe connection) codes ?
./switter -u test […]


Environment vars

February 8th, 2007

ENV is the hash that contains environment variables:
ENV.collect { |key, val| puts “#{key} ==> #{val}” }
ENV.each_pair { |key, val| puts “#{key} ==> #{val}” }

Need to know $HOME of the current user (needed for config files, say)?
puts ENV[’HOME’] if ENV.has_key?(’HOME’)
puts ENV[’HOME’] if ENV.key?(’HOME’)
puts ENV[’HOME’] if ENV.include?(’HOME’)
puts ENV[’HOME’] if ENV.member?(’HOME’)


switter: ruby twitter shell client

February 5th, 2007

been having some fun coding a twitter client for the *nix shell in (pure) ruby.
Soon will post source file for anyone to play with it.
Cool libraries used, include:
require ‘net/http’
require ‘rexml/document’
require ‘optparse’
require ‘yaml’
Configuration file created for user defs;
Command line switches prioritized over config. file;
Timeline options;
Working now on a minimal (shell) UI, message posting […]


Ruby footprint - Tattle

January 27th, 2007

Tattle is a little reporting script used for collecting system information from the Ruby community. The purpose is to help implementors of Ruby and its libraries to better understand the install footprint of the community at large.
Project Admins: Chad Fowler / Bruce Williams / Jim Weirich
me@system:~/workspace/ruby$ gem install -r tattle
me@system:~/workspace/ruby$ tattle


shell addiction…

September 29th, 2006

pedro@dapper:~$ history|awk ‘{print $2}’|awk ‘BEGIN {FS=”|”} {print $1}’|sort|uniq -c|sort -rn|head -10
based on Gunnar Wolf geeky script. See your shell trends…