Amazing how SQLite looks and feels like a VFP database


>Hi Alejandro,
>
>I am moving my stuff out of VFP as well. Not fully sure about the end platform, some sort of *ython (plain old C-based Python, Ironpython on the MS platform, Jython or a js-based one, should that arise). The only sure thing to me is the data handling on the next version: SQLITE.
>
>Both as a persistent layer at runtime (yep IN-MEMORY... That does not preclude using more efficient data structures when needed but I am bought on SQL) and as persistent storage (yep as an "Application file format" à la VFP but on a wider multi-table basis). Why? It's speedy enough for most usages. You can read:
>
>https://www.sqlite.org/about.html
>
>And specifically:
>
>https://www.sqlite.org/whentouse.html
>
>A database engine for this.... Quite a number of products do that (including browsers and widely spread apps). The only thing that would keep me outside of the comfortable sqlite bandwagon:
>1- such a limited need that can be catered for with ini file (or a minimalist json-like format),
>2- an alternative engine that would be more MS-OS friendly. Sqlite is OS-agnostic.
>
>My 0.2 cents
>
>Daniel