dev-cpp-users

[Dev-C++] Which database to use ???

[<A_B...@gm...>]

Hi,
I whant to create an advanture game.
To store all the datas I whant to use a data base.

First I tried to implement MySQL but don't get it to work...  :(
I've got the latest MySQL version (incl. MyODBC) and the MySQL-DevPak installed.
I used to test it with the sample projekt from the DevPak but can't get any connections to the 
data base... 

Well, MySQL also seems not to be the right DB for use with my project...

Which data base I can use instead - and how ???
Or can someone tell me how to connect to an MySQL DB, maybe with an example source ???

thx, Acki

Re: [Dev-C++] Which database to use ???

[Daniel K. O. <dan...@ya...>]

A.Buschhüter wrote:

>I whant to create an advanture game.
>To store all the datas I whant to use a data base.
>  
>

Is it really needed? Can't you just use a binary file like almost every 
game does?

>First I tried to implement MySQL but don't get it to work...  :(
>I've got the latest MySQL version (incl. MyODBC) and the MySQL-DevPak installed.
>I used to test it with the sample projekt from the DevPak but can't get any connections to the 
>data base... 
>  
>

Did you try first running the MySQL database (so you'll have something 
to connect to)? Just a guess, because you didn't mention that your MySQL 
server is running in your e-mail.


>Well, MySQL also seems not to be the right DB for use with my project...
>  
>
>Which data base I can use instead - and how ???
>  
>

Unless you really need multiple clients accessing your database at the 
same time, you'll probably be satisfied with SQLite (it doesn't need a 
db server, so it's faster). That is, if you really need a SQL database.


Daniel K. O.

Re: [Dev-C++] Which database to use ???

[Les F. <lh...@xt...>]

A.Buschhüter wrote:

>Hi,
>I whant to create an advanture game.
>To store all the datas I whant to use a data base.
>
>First I tried to implement MySQL but don't get it to work...  :(
>I've got the latest MySQL version (incl. MyODBC) and the MySQL-DevPak installed.
>I used to test it with the sample projekt from the DevPak but can't get any connections to the 
>data base... 
>
>Well, MySQL also seems not to be the right DB for use with my project...
>  
>
I am sure that MySQL is more than adequate.  Like most databases, you 
need to read the instructions for it and configure a username/password 
for access rights (the default admin user and password from installation 
will probably do for testing purposes).
The details of this user, the host and database name all need to be used 
in the database connection string to get a connection to work.

I do not know which example code you followed, but I am sure it 
contained a connection string or a series of connection parameters, 
which you modified to match your local database settings.  Those details 
and the results of your debugging from attempting to run the code, may 
be useful information when you ask here for assistance.

There are other issues tho, if you want a quick light database back end 
to an application, maybe SQLite or similar would be better for a 
distributed app, as the MySQL database must be installed and executed as 
a separate background service.

-- 
Les Ferguson

Re: [Dev-C++] Which database to use ???

[David M. <ci...@ya...>]

There is an embeded version of MySQL, possibly the OP could use that
to reduce the memory footprint.

--- Les Ferguson <lh...@xt...> wrote:
> A.Buschhüter wrote:
> 
> >Hi,
> >I whant to create an advanture game.
> >To store all the datas I whant to use a data base.
> >
> >First I tried to implement MySQL but don't get it to work...  :(
> >I've got the latest MySQL version (incl. MyODBC) and the
> MySQL-DevPak installed.
> >I used to test it with the sample projekt from the DevPak but
> can't get any connections to the 
> >data base... 
> >
> >Well, MySQL also seems not to be the right DB for use with my
> project...
> >  
> >
> I am sure that MySQL is more than adequate.  Like most databases,
> you 
> need to read the instructions for it and configure a
> username/password 
> for access rights (the default admin user and password from
> installation 
> will probably do for testing purposes).
> The details of this user, the host and database name all need to be
> used 
> in the database connection string to get a connection to work.
> 
> I do not know which example code you followed, but I am sure it 
> contained a connection string or a series of connection parameters,
> 
> which you modified to match your local database settings.  Those
> details 
> and the results of your debugging from attempting to run the code,
> may 
> be useful information when you ask here for assistance.
> 
> There are other issues tho, if you want a quick light database back
> end 
> to an application, maybe SQLite or similar would be better for a 
> distributed app, as the MySQL database must be installed and
> executed as 
> a separate background service.
> 
> -- 
> Les Ferguson
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle
> 10g. 
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Dev-cpp-users mailing list
> Dev...@li...
> TO UNSUBSCRIBE: http://www23.brinkster.com/noicys/devcpp/ub.htm
> https://lists.sourceforge.net/lists/listinfo/dev-cpp-users



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 

Re: [Dev-C++] Which database to use ???

[Axel B. <new...@th...>]

A.Buschhüter wrote:

> I whant to create an advanture game.
> To store all the datas I whant to use a data base.
> Well, MySQL also seems not to be the right DB for use with my project...

I really think so, too.

> Which data base I can use instead - and how ???

ah well ... I really don't think you need a complete enterprise grade
sql database for your adventure game :-)

why not trying
	- berkeley db: http://www.sleepycat.com
	- sqlite: http://www.sqlite.org

pro's: both are embedded and thus simply part of your program without
the need of an external server (mysql)
the docs of both are quite good, the berkeley docs are excellent (I used
it in several projects to up to now)

cons: berkeley is a key -> value db, without any own language.


hope that it helps.


ciao,

axel.

Re: [Dev-C++] Which database to use ???

[Peter B. <pb...@hg...>]

A.Buschh=FCter wrote:
> Hi,
> I whant to create an advanture game.
> To store all the datas I whant to use a data base.

Have a look at http://www.sqlite.org/

peter