sqlFree A 100% Java Visual SQL query builder
Download

sqlFree Ranking & Summary

sqlFree Tags

build builder query SQL builder query generator locate visually build SQL visually SQL statements executer build Python program client statements

sqlFree Description

The SQL Builder part is a component taking a model-description of tables and attributes. It is completely separated from any needs to work on ResultSets or DB-specifics. Over an interface there's also the possibility to integrate the builder into any application. Get sqlFree and take it for a test drive to fully assess its capabilities! Main features: Visual SQL query builder: Support for statement types (Select, Insert, Delete, Update) supported join types (inner, left, right, self) Meta-information available for inspection: Primary key, nullable, datatype etc. Generation optionally includes schemanames into the built SQL-statements Uses metainformation for generation. Example: if datatype information is available values automatically are quoted. ability to visualize DB-stored relationinformation - only for displayed tables as well as for all tables (think of displaying a datamodel) - of course this information has to be provided by the database Supports tablenames with whitespaces For layouting issues fontsizes of your tables can be specified No syntax-errors in queries You see that your queries do what they are intended to do. This especially is an advantage in bigger queries. Generates readable layouted SQL statements Easier and faster than writing by hand. Just think of queries having a few joins, criteria, sorting clauses and all the other stuff. Reverse engineering of SQL statements - the Parser: Give sqlFree your statement and it will visualize it in its SQL query builder. You'll see what it does. Preconfigure queries. Load and use them without writing them again. Use placeholders in your statements and configure them at the time you are sending your statement to the database. Sending SQL statements to the database: Send your specified queries directly to the database and view the results. Use any JDBC-driver you like for database communication. The RMI-server of sqlFree gives you the opportunity to run it anywhere. So you just have to install a database-driver once. Connecting to this RMI-server you may access the database from any PC a Java virtual machine is available on - sqlFree will run as applet in your browser. Characterencoding can differ between database and application. Specify it. Viewing returned results: Results may directly be viewed Lazy read: You can configure how many results shall be read in a block. Interesting for very big resultssets. Binary data fields are offered to be saved to disk Generate XML-representations of your results Generate appropriate Insert-scripts for the displayed results Databasebrowser: Information about your database is diplayed hierarchically in a treeview. Generate XML/HTML representation of your database Generate Drop-table scripts General: 100% java application Included installer/uninstaller No switching between operating systems for getting DB-information Tested with databases: Oracle, DB2, SQLServer, Cloudscape, MySQL, PostgreSQL, Access, SAPDB, Solid, HSQLDB Connecting to any database having its own JDBC-driver Easy to use Easy to configure

sqlFree Related Software