data/jdb/browser - JDB browser
JDB browser allows to connect to a database and browse database schema, view table data and execute queries.
JDB Browser connects to a JDB database through the file system, so it acts as an in-memory database, as opposed to a remote client.
You can start JDB Browser loading the data/jdb/browser script: associating a key in J configuration or typing in J session
or from shell command line or shortcut (see Explorer Integration below)
j -jijx data/jdb/browser
j -jijx data/jdb/browser "path/folder/database"
To connect to a database file, use File|Connect menu item.
A regular File Open dialog is used to locate the JDB database. To open a database, select the file named dir in the database folder.
Window title shows currently open database.
The Tables list shows available tables in the database. The Schema tab shows the schema of the selected table. The top script view shows the Create syntax, and the grid at the bottom shows the structure of the columns.
The Data tab shows the values in the selected table. The top script shows the query used to retrieve the data. The grid at the bottom shows the result.
You can copy the query to the Script tab to use as a starting point.
The Script tab allows to enter one or more query statements, separated with semicolon (;). When Run button is pressed the query containing the caret is executed. The bottom grid displays the result.
To open or save the script, use File|Open and File|Save menu items.
The bottom log view tracks the status of the execution.
For Windows, edit path to J and extensions and run browser.reg to open jdb files from Explorer.
Before running the reg file, replace path-to with the location of J installation.
Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Directory\shell\jdb] @="Browse JDB" [HKEY_CLASSES_ROOT\Directory\shell\jdb\command] @="\"d:\\path-to\\j602\\bin\\j.exe\" -jijx data/jdb/browser \"%L\""
Contributed by OlegKobchenko