Stress-testing SQLite

Lynn Fredricks lfredricks at
Sat Oct 30 13:28:50 EDT 2010

> many of the data stores for the major apple apps use sqlite. 
> it's a petty robust single user data store. 

Of course I don't need to expand on what Ruslan will say about Valentina,
but I will say that there's a right tool for each job, and others that sort
of work but aren't optimal. I can use a brick or the butt of a screwdriver
to drive a nail into a piece of wood. There are reasons why, for example,
AOL Europe, Nikon Corporation and others that may not be named chose
Valentina over something like SQLite for their specific projects. 

I can say for certain that developers do not pick Valentina because it is
free or in public domain :-)

SQLite is a functional, single user database, but the database market is
filled with alternatives. Its worth looking at Ruslan's emails recently
asking about changing schema to see where even his expectations for SQLite
were different.

SQLite has its place in development, and there are good reasons to use it.
But like evaluating any infrastructure technology, you have to consider what
your long term plans are and what your clients are likely to ask for later.

Best regards,

Lynn Fredricks
Paradigma Software

Valentina SQL Server: The Ultra-fast, Royalty Free Database Server 

More information about the Use-livecode mailing list