TCB db Manager Lite

db Manager Lite displays a graphic representation of data structures. It can display a real database, i.e., multiple datasets, each containing multiple recordsets or tables. The Data Tree Window can also show other hierarchically organized files.

Selecting a dataset in the Data Tree Window sets the data set as the default data set and displays its tables in the Recordsets drop-down selection box. Selecting a table in the display sets it as the default table and fills the Data Grid with records from the table. Full, multi-line SQLite queries, including "dot" commands, can be entered in either the Composition Window or Results Window and run. DBML can also run queries from disk files

The DB Manager Window

Near the left-top of the window is a tuerquoise "Menu" button. Clicking the button enables a drop-down menu that runs various database functions..

On the left, top of the window is a set of buttons arranged vertically. The first or topmost button should display this document. The next three buttons are window control buttons. The first minimizes the window. The second button toggles the window to stay on top of other windows or not. The third button closes the process.

To the left of those buttons is a data tree window. It can contain data base structures or display data from TCB data tree files. At the top of the data tree display are three buttons arranged horizontally. The first or left-most button opens a dialogue to select a data tree file to load. The next button from the left clears the data tree diagram. The last button refreshes the data tree.

A set of drop-down selection boxes are located to the right of the data tree. The top left drop-down, Data Sets, contains SQLite data set files names used in the process. It is loaded with an initial list of files from a prepared plain text file. Subsequently, it can be added to using the Open dataset file button described below. When a dataset is selected and the Enter key is pressed, the dataset is set as the default dataset, and the tables in the data set are loaded into the Recordsets drop-down next to it.

When a table is selected in the Recordsets drop-down and the Enter key is pressed, the Data Grid is filled with records from the table. Below the Data Sets and Recordsets drop-downs are three drop-downs containing useful information that can be used in formulating SQL queries. When an item is selected in these drop-downs and the Enter key is pressed, the text of the item is inserted into the Composition Window.

To the right of the data tree window are two large boxes arranged vertically, the Data Grid, and Composition Window. The Data Grid displays data from TCB data grid files or SQLite databases generated from queries or object functioning. The Composition and Results windows can be used interchangeably. The difference is that the drop-down objects in this process, insert their selected contents into the Composition Window when the Enter key is pressed. Both these boxes have clear box, run SQL, execute box contents, save to file, and load from file buttons. The Composition Window also has an explain query button.

Finally

The Menu button at top of the DB Manager window provides most of the real power of db Manager Lite. The Make browse selection makes a table browse\edit process for the default table and runs it. The process screen is properly labeled for the table with any needed input boxes. It contains a Data Grid loaded with records from the table. The created process will have the current screen background image applied.

The Export data selecttion opens a dialogue for the user to select a file to exports data from the default table into a .csv file.

THe Check data set selection checks the default dataset for integrity, if OK, the Composition Window will display "ok."

The Compact data set selection compacts the default dataset and the

The Load query from file runs query from a file and puts the results in the Composition Window.

The Default table selection gets information for the default table and inserts it into the Composition Window.

The Open a data set selection opens a database file or create a new one. Open sets the dataset file as the default or creates it new, adds it to the Data Sets drop-down, loads the dataset structure into the Data Tree, and loads the Recordsets drop-down with tables, if any, from the dataset.

The Add column selection opens a dialogue to add a column to the default table.

The Rename default selection opens a dialogue to change the name of a table.

The Register default selection registers the default default table as a TCB table. It creates a special descriptor record for the table in a system table called "Recordsets." If this table doesn't exist in the default dataset, it is created automatically. This descriptor uses descriptions for the table that already exist. The Recordsets descriptor record can be edited to create enhanced descriptions for a table structure.

The Import .csv data selection opens a dialogue for the user to select a file to import comma separated or .csv data into the default table. Of course, the format (location of data) should mirror that of the table.

The Recordset Master selection runs te RecordSet Master program to create TCB datasets. It produces SQLite datasets and tables with special descriptors for enhanced TCB processing. All the tables created by RecordSet Master have the first column described as "rsid integer autoincrement." It creates a special descriptor record for the table in a system table called "Recordsets." If this table doesn't exist in the target dataset, it is created automatically.

The Remove the default selection opens a dialogue to delete the default table from the default dataset.

There is a row of data control buttons for scrolling and adding, deleting, and updating the table. Next is a search box that allows a record to be placed in the view/edit area using its id number. The user can also enter a SQL where clause without "where" and no closing semicolon, ";". For example: categoryname like '%produce%'. That example will result in data from the first record with the string "produce" in the "categoryname" column being placed in the view/edit area. Selecting and the right-clicking a record in the Data Grid, places its data in the view/edit area.

Summary

The db Manager Lite process provides a better SQLite database manager than most all hard-coded database managers except maybe our own from which this process is modeled on. In fact, the only thing the db Manager Lite process doesn't do that our hard-coded one does, is convert dBase .dbf files. But, the drag-and-drop TCBdbCnv.exe program that comes with this version does that.

Features:

  1. Real database view with up to 99 datasets at once
  2. Each dataset can have up to 199 tables
  3. Each table can have up to 199 columns
  4. Multifunction data tree
  5. Multifunction data grid with re-sizable columns
  6. Composition Window
  7. Use window as a batch execution engine
  8. Use window as a SQLite query engine
  9. Load and save files to and from window
  10. Datasets drop-down
  11. Recordsets drop-down
  12. SQL scraps drop-down
  13. TCB functions drop-down
  14. SQLite pragmas drop-down
  15. Create and run independent browse/edit screens (processes) for any table
  16. Create SQLite datasets
  17. Create SQL tables in SQLite datasets
  18. Rename SQL tables in SQLite datasets
  19. Delete SQL tables from SQLite datasets
  20. Add columns to tables in SQLite datasets
  21. Compact SQLite datasets
  22. Check SQLite dataset integrity
  23. Run SQL queries from a file
  24. Get SQLite table information
  25. Import data from a .csv file into a table
  26. Export data from a table to a .csv file
  27. DBML is user-modifiable
  28. DBML is user-extensible
  29. DBML is customizable












Copyright © 1982-2016 Phoenix Information Systems/TM all rights reserved
Contact: Fred Pierce, makpiya@aol.com, makpiya@gmail.com, 831.240.9969