Hi all,

I am starting the rewrite of a VFP-based application. The UI is still undecided but the glue language for the application is: that's python.

An essential key of the success of this rewrite: the ability to translate a decent part of the current application logic. Since the current VFP app makes a very significant use of VFP temp indexed cursors massaging data with a mix of both SQL and non-sql VFP operations, I definitely want to find a robust alternative to VFP cursors within the python eco-system.

On the paper, current SQLITE has everything that fits the bill to replace VFP cursor operations including a great "in-memory" mode, UDFs and a lot more. For those among you who have an experience in SQLITE, I'd be glad to get your feelings on their respective merits in terms of local temp storage.

I am especially interested by the performance level that I can expect with "in-memory" application-level data stores in view of rushmore-optimized VFP operations we are all used to and, as far as I am concerned, always amazed, even in 2015...

Regards to all of you

Daniel