Archive for the 'Web' 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 »

Make free worldwide phone calls with flashphone

October 31st, 2007

Flashphone is a free-of-charge web service which allows you to make free calls from a web browser. To use flashphone you need to have a computer with access to the Internet, a microphone and the headphones (headset) correctly connected to this computer, and Adobe Flash Player 9 or above installed. You can use flashphone on [...]

Read the rest of this post »

National Bank of Romania: Exchange Rates in XML Format

October 22nd, 2007

Starting 15 October 2007, the NBR provides information multipliers with daily exchange rates in XML format. In view of changing the website design and structure, webmasters are encouraged to use the new XML files rather than parsing the existing html files. * The link to the XML file is: http://www.bnro.ro/nbrfxrates.xml I wonder if this is [...]

Read the rest of this post »

How many other websites your hosting company hosts your server?

October 15th, 2007

Shared hosting simply means that your web site will be hosted with other websites on the same server or machine. Shared hosting is good for the average web site where speed is not a priority. Would you like to know how many other websites your hosting company hosts your server? Use my new advanced SEO [...]

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 sha1() to PostgreSQL?

March 10th, 2006

First you need to add cryptographic functions to PostgreSQL. Look into contrib/pgcrypto directory from PostgreSQL sources and follow the instructions. After you installed pgcrypto.so, just create a small function: CREATE OR REPLACE FUNCTION sha1(text) RETURNS text AS ' SELECT ENCODE(DIGEST($1, "sha1"),"hex") AS result ' LANGUAGE 'SQL'; Examples: SELECT SHA1('test'); sha1 —————————————— a94a8fe5ccb19ba61c4c0873d391e987982fbbd3

Read the rest of this post »

How to add unix_timestamp() and from_unixtime() to PostgreSQL?

March 10th, 2006

CREATE OR REPLACE FUNCTION from_unixtime(integer) RETURNS timestamp AS ' SELECT $1::abstime::timestamp without time zone AS result ' LANGUAGE 'SQL'; CREATE OR REPLACE FUNCTION unix_timestamp() RETURNS integer AS ' SELECT ROUND(EXTRACT( EPOCH FROM abstime(now()) ))::int4 AS result; ' LANGUAGE 'SQL'; CREATE OR REPLACE FUNCTION unix_timestamp(timestamp with time zone) RETURNS integer AS ' SELECT ROUND(EXTRACT( EPOCH FROM [...]

Read the rest of this post »