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. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: https://lists.leafe.com/postorius/lists/profox.leafe.com/ To unsubscribe send an email to [email protected] OT-free version of this list: https://lists.leafe.com/postorius/lists/profoxtech.leafe.com/ Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/[email protected] ** 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
