Always The Lasted Version of SQLITE current [3.6.22]
by Javier Canon · 02/13/2010 (7:58 pm) · 8 comments
Before anything, thanks for the authors of the others SQLITE resources.
In this occasion i can tell you a more easy way to compile the last version of Sqlite.
1. Use the SQLiteObject.h and .cc of this resource: www.torquepowered.com/community/resources/view/18425
2. Download the lasted "amalgamation": www.sqlite.org/sqlite-amalgamation-3_6_22.zip
3. Create a folder in your project and put all files in that forlder, add the files to your project.
4. update the #includes of SQLiteObject.X for can find selves.
5. Compile.
6. Download the sqlite.exe (A command-line program for accessing and modifying SQLite databases) from:
www.sqlite.org/sqlite-3_6_22.zip and put in your game folder.
you can use some GUI resources for create and administer the databases:
www.sqlite.org/cvstrac/wiki?p=ManagementTools
6.1. sourceforge.net/projects/sqliteman/files
6.2. osenxpsuite.net/?xp=3&uid=managementtools
script for test the connection:
torquetools.googlecode.com/files/SQLITE%203.7z
Enjoy! ;D
Yes, you dont need to distribute with your game the .dll and the .exe, sqlite.dll and sqlite.exe, only your own game.exe, tested in Windows 7 64 bits, and Windows XP SP3.
In this occasion i can tell you a more easy way to compile the last version of Sqlite.
1. Use the SQLiteObject.h and .cc of this resource: www.torquepowered.com/community/resources/view/18425
2. Download the lasted "amalgamation": www.sqlite.org/sqlite-amalgamation-3_6_22.zip
3. Create a folder in your project and put all files in that forlder, add the files to your project.
4. update the #includes of SQLiteObject.X for can find selves.
5. Compile.
6. Download the sqlite.exe (A command-line program for accessing and modifying SQLite databases) from:
www.sqlite.org/sqlite-3_6_22.zip and put in your game folder.
you can use some GUI resources for create and administer the databases:
www.sqlite.org/cvstrac/wiki?p=ManagementTools
6.1. sourceforge.net/projects/sqliteman/files
6.2. osenxpsuite.net/?xp=3&uid=managementtools
script for test the connection:
torquetools.googlecode.com/files/SQLITE%203.7z
Enjoy! ;D
Quote:Is there any difference between that method and yours ?
Yes, you dont need to distribute with your game the .dll and the .exe, sqlite.dll and sqlite.exe, only your own game.exe, tested in Windows 7 64 bits, and Windows XP SP3.
About the author
God blessed me with a brilliant mind... so im a genius...
#2
Also, do you know of any good portable SQLite manager ? I'm currently using SQLiteSpy which does not need installation. This is an essential feature. The SQLite management tools listed on the page does not state if they are portable. Thanks in advance for any help !
02/14/2010 (9:43 pm)
Using the resource, i modified the SQLiteObject.h and .cc and have just been replacing the dll file to keep up to date. Is there any difference between that method and yours ?Also, do you know of any good portable SQLite manager ? I'm currently using SQLiteSpy which does not need installation. This is an essential feature. The SQLite management tools listed on the page does not state if they are portable. Thanks in advance for any help !
#3
Yes, you dont need to distribute with your game the .dll and the .exe, sqlite.dll and sqlite.exe, only your own game.exe, tested in Windows 7 64 bits, and Windows XP SP3.
02/15/2010 (12:12 pm)
Quote:Is there any difference between that method and yours ?
Yes, you dont need to distribute with your game the .dll and the .exe, sqlite.dll and sqlite.exe, only your own game.exe, tested in Windows 7 64 bits, and Windows XP SP3.
#4
02/16/2010 (3:50 am)
Cool ! Thanx for the fast reply :D 
#5
02/23/2010 (12:30 am)
Works great....I like the links for the tools makes it so much easier to manage the databases.... 
#6
But I have an error that I can't seem to figure out, it's a fresh VS2008 install so I probably just forgot to install some bit of framework/tools. If anyone could point me in the right direction it would be appreciated.
The dll for my project wont compile and when I track the error it takes me to line 15494 in sqlite3.c
14>..........Enginesourcesqlite3sqlite3.c(15494) : warning C4013: 'InterlockedCompareExchange' undefined; assuming extern returning int
03/16/2010 (6:34 am)
FYI new version of sql Amal 3.6.23 is out.But I have an error that I can't seem to figure out, it's a fresh VS2008 install so I probably just forgot to install some bit of framework/tools. If anyone could point me in the right direction it would be appreciated.
The dll for my project wont compile and when I track the error it takes me to line 15494 in sqlite3.c
14>..........Enginesourcesqlite3sqlite3.c(15494) : warning C4013: 'InterlockedCompareExchange' undefined; assuming extern returning int
#7
03/16/2010 (8:32 am)
search of that in the engine. I think torque use the same name bout with an underscore at the beginning. I think I had the same issue and that fix it.
#8
*Note: Check this if you're unsure of what the Torque Script commands are.
www.torquepowered.com/community/resource/view/5531/
*Note: And here is "an almost working" example.
www.torquepowered.com/community/forums/viewthread/27467
03/18/2010 (4:33 am)
William's fix appears to have done the trick. Just be aware that it worked with Visual Studio 2008 SP1 but not the pre-SP 1 versions.*Note: Check this if you're unsure of what the Torque Script commands are.
www.torquepowered.com/community/resource/view/5531/
*Note: And here is "an almost working" example.
www.torquepowered.com/community/forums/viewthread/27467
Torque Owner Javier Canon
engin.bzzzt.biz/embeddeddb.shtml
What do you think that its the best for game development?