advantage db

[chukalv]

Hello!

I`m now starting to understand database structures and how they`re working. As i understood, the Advantage database's are one of the good. I'm looking forward to make a local db, for huge entries (70 000 and up). It's for a lexicon.
Right now there's a mysql+php version already ready, but my goal is to make an local version. To understand I was exploring an already ready project. I think I understood how the delphi is communicating with the db files (local db), but
there are some questions:
- for what is the *.adt file and for what is the *.adi file? Do I have to include both of them into my project?
- how to make an Advantage table (the adt and adi files) from a sql code? Do I have to use delphi or are there any other tools?
- how much space would the advantage local db file take, that includes 70 000 entries?
- what exactly is not free in the Advantage db system? I'v downloaded the TDataSet and as it seems, it works and reads the db files for free.
- are there any other better solutions or example how to manage and create a local lexicon?


Thanks in advance!

[hsg]

Zitat von chukalv:

Hello!

I`m now starting to understand database structures and how they`re working. As i understood, the Advantage database's are one of the good. I'm looking forward to make a local db, for huge entries (70 000 and up). It's for a lexicon.
Right now there's a mysql+php version already ready, but my goal is to make an local version. To understand I was exploring an already ready project. I think I understood how the delphi is communicating with the db files (local db), but
there are some questions:
- for what is the *.adt file and for what is the *.adi file? Do I have to include both of them into my project?
- how to make an Advantage table (the adt and adi files) from a sql code? Do I have to use delphi or are there any other tools?
- how much space would the advantage local db file take, that includes 70 000 entries?
- what exactly is not free in the Advantage db system? I'v downloaded the TDataSet and as it seems, it works and reads the db files for free.
- are there any other better solutions or example how to manage and create a local lexicon?


Thanks in advance!

I try to answer some of your questions, sorry my english is not the best (feel free to correct me):
1) adt-files are a special table format from advantage similar to .dbf (old dbase-format), .adi are the index-files

2) download the adac or tdatadescands from advantage (adac if your delphi-version is above delphi8) and install it, so you have native access to the table, use a TADSConnection for the connection to the databases and a TADSQuery for your sql-stateman. If you don't want to play with delphi directly, you can use the advantage database architect (arc32), with this tool you can create new databases and connections to dictionarys (a set of tables), also it offers a grid to show the data inside and a sql-tool to build your queries.

3) the size of the whole database is depends on the fieldsize.

4) the local database-system is free, if you need a client-server solution then you must by a server with more capabilities (transactions for example)

hth
Jörg

[Bernhard Geyer]

Zitat von hsg:

4) the local database-system is free, if you need a client-server solution then you must by a server with more capabilities (transactions for example)

It's not free if you use it as a "server". For this you need a license.
A "server" is when you use it in Webbased/Server-Technik like ASP.NET or Intraweb or Citrix or Remote Desktop!

[hsg]

Zitat von Bernhard Geyer:

Zitat von hsg:

4) the local database-system is free, if you need a client-server solution then you must by a server with more capabilities (transactions for example)

It's not free if you use it as a "server". For this you need a license.
A "server" is when you use it in Webbased/Server-Technik like ASP.NET or Intraweb or Citrix or Remote Desktop!

Advantage has two products: "advantage database local" (this is free) and "advantage database server", wich is not free (so here you must by a license ). the "advantage server" is a service on a computer and your application talk through a client-mechanismen over the lan/wan with the server. I hope now is it clearer...

Jörg

[Pfoto]

Hello!

I'm currently using the NexusDB-system,
there is a free embedded version too with no restrictions!
(also full support of transactions)

One of the reason I use NexusDB is the very large pool of SQL-Statements,
even SQL 2003 and Nexus-own commands.
And there is a really huge newsgroup with a fast und helpfull support...

Of course, that's only my experience... (ADS is a fine DB-system too)


I always would recommend to use a database-system for your task,
because with a real database you needn't to load in the whole (uge) file -
after a user has made a database-query there will be just loaded in
the result you are asked for...

Do not worry about the file size! If you have only text (no media-files)
it's not all to mutch. (And of course you can optimized your table/datafield-
strukture as long until you satisfied)


Regards
Pfoto

[Bernhard Geyer]

Zitat von hsg:

Advantage has two products: "advantage database local" (this is free) and "advantage database server", wich is not free (so here you must by a license ). the "advantage server" is a service on a computer and your application talk through a client-mechanismen over the lan/wan with the server. I hope now is it clearer...

Thats clear. But starting with Version 7.0 your app will not run in a Remote Desktop-Environment if you use the ADS Local Server. You will get a Message-Dialog that show this limitation.

[chukalv]

many thanks guys