Ok, it's been a while since I had anything new to post to the discussions

here. Life and work have been getting in the way.

However, this morning, I accidently learned (yes, I'm probably the last one

to know about this!) about DuckDb (https://duckdb.org) that seems to be an

open source, embedded database engine similar to SQLite. I read where it may

have the ability to query CSV, Excel, JSON and other file types directly

without importing them first. Those types of files are ones I work with

extensively on a daily basis and importing the data into temporary cursors,

while very fast on VFP, still requires time as some of the files I work with

may include hundreds of thousands of records.

Before I go down this rabbit hole of figuring out how to use VFP9 as a

front-end to DuckDb, I wanted to ask if anyone here has used DuckDb with VFP

before? I'm all ears if you have suggestions, samples, code snippets or

anything related to help guide me. As you might imagine, the DuckDB website

doesn't have a lot of Foxpro specific information. :)

I have at least learned that currently they only have a 64bit ODBC driver

which means I'd probably have to use VFA64 to use this method of connecting

to the data, but DuckDB supports multiple API's so I may have to use those

alternatives instead. As I said, I'm just starting to getting into this, so

any ideas would be appreciated.

Thanks in advance!

Paul H. Tarver

Tarver Program Consultants, Inc.