Visual Mashup
Builder
|
AppliBuilder
User Documentation
|
|
Manage Your Application Database
Each application developer gets one database to be used for her/his
application(s). Only one database is provided for each developer, and
the same database needs to be used for all applications created by that
developer.
With DataCaster, tools are provided for managing your database from
the client. When working with other databases, separate tools not
provided by this product must be used to manage the database.
Database Administration
Choose the Manage Databases item from the Database menu. A
separate window is provided to let you manage and interact with the
database. The functions provided include:
- You can browse your database and see all the tables and data in
your database.
- You can run queries (which includes update statements) using the
Run Query window.
- You can open a separate Manage Named Queries interface (this is
being transitioned to the Builder tool, and will be provided only until
all features have been integrated into the buiilder.)
You will need to monitor and manage your data when required using these
tools and SQL.
Remote Database Access
You can access remote databases, both databases of other users and
remote server databases like geodbs.com,. using URLs. You may
also grant remote access to your
database to other users.
To access remote tables in your queries, use the following syntax:
http://<server_name>[:<portnumber>]/Table/<database_name>/<table_name>
For example, http://datadirectory.net/Table/CHART_DB/COMPANY_STATISTICS
Currently you can grant only anonymous access to other users and
servers. Allowing authenticated user-based access will be
permitted soon. To grant anonymous remote select access to a
table, execute the following SQL statement
GRANT SELECT ON mytable TO ANONYMOUS
Database Archiving
Database archiving will be available as a service. Details to be
provided.