Archived

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

Jehoshaphath

Users database question

Recommended Posts

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