SQL Library
The SQL library is one of the key features of DTM SQL editor. It is a collection of SQL scripts, statements or even fragments of the statements. This collection has hierarchical structure and integrated to DTM SQL editor and a few other database utilities by DTM soft like DTM DB Stress.
Physically the library stored as a set of .SQL files in the location provided by the user. By default, it is library subfolder of DTM SQL editor installation. The user can move the library with operating system tools (like Windows Explorer) and change a path to the library in the product's settings. Of course, the library back up will be created automatically by system process if the user configured his or her data to back up.
There are two useful locations of the SQL Library: locally and on the shared network drive. The first case is suitable for the individual library when the second one is perfect for the team.
How the SQL Library increases performance of SQL developers or developers team?
Due to static database structure all users, administrators, and developers select data from the same set of tables. Most popular queries are executed again and again by same or different users with or even without variations. Another idea is to store database-specific versions of most useful scripts at library's subtree.
If mentioned query or part of the query is stored in SQL Library, any DTM SQL editor user can insert it to the editor by 2-3 clicks. We recommend to add to the library following items:
- Complex queries with joins that reflects to business objects. For example, it may be join between "Order" and "Order Details" tables by "Order ID" column. This join will be used in any query from this pair of tables
- Complex "where" statements. The user will change constant values and save a lot of time on names entering.
- Reports. If the complete statement or query will be executed once per week, month or year it should be located in SQL Library.
- Lists of columns for "select" and "values" clauses. The complex list of columns with "AS" clauses is a good candidate to load to your library because all users can get it for statements designing.