Sign in to follow this  
Butabee

SQL softwares?

Recommended Posts

I'd like to use MySQL, but I don't really want to pay for the license or open source my game. I'm wondering if anyone knows of any other free SQL database software that performs well. I'd be interacting with the database about every 30 seconds for each of my games region servers to take a snapshot of all player/monster/world data. I don't know for sure yet but I'm guessing I'll have about 60 different regions.

Share this post


Link to post
Share on other sites
Are you using MySQL on the client, or on the server?
The GPL generally requires you to supply source code with any shipment of binaries that link against GPL code.
If you only use MySQL on the server, and you don't ship the binaries anywhere, then, according to the GPL (at least version 2 -- haven't read up on 3 yet), you don't need to ship your source to anyone.

That being said, PostgreSQL and SQLite are also great packages; PostgreSQL as a slightly more "enterprisey" database (nested transaction support, etc), and SQLite as the simplest, lightest solution to structured storage you can find. If you want to use SQL in the client, I would recommend SQLite.

Share this post


Link to post
Share on other sites
I'd be using it only server side I think. I'd want to use it just between my characters/login and region servers. I'd also need to connect to it through a browser for account management.

So I think just server side.

I might just use PostgreSQL to avoid any possible unforseen problems though.

Share this post


Link to post
Share on other sites
Personally I find PostgreSQL to be a much nicer database system to work with than MySQL.

I've never really had the chance to use a commercial database product (other than a very brief encounter with Microsoft SQL Server 2008 Dev edition) but it seems to support just about everything you could want with decent documentation to boot.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this