Screenshots |
|
Db7 | Source Code |
|
|
Db7 is a Database Inspector. The Database Inspector provides access to MySQL, MariaDB, SQLLite, PostgreSQL, Oracle, Firebird, Interbase, Db2 and SQL Server databases. Databases can also be accessed via the ODBC interface. Db7 uses a browser as user interface. If the browser is not running it will be started. If the browser is already running a new tab is opened, which contains a dialog to do a database login. UsageDb7 can be executed from the commandline with: s7 db7 At the Db7 login page the database type can be selected. The name of the database can be given in one of these forms:
The user name and the password can be entered also. After a successful login SQL statements can be executed. The SQL statements are sent to the database. So it depents on the database, if a SQL statement is accepted and executed. Only a few things are independent of the database:
Instead of executing a SQL statement it is also possible to get a catalog of tables defined in the database. In the catalog it is possible to get the contents of a table. How the user interface worksThe library browser.s7i defines a function to open a browser. The browser is instructed to load a page from a specified port. The program listens at this port and answers the HTTP request. Pressing a button in the browser triggers a new request that is again answered by the program. The program uses the library cgidialog.s7i to create HTML to answer the HTTP request. In the Seed7 program dialog elements are defined. HTML and HTTP are encapsulated in the library, such that the programmer does not need to handle HTML or HTTP. |
|
|
|
|