which database do u use ??

Hi everyone,
i was wondering about what kind database r most familiar to be used by programmers here, and im curious to know the resons behinde the choice.

ur completley right salem . sorry for that stupid poll , i dont know how was i thinking when i post it , but its mostly because of the sleep shortage :-((

what i was trying to get , some advices and tips about the available choices of databases ... so i can make up my mind before paying alot for an Oracle courses which i attend to to join,

please reply and tell me about ur choice of database( and why )

thx in advance !! :-)

At home, I mostly use InterBase because it comes free with Delphi Professional and is easily good enough for my demands. I also have SyBase at home, but it's a bit resource intense, so I only use it when I have a good reason. The job before last was at a SyBase house.

I use MySQL majorly, but when I want to do something on Brinkster I use Access (yuk!)

Oracle at work. MySQL or PostGreSQL for side projects (cost is always a factor).

Oracle at school. A very good DB from what ive experienced.

I use MySQL because its easy to set up, use, interact with and edit. And because its free and integrates with (oh hell no... please...) php for my webpages.

MySQL, because I have no idea what I'm doing and my good buddy Mackrory is helping me get it set up ;)

MySQL is the next biggest thing (1rst is Access I think, either that or SQL).

MySQL is by far one of the best. Its free, and powerful. Both work and play, we bet you'll say, mysql is best for what you pay =P

Quote:

---

Originally posted by DeepBlackMagic
MySQL is by far one of the best. Its free, and powerful. Both work and play, we bet you'll say, mysql is best for what you pay =P

---

Catchy tune. ;).

I think MySQL itself is easier than any other DB out there. In access connections are hard to remember, where as in php you just do this:

PHP Code:

---

$username = "";
$password = "";
$host          = "";

mysql_connect($host, $username, $password); 


---

If it's running off of your computer, you might just need the host, and username.

Actually in terms of functionality and advanced features (stored procedures, triggers, table inheritance etc.) PostgreSQL is much better than MySQL. It also provides SQL92/SQL99 language support. Yes, it's open source as well.

Yes but i have never got postgre to work with my stuff. (yes this is a personal issue, on a freebsd box. it has slightly left me soured toward postgre and its possibly unfair.) Ease of instaliation, use, implimentation and upgradability is just as important as advanced features. Besides, if your running a mission critical app that needs those ultra-advanced features, your probablly going to be using something that is considered more commercially secure. (not that its more or less secure, but more acceptable. There is wide spread mistrust of free software in businesses, unfortunately, and perception of management is reality in business)

For ASP, I use Access for developing (on my box) and SQL Server when deployed.

For PHP, I'm using MySQL for both development and deployment.

I'd love to get my hands on some Oracle, though. Not sure if I'd know how to turn it on. ;)

used Access for my pet ASP project and Oracle both at Home and College to lear what else.. Oracle..