Tell Us Which Database You Use Mostly which one you prefer

[yordan 10]

Tell us which database you prefer, and which one you use mostly (they are not necessarily the same).I would say that Oracle is the king today : the most robust on the market, it handles really huge databases, the parallel query feature is really fantastic when you have a quite a lot of disks (let's say some thousands) and a lot of cpu's. Unfortunately, as most of powerful professional things, it's rather expensive.I would say that mysql is currently the most widely used, including in our websites here at astastahost.Maybe my currently preferred one is PostGreSql, it's a rather standard sql language, very close to Oracle, and today it's free. Let's see it it will also become very popular.

[mahesh2k 0]

At workplace i use mysql and MS-SQL express 2008. Most of the clients are using this limited feature express edition and it is working fine for them. Other than these two i've seen two projects with postgres but now a days it is rare to see projects with postgres. I've personally used SQLite for most of my short apps in java/c#. On point of postgres becoming popular, i can't comment much. But looking at the way java and mysql faling in open source community. I can say that postgres has better future later for sure.

[8ennett 0]

I prefer to use MySQL but that is purely based on the fact I am a PHP developer and the two seem to go hand-in-hand. Although PHP does offer functionality for other databases, securing connections and transmitted data and processing the retrieved data from the MySQL database through PHP is a lot simpler and faster. PHP seems to have been developed more toward the MySQL side rather than Oracle or such like as is demonstrated by the extensive mysql_* functions provided with the MySQL include. Also, the majority of PHP tutorials on the web and web hosts all seem to use MySQL as a standard.

[yordan 10]

MySQL database through PHP is a lot simpler and faster

You are partly right. However, you can use oracle with php. For instance, the 4Images Photo Gallery system (https://www.4homepages.de/download-4images ) is obviously a php application. It can use MySQL, but it also uses Oracle, with a local database or by means of the oracle thin client environment.

[8ennett 0]

You are partly right. However, you can use oracle with php. For instance, the 4Images Photo Gallery system (https://www.4homepages.de/download-4images ) is obviously a php application. It can use MySQL, but it also uses Oracle, with a local database or by means of the oracle thin client environment.

True, but the oracle functions don't carry security features like mysql_real_escape_string() so you have to use php to escape the characters in a custom function instead of a single line function.

[yordan 10]

True, but the oracle functions don't carry security features like mysql_real_escape_string() so you have to use php to escape the characters in a custom function instead of a single line function.

Except if you use the thin client, so the communication with the database are inside the Oracle SQL*net protocol, no way to catch the info while listening the IP traffic.

[8ennett 0]

That's very true, which is why with sensitive data such as passwords I always MD5 before sending to the database, and obviously PASSWORD() inside the database query. Mind you MD5 has been broken now so would probably be better to ssl the data instead. But apart from passwords, financial transactions and possibly email addresses, there really isn't any need to secure the data before passing it to the database. I think my main point was there are more web hosts out there that provide php with mysql as apposed to any other database.

[wutske 0]

I've mostly used mySQL, but that of course was because I mostly use databases in a php environment and I don't mind, it's a good, free database and it does what it has to do and the kind of things I do with database aren't realy that complex .I've also worked a bit with MSSQL. I started using it when I was doing a voluntary internship and I must say that it's not bad either. I must say however that the offline front end administration is much better compared to the tools you get with mySQL, but that's probably because you have to pay for them (at least, you're supposed to do so, I get it all for free from MSDNAA ).I now have a small WPF application that works with a MSSQL server and I'm happy with it.

[mahesh2k 0]

MS-SQL server is really good database. And with SQLite administrator things are easy with sqlite. i'm using that small gui for sqlite which is making my work easy with sqlite. Hmm never worked with WPF and MS-SQL server before, have to try that. is it possible to use WPF with other database effectively ?

[BCD 1]

I use and prefer SQLite for my personal projects, as its easier to deploy them. And sometimes MySQL for quick and dirty operations as Working with MySQl is really fast. Apart from that I haven't done much serious work on databases.

[Quatrux 4]

For personal stuff and some projects I usually use MySQL, especially if working with websites, but sometimes for simple projects XML is enough to do the work. Sometimes SQL lite is a good alternative too, but it has it's negatives aspects, same as working with large XML files ;DNevertheless at my current workplace everything is done using Oracle, it's really a powerful Database and offers a lot of stuff, so I mainly work with it.

[vhortex 1]

i personally use MYSQL and ORACLE, some other databases comes in third exception for POSTgre which seem to die out. MSSQL also was on my bin for "not to use".MSSQL seems to be used a lot by corporations to develop software faster (or at least the programmers they hire) but this is a double edge system regardless of version. MSSQL like all software that runs over windows OS tends to crash way often and seeing a message such as "kernel fault/read access error on file <some other file on the remote database MSSQL server accross the network>" which suck pretty much when the system requires accurate data. MSSQL is also known to load locks and rules into its OS memory (windows 2000 and up server). This added more access violation errors.********MySQL on the other hand is light, its database engine can be changed anytime from berkely, INNODB, ISAM/MYISAM and others that comes shipped or attached to your MySQL compilation. MySQL is also cross platform compatible and it is not hard to have a MYSQL server over Windows, LINUX, UNIX, BSD, Mac and other OSes. The program also runs on other custom build OS that can run and open Apache.The main problem with MySQL was it comes out preconfigured to run as a small scale database which is not a problem since you can configure this anytime.********Oracle is much like a big brother to MySQL and support a lot of features and it was also cross platform. I never have any problem from migrating any kind of database into Oracle in exception with MSSQL (though they have an Oracle export on Enterprise editions, they don't really work as expected).Oracle also offers database roll backs if one part of the data failed to update specially if more than 1 table was involved and they must be synced. This can happen without stopping the database instance and all affects the data that was being updated.********I use a lot of combination of databases with my PHP. My current work involves converting a coldfusion system into PHP (security reasons) and connect to MSSQL database. It gives me a headache specially that MSDN is so helpful on problems with the products that they have that it is almost like reading an instruction book on how to repair a submarine when you are just trying to fix your bicycle. Funny thing was that even if you follow the instructions, things will still not work and it will just be dumped to millions of "unsolve" or "solved which still don't work" bin of death. To top all of this, i also failed a lot of times to connect Visual Studio to MSSQL and then boom it suddenly work and then it wont.. In fact I have written intranet company developed softwares that connect to Oracle, MySQL (only guys from MSDN and M$ supporters tells that it is not possible), POSTgre(yes i also connect this one with no problem) and MS Access(much better than MSSQL in terms of connectivity. I also develop 2 softwares that connect to MSSQL, 1 connects without a problem if the MSSQL gets rebooted every 5 days (pretty funny since the Oracle version I have runs with Oracle 9 which never gets booted and was setup and made live 6 months after Oracle 9 was released) and another one that sometimes say that the database server is missing.. ********Also include the migration support, there are thousands of people that knows how to migrate MySQL into MSSQL and claims it was a nightmare and millions of people knows how to do it for free. and out of this millions there are a few hundreds who know how to migrate MSSQL to MySQL using a paid 3rd party service that cost at least $200 for a 1 year license.. I already know and solved migrating database from and to MSSQL and MySQL after a very painful battle with MSSQL and also I already know how to attached that M$ product to apache/php..

[frazz86 0]

I like to use Mysql just i seems easiest for use and i find the best and i didn't really know there were others out there it seems Mysql is the most used of them all in websites so i have to use it lol but i do prefer it, i have tried the others and don't really like them and like 8ennett said PHP=mysql they go hand in hand really most Php scripters use it

[vhortex 1]

I like to use Mysql just i seems easiest for use and i find the best and i didn't really know there were others out there it seems Mysql is the most used of them all in websites so i have to use it lol but i do prefer it, i have tried the others and don't really like them and like 8ennett said PHP=mysql they go hand in hand really most Php scripters use it

On some..

PHP = Oracle, MySQL and Postgre..

I think postgre is on a development end since it was having less and less exposure and use. For ordinary websites and hostings, you will always get MySQL since it was free but you can always have the hosting install Oracle which operates faster but have more rigid locking and multi user mechanism or you can just set it up to run like a clone MySQL server.

Oracle is not free and cost a huge amount of money for the license. Using it requires adding a few library files for Oracle to your PHP installation. This libraries will enable you to access Oracle on a manner similar to accessing MySQL server. The library is free but the database server software was not.

[Vistz 1]

I primarily program in Java and I'm trying to integrate Java with databases. Most of the examples I've seen use MySQL databases but I've seen some instances where an oracle database is used.