Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Author
Message
DRYAD
23
Years of Service
User Offline
Joined: 20th Dec 2002
Location: Greece
Posted: 9th Apr 2003 13:53
Hello there,

I was wondering if DB supports some basic database connectivity. I ve been through the documentation, and the only thing i ve found so far is that DB is able to read data from text files. I could do my job if it was kinda old GW basic (fields) or if i could use comma separated files for that, but there is nothing like this. All i can do is read lines from a file, and manually seperate the values.

Anything with an ODBC driver could do.

Any feedback on this ?

Thanks in advance

DRYAD
Rob K
Retired Moderator
23
Years of Service
User Offline
Joined: 10th Sep 2002
Location: Surrey, United Kingdom
Posted: 9th Apr 2003 14:06
I think Toady has already written a plugin for this, but using SQL.

Current Project: Retro Compo. Entry.
Ratty Rat
23
Years of Service
User Offline
Joined: 24th Sep 2002
Location:
Posted: 9th Apr 2003 14:28
Rob is correct, look at dbpro plugins on - http://www.nickk.nildram.co.uk/

He also has some other superb plug ins there, well worth a look.

"Don`t try to engage my enthusiasm, I don`t have one"
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 9th Apr 2003 14:45 Edited at: 9th Apr 2003 14:50
Yes, I've done a SQL plug-in. On the RGT site, someone got it working on Microsoft's SQL 2000 server. As I didn't have that, I tested it on Pervasive and mySQL.

By the way, you dont have to use those - almost any ODBC driver will actually do...

The only slight problem with it at the moment, is that the 'database' has got to be created before you do a connection.

By the way, I belive I released the source code to it in the code snippets last year, so if anyone wants to sort that problem out, let me know and I'll stick it in the plug-in.

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
DRYAD
23
Years of Service
User Offline
Joined: 20th Dec 2002
Location: Greece
Posted: 9th Apr 2003 19:19
Well, i could do some work if i had a vblike "split" function handy, i could use comma separated values on a text file, so no database connectivity would be necessary. But...

Perhaps there is some plugin for that too

DRYAD

MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 9th Apr 2003 19:28 Edited at: 9th Apr 2003 19:29
Not that I know of... I needed to do that sort of thing at work, and seperating sections of a line can be a pain, because of commas in quotes...

You might find INI files useful - got a plug-in for that...

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Dimos
23
Years of Service
User Offline
Joined: 9th Apr 2003
Location: Greece
Posted: 9th Apr 2003 19:57
(Just signed up, DRYAD is my partner and i used his account for this thread, i am doing the code works

Well, the thing i had in mind actually, is that if someone wants to create a game or something, he would HAVE to store data somewhere. The basic principle is that, lets say, for a shoot'em up game: We could have a table on a database that stores the enemy types, with their attributes etc, the patterns that each enemy type uses to move, you could even store the firing attributes of each weapon, update etc, with hitpoints and stuff like that.

In that case, the only thing that one has to do when creating a game is to build the engine. The engine will then read all game stuff from the database (which object to load) etc.

That way, it could be much easier to create some kind of game editor for the specific game, and just create add-ons, without the need to mess with the DB engine every time that you want to do something new.

I think that creating a game starts from designing it, and not from creating the models first...

(-*-)(-*-)(-*-)(-*-)(-*-)(-*-)(-*-)(-*-)
(-*-)Where no man has gone before..(-*-)
(-*-)(-*-)(-*-)(-*-)(-*-)(-*-)(-*-)(-*-)
Ratty Rat
23
Years of Service
User Offline
Joined: 24th Sep 2002
Location:
Posted: 9th Apr 2003 20:29
Databases could be used for what you say, but generally, unless you are doing some sort of MMORPG (where you might find SQL useful for maintaining massive amounts of data) they could be overkill.

I find INI files easier, they are basically text so you can make quick changes if you need (though maybe not as easily as a good database, depend son how easy to read you make them, easier to read = more difficult to code), and the routines to read them are usually not much more complicated than database equivalents.

If you write some sort of level editor you can make it create these files automatically (thats kind of what I did for my old breakout 3D game, the level files are just a dump of data from the level editor).

"Don`t try to engage my enthusiasm, I don`t have one"
Dimos
23
Years of Service
User Offline
Joined: 9th Apr 2003
Location: Greece
Posted: 9th Apr 2003 20:57
Truth is that we have several plans regarding Dark Basic. There is a plan to launch a tv-game being played by tv-viewers using their mobile phones. We are now studying the case, and it seems that Dark Basic is more that enough to handle all the 3d job. The problem is that since its going to work upon incoming SMS from the players, well... I think that this is off-limits.

The fact is that we can handle this issue using MS VB and a web server or a GSM modem. The problem is that another application written in VB needs to "tell" the Dark Basic app what to do! With basic database connectivity we could write the data on some database, and get the Dark Basic app to read the data from there. That would solve the communication issue. This way we can have multiple applications, that end up with a Dark Basic 3d interface, without having anything to do with that ... what they call it ? I think its DirectX SDK, Microsoft's most confusing API!

My conclusion is that basic database connectivity can expand much further the final result.
3d Email clients, ltes say...

(-*-)Where no man has gone before..(-*-)

Login to post a reply

Server time is: 2026-07-10 23:13:23
Your offset time is: 2026-07-10 23:13:23