Just curious--given what you said, why wouldn't you just go to MariaDB right away then, skipping SQLite?
On 6/23/2020 11:48 AM, Vince Teachout wrote:
On 06/23/20 10:18 AM, John Weller wrote:
Has anyone used SQLite with VFP? I have always used DBFs as it seemed over-kill to use SQL Server for the small membership databases I've been using (2000 records) however I was introduced to SQLite as part of a Python course so thought I'd give it a try with VFP.
I played with it a bit, and am considering porting my small, ancient billing program over to it.
I found it easy to use, although the limited data types annoys me, and the right there out in the open database files worry me a bit.
But it seems to work well, it's easy to use, and bonus, there are actual ODBC drivers for it. Not that your really need it, but then you could do views, etc.