Direct Database File Access and ListManager

It is possible to directly manipulate the Aurea List Manager database. Much of the data in the database is related to other data, so changes to one field might require a change to another field in another table. Making modifications without understanding the data dependencies and field definitions can lead to unexpected results. It is highly recommended that users test their scripts on a private test list before running them on public lists.

Changing the data in tables while Aurea List Manager is running is a little dangerous but should generally work. You need to understand the database design well enough to know if changes made to the tables has an immediate effect or not. In some cases, Aurea List Manager is regularly polling a table for changes, but in other cases, it won’t pick up a change until the system is restarted.

 

Programmers should feel free to work with the members_ table. Many companies want to be able to add or change the membership information in the members_ table dynamically, and doing so generally should not cause problems.

Programmers are encouraged to import their membership data directly into the database server using the native tools provided by the database. Using these tools results in import speeds of millions of records per hour, which is faster than any other method available through Aurea List Manager.

While Aurea List Manager is expecting users to add columns to the members_ table, it may cause errors if existing columns/indexes are changed, or the schema is modified in other tables. Developers interested in making demographic data available for mail merging or for the purpose of determining whom to send mail are encouraged to add columns to the members_ table or to a new table. Aurea List Manager has the easy ability to pull data from user-provided tables during the mail merge process.  

All tables are designed by Lyris for the purpose of making Aurea List Manager as fast and powerful as it is today.

Remember that any of the tables used by Aurea List Manager presently may be changed in subsequent versions of Aurea List Manager.

Lyris offers no guarantees that the schema used for one version of Aurea List Manager is the same for another version.