Archive for the 'Linux' Category

WebCapture, a tool for generating website screenshots

March 18th, 2009

I just added a small tool for creating website screenshots. Feel free to make suggestions, comments here. WebCapture Rav

Read the rest of this post »

Optimizing MySQL server using "MySQL Performance Tuning Primer" Script

August 21st, 2008

Matthew Montgomery has created a script called MySQL performance tuning primer script that generates recomendations for tuning MySQL server variables like: Slow Query Log Max Connections Worker Threads Key Buffer Query Cache Sort Buffer Joins Temp Tables Table (Open & Definition) Cache Table Locking Table Scans (read_buffer) Innodb Status It's designed to work on Linux, [...]

Read the rest of this post »

Safari 3.0.4 beta for Windows XP/Vista on Fedora 8

February 6th, 2008

For installation on Fedora 8 see my previous post: How to install Safari 3.0.3 beta for Windows XP/Vista on Fedora 7 Only problem I've found is that menu still doesn't render properly. Most of the bugs have been fixed in Safari 3.0.4 and latest version of wine.

Read the rest of this post »

Kiwi, an Ubuntu derivative tailored for Romanian and Hungarian users

October 22nd, 2007

Kiwi is an Ubuntu derivative tailored for Romanian and Hungarian users. Kiwi is a modified Ubuntu live CD for the i386 architecture. It includes Romanian and Hungarian localization, multimedia codecs, encrypted DVD support, Flash and Java plugins for Firefox, PPPoE GUI for accessing local internet services (Clicknet and RDS). The latest release, Kiwi 7.10 is [...]

Read the rest of this post »

How to install Safari 3.0.3 beta for Windows XP/Vista on Fedora 7

September 29th, 2007

Is it possible? Yes, it is. However, there are some issues not fixed yet: Downloads may crash Safari/wine Mouse cursor is not always visible Toolbars are not rendered properly Updated: Adobe Flash 9 plugin seams to work. At least, as much as I tested it. Preparation 1. Download Safari for Windows XP/Vista from http://www.apple.com/safari/download/ 2. [...]

Read the rest of this post »

How to add uuid() to PostgreSQL?

March 10th, 2006

Updated UUID support is already in latest version of PostgreSQL. This is not longer needed. http://www.postgresql.org/docs/8.3/static/datatype-uuid.html What is uuid? UUID stands for Universally Unique Identifier. The UUIDs generated can be reasonably expected to be unique within a system and unique across all systems. They could be used, for instance, to generate unique HTTP cookies across [...]

Read the rest of this post »

How to add inet_aton() and inet_ntoa() to PostgreSQL?

March 10th, 2006

CREATE OR REPLACE FUNCTION inet_aton(text) RETURNS bigint AS ' SELECT split_part($1,''.'',1)::int8*(256*256*256)+ split_part($1,''.'',2)::int8*(256*256)+ split_part($1,''.'',3)::int8*256+ split_part($1,''.'',4)::int8; ' LANGUAGE 'SQL'; CREATE OR REPLACE FUNCTION inet_ntoa(bigint) RETURNS text AS ' SELECT (($1>>24) & 255::int8) || ''.'' || (($1>>16) & 255::int8) || ''.'' || (($1>>8) & 255::int8) || ''.'' || ($1 & 255::int8) as result ' LANGUAGE 'SQL'; Examples: SELECT [...]

Read the rest of this post »