Deployment issues: sqlite?

[Monte Goulding]

On 24/09/2010, at 8:07 PM, David Bovill wrote:

> I'm interested in the experience of people deploying Rev / LiveCode based
> app that use sqlite databases. What issues do you get when deploying to the
> various platforms? Is Linux OK?
> 
> Also I'd like to provide an IDE plugin that creates and uses an sqlite
> database - this complicates things as the different IDE versions will have
> different driver versions, and pervious versions di have a number of bugs as
> far as I could tell - Livecode 4.5 seems to have fixed a good number of
> these. However, I'm not planning on doing anything fancy, so having an idea
> of how well basic sqlite functionality worked out of the box in earlier
> IDE's would give some encouragement. How has your experience been with Rev
> and sqlite on your platform?

I've been using the sqlite driver since it was an altuit product. There were a few teething problems in the early versions but nothing major for years. I don't know about linux issues though. As long as people aren't jumping backwards and forwards into different ide's with your plugin trying to access the one file then I don't think you will have much trouble. I guess you will have to remember it's possible to have multiple instances of the IDE running etc.

Cheers

--
Monte Goulding
M E R Goulding Software Development
Bespoke application development for vertical markets

InstallGadget - How to create an installer in 10 seconds
revObjective  - Making behavior scripts behave