SQL intergration with Torque Script
by Wayne Taylor · in Torque 3D Professional · 02/21/2011 (10:59 am) · 2 replies
Hello all,
Crimsoneye Games is due to release a series of plugins for Torque3D. We are looking at a 2D solution.
First is a SQLite plugin that will give your game it's own in-built database. From here you can call database scripts giving your game extra functionality. This is ideal for stand alone games of large size and complexity.
Second is a web based game plugin that can run SQL commands from torque to any resolvable SQL database. You would then run the game through IIS or a web provider. This gives Torque extra power for indie developers who want to create MMO's with a resolvable database. This also gives you a more practical way to back up data.
Advantages of this;
You can call multiple SQL databases.
High Availibility possible with 1 database multiple server front ends.
Users not familiar with SQL can use just Torque script.
Stil has security from end users.
This makes backups easy for your important data.
Remote servers can be used however security layers advised.
Web based games not required but this is not advised for a client server environment for your own security.
We intend to integrate with multiple SQL platforms for ease of use.
I am keen to hear peoples ideas on this. Would you use this?
We hope to have some beta testers for the first release in just over 1 month after alpha testing.
This was originally designed for us but wanted to know if others were interested.
Thank you
Wayne Taylor
Team Lead
Crimsoneye Games
Crimsoneye Games is due to release a series of plugins for Torque3D. We are looking at a 2D solution.
First is a SQLite plugin that will give your game it's own in-built database. From here you can call database scripts giving your game extra functionality. This is ideal for stand alone games of large size and complexity.
Second is a web based game plugin that can run SQL commands from torque to any resolvable SQL database. You would then run the game through IIS or a web provider. This gives Torque extra power for indie developers who want to create MMO's with a resolvable database. This also gives you a more practical way to back up data.
Advantages of this;
You can call multiple SQL databases.
High Availibility possible with 1 database multiple server front ends.
Users not familiar with SQL can use just Torque script.
Stil has security from end users.
This makes backups easy for your important data.
Remote servers can be used however security layers advised.
Web based games not required but this is not advised for a client server environment for your own security.
We intend to integrate with multiple SQL platforms for ease of use.
I am keen to hear peoples ideas on this. Would you use this?
We hope to have some beta testers for the first release in just over 1 month after alpha testing.
This was originally designed for us but wanted to know if others were interested.
Thank you
Wayne Taylor
Team Lead
Crimsoneye Games
#2
I know I wont be answering your questions completely but I will give you I hope enough to work with.
How this came about;
We are a web based games company. No clients just servers, instances and databases. The game is on the same local network as the SAN and the SQL database. We use 3 clustered Databses in which 2 are different.
The server runs through IIS and is made with 2 parts. 1: user 2: translation / backend. All users log on to the single server instance. The backend retrieves and controls all "global" databses and the user side controls all the "user" databses. We also have a system databse. Each databse moves accross multiple games. This also means the server is just a front end to IIS and the database. From this we can have server instances accross multiple servers and with HLB controling the access points. The user runs a access point inside a server instance (part 2).
To add to the complexity we have developers world wide. We want to avoid developers logging into the servers directly so from a server they can log in and modify the servers and databases directly from the game. Server patches being the exception.
I have seen issues from TCP/HTTP and since its on a secured network security is not needed from the backend by design. The user will not see or be able to view any backend code or even control with a bot program. User controls are strictly limited.
If you have a infrastructure specalist in your team this plugin is not needed but would save time. like all plugins this can be replicated and is built of the foundations of current SQL resources on this site. This is designed for a purpose however can and is being modified for others.
This plugin is not designed for a client to connect with a remote SQL database in which the TCP/HTTP would be the method to use however even then I would advise a 443 translation server.
If you have any further questions please let me know. I believe as we have done the leg work already if others needed something similar this would be possible with the plugin.
There is more to this product however this will be said closer to the release date.
Thank You
Wayne Taylor
Team Lead
Crimsoneye Games
03/03/2011 (1:29 pm)
Hello Ted,I know I wont be answering your questions completely but I will give you I hope enough to work with.
How this came about;
We are a web based games company. No clients just servers, instances and databases. The game is on the same local network as the SAN and the SQL database. We use 3 clustered Databses in which 2 are different.
The server runs through IIS and is made with 2 parts. 1: user 2: translation / backend. All users log on to the single server instance. The backend retrieves and controls all "global" databses and the user side controls all the "user" databses. We also have a system databse. Each databse moves accross multiple games. This also means the server is just a front end to IIS and the database. From this we can have server instances accross multiple servers and with HLB controling the access points. The user runs a access point inside a server instance (part 2).
To add to the complexity we have developers world wide. We want to avoid developers logging into the servers directly so from a server they can log in and modify the servers and databases directly from the game. Server patches being the exception.
I have seen issues from TCP/HTTP and since its on a secured network security is not needed from the backend by design. The user will not see or be able to view any backend code or even control with a bot program. User controls are strictly limited.
If you have a infrastructure specalist in your team this plugin is not needed but would save time. like all plugins this can be replicated and is built of the foundations of current SQL resources on this site. This is designed for a purpose however can and is being modified for others.
This plugin is not designed for a client to connect with a remote SQL database in which the TCP/HTTP would be the method to use however even then I would advise a 443 translation server.
If you have any further questions please let me know. I believe as we have done the leg work already if others needed something similar this would be possible with the plugin.
There is more to this product however this will be said closer to the release date.
Thank You
Wayne Taylor
Team Lead
Crimsoneye Games
Torque 3D Owner Ted Southard
1) What do these plugins have over SQL resources on this site?
-and-
2) Why would you have a Torque engine make direct contact with a SQL database on the web when you can use TCP or HTTP objects in a network/internet architecture? It seems that using TCP/HTTP objects is safer because it adds a layer of abstraction from the database server (and the game itself won't have the password).
I'm interested in hearing about your plugins and how they address these issues. Thanks in advance.