MYSQL -> getting started tips

[Alex]

Hey all,

gonna get started on an ambitious project... i have good MS Access and general database concepts knowledge and i've been monitoring our sql server and app here at my job for a while so i think í'm ready to take the plunge...

friend and i were asked to develop a database and gui for a small company. my friend is a good delphi programmer but knows nothing about databases so thats where i come in...


i'm gonna download mysql tonight and play around with it but i was just wondering how tough its gonna be to set up a simple database and make it ready to work with Delphi.

Also, i'm wondering how sql behaves in a network environment... in the past i tried something similar with VB6 and MS ACCESS and it didn't work well in a network cause the database would be read only if one person was modifying it etc... i was wodnering if sql is better for that or if the networking, multiple user accessing at the same time issue will have to be worked out in delphi?

looking forwards to the replies!! thanks all!

-frang

 

[kamper]

What 'Delphi' is this? Pre-.net? There's a whole lot of RAD stuff out there for data apps with delphi, gui components that talk straight to the database and such through the BDE (Borland Database Engine). I'm not sure how well all that supports mysql but googling stuff like "delphi", "bde" and "mysql" together should give you some indication (unless someone here has actually done something similar).

If it's delphi.net, I'm sure there's just as much, if not more, integrated database support (like you'll probably never write, or even see, a real sql query).

Any real database is designed very specifically to be able to handle multiple concurrent sessions. You still have to know how to use transactions, so that your data not become inconsistent, but mysql itself will (in theory) never become confused.

One other thing I'd suggest is to check out postgres as well. Maybe you have requirements for mysql and that's fine, just wanted to make sure you knew that mysql isn't the only (or even the best in some people's opinions) free database.

 

[Alex]

Originally posted by: kamper
What 'Delphi' is this? Pre-.net? There's a whole lot of RAD stuff out there for data apps with delphi, gui components that talk straight to the database and such through the BDE (Borland Database Engine). I'm not sure how well all that supports mysql but googling stuff like "delphi", "bde" and "mysql" together should give you some indication (unless someone here has actually done something similar).

If it's delphi.net, I'm sure there's just as much, if not more, integrated database support (like you'll probably never write, or even see, a real sql query).

Any real database is designed very specifically to be able to handle multiple concurrent sessions. You still have to know how to use transactions, so that your data not become inconsistent, but mysql itself will (in theory) never become confused.

One other thing I'd suggest is to check out postgres as well. Maybe you have requirements for mysql and that's fine, just wanted to make sure you knew that mysql isn't the only (or even the best in some people's opinions) free database.

thanks for the reply! 🙂

very informative post!! :beer:

ok so good to know mysql can handle multiple concurrent sessions... i did some searching of my own and found some good delphi & bde links that might help us out...

my buddy says hes good at delphi etc but i think he's way in over his head... so i wanna find out as much as possible about this before actually taking the project cause it involves a great deal of responsability