Board index » delphi » Database

2003-07-16 04:03:22 PM
delphi39
Hi,
I would like to know if anyone could advise me on which database application
to use based on a choice between Paradox and Access.
I have been told Paradox is unreliable and Access has a limit on how many
records it can store.
Any advice would be great,
Thanks
Tgn
 

Are you limited to these two?? - there are lots of others.
Paradox seems a bit old hat now.
Access works fine for me and the limits aren't too bad. I use Access 97 -
there are much newer versions - but it happily runs a million records for my
application.
From the help on "Limits" -
Database (.mdb) file size 1 gigabyte. However, because your database can
include linked tables in other files, its total size is limited only by
available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to
True) 1024
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
(BTW the "number of objects" is NOT the number of records.)
HTH
Eddie
Remove XORY from address to reply.
"sct" <XXXX@XXXXX.COM>writes

Have you tried DBISAM. it is a very good database
environment.
try this link.
www.elevatesoft.com/
"Eddie O'Brien" <XXXX@XXXXX.COM>writes

i want to use mysql as my database. the problem is what do i need to tell
cbuilder what component do i have to use
 

Look at TSession, TDatabase, TTable, TQuery, etc. You will have to set up
an ODBC datasource that points to your MySQL database first. To set up your
ODBC go to your control panel in your windows OS and then go Data Sources
(ODBC).
I think there are also some vcl components you can download that access a
mysql database through native drivers rather than going through the ODBC if
you are interested in high performance. Just don't remember names of
them...been I while since I messed around with MySQL.
"nunjimmimya" <XXXX@XXXXX.COM>writes

components works like a charm. The best option by far if you
want to work with mySQL and Builder.
 

thanks a lot
 

How does one do this: Write an app that manages a local database. Users
can go to a website and query (read only) the database. The database
contains 50,000 records, and so we do not want the queries to use up a
great deal of bandwidth.
Basically, I am asking how does one write an app that will interact with
a web page permitting queries?
Thanks.
 

I am not sure whether I understand what you want...
let's say you have a database and a web server...
You want to develop a web app to access the DB... first of all I would
access the DB with SQL ( C/S-way )...
I would look for a DB capable to handle SQL in Client/Server-way ( like
DBISAM / Oracle / FireBird etc. )... there are a lot of ree and commrecial
ones out there....
If you really have only a local DB available ( like a DBF or Paradox ) then
you will use some bandwidth. Perhaps the DB vendor has built in some
optimization techniques ( like being able to utilize Indices when browsing
the DB )... use whatever the DB has to offer and hope it is ok for your
users / load / bandwidth...
Yahia
"Sanford Aranoff" <XXXX@XXXXX.COM>schrieb im Newsbeitrag

I can use dbisam with sql.
What about kbmMW?
Then what?
Yahia El-Qasem writes:

If you have Delhpi 7 then there is a component set called IntraWeb in it - I
would upgarde to latest 5.x version for free or buy the subscription incl.
the current version 6.0.20 and start developing. It is very easy because you
can leverage all your delphi skills... IntraWeb allows you to use the form
designer to create web applications...you have all the things you already
know ( like events etc. ) available like in a normal app - but for the web
:-)
IntraWeb comes ready with Data-aware controls ( TDataSet compatible like the
ones in the IDE )...
Depending on what load you expect for your app you could develop a
middletier using kbmMW - I myself never used it though I read it is very
good...
If you don't expect for the start a big load then just partition your app
logic into data modules so it would be easy to switch from two tier to
multitier architecture with whatever framework you like ( i.e. kbmMW / SOAP
/ CORBA... )
Yahia
 

recently i bought c++ builder 6.00 personal, just then i realised that there
were no standard database connections possible.
is there an other way to connect to an odbc, mysql database from this
package.
please reply to XXXX@XXXXX.COM