Archive

Archive for the ‘General’ Category

Web 3.0 Concepts Explanation

November 6th, 2011 No comments

Web 1.0 – That Geocities & Hotmail era was all about read-only content and static HTML websites. People preferred navigating the web through link directories of Yahoo! and dmoz.

Web 2.0 – This is about user-generated content and the read-write web. People are consuming as well as contributing information through blogs or sites like Flickr, YouTube, Digg, etc. The line dividing a consumer and content publisher is increasingly getting blurred in the Web 2.0 era.

Web 3.0 – This will be about semantic web (or the meaning of data), personalization (e.g. iGoogle), intelligent search and behavioral advertising among other things.

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: +5 (from 5 votes)
Categories: General Tags: ,

‘O Sole Mio

October 29th, 2011 No comments

Orijinal (Napoliten) Türkçe Çeviri
Che bella cosa e’ na jurnata ‘e sole,
n’aria serena doppo na tempesta!
Pe’ ll’aria fresca pare già na festa
Che bella cosa e’ na jurnata ‘e sole

Ma n’atu sole,
cchiù bello, oje ne’
‘O sole mio
sta ‘nfronte a te!
‘O sole, ‘o sole mio
sta ‘nfronte a te!
sta ‘nfronte a te!

Quanno fa notte e ‘o sole se ne scenne,
me vene quase ‘na malincunia;
sotto ‘a fenesta toia restarria
quanno fa notte e ‘o sole se ne scenne.

Ma n’atu sole,
cchiù bello, oje ne’
‘O sole mio
sta ‘nfronte a te!
‘O sole, ‘o sole mio
sta ‘nfronte a te!
sta ‘nfronte a te!

Ne güzel bir şeydir, güneşli bir gün,
Hava nasıl da durgun fırtınadan sonra
Öylesine taze ki hava, sanki şimdiden bayram gelmiş
Ne güzel bir şeydir, güneşli bir gün,

Ama baska bir güneş var ki
Çok daha görkemli ve ışıltılı,
O da senin yüzünde doğan
Benim güneşim
Benim kendi güneşim
Senin çehrende
Senin simanda

Gece olunca ve güneş batınca
Bana öylesine bir kasvet çöker
Evinin penceresinin altında otursam
Gece olunca ve güneş batınca.

Ama baska bir güneş var ki
Çok daha görkemli ve ışıltılı,
O da senin yüzünde doğan
Benim güneşim
Benim kendi güneşim
Senin çehrende
Senin simanda

VN:F [1.9.22_1171]
Rating: 7.0/10 (3 votes cast)
VN:F [1.9.22_1171]
Rating: +5 (from 7 votes)

Manage your virtual hosts on apache server easily

May 28th, 2011 No comments

Building up and making all modifications on your server is pretty boring. There is no need to find the sun again and again. I’ve had to go through the process of reconfiguring my virtual hosts for Apache2 several times and i found a pre modified shell script and modified the script according to my needs. This script enables you to create, destroy your virtual host in a second.

you can download the script from here : vhost.txt or;

mkdir ~/bin
cd ~/bin
wget http://samet.kilictas.com/wp-content/uploads/2011/05/vhost.txt
mv vhost.txt vhost
chmod 755 vhost

Now, to invoke the script, type the following:

. ~/bin/vhost

By using this script you can create, destroy a virtual host. In order to create a new host on your server user following command by replacing appreciate values:

vhost create <domain> <admin -email> <host -ip>

The script creates required directories,files as shown below;

Web directories
/www/htdocs/$domain

Web cgi-bin
/www/cgi-bin/$domain

Web logs
/www/logs/$domain/apache2
/www/logs/$domain/apache2/access.log
/www/logs/$domain/apache2/error.log

then builds virtual host config file and enables it right away (enabling is optional), which is placed in following directory

/etc/apache2/sites-available/$domain

After getting done with all these process it simply creates a little info file

/www/$domain/logs/site_info

Great you have created and enabled your virtual host, you may need to destroy a virtual host, here is how;

vhost destroy <domain>

Read more…

VN:F [1.9.22_1171]
Rating: 5.5/10 (4 votes cast)
VN:F [1.9.22_1171]
Rating: +3 (from 3 votes)
Categories: General, HowTo, Linux, Tips Tags: , ,

Bash Shell Scripting Tutorial

April 30th, 2010 No comments

Basics
This tutorial assumes that you already know how to log in to your UNIX machine, bring up the bash shell, and run basic commands such as ls and cat. Getting to this point is fairly easy, but unfortunately this is the level that most users stay at indefinitely. This tutorial is intended to help you start to learn the more advanced features of using a shell, and specifically bash, one of the most powerful shells available.

Please note that most of the command themselves are not explained; you can examine their functionality yourself by either reading their man page, or just experimenting with them to see what they do.

Redirection
Normally programs take input from our keyboard, and display the output to our screens. However, these are just the defaults – UNIX has the ability to redirect the input (commonly referred to as stdin, short for standard input) and output (commonly referred to as stdout, short for standard output).
Read more…

VN:F [1.9.22_1171]
Rating: 7.0/10 (4 votes cast)
VN:F [1.9.22_1171]
Rating: +2 (from 2 votes)
Categories: General, HowTo, Linux Tags: , , ,

if exists syntax in sybase

April 20th, 2010 1 comment

Below shows the if exists usage with examples in sybase

If exists (select record)
begin
sql statement 1
sql statement 2
end
else
begin
sql statement 3
sql statement 4
end

Example

Scripts that include constructs like the following may produce errors if the table described in the script does not include the specified column:

if exists (select 1 from syscolumns
where id = object_id("some_table")
and name = "some_column")
begin
alter table some_table drop some_column
end

In this example, some_column must exist in some_table for the batch to succeed.

If some_column exists in some_table, the first time you run the batch, alter table drops the column. On subsequent executions, the batch does not compile.

Adaptive Server raises these errors while preprocessing this batch, which are similar to those that are raised when a normal select tries to access a nonexistent column. These errors are raised when you modify a table’s schema using clauses that require a data copy. If you add a null column, and use the above construct, Adaptive Server does not raise these errors.

To avoid such errors when you modify a table’s schema, include alter table in an execute immediate command:

if exists (select 1 from syscolumns
where id = object_id("some_table")
and name = "some_column")
begin
exec ("alter table some_table drop
some_column")
end

Because the execute immediate statement is run only if the if exists() function succeeds, Adaptive Server does not raise any errors when it compiles this script.

You must also use the execute immediate construct for other uses of alter table, for example, to change the locking scheme, and for any other cases when the command does not require data copy.

VN:F [1.9.22_1171]
Rating: 7.0/10 (6 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 4 votes)