Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DSN-Less connect to Postgres
Message
General information
Forum:
Linux
Category:
Databases and Admin issues
Miscellaneous
Thread ID:
00638809
Message ID:
00640656
Views:
24
Hi Jerry,

I not as familiar with postgres as you are, because most of my experience has been with VFP and MySQL. Also I've taken a serious look at MSSQL which is a great product, but I think my clints would find it rather expensive relative to some their other options.

From what I've seen of postgres I am quite favorable impressed. It has transactions, triggers, sequences, and at least everything VFP has, so they match up well. However VFP could limit postgres as a front end in areas like its 256 field limit as opposed to postgres's 1600 fields allow by postgres. For me this is not a problem because I can't imagine a table with 1600 field. It would take half a day to find the field you need to do an update. Also it would take to long to complete a from that called for so many fields. Also, I think VFP has a 2 gig limit on its memo field where postgres blob field is much larger. However there may be work arounds for these areas where VFP and prosgres don't exact match.
Leland F. Jackson, CPA
Software - Master (TM)
smvfp@mail.smvfp.com
Software Master TM
Previous
Reply
Map
View

Click here to load this message in the networking platform