Relational Databases

[mike]

What does everyone here like to use for creating relational databases?

 

I need to write an inventory tracker that posts and has re-order points.

 

thanks in advance

Edited January 30, 2006 by mike

[stevevan]

MySQL for me...because it's just as powerful as anything out there and, the best part, it's FREE! And because I like working with databases (have an Oracle DBA), I usually code mine by hand.

[sdempsey]

What does everyone here like to use for creating relational databases?

 

I need to write an inventory tracker that posts and has re-order points.

 

thanks in advance

If you prefer to work visually using a DB administration GUI then you can always use MySql front.

http://www.mysqlfront.de MySQL really is a great database. One of the fastest with a good overall level of standards compliance (ANSI-SQL). Hope this helps.

[mike]

I have never used mysql but will take a look.

Sounds good.

But can you create stand-alone applications with it for inventory that

always tells you how much inventory you have left, etc.?

 

I used to program applications in access and alpha.

 

they are claiming that Alpha 5 is good. But around $500.00 for the runtime version to distribute

apps.

 

thanks

Edited January 30, 2006 by mike

[btrfld]

If you like Access as a front end, you can use it to manage a MySQL database.

 

Check out how here: h*tp://www.itc.virginia.edu/desktop/web/mysql/msaccess.html

[stevevan]

You can use MySQL for anything that you would use something like Oracle for. Of course, each program will have its pluses and minuses...depending upon whom you talk to.