What database do you use and why?

[ViperGTI]

I only use MS SQL. Since I develop only in .NET, I decided on that as my standard. If the client doesn't want to pay for a db engine, then I simply recommend the free edition of MS SQL (SQL Express). Since SQL Express (for smaller clients), I've never had the need to experiment with other engines and since 90% of my clients have MS SQL already.

 

[_Hecate_]

Mssql work uses it and I only use it for data extraction/manipulation anyway.

 

[Solitude]

Pervasive PSQL and MSSQL mostly.

 

[Sparkz0629]

Sybase and Oracle... for work...

Microsoft Access for home

 

[SQLGuru]

for work purposes:
Sybase IQ
MSSQL
Oracle
MySQL

soon to be accompanied by:
SAP HANA

 

[Raithlin]

MS-SQL for .Net projects, MySQL for PHP projects, whatever work throws at me otherwise (UniVers / DB2 / ADABAS)...

 

[karnuffel]

for work purposes:
Sybase IQ
MSSQL
Oracle
MySQL

soon to be accompanied by:
SAP HANA

Using mostly MSSQL by have been forced/asked politely to use MaxDB and DB2 a few times. Cant wait for a project using HANA!!!!!

 

[rward]

MySQL

You use the db that's best paired with the language you're in AND OS you run. There are exceptions to the rule of course.

The only reason why I'd say the "because it's open source yay" argument holds water with choosing MySQL is if you actually do custom builds for the projects you're busy with. However, to me that's just stupid since if your application is supposed to go to clients, you need to worry about, not only your application, but the build of their MySQL which can get to be a big pain in the ass.

You could also be using a database abstraction layer.

That way you don't have to worry about what you're doing development on or what your client is using.

 

[Other Pineapple Smurf]

PostgreSQL because MySql is for noobs

Sent from my Transformer TF101 using Tapatalk 2 Beta-4

+1

I only use MySQL as thats what I clients use, for personal use its PostgreSQL all the way.

 

[shogun]

MSSQL
MySQL (using this mostly now as the deployment cost is non existent for a self hosted server, and it comes with replication without having to fork out tons in licensing, or having to allow an SPLA licensor access to the server)
SQLite
SQLCE

Depends more on licensing requirements, or deployment requirements than anything else. MySQL works just fine with .Net I have found... but I still prefer MSSQL because it is simpler to use and understand, and you cannot beat the tools available (Management Studio > MySQLWorkbench 100 times over).

 

[zippy]

Sybase and Oracle... for work...

Microsoft Access for home

There should be a law against referring to Microsoft Access as database software

 

[froot]

There should be a law against referring to Microsoft Access as database software

I do agree with you there. But thing is, the OP said database. Not RDBMS

 

[iceman_coolasice]

MS SQL 2008 R2 definitely. Rishan Singh