dbtab

Using a Database

Your TAD model can be developed along with an associated database to flesh out the finer properties of the objects in your model. We strongly recommend that you use the SQLITE database system. You can set any executable or batch file which will handle the database (such as creating or editing; or even browsing it) TAD has a special affinity to to an open source project called “sqlitebrowser” It is an excellent, simple to use system to work on Sqlite databases.

You can download that software from here: https://sqlitebrowser.org/dl It is free. Moreover, you can directly set the name of this executable by double clicking on the space provided for the name of the Db app that you plan to use. In the open file dialog that comes up; you can either select the executable (as noted earlier, we highly recommend sqlitebrowser) or you can even use a batch file that internally starts whatever program that handles the database attached to TAD.

TAD opens this database application by double clicking special lines in the “has” editor. (Read about that here) When opening the application or batch file; TAD will pass on the following command line parameter also:

-t <TABLENAME> <DBNAME>

In the above command line parameters; <TABLENAME> is the name of the database table TAD was able to deduce. And <DBNAME> will ALWAYS be the name of your TAD file (along with path) with an additional extension of .db

You can use all that information to change your BATCH file (in case you are not using sqlitebrowser but it is something else). As explained earlier; TAD highly recommends using the simple and excellent Sqlite database system but with some tweaks, you could use other kinds of databases; including those you host on the web. But you would need to configure the batch file accordingly

The way a TAD model works with databases is explained separately in another topic here

All said and done; in order to use this feature; you would need to give a special token here. You can get the token from here: https://tad.in.net/goodies either free or by paying a donation.