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.
John
John Weller
01380 723235
07976 393631
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
There's some articles by Whil Hentzen on his website covering the whole enchilada:
https://www.whilhentzen.com/artpres.htm
Thanks Alan - there's some good stuff there!
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Alan Bourke Sent: 23 June 2020 15:51 To: profoxtech@leafe.com Subject: Re: SQLite
There's some articles by Whil Hentzen on his website covering the whole enchilada:
https://www.whilhentzen.com/artpres.htm
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
I have and it works great. I'm using it to import a table much wider than 250 columns and then querying that table for specific results and using them to create an upload file for a third party service. I recommend the following book as your starting point:
https://www.hentzenwerke.com/catalog/sqlite2gb.htm
Paul H. Tarver
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 9:19 AM To: profoxtech@leafe.com Subject: SQLite
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.
John
John Weller
01380 723235
07976 393631
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
Thanks Paul. I'll investigate. I'm only playing as I've retired but it's something to do in lockdown 😊
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Paul H. Tarver Sent: 23 June 2020 15:57 To: profoxtech@leafe.com Subject: RE: SQLite
I have and it works great. I'm using it to import a table much wider than 250 columns and then querying that table for specific results and using them to create an upload file for a third party service. I recommend the following book as your starting point:
https://www.hentzenwerke.com/catalog/sqlite2gb.htm
Paul H. Tarver
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 9:19 AM To: profoxtech@leafe.com Subject: SQLite
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.
John
John Weller
01380 723235
07976 393631
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
I think you'll find SQLite interesting, fast and efficient. There are some caveats particularly when it comes to multi-user functionality, but the book (edited by none other than Ted Roche!) covers all of that material in an easy to understand way. I think I only had to ask Ted for help once! :)
Have fun!
Paul H. Tarver
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 10:06 AM To: profoxtech@leafe.com Subject: RE: SQLite
Thanks Paul. I'll investigate. I'm only playing as I've retired but it's something to do in lockdown 😊
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Paul H. Tarver Sent: 23 June 2020 15:57 To: profoxtech@leafe.com Subject: RE: SQLite
I have and it works great. I'm using it to import a table much wider than 250 columns and then querying that table for specific results and using them to create an upload file for a third party service. I recommend the following book as your starting point:
https://www.hentzenwerke.com/catalog/sqlite2gb.htm
Paul H. Tarver
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of John Weller Sent: Tuesday, June 23, 2020 9:19 AM To: profoxtech@leafe.com Subject: SQLite
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.
John
John Weller
01380 723235
07976 393631
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
I know some here have but I have not. I've been using MySQL (then MariaDB) for anything of size since 2004. Never looked back with regret. It's easy, rock solid, and can grow to behemoth sizes and never need any changes.
I'll be happy to lend you advice if you need some. The key is to have your app separated by tiers (UI, BizObj (if needed), and DataObj).
hth, --Mike
On 6/23/2020 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.
John
John Weller
01380 723235
07976 393631
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
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.
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.
On Jun 23, 2020, at 12:35, MB Software Solutions, LLC mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Just curious--given what you said, why wouldn't you just go to MariaDB right away then, skipping SQLite?
MariaDB requires a separate server. SQLite is a small library for a file-based database that doesn’t require a server.
-- Ed Leafe
On 6/23/2020 2:06 PM, Ed Leafe wrote:
On Jun 23, 2020, at 12:35, MB Software Solutions, LLC mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Just curious--given what you said, why wouldn't you just go to MariaDB right away then, skipping SQLite?
MariaDB requires a separate server. SQLite is a small library for a file-based database that doesn’t require a server.
-- Ed Leafe
Ah...yes...good answer. I'm not a fan of file-based for security, though, but honestly I've not used SQLite ever...just went right from VFP to MySQL after watching Bob Lee's WhilFest presentation in 2002 or 2003.
On 06/23/20 1:35 PM, MB Software Solutions, LLC wrote:
Just curious--given what you said, why wouldn't you just go to MariaDB right away then, skipping SQLite?
All of our shops have established MSSQL backends. I don't have a business case for suddenly migrating them to MariaDB, and I have no desire to learn another database server. Business-wise, If they're not paying me to learn it, I don't have the time anyway.
Personally-wise, I'm looking at SQLLite because it doesn't require a server at all, so can be packaged right along with small apps, and is inter-operable.  On my own dime, I'm learning Android programming, and SQLLite's ideal for that. So my plan is to rewrite this decades-old simple VFP app to use SQLLite backend for learning, and get my hands wet before I start using it for Android.
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 < mbsoftwaresolutions@mbsoftwaresolutions.com> 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]
Rick Borup did a session on this at last year's SW Fox. Good stuff. I don't see it on his webpage http://www.ita-software.com/foxpage.aspx yet but maybe if you asked him you could get his whitepaper.
E
On Tue, Jun 23, 2020 at 9:18 AM John Weller john@johnweller.co.uk 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.
John
John Weller
01380 723235
07976 393631
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
-
Alan Bourke -
Ed Leafe -
Eric Selje -
John Weller -
MB Software Solutions, LLC -
Paul H. Tarver -
Stephen Russell -
Vince Teachout