|
Wednesday, 18 April 2007 |
SQLite is receiving a lot of extra attention these days, mainly due to its welcome introduction to PHP. It was really only a matter of time, as SQLite's no-nonsense database handling is simply too good to be ignored. This extra attention is great, as it means the code-base is also getting extra attention - meaning SQLite as a product is becoming stronger by the month.
Blitzmax users are lucky to have access to the excellent SQLiter module by René . This makes SQLite about as accessible as you can hope to have it. I have been, however, a little concerned about keeping SQLiter up to date, as the original wrapper by Tea Monkey is quite old now and Tea Monkey's site is down. And if you check on the SQLite updates page, you'll see a lot of bugs have been caught since the Tea Monkey release.
Fortunately, the makers of SQLite have completely spoiled us by providing, not only the latest source, but the latest source in a single file. Updating the tm.mod is now simple and easy. Just:
- Download the latest source code as a single file. Currently it is (link removed, find it on the SQLite downloads page ):
sqlite-source-3_3_15.zip
(574.56 KiB) | This ZIP archive contains pure C code for the SQLite library. Unlike the tarballs below, all of the preprocessing and automatic code generation has already been done on these C code files, so they can be converted to object code directly with any ordinary C compiler. |
- Open your tm.mod folder and delete everything except sqlite.bmx (back it up first!).
- Copy sqlite3.c and sqlite3.h to the tm.mod folder
- Edit sqlite.bmx, commenting out all the "Import .c's" within a Rem End Rem
- Insert a simple Import "sqlite3.c" in their place
- Open terminal, steer to your blitzmax bin folder and type
- bmk makemods -a tm
- And remake your SQLiter project.
I should add my usual disclaimer. The above worked fine for me in OS X. I am certainly no authority on the matter - I'm just a guy trying to get a set of tools to do what he needs. How does the saying go: If you let the blind lead the blind, we'll all end up in the ditch?
Good luck! 
|
