I am now in big dilema too, i just don't know what Database server i should choice :-( Right now i am make my own project that will contain 2 big games (with alot of lines code), one game going be strategy and secon RPG. From start i will host in my own computer,
but then if it will go realy good i will need move to some hosting provider, and here my problems can start. I mean if i choice use FirebirdSql now, then i will have very very dificult time to find hoster that have firebirdSql, and i will need rebuild all
my code that connect to database and also all my stored procedures, but from ather hand FirebirdSql can be great in start since it fast, can work with big databases and alsow allow big amount of connections in some time. And if i choice MySQL i willnot have
any problems to find hoster, but i am not sure about MySql ability work with big databases or big amount of connections per some time. So, my situation pretty bad :-( And i have no idea what i should choice now :-(
I created my games, and they was using flatfiles (ini) and .dat to store data. I switched over to mySQL, and in the process of switching over to FireBirdSQL. If you are actually creating your own game (not using some prefab stuff), get a dedicated server for
$99/mo. Then you dont have to worry about rigid hosting, and can install whatever you want, whenever you want. mySQL is great if you are not using it for forums/messengers/news/kb, any kind of software that require the use of strings/text, and parameters.
This usually include all games. I would still recommend FirebirdSQL over mySQL since it includes real parameter support AND triggers AND procedure steps :) A very good combo. Unfortunately, from what I heard, it's not as fast as mySQL, an does not provide
DSN-less connections which is another big slow down.
I am not so sure that you can install your own software on dedicated server. Are you sure about this ? I also heard that FirebirdSql and Yaffil (they both clones of InterBase) databases make migration for they project, and it actualy will be in FirebirdSql
2.0 , and it's great news.
Hmm, you have no idea what a dedicated server is, do you? Its a server you rent out usually on a monthly basis, that you can install whatever you want on it.... I havent heard of the other database, is it free? FirebirdSQL looked great a the first couple of
glances, but the slowness is killingit.
Yes, in that we agree :) But do you still need to work with vb6? that sucks.... If you can use .NET you have a native provider for FirebirdSQL as you already know
I tend to gravitate towards programming languages (vb6, vc, asm, delphi) over scripting languages (vbscript, .net, perl, php). I use vb6 to maintain and enhance any applications I aquire/buy, with the intention of converting them over to asm (forget the c junk).
However, as it stands, I use the .NET scripting languages for web development (server side), and some in-house tools (not for public release). Using it for a client or any desktop application is pure business suicide, so I do not use it for that. Im going
to create some libraries to interface Firebird with ASM, but until that time, I'll be using it with VB6. There's a migration tool for IBExpert (plugin) that requires ODBC for migrating from mySQL to Firebird.. I installed both the .NET provider and the ODBC
driver, does not work in any case. The only way I can work with databases is to create a connection to a "remote" server, using the localhost as the IP.. bah! This effectively makes the migration tool worthless for me :(
Shannara Thanks for answer about dedicated server, i never used it, so i didnot knew. I am not agree that .Net give you scripting languages for web. C# , VB.NET and VC++.NET , they not scripting languages.
fetcher
Member
635 Points
127 Posts
Re: Any advantage in using Mysql?
Dec 02, 2003 03:59 PM|LINK
vergilius
Member
430 Points
86 Posts
Re: Any advantage in using Mysql?
Dec 03, 2003 07:35 PM|LINK
Shannara
Member
425 Points
85 Posts
Re: Any advantage in using Mysql?
Dec 03, 2003 09:29 PM|LINK
vergilius
Member
430 Points
86 Posts
Re: Any advantage in using Mysql?
Dec 03, 2003 09:58 PM|LINK
Shannara
Member
425 Points
85 Posts
Re: Any advantage in using Mysql?
Dec 04, 2003 04:40 PM|LINK
fetcher
Member
635 Points
127 Posts
Re: Any advantage in using Mysql?
Dec 04, 2003 05:21 PM|LINK
Shannara
Member
425 Points
85 Posts
Re: Any advantage in using Mysql?
Dec 04, 2003 06:49 PM|LINK
fetcher
Member
635 Points
127 Posts
Re: Any advantage in using Mysql?
Dec 04, 2003 09:58 PM|LINK
Shannara
Member
425 Points
85 Posts
Re: Any advantage in using Mysql?
Dec 04, 2003 10:33 PM|LINK
vergilius
Member
430 Points
86 Posts
Re: Any advantage in using Mysql?
Dec 05, 2003 08:29 PM|LINK