SQLite is not an RDMS. It isn't always on via an API like what you and I are familiar with. Each request is a new connection to the same db file. It can be used on very light machines like a raspberry PI.
On Tue, Jun 23, 2020 at 12:36 PM MB Software Solutions, LLC < [email protected]> wrote: > 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. > > > > > > > > -- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cajidmyj4udzomdap8xbbhpszuwig6duhsqj-bz+rzm5+pn_...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
