The geniuses at FoxSoft made the fastest, cleanest,
thinnest data access of any integrated database development tool, and the use
of my "100% coded in Foxpro" client and server can extend its capabilities
to make it both robust and secure. With the addition of the Vtables it will also demolish
foxpro's existing size limitations without making it as clumsy , complicated or unwieldy
as its competitors..
If you modify your code by encapsulating the data calls inside my
XSERV( <your seeks ,SQL select , Gather, Scatter,Replace Locate or
update here>) UDF which calls the local client part of my package.. ( and then
passes the request on to the transactional database server application running on a
separate data server waiting for requests... that server then performs the
queries/operations on the tables and passes the information back to the requesting
client...
only one, (probably LOCAL) connection is established to your tables per
server session, you can run as many server sessions on a machine as you choose...best of
all , the code is compatible with ALL versions of Foxpro back to 2.5 (DOS and windows) up
through VFP6
Security is primarily handled at this point by restricting access to
the dataserver (but not the transaction tables from whence it gathers requests) , But file
and field and record level security are available for development upon request.
A future version is planned to break the 2Giggabyte barrier by
seamlessly incorporating concatenated "virtual tables" (and archiving ) allowing
tables of ANY size...
Why use this product instead of SQLserver or SYbase or even
ORACLE
1) Control : if you purchase an open source copy , you have
control of it, and can hire a programmer to change , tweak or add to its capabilities at
your
leisure
2) cost: I guarantee I'm cheaper, and that the maintenance and
operation of this server will be cheaper both in the short and long term than its larger,
clumsier , more complicated rivals
3) let me just say maintenance costs AGAIN.. you wont have to scour the
world for an oracle wizard or even some who knows the intricacies of SQLserver to VBasic
gymnastics... the beauty of this code is that its simple and small , and its genius is
that once you've seen it you'll kick yourself for not having written it. Its tiny. any
Xbase programmer you hire will be able to read the code itself, no classes, seminars,
expensive upgrades and retraining... just read the code, and no how it works and what to
do with it.