Delphi and database choices for network installed database

Delphi and database choices for network installed database

Post by Andrew H. Gril » Wed, 21 Aug 1996 04:00:00



Well, if you are using Access you are restricted to Delphi 2.0 if you plan
on not using ODBC.  If you choose Paradox on the other hand both are
supported with the BDE.  We are currently using Paradox for the same
reasons.  Our current project is 16-bit and the biggest problem, other than
cost, of scaling up to Interbase is the installtion nightmare it creates
for your end users, if they want to run it on the network.

I vote for paradox.  When setup right it is very fast and effecient.  Be
sure to make Primary Keys for your indexes because the secondary ones don't
do squat when using TQuery.

--
Andrew H. Grilk
Securities Data Co.
Newark, NJ



Quote:> I'm just getting ready to start a new project using Delphi and I would
like
> some opinions as to what database to chose for a network installed
database
> for multi-user access.  I can not recommend a interbase or SQL server
type
> solution (too costly) and hence have to make a choice between Paradox and
> Access.  Which database is the best choice for a multi-user network
> installed database and what issues should I beware of(not sure if I'm
using
> Delphi 1 or 2 yet either).

> Thanks
> Blake

 
 
 

Delphi and database choices for network installed database

Post by Blake McNeil » Wed, 21 Aug 1996 04:00:00


I'm just getting ready to start a new project using Delphi and I would like
some opinions as to what database to chose for a network installed database
for multi-user access.  I can not recommend a interbase or SQL server type
solution (too costly) and hence have to make a choice between Paradox and
Access.  Which database is the best choice for a multi-user network
installed database and what issues should I beware of(not sure if I'm using
Delphi 1 or 2 yet either).

Thanks
Blake

 
 
 

Delphi and database choices for network installed database

Post by Jay Schwis » Thu, 22 Aug 1996 04:00:00




Quote:> I can not recommend a interbase or SQL server type
> solution (too costly) and hence have to make a choice between Paradox
> and Access.  Which database is the best choice for a multi-user
> network installed database and what issues should I beware of(not sure

  > if I'm using Delphi 1 or 2 yet either).

Paradox, since it is Borland fits the best IMHO with Delphi.

my $.02

God Bless,

 
 
 

1. Choice of database solution for a small database.

Let's say that there's a Unix program and there's some data.
Program should run on low-end computers.
The most probable amount of data is between 512kB to 16MB, and
operations on data are quite simple: lots of searching,
some adding and altering record and iterating, rarely deleting record.

There would be only one thread using data, so there is no locking issue.
Program doesn't need to be systemcrash-proof.
It would be nice if not too much memory were used.

Should program:
    1) implement data as C structs ?
    2) use database library (like libHDF) ?
    3) use external database program (like MySQL) ?

And in cases 2 or 3 which library/program would be the best ?

2. Mail

3. Delphi and network database

4. Fox FAQ List

5. Tool or engine to open Clipper Databases in a Networking Environment using Delphi 5

6. UDR with esqlc ?

7. Rule in Delphi when updating network database file

8. ADOX, Jet OLEDB:Allow Zero Length ERROR...

9. How to access database via network using delphi 3.0

10. HELP with Delphi database access on a network

11. Delphi database application on a Novell network.

12. Networking Delphi Databases - help requested