some1

Guys I`m going to create an big (at least for me) app which will use a database to store its data. However I have no knowledge of database programming so anyone has any suggestions?

I though of using mysql since I already have knowledge of it but I don`t want my app to require mysql server to be installed since not everyone knows where to find it and how to set it up.

Infinite Recursion

MySQL is the way to go in my opinion. If you plan on using a database... either the users have to have the client, or you have to have a DB connection to a central server that you control, which also implies your users have a net connection. If you don't want to go this route, I suggest a delimited text file to hold your values.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

Pizentios

i have made a few apps where the client has the front end, and it connects to one central db (postgresql :-)). It runs quick and stable, i have very good luck with it.

http://tangentsoft.net/mysql++/

That's the API that you'd want to use. Aparently there are a few examples to get you going in the archive that MySQL++ comes in.

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!

some1

thanks for the help

isn`t there any support in windows for msaccess dbases?

Ooble

Of course there is. It's just that Access likes to crash a lot.

__________________
Me :: You :: Them

ZenMasterJG

I'd just like to say that for any big-ish project, delimited text files should probably be avoided like the plague, they're unreliable and really, really prone to corruption in my expiriance.

Pizentios

access isn't good. It doesn't even really use real sql. It uses some half breed abomonation that M$ made up. Also, it's really not stable at all, you'd be better off to save your self some head aches and just grab up a free copy of mysql or postgresql. Although, access does have it's advantages, you can set up a vb program with it in a mater of hours. It might not look good or function right, but it'll be there :-)

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!

some1

I`m going to make a client management app which will store all clients, their visits, their payments in detail etc so it won`t be THAT complex, all I need is to be able to store data in tables and make table relationships (or isn`t that the word?)
Dunno if msaccess can to all these

I`m a step before choosing mysql, I`m just looking for a easy to setup database system (because as I said before, not everyone knows where to find it and how to set it up) and easy to backup.

Anyone can point me to a msaccess tutorial/doc as i couldn`t find one? I`ll just check it before I go with mysql

Berto

msaccess avoid worse then you would avoid the plague, i would prefer to have the plague then use that program.

Anything more then 10 users it dies, anything more then about 5k records it takes a lto of processing, and time :/

some1

I actually need one user My application will be the one to query it and thats on the same computer, no remote access.