Thread: Database API?

  1. #1
    Registered User taelmx's Avatar
    Join Date
    Oct 2006
    Location
    Japan
    Posts
    55

    Database API?

    I'm designing an MMORPG and was wondering what would be the fatstest way to store stats and such in a database. I was thinking that you could store stats, items, and other things in an SQL database, but I have no clue about database programming. I'm using IRRnet and IRRlicht for the engine. The network connection is ok, its just the database that I need to decide on. I need something that can keep up with about 5 querys per second or faster. Like when the player picks up an item or gets money.Most of the real time part of the game will be done directly through networking. Hacking is only a concern for the database. Speed hacks and teleporting hacks are not that much of a deal for the game; they won't affect other player's stats or anything. Thanks ;D

  2. #2
    Cat without Hat CornedBee's Avatar
    Join Date
    Apr 2003
    Posts
    8,895
    5 queries per second is nothing. Every database can do it easily.

    I recommend SOCI as an access library. It provides a pretty generic interface.
    http://soci.sourceforge.net/

    Then the backend is not that important anymore.

    Alternatively, you could use an embedded engine like SQLite. It has the advantage of not requiring a separate server process, but it is a bit slower than other DBs.
    All the buzzt!
    CornedBee

    "There is not now, nor has there ever been, nor will there ever be, any programming language in which it is the least bit difficult to write bad code."
    - Flon's Law

  3. #3
    Registered User taelmx's Avatar
    Join Date
    Oct 2006
    Location
    Japan
    Posts
    55
    Wow nice! That will probably a good start...;D

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Creating a database
    By Shamino in forum Game Programming
    Replies: 19
    Last Post: 06-10-2007, 01:09 PM
  2. Replies: 10
    Last Post: 05-18-2006, 11:23 PM
  3. FILES in WinAPI
    By Garfield in forum Windows Programming
    Replies: 46
    Last Post: 10-02-2003, 06:51 PM
  4. Database Library or Api
    By face_master in forum C++ Programming
    Replies: 1
    Last Post: 11-02-2002, 07:49 AM
  5. Database frontend in API
    By Robert602 in forum Windows Programming
    Replies: 1
    Last Post: 01-29-2002, 09:07 PM