projects:querybuilder
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
projects:querybuilder [2011/01/24 11:42] – rlunaro | projects:querybuilder [2011/06/01 11:29] – [http://sourceforge.net/projects/sqleonardo/] rlunaro | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Query builder tool ====== | ||
- | |||
- | ===== The project ===== | ||
- | |||
- | The objective is to replace the query designer of access with a similar tool. This is because access have known liminations with the size of the MDB files that make it inadequate for running enteprise-size or huge databases. | ||
- | |||
- | |||
- | ===== My notes ===== | ||
- | |||
- | I've search in codeplex, google and sourceforge for the most suitable products. And in the next section I've put those that more or less appear to be " | ||
- | |||
- | ==== http:// | ||
- | |||
- | * **Webpage: | ||
- | * **Price:** 360$ per licence. Discounts for big quantities. | ||
- | |||
- | Does it connect to Oracle and Access?? | ||
- | How good is the query tool? | ||
- | Does the query tool allow to export the query as sql? | ||
- | Supports the creation of batch jobs?? | ||
- | |||
- | ==== http:// | ||
- | |||
- | * **Webpage: | ||
- | * **Price:** | ||
- | |||
- | **My Impression** | ||
- | |||
- | Easy installation. All the application in english, not good. | ||
- | |||
- | Professional appearance. | ||
- | |||
- | Doesn' | ||
- | |||
- | ==== http:// | ||
- | |||
- | * **Webpage: | ||
- | * **Price:** | ||
- | |||
- | **My Impression** | ||
- | |||
- | Easy installer. Auto-updater available, you can forget about the hassle of checking for updates from time to time. | ||
- | |||
- | Professional appearance. | ||
- | |||
- | Doesn' | ||
- | |||
- | Everytime I try to open a table it fails. | ||
- | |||
- | The trial version is only for 1 day. | ||
- | |||
- | ==== FlySpeed SQL Query ==== | ||
- | |||
- | * **Webpage: | ||
- | * **Price:** | ||
- | |||
- | **My Impression** | ||
- | |||
- | Very fast installation. | ||
- | |||
- | Quickly connection to big databases, with a feature to filter databases. It took the list of tables in a glimpse. And it refreshes the list while allows operation of the application. | ||
- | |||
- | It has an option to set the database as read only, an interesting feature that could avoid those nasty problems I got with other software when they try to open the tables for modify. | ||
- | |||
- | It doesn' | ||
- | |||
- | It doesn' | ||
- | |||
- | ==== http:// | ||
- | |||
- | * **Webpage: | ||
- | * **Price:** 180 euros | ||
- | |||
- | **My Impression** | ||
- | |||
- | I were unable to connect to the oracle database. Probably a bad design in the connection interface make it difficult to achieve. | ||
- | |||
- | Location of tables very quickly, you don't have to wait until the list is filled. | ||
- | |||
- | Can't save the sql into a text file, but not store the result table into a new table (for make further queries). | ||
- | |||
- | |||
- | ==== http:// | ||
- | |||
- | * **Webpage: | ||
- | * **Price:** free | ||
- | |||
- | **My Impression** | ||
- | |||
- | It's a java application that uses the power of JDBC to connect to many databases and ease the creation of queries. | ||
- | |||
- | However, it is somewhat difficult to install -you have to install the jar file and provide access to it across the system- and you have to provide the necessary drivers for the application. | ||
- | |||
- | It takes some time to create a query, but finally it does the job. | ||
- | |||
- | It doesn' | ||
- | |||
- | ==== http:// | ||
- | |||
- | My impression is that this program is a tool to help developers to create their own queries, and | ||
- | doesn' | ||
- | |||
- | |||
- | ==== http:// | ||
- | |||
- | * **Webpage: | ||
- | |||
- | Only for mysql. It is a web application, | ||
- | |||
- | |||
- | ==== http:// | ||
- | |||
- | * **Webpage: | ||
- | * **Price:** Free | ||
- | |||
- | **My Impression** | ||
- | |||
- | It seems that the qurery builder tool is a bit rare, so I decided to evaluate this the last. | ||
- | |||
- | |||
- | ==== http:// | ||
- | |||
- | * **Webpage: | ||
- | * **Price:** Free | ||
- | |||
- | **My Impression** | ||
- | |||
- | It only works with mysql. Furthermore, | ||
- | |||
- | |||
- | ===== Products I am evaluating ===== | ||
- | |||
- | |||
- | |||
- | |||
- | http:// | ||
- | |||
- | |||
- | http:// | ||
- | |||
- | Curious: | ||
- | |||
- | http:// | ||
- | |||
- | |||
- | ===== And the winner is... ===== | ||
- | |||
- | No winner yet. | ||
- | |||
projects/querybuilder.txt · Last modified: 2022/12/02 22:02 by 127.0.0.1