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