Wich SQLite have to be use by

greggarcia · Post by **greggarcia** » Fri Dec 04, 2009 9:19 pm

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

malte · Post by **malte** » Fri Dec 04, 2009 9:34 pm

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

greggarcia · Post by **greggarcia** » Fri Dec 04, 2009 9:47 pm

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

malte · Post by **malte** » Fri Dec 04, 2009 11:03 pm

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

LiveCode Forums.

Wich SQLite have to be use by

Wich SQLite have to be use by

Re: Wich SQLite have to be use by

Re: Wich SQLite have to be use by

Re: Wich SQLite have to be use by