Owner: Claudiu Raveica URL:http://raveica.comdurav.com Join Date: Mon, 01 Oct 2007 18:42:51 -0500 Rating:0 Site Description: Claudiu Raveica Site statistics:Click here
How to install Safari 3.0.3 beta for Windows XP/Vista on Fedora 7 2007-09-29 07:19:49 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. Make sure you have the latest version [...] Read more:Fedora
, install
New page added: My Books 2006-03-16 09:11:48 Today I added a new page: My Books
Feel free to browse the list here: http://raveica.comdurav.com/books/index.html
The list was generated by tellico . I will try to customize HTML output generated by tellico as soon as I can.
How to add uuid() to PostgreSQL? 2006-03-09 20:27:58 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 multiple web servers without communication between the servers, and without fear [...]
How to add sha1() to PostgreSQL? 2006-03-09 20:01:55 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
How to add unix_timestamp() and from_unixtime() to PostgreSQL? 2006-03-09 19:51:43 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 ABSTIME($1) ))::int4 AS result;
' LANGUAGE 'SQL';
Examples:
SELECT UNIX_TIMESTAMP(), UNIX_TIMESTAMP(NOW());
unix_timestamp | unix_timestamp
—————-+—————-
1141955358 [...]
How to add inet_aton() and inet_ntoa() to PostgreSQL? 2006-03-09 19:21:53 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 INET_ATON('127.0.0.1');
inet_aton
————
2130706433
(1 row)
SELECT INET_NTOA(2130706433);
inet_ntoa
———–
127.0.0.1
(1 row)
Warning!
INET_ATON() does NOT understand short-form [...]
Moving from MySQL to PostgreSQL 2006-03-04 23:40:20 I have to port couple of MySQL
based applications to PostgreSQL. This will take some time, so I decided to create this POST to share my thoughts with you Read more:Moving
How many other websites your hosting company hosts your server? 2007-10-15 01:27:30 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 tool [...]
Kiwi, an Ubuntu derivative tailored for Romanian and Hungarian users 2007-10-21 19:18:05 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 based on [...]
National Bank of Romania: Exchange Rates in XML Format 2007-10-22 06:55:08 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 more:Exchange
, National
, Rates
Make free worldwide phone calls with flashphone 2007-10-31 02:52:07 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 [...]
Safari 3.0.4 beta for Windows XP/Vista on Fedora 8 2008-02-06 13:38:05 For installation on Fedora
8 see my previous post:
How To install Safari
for Windows
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 more:Vista
Optimizing MySQL server using "MySQL Performance Tuning Primer" Script 2008-08-21 15:06:24 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, Solaris, FreeBS Read more:Performance
, Tuning
Recommend Site To A Friend
