Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and sqLite
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01513514
Message ID:
01513990
Views:
91
Your point(s) are well taken..... thanks for the thoughts.

>>Good question - its in 7 tables now, which with indexes is 14 files. I was hoping I could just ship it with one database file for easier installation issues.
>
>Having a native engine that is flexible as FoxPro's is a much better choice than trying through some sort of interop to get to sqlLite or even Sql Compact is not even a contest in my opinion. Part of the reason you're using VFP I'd hope is BECCAUSE of the native data engine.
>
>Stick the files into a seperate folder to minimize the impact of file pollution and call it a day - you'll be much happier in the long run using native tables for a small app than anything that'll require remote commands or ODBC. Plus you probably have to install DB drivers on install machines...
>
>+++ Rick ---
>
>
>>
>>
>>>>Anyone have any experience using VFP and sqlite? I have a small app (7 tables), and something bigger than sqlite seems like overkill.
>>>>
>>>>If so, suggestions would be appreciated.
>>>
>>>Then why not VFP Native DB?
Previous
Reply
Map
View

Click here to load this message in the networking platform