Swobodin v Brně

Here’s a quick and dirty shell script to convert some data from SQLite to HTML format.

sqlite3 -html contacts.sqlite “SELECT name, number FROM contacts” | tidy -asxhtml > contacts.html

Tidy will fix errors and convert the table into XHTML format.

I found out a good tool to make slide shows without having to use a program such as PowerPoint or OpenOffice presentation, called Slidy.
You only have to include a JavaScript file, and optionally, a CSS in order to define different classes. All what you need is a basic [X]HTML/CSS knowledge, and go ahead! It […]

I have found an interesting post in Hannibal’s blog (not Lecter, Barca himself) about happiness in the world; there was a link to the World Map happiness, according to a British psychologist.
The page, however, only shows countries classified by their alphabetic order, and not happiness rank. Lazy as I am, I did a quick […]

After dumping some MySQL tables, whose the structure is the follwing:
CREATE TABLE `mydata` (
`id` tinyint(10) NOT NULL auto_increment,
`content` varchar(20) NOT NULL default ‘’,
PRIMARY KEY  (`id`)
)  TYPE=MyISAM AUTO_INCREMENT=1 ;
INSERT INTO `mydata` VALUES (’1′, ‘First entry’);
etc.
After dumping the tables, you want to drop the original tables from the database in order to replace the content; however, […]

My hosting’s MySQL server was diown yesterday (too many connections). Apparantly, they could fix that problem; I thought of migrating the backup’ed data temporarily to another MySQL server but everything works fine now.

I have coded a funny and buggy Feed Reader, with PHP and SQLite. So don’t be afraid if you see on the log a user-agent with a strange identity showing my URL: it means that I have added your RSS to my bookmarks

I have released a quick Perl script to parse an Apache log file and insert data into a SQLite database.
Click here to download the script.