Re: IS PostgreSQL suitable in VFP Application
- From: "Matthew L Reed" <nousenetspam at dead ice dot us>
- Date: Wed, 15 Feb 2006 08:51:29 -0800
MySQL is your friend. Simply copy the files to the directory of your choice,
edit my.conf or my.ini if needed, and start the server. None of the bloat or
overhead of MSDE or MSSQL, no dot net, no IE, no install hell. You don't
even need to run windows, I've used MySQL on linux and Windows and both
worked equally well. I would guess that PostgreSQL is similar with respect
to installation?
Given a choice, my first choice would be MySQL on Slackware 10.2, assuming
MySQL meets the requirements for the app.
"Tsair" <lstsair@xxxxxxxxx> wrote in message
news:uBcHR0fMGHA.3496@xxxxxxxxxxxxxxxxxxxxxxx
Thanks Cindy Winegarden,
The main concern is if i distribute VFP application (Single user) with
MSSQL Express, i need to install DotNet and IE version 6.0 in that PC. It
may take up to 150MB disk space, 256 MB memory RAM.
"Cindy Winegarden" <cindy_winegarden@xxxxxxx> wrote in message
news:uqRH7GeMGHA.208@xxxxxxxxxxxxxxxxxxxxxxx
Hi Tsair,
Your questions are a little confusing. Visual FoxPro makes a great front
end to any ODBC or OLE DB compliant database, which I assume PostgreSQL
is. I don't know whether PostgreSQL is faster (or whatever) than MySQL or
Microsoft SQL Server/SQL Express. (SQL Express is free.) When you access
any of these databases you use an ODBC driver or OLE DB data provider
that matches the database you're working with. You don't use the VFP ODBC
driver or OLE DB data provider.
Visual FoxPro is a file server database; as such there is no advantage in
accessing data from "outside" via ODBC or OLE DB. In fact, native access
is always faster and ODBC and OLE DB only add another level of complexity
(complexity = slower).
On a reliable network 50 users and a 200 MB table aren't pushing the
limits for VFP.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
"Tsair" <lstsair@xxxxxxxxx> wrote in message
news:%23JnzAcdMGHA.2668@xxxxxxxxxxxxxxxxxxxxxxx
1. Is PostgreSQL is suitable in VFP application ?
2. Is VFP OLEDB is faster than Native VFP Database when that is more
than 200 MB size of table and more than 50 users concurrently access the
VFP Tables ?
.
- Follow-Ups:
- Re: IS PostgreSQL suitable in VFP Application
- From: Linn Kubler
- Re: IS PostgreSQL suitable in VFP Application
- From: Tsair
- Re: IS PostgreSQL suitable in VFP Application
- References:
- IS PostgreSQL suitable in VFP Application
- From: Tsair
- Re: IS PostgreSQL suitable in VFP Application
- From: Cindy Winegarden
- Re: IS PostgreSQL suitable in VFP Application
- From: Tsair
- IS PostgreSQL suitable in VFP Application
- Prev by Date: Re: How to mask a jpg?
- Next by Date: Re: Enabling speech in VFP using SAPI5
- Previous by thread: Re: IS PostgreSQL suitable in VFP Application
- Next by thread: Re: IS PostgreSQL suitable in VFP Application
- Index(es):
Relevant Pages
|
