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.

DarkBASIC Professional Discussion / SQLLite

Author
Message
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 24th Jun 2003 19:08
Link
Aside for disliking the American spelling of light (and yes, in this context they both mean the same), it appears that this is an easier way of using SQL databases (and has the distinct advantage that you dont need to create the database beforehand, as it can be done in the program).

Therefore, who wants a plug-in (assuming no-one else wants to do it) ?
Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
GinGuy
23
Years of Service
User Offline
Joined: 13th May 2003
Location: United States
Posted: 24th Jun 2003 20:13
Link
That would be great!
Back to top
Profile PM
IanM
Retired Moderator
23
Years of Service
User Offline
Joined: 11th Sep 2002
Location: In my moon base
Posted: 24th Jun 2003 20:30
Link
Wow, never heard of that one. I found comparisons between SQL-Lite, MySQL and PostGreSQL here that are actually quite suprising.

And it's fully PD, no GPL/LGPL to worry about. Do it
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 24th Jun 2003 21:30
Link
Yes, and it's (looks) easier that the full SQL system.
I'll see what I can do - unless you want to do it...

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
IanM
Retired Moderator
23
Years of Service
User Offline
Joined: 11th Sep 2002
Location: In my moon base
Posted: 24th Jun 2003 22:00
Link
I might have a play around with it later (days!), but I'm a bit engrossed ATM with something else.
Back to top
Profile PM Email Website
enablerbr
23
Years of Service
User Offline
Joined: 22nd Jun 2003
Location: United Kingdom
Posted: 24th Jun 2003 22:27
Link
as your talking of such things as MySQL & SQLlite. could you give me some info about what they do as i'm new to this. i know they are database's but could you give me some idea of how such things would work in a game type enviroment. reason i ask as i have a fealing that i would need to use such tools in my own game idea.

Back to top
Profile PM
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 00:43
Link
Well, if your refering to the main SQL plug-in, it allows access to any ODBC system, ie mySQL, Access, Pervasive, SQL 2000, text, almost anything. In a game type environment, it could be used to store multiplayer hiscores, or perhaps the locations of all the players, what they're carrying and what they last ate.
The only problem with it (at the moment), is that the database needs to be present before you can use the plug-in. In addition, the relevant ODBC system needs to be installed (ie if your going to use Access, then for all clients, the ODBC Access system must be installed).

With SQLite, it is the complete SQL system (so nothing else is needed). It has a few less features that the main system (although it appears nothing particularly important). It should be easier to use, and you can create the database programatically.

The SQLite system has been started...

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
iaretony
23
Years of Service
User Offline
Joined: 6th Jun 2003
Location:
Posted: 25th Jun 2003 00:55
Link
SQLite is cool.. I have been playing with it for about 1 year now... The author is usually quite good about providing help too!

Tony

Back to top
Profile PM
Rob K
Retired Moderator
23
Years of Service
User Offline
Joined: 10th Sep 2002
Location: Surrey, United Kingdom
Posted: 25th Jun 2003 01:42
Link
The question Toady, is can you resist making a plugin?

Do you want Windows menus in your DBP apps? - Get my plugin: http://snow.prohosting.com/~clone99/downloads/tpc_menus_103.zip
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 01:52 Edited at: 25th Jun 2003 01:53
Link
No - I've started on it already. Got it opening, closing and creating tables...

Lack of decent documentation is a pain - and as there are no .LIB files, it will have to be loaded at use-time.

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
IanM
Retired Moderator
23
Years of Service
User Offline
Joined: 11th Sep 2002
Location: In my moon base
Posted: 25th Jun 2003 02:01
Link
Why not generate one:

LIB /DEF:sqlite.def

You might get a warning 'machine not specified' but it defaults to intel anyway.
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 02:21 Edited at: 25th Jun 2003 02:23
Link
Unfortunately, it didn't create it (Cant open SQLite.DEF file)

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
IanM
Retired Moderator
23
Years of Service
User Offline
Joined: 11th Sep 2002
Location: In my moon base
Posted: 25th Jun 2003 02:27
Link
I assumed from what you wrote that you were putting a front-end onto the DLL. The .def file is included in that download.

If you need the .lib, just mail me and I'll send it.
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 10:42 Edited at: 25th Jun 2003 10:50
Link
Okay... It'll be easier for the user.

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 10:48
Link
Haven't totally decided to deal with results from queries yet. As its all done in one go (from the view of the user anyway), I'm probably going to go with an memory allocated holding other memory allocated.

It'll be so low level, it'll be able to limbo under a fridge.

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
Martyn Pittuck
23
Years of Service
User Offline
Joined: 27th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 11:31
Link
Well you could quite easily make a flat SQL server, there is loads of PHP out there that emulates MYSQL in its simplist forms. You could write DB functions to do it i think.

The Outside is a evil place to be, too much light, too much noise and too many distractions....
I went outside once and my FPS rate dropped to 5.
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 11:51
Link
Dont know anything about PHP. Anyway, this is pretty simple (except for the tri-pointer parameter functions - which I wont use yet).

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
GinGuy
23
Years of Service
User Offline
Joined: 13th May 2003
Location: United States
Posted: 25th Jun 2003 19:01
Link
what is the URL for SQLLITE ?

thanks,
Dylan
Back to top
Profile PM
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 19:40
Link
http://www.hwaci.com/sw/sqlite/

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 19:42
Link
The easiest way of getting results back, I think (unless anyone else can come up with anything better), is to extend a reserved amount of memory for each interation and then have a function that returns the address of this reserved memory.

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 19:42 Edited at: 25th Jun 2003 21:13
Link
IanM - I've generated a .LIB file now.

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
IanM
Retired Moderator
23
Years of Service
User Offline
Joined: 11th Sep 2002
Location: In my moon base
Posted: 25th Jun 2003 22:05
Link
Too late, I've just sent it. I should have checked here first
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 25th Jun 2003 22:14
Link
Fair enough...

I'll be posting the beta version very soonish...

Getting the data is slightly awkward at the moment - I just dont feel like deal with triple pointed variables with the VM system in SQLite...

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
MasterInsan0
23
Years of Service
User Offline
Joined: 14th May 2003
Location: United States
Posted: 26th Jun 2003 04:24
Link
I lost you a few posts back, MrTAToad. You said something about this being able to manipulate an Access database. Is it true? (All of the design for my goal game I put into an MSAccess database planning to transport it to text later)

My friends' and my website for DBPro Programming:
http://unseenstudios.netfirms.com
Back to top
Profile PM Email Website
MrTAToad
23
Years of Service
User Offline
Joined: 26th Aug 2002
Location: United Kingdom
Posted: 26th Jun 2003 11:02 Edited at: 26th Jun 2003 19:10
Link
No, I said you dont need Access, Pervasive, mySQL or any other database system, as SQLite is a database system.
Its pretty much on par with mySQL and others (see Ian's previous post with regards to timings).

Good news everyone! I really am THAT good...
http://www.nickk.nildram.co.uk/ for great plug-ins - oh my, yes!
Back to top
Profile PM Email Website
Back to top

Login to post a reply

Server time is: 2026-07-17 00:19:43
Your offset time is: 2026-07-17 00:19:43