Which kind of SQL database do you use?

Which kinds of SQL databases do you use/have you used? Most people use MySQL because its simple to use, free, widely compatible, and included with most hosting accounts. Other common alternatives to MySQL are PostgreSQL, MSSQL, Oracle, Firebird, and SQLite. I mainly use MySQL for my projects because of its availability and ease of use. At work, I run an MSSQL server. As most of you know, its a Microsoft commercial product. I do like MSSQL because of the amount of tools you have at your fingertips when administrating a MSSQL server. You also generally have direct physical access to your database server so you can perform your backups very frequently and quickly.
Back onto the topic of MySQL, for those who don't know, you can actually download and install it on your own computer. This is useful if you want to create a testing environment that you can use before putting your content up live on the internet. You could also utilize MySQL on your local system if you really want to use your own PC as a web server.
I will get discuss that subject a bit more at a later time, but in the meantime, what database software do you use? Have you ever branched out and tried other database software?

PostgreSQL has some additional features not included in MySQL. I believe Postgre supports subqueries while MySQL doesn't. I think there are some other differences between the features but I am not all that familiar with those differences. The main thing I hear about MySQL is that many of it's new features have been around in Postgre for much longer (stability). I'm sure its not a deal breaker to most people but some database admins find these features vital. MySQL was designed with speed in mind while Postgre was designed with advanced features in mind. Because of that, I often hear from people that MySQL runs faster than Postgre. MSSQL offers probably some of the most advanced tools for managing triggers and procedures. I generally notice though that MSSQL is slower than MYISAM tables in MySQL since it was designed to be lightweight and fast. Another thing to consider is compatibility. Pretty much all forum software supports MySQL but most don't support the other databases. vBulletin only supports MySQL. IPB only supports MySQL and MSSQL but charges an extra $75 for the MSSQL driver. On the other hand, phpBB supports MySQL, PostgreSQL, MSSQL, Firebird, SQLite, and Oracle.

i use MYSQL data base to perform operations The main thing I hear about MySQL is that many of it's new features have been around in Postgre for much longer (stability) i found MySQL hard enough to grasp so moving to something else would be very much ugly as this is the best database.

When it comes to performance, MySQL will trump Postgres every time.

That seems to be the general consensus. And it really shows in the way how MySQL is the most popular database available. Supposedly Postgre has gotten quicker than it used to be, but if you truly want a fast, lightweight and easy to use database, MySQL appears to be the most prevalent choice.

Also, only one of them is a true RDMS, guess which one? Can't find the link to the article I read a while back, but MySQL crushed MSSQL and other big DB engines in performance tests, and was only a tiny bit slower than Oracle.

Have you ever used Oracle? It is pretty much the only one of those systems I haven't used at some point in time yet but I heard its very solid.

I haven't used Oracle, just see it mentioned in the comparisons.

Ah ok. I might give it a try one of these days to get a first hand look at how it compares to the rest.

Different types of SQL db's? i've only used the most common one, MySQL.

My sql is a best backend process for any projects...because it not only serves for microsoft products but also it supports with other technologies one of them is php which is widely used now...because it is faster than other technologies...combined with this both php and mysql a better and best projects can be done .....for more best projects and other cms technologies ...check out by just clicking below the message....

I have worked with MySQL till now and now want to write a code which can run on MySQL as well as Oracle.
Is it possible? If yes what things I need to care about. Any tutorials?

Yes, in the past working for some banks and telecoms. Actually Oracle fits mainly for high-load, high-demand, high-end corporative environment with its robustness and high scale reliability. And there is no reason - cost and resource-wise - to use it for a web project, unless you'll be running next Facebook or PayPal.
As you said PostgreSQL has the needed enhancements ( subqueries, triggers, stored procedures and the like ) while fitting in the price/resource mid-niche ( free/lightweight ).

I'm using Mysql. I know only about mysql. Don;t know others

Re:

Hi

I am using MySQL and if I wan to select alternative I would like to opt PostgreSQL. According to my knowledge, MySQL is believed to be faster than PostgreSQL, but developers seem to prefer PostgreSQL when it comes to variety of features, since MySQL is seen as basic, and well suitable for novice like me The person who use Oracle also tend to prefer PostgreSQL.

Actually both have an astonishing range of features that increase data integrity, functionality, and performance. However MySQL is slightly popular between different open source web development packages and that the reason my vote goes to MySQL. However, PostgreSQL has more popularity in experienced developers Community, specially those who willing to work with Oracle and SQLServer experience.