Most intelligent database technique: For PostgreSQL and MySQL
Man invented computer because his brain is very slow - today Intel
cpu runs at 1.5 gigahertz!!.
The speed is doubling every 15 months .. this will go on for the next 40
years.
But software is the most time consuming effort - it requires millions of
persons
coding and banging on the computer keyboards.
Each and every person in the world is asking - "How come Al Dev (that is
me), single
handed is checking the software quality of pgsql and mysql????!!!!
PostgreSQL (and MySQL) is written by millions of persons from
over 300 countries in the world!!
Answer is very simple - I (Al Dev0 simply use the very high speed linux
box and
run the regression test package of PostgreSQL and
see if it runs ok and results tally!! And do you know - I "hire"
thousands
of guys from internet to write the regression test package!! Bigger the
regression package
the better it is. Make the regression package about 10 million lines of
code.
Regression test package is the most important package in PostgreSQL.
Regression test package is a very "SOLID TECHNICAL DOCUMENT" mutually
agreed
between millions of developers and millions of users of pgsql!!
Whatever commands pass in regression test is supported by pgsql and
others
may run (if they run you add it to test package!)
In hindi - "database bahooth mainga padega, jee haan!! Yeh apne se nahin
hota".
(Developing a SQL database is very expensive. Yes sir!! It is impossible
for India to create a SQL server
It takes 25 years to create PostgreSQL).
Now, I tell all the countries - "USA, Russia, Germany, France, Japan,
UK, Italy, China, India, Malaysia
all others must work together and create just ONE GOOD SQL server"
Every minute of your time is costs about $3 US dollars.
If Larry Ellison and Bill Gates reads this message they will get
very alarmed!!
Read the article - "How can I trust PostgreSQL" in
http://www.aldev.8m.com and click on PostgreSQL howto