SQLite 3 Implementing (Latest - No lib requried)
by Kevin Mitchell · 01/13/2013 (11:24 am) · 17 comments
Attached is an updated and easier method to implement SQLite3 into your project. This uses the pure c++ files from the SQLite website. Also the wrapper is still the same wrapper from the orginal SQLite 3 resource here. Which is not mine mind you.
It's this guy. And he's awesome.
All Files can be found here: DOWNLOAD
Steps:
1. Extract the SQLite zip into the source folder some where.

Note: How to add a filter.
2. Create a new filter under engine named: rpg_engine
3. Create a filter in rpg_engine named: sqlite
Note: How to add files
4. Right Click sqlite folder and add existing files.
Note: Select all files in the extracted folder.
5. Add the following files: shell.c,sqlite3.c,sqlite3.h,sqlite3ext.h,SQLiteObject.cc,SQLiteObject.h
6. Recompile.
7. ???
8. Profit!
Edited: Revised the instructions.
It's this guy. And he's awesome.
//----------------------------------------------------------------------------- // Torque Game Engine // Written by John Vanderbeck // // This code is written by John Vanderbeck and is offered freely to the Torque // Game Engine wth no express warranties. Use it for whatever you want, all // I ask is that you don't rip it off and call it your own. Credit where // credit is due. If you do use this, just drop me a line to let me know. It // makes me fell good :) // Contact: jvanderbeck@novusdelta.com // http://www.novusdelta.com //----------------------------------------------------------------------------- //----------------------------------------------------------------------------- // This code implements support for SQLite into Torque and TorqueScript // // Essentially this creates a scriptable object that interfaces with SQLite. // // The supported SQL subset of SQLite can be found here: // http://www.sqlite.org/lang.html //-----------------------------------------------------------------------------
All Files can be found here: DOWNLOAD
Steps:
1. Extract the SQLite zip into the source folder some where.

Note: How to add a filter.
2. Create a new filter under engine named: rpg_engine
3. Create a filter in rpg_engine named: sqlite
Note: How to add files4. Right Click sqlite folder and add existing files.
Note: Select all files in the extracted folder.5. Add the following files: shell.c,sqlite3.c,sqlite3.h,sqlite3ext.h,SQLiteObject.cc,SQLiteObject.h
6. Recompile.
7. ???
8. Profit!
Edited: Revised the instructions.
About the author
Riding Solo since 2005. Current Project: Fated World 2005-Present RPG Engine Tool Kit - Now available.
#3
Still tryin to get this to work out.
T.
Got it! Turns out I had some issues with adding in another resource and it goofed up the version. Fell back to an older version and your resource went right in.
Now, I have to figure out how to use it. Your old resource, created a db I believe. I never got far enough to see it work. LOL.
Who knew trying to build a game would be so much work. WHO KNEW!
I need an easy button. :)
01/13/2013 (6:51 pm)
grrr.. 83 errors when I compile... and I found you were serious... you really need it as rgp_engine it REALLY doesn't work if you don't follow the file structure you laid out.Still tryin to get this to work out.
T.
Got it! Turns out I had some issues with adding in another resource and it goofed up the version. Fell back to an older version and your resource went right in.
Now, I have to figure out how to use it. Your old resource, created a db I believe. I never got far enough to see it work. LOL.
Who knew trying to build a game would be so much work. WHO KNEW!
I need an easy button. :)
#4
01/31/2013 (3:07 pm)
Nice! I've been prototyping RPG systems in C# with SQLite (via the handy System.Data.SQLite) with the intent to port over to T3D and C++. This resource will be quite helpful. Thanks!
#5
Enjoy.
04/04/2013 (1:35 pm)
I've taken the initiative to package up the files into a zip file, and wrote up a quick ReadMe.txt to go along with it, for this resource for those of you who rather not have to go through and download the files one by one: t3d_sqlite3_20130404.zip.Enjoy.
#6
04/04/2013 (1:41 pm)
you dont have to download them one by one you just have to flick file->download then it downloads as a zip.
#7
"fatal error C1083: Cannot open include file: 'atlbase.h': No such file or directory"
I have been looking into this error and it seems to be that I just can't use 2010 express. Is this true or is there something I can do to fix this?
05/14/2013 (9:44 am)
What version of VC++ are you using, I am using 2010 express and I am getting a "fatal error C1083: Cannot open include file: 'atlbase.h': No such file or directory"
I have been looking into this error and it seems to be that I just can't use 2010 express. Is this true or is there something I can do to fix this?
#8
05/14/2013 (10:30 am)
I am also using express and it does indeed work. Let me check some things when I get home.
#9
Did you change the rpg_engine references and replaced it with the proper filter path names?
IE
#include "rpg_engine/sqlite3/SQLiteObject.h"
to
#include "CUSTOM_CODE_FOLDER/sqlite3/SQLiteObject.h"
or
#include "sqlite3/SQLiteObject.h"
Do you have all 6 files included in the project?
Also can you take a screenshot of the files in your project?
05/14/2013 (6:31 pm)
Yes just manually inserted it into the project again. Did you change the rpg_engine references and replaced it with the proper filter path names?
IE
#include "rpg_engine/sqlite3/SQLiteObject.h"
to
#include "CUSTOM_CODE_FOLDER/sqlite3/SQLiteObject.h"
or
#include "sqlite3/SQLiteObject.h"
Do you have all 6 files included in the project?
Also can you take a screenshot of the files in your project?
#10
05/14/2013 (7:26 pm)
I couldn't figure out how to upload screenshots so I sent you an email.
#11
From the SS the error is in the NP (project name) Plugin module.
05/15/2013 (1:03 am)
I do not think the compiler is complaining about the SQLite add on. I think it's complaining about one of the other modules. To check only right click the (project name) DLL module and hit build. There should be no errors. From the SS the error is in the NP (project name) Plugin module.
#12
05/15/2013 (11:01 am)
Hmm, yea your right its not an issue here its something else. That's strange I made a fresh project to try this, well thanks
#13
05/15/2013 (11:12 am)
Got it, you were right the "IE <project name> plugin module was conflicting... thank man
#14
05/15/2013 (3:47 pm)
glad you got it sir.
#15
07/23/2013 (2:47 pm)
I have noticed that not all the editors are movable. This creates an issue on my screen where the editor's save and cancel buttons are out of reach, below the visible screen. To get out of the editor, I have to quit the project. Am I missing something obvious? (I figure I am otherwise this error should have cropped up for someone else by now.) They are a nice beginning to creating a great concept within a game. Thanks for making this wonderful resource available to the rest of us!
#16
If so the interface was initially designed for 1280 to 1920 resolutions. For the full release I have modified all popups to fit int smallest game resolution 1024x768
07/23/2013 (5:10 pm)
Are you referring to the Free version of the RPG Editor? If so the interface was initially designed for 1280 to 1920 resolutions. For the full release I have modified all popups to fit int smallest game resolution 1024x768
#17
~K
07/24/2013 (1:49 pm)
Thanks for the info.... (I knew it was a resolution issue, but thought you might want to change that-and you already have!!!) Just wanted to give you a heads up about it. :)~K

Torque 3D Owner Tarly
I then click on open in a new window. and it wants a google sign in
After signing in, you have to cut and paste thru all of it ?
ok.. it does not cut nad paste...
AH HA! right click save it :)
ty bud