LiveCode Forums.

Hello every body.
I just bought Rev 4.0 and i will try to work with Databases i want start with SQlite but i am working in a MAC platform i want to create application to windows XP(with the database embed), so i must download the SQlite for a MAC or for a Windows? or both of them? since i am pretty new working with a MAC databases would you mind tell me the link where i can find the SQlie for a MAC, i mean i know that must of the program for a windows come with .exe or zip extension and .DMG for a MAC but i did see SQlite.dmg? i found:
sqlite-amalgamation-3.6.20.tar.gz
sqlite-3_6_20-tea.tar.gz
or this:
sqlite3_analyzer-3.6.1-osx-x86.bin.gz
for a windows:
sqlite-3_6_20.zip

thanks so much for your inputs.
Greg

Hi,

to actually work with SQLite, you do not need anything more than rev. If you want a tool to analyse and put stuf into the database, there are a lot of options, one of them being a plugin for firefox. SQLite is different from DBs like mySQL or postgre, in that you do not need to install a db server on the machine.

Just use revOpenDataBase. If you point to a file that does not exist, it will created for you by the embedded SQLite engine.

Hth,

Malte

Thanks Malte, but what happen if i want to keep the records for a month? still de Rev engine works? just send the datas to a file and then get it?

kinds regards
greg

If you use SQLite to hold your data, the data will be stored permanently in the file on your Harddisk.

this page explains a bit on how it works: http://www.sqlite.org/about.html

Cheers,

Malte