Sorry your browser is not supported!

Hey guys.

I am very new to the entire concept of SQL's. Would it be possible for someone to explain what exactly they are.

I have gathered so far that they are online data bases that are very effective with real time transactions on networks. I cant see any other alternative but to use SQL's as i am making a lobby system, and the only way i can create a efficient system of storing lobby details is through SQL. If i then get SQL working properly, i may convert my FTP oriented key codes into SQL, and likewise my update record.

Also, does anyone know any good database hosting sites? I can seem to find somewhere, i have used http://wwww.zymic.com/ for some time but it has now let me down when using the SQL's as i cant seem to create a table.

Thanks in advance.

Used to be you couldn't throw a rock without hitting a web host that has either MySQL or Microsoft SQL Server available as an option. Don't know now, I've not been running an ISP for about 5 years. I used to offer both.

Anyway, using DBPro there are 4 options for storing and using data on a server for a client-server based application.

1. Using text files
This can and likely will be slower, but has the advantage of not caring whether or not you have access to an SQL server.
2. CattleRustler's SQL Plugins
There are 3 separate ones. 1 for MySQL, 1 for MSSQL, and 1 for Microsoft Access.
3. My DBConn Plugin
This plugin gives you access to any data source that uses ODBC. If the machine your server application is running on has access to the data through ODBC, then you can access it in DBPro using this.
4. DarkData
A plugin that gives you database like access using text files. Probably not quite as fast as an SQL server, but certainly a good solution.

The first 3 choices are free.

Knowing only that your application is a "Lobby" doesn't really indicate how much data is going to be stored, and how often the database is going to be read from or written to, it's difficult to recommend which way to go. However, if you are having difficulty in getting an SQL Server host, I would go with a Microsoft Access file. They are simple enough to create, and they don't require anything special from the server host.

If that's to slow for the amount of data you plan to read/write, then you'll have to go with one of the SQL Servers.

Links:

CattleRustler's Plugins
Microsoft Access Plugin
MySQL Server Plugin
Microsoft SQL Server Plugin

DBConn
http://www.kistech.com/dbpro/dbconn

Thanks. I think im gonna have a small look into dark data, cause that sounds very interesting

I'll have a look at your sites ect... The problem i am having is the SQL database creation. Apart from that the commands look reletively simple. I guess is Dark Data doesnt need a data base and uses text file that will be the best option for me

If you are able to use a MySQL database on a server where you have a web site hosted, upload phpMyAdmin to the server and use that to administer the database.

For simplicity for a low volume task, I would go with text files with the built in commands, or with DarkData, or the Microsoft Access approach. If you are logging data for more than 20-50 users, then you might need to think about using an SQL Server.

Hey. I have now gathered enough money for Dark Data from selling material and doing odd jobs around the FPSC community. Would it be possible for you to elaborate on Dark Data and how it actually works? If it is effectively a data base with text documents (but faster then FTP), then I think I will most likely get that. I would just like a bit of description on the program. I will also be searching for information on it as well. Any reviews from users would also be appreciated.

Thanks, Arenas

Best place to start is the Sticky in this forum. I've not used it because I've got the SQL servers, but from what I hear it's good.