PDA

View Full Version : which database do u use ??



moemen ahmed
08-26-2003, 04:27 AM
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.

moemen ahmed
08-26-2003, 05:45 AM
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 !! :-)

adrianxw
08-26-2003, 08:30 AM
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.

Quantrizi
08-26-2003, 09:15 AM
I use MySQL majorly, but when I want to do something on Brinkster I use Access (yuk!)

DISGUISED
08-26-2003, 01:23 PM
Oracle at work. MySQL or PostGreSQL for side projects (cost is always a factor).

Perspective
08-26-2003, 03:37 PM
Oracle at school. A very good DB from what ive experienced.

Speedy5
08-26-2003, 04:44 PM
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.

confuted
08-26-2003, 04:53 PM
MySQL, because I have no idea what I'm doing and my good buddy Mackrory is helping me get it set up ;)

Quantrizi
08-26-2003, 05:02 PM
MySQL is the next biggest thing (1rst is Access I think, either that or SQL).

DeepBlackMagic
08-26-2003, 06:39 PM
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

Quantrizi
08-26-2003, 06:42 PM
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:



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

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


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

DISGUISED
08-26-2003, 07:18 PM
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.

DeepBlackMagic
08-26-2003, 10:27 PM
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)

Hillbillie
08-27-2003, 10:58 AM
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. ;)

vasanth
08-27-2003, 11:12 AM
used Access for my pet ASP project and Oracle both at Home and College to lear what else.. Oracle..