NoSQL

Came across the term "NoSQL" from one of the mail threads in WSO2 carbon-dev mailing list.

What is NoSQL, I didn't know it. Even wondered whether its a typo :p... can't obviously be. So googled;

Here's the wikipedia intro (until I read more detailed stuff later);

"NoSQL is a movement promoting a loosely defined class of non-relational data stores that break with a long history of relational databases. These data stores may not require fixed table schemas, usually avoid join operations and typically scale horizontally. Academics and papers typically refer to these databases as structured storage.
Notable production implementations include Google's BigTable and Amazon's Dynamo. However, there are also many publicly available open source variants including HBase and Cassandra."


REFERENCE: 
NoSQL. (2010, May 14). In Wikipedia, the free encyclopedia,retrieved 21 May 2010, from http://en.wikipedia.org/wiki/NoSQL

LGPL

LGPL - Lesser General Public License.

Also counts as the successor of the GNU Library Public License, version 2.

http://www.gnu.org/licenses/lgpl.html

http://en.wikipedia.org/wiki/GNU_Lesser_General_Public_License

mySQL - basics

A note copied from someone blogged in web . Was extremely handy when I was picking mysql commands from here and there ...


Install MySql database:
sudo apt-get install mysql-server

Start MySql server:
/etc/init.d/mysql start

Stop MySql server:
/etc/init.d/mysql stop

Restart MySql server:
/etc/init.d/mysql restart

Check the status of  MySql server:
/etc/init.d/mysql status

List mysql packages
dpkg -l mysql

uninstall mysql server

 apt-get --purge remove mysql-server-5.0

re-install mysql server
 apt-get --reinstall install mysql-server-5.0

 Invoking mysql command-line tool

mysql --user=user_name --password=your_password db_name 

To allow remote connections

http://www.debianhelp.co.uk/remotemysql.htm

Postgres- basics

1. login to postgres -
sudo -u postgres psql postgres

2. Create a database
create database is_db;

3. grant permission
grant all on database is_db to postgres;

in above;
postgres is the user who was created at the time PostrSQL was installed.

4. to navigate to the files system from postgres prompt.
\cd c:cc\vv\vv\v\mmmm

5. run a script
\i postgre.sql

6. quit postgres
\q

Moved to Ubuntu 9.10

After all my effort of fighting away the virus attacks in my WinXP environment, I decided to move to Ubuntu.  I feel the time and resource put on virus scanners, isn't worth it. So I installed Ubuntu 9.10 and setup my test environment there.

This blog is about the test enviro nment setting-up (which can be useful next time I think of a change)

Software that were gathered;

Sun JDK1.6 - jdk-6u2-linux-i586.bin

idea - idea-8.0.tar.gz

ant - apache-ant-1.7.0-bin.zip

maven - maven-2.0.7-bin.tar.gz

tomcat - apache-tomcat-6.0.10.zip

directoryStudio - ApacheDirectoryStudio-linux-x86-1.5.3.v20100330.tar.gz

jboss - jboss-5.0.0.GA.zip 

Installation and setting-up;

Sun JDK

- navigate to folder u hv the bin distro and run it

sh ./jdk-6u2-linux-i586.bin 

OR

sudo apt-get install sun-java6-jdk sun-java6-jre

IDEA

- Unpack the IntelliJ IDEA distribution file

tar -xvz idea-8.0.tar.gz

- Go to IDEA_HOM/bin and type sh idea.sh

ant

Simply unzip the zip distro

maven 

untar the tar.gz distribution

tomcat

unzip the distro

directoryStudio

untar the tar.gz distribution

After installing the software, set the home path in bashrc

-type at promt; 

sudo vi ~/.bashrc

 -Change below;

export JAVA_HOME=/opt/software/java/jdk1.6.0_02
export PATH=$PATH:$JAVA_HOME/bin
export JDK_HOME=$JAVA_HOME

export IDEA_HOME=/opt/software/idea/idea-9013
export PATH=$PATH:$IDEA_HOME/bin

export ANT_HOME=/opt/software/ant/apache-ant-1.7.0
export PATH=$PATH:$ANT_HOME/bin

export MAVEN_HOME=/opt/software/maven/maven-2.0.7
export PATH=$PATH:MAVEN_HOME/bin