Re: IS PostgreSQL suitable in VFP Application

Thanks Matthew,

That is what i need.

Could you guide me what are the files I need to copy into windows OS like
win98, win2000, winxp and how to run the server ?


"Matthew L Reed" <nousenetspam at dead ice dot us> wrote in message
news:uNPzkDlMGHA.3732@xxxxxxxxxxxxxxxxxxxxxxx
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 ?











.

Relevant Pages

  • Re: cascade
    ... I am talking about creating a cascade relation in MS Access 2003 ... VFP, but it needs a supporting stored procedure in the database. ... cascade delete update relation using odbc. ...
    (microsoft.public.fox.vfp.forms)
  • Re: FoxPro free table, index, seek, with vb.net
    ... "Seek" command against a FoxPro table via ODBC or OLE DB. ... writing that SQL command string in VB, VB.Net, C#, VBA, or anything else ... VFP OLE DB:http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx ...
    (microsoft.public.vb.database)
  • Re: IS PostgreSQL suitable in VFP Application
    ... to any ODBC or OLE DB compliant database, ... You don't use the VFP ODBC driver ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Unable to open data source
    ... from Access when it executes a DATABASE field. ... that it uses the OLE DB Provider for ODBC Drivers to do it. ... The sreason I suspect that is because when you use OLE DB to open an Access ... square brackets (Jet syntax AFAIK): ...
    (microsoft.public.word.mailmerge.fields)
  • Re: trigger problem
    ... If the database is open shared you can't add tables to it. ... Are you using ODBC or OLEDB? ... Are you using ODBC or OLEDB from a VFP application to talk to a VFP ... >> BUT I USE SQLPASSTHRU THE TRIGGER WONT MAKE QQ.DBF AS WELL. ...
    (microsoft.public.fox.helpwanted)