Jump to content
  • Advertisement

Archived

This topic is now archived and is closed to further replies.

Jehoshaphath

Users database question

This topic is 5913 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Hi. I''m making an online RPG. What''s usually used to store all the info for the user ID''s and stuff? an existing database (ie: access), or a personal file system?

Share this post


Link to post
Share on other sites
Advertisement
HI

I think this is one of those rare chasees when it''s best NOT to reinvent the wheel.

Use an off the shelf Database, preferably not Access. Use an SQL DB such as Microsoft''s SQLServer, or MySQL (free and open-source !). With this you can use Stored Procedures to help speed things up a bit.

Hth

necr0

Share this post


Link to post
Share on other sites
which one of those would you recommend?

If I'm holding information like battlenet (filename=player name, one filename per player, etc.), would you still recommend one of those engines?

Tnx.

[edited by - Jehoshaphath on July 17, 2002 12:03:56 AM]

Share this post


Link to post
Share on other sites
I liked that Necr0

If you are producing a system you expect others to deploy I would use MySQL as it has the lions share and from your point of view probibly cheaper to deploy to test.

However, I would be careful to encapsulate the database code so that changing it from one system to another would be a pretty trivial exercise.

Regards

BaelWrath

If it is not nailed down it''s mine and if I can prise it loose,
it''s not nailed down!

Share this post


Link to post
Share on other sites
Hi

Jehoshaphath : I would never use a flat file system for information storage like that. The only time I would use a personal file system is to get something up and running quickly.

I am going to recommend MySQL (as it is free), unless you can afford MS SQLServer.

Share this post


Link to post
Share on other sites
quote:
Original post by necr0
MySQL (free and open-source !). With this you can use Stored Procedures to help speed things up a bit.



MySQL doesn''t support stored procedures, and there''s no plans in the near future to support them (it would mean also supporting some sort of scripting language, and there''s lots of debate about which language to use).

MySQL is good though, so I still recommend it.


codeka.com - Just click it.

Share this post


Link to post
Share on other sites
Guest Anonymous Poster
Why not use MSDE (Free version of MS-SqlServer)

Share this post


Link to post
Share on other sites
FreeBSD & Apache Webserver w/ MySQL
mainly because its all free all you need an ip or two and some memory to partition. =P

Share this post


Link to post
Share on other sites
Hi

If you do use MySQL here are a couple of useful programs to get :

MySQL Navigator : A GUI for MySQL

mySQL++ : C++ MySQL API

Hth

Necr0

Share this post


Link to post
Share on other sites

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!