Q: I am interested in
integration the Visual SQL Builder into my product. Is
this an option for IndependenceSoft and how can this be
done? A:
Of course it is! sqlFree is implemented componentbased.
There are several parts: a
SQL console, a Visual SQL Builder, a databaselayer etc..
The SQL builder for example is completely separated from any other layer.
This means it is working on a model-representation of the
database. Think of table-objects
each containing multiple attribute-objects. Generation of
statements, table adding, relation adding etc. can be triggered by your
application. But in the normal case you simple create the
basic information of table- and attributenames, give it to
the builder and wait until your listener is called with
the finally generated statement.
The other parts of sqlFree include also DBLayer:
This layer does the backend communication and builds the table/attribute model
for the database, queries the database etc.. The functionality is encapsulated
for use with RMI. So you are able to run the RMI-Server on a Windows-machine
having the appropriate drivers and querying databases while using the
frontend
from Linux/Unix machines. For more
information please directly contact us. |