Tagged

The mood in here

SQL editor

My idea is to improve the query builder! It needs joins. Sure the SQL editor fixes that, but it doesn't feel iPaddy.
The whole query builder is too small. It shouldn't be a popup. I'll be spending a lot of time there, and can't imagine I'm the only one. And can the query editor recognize a sql statement. Otherwise great app. Thanks

Thanks for the suggestions for improving the SQL editor. Do note, though, that we do have some level of support for automatic joins in the current SQL builder: if your database schema declared foreign key constraints between tables, then in the screen where you select the columns for your query, you should also see the list of related tables at the bottom of the view. Tapping the related tables and selecting the columns in the related table to include will automatically create the join to the other table.

Thanks for the suggestions for improving the SQL editor. Do note, though, that we do have some level of support for automatic joins in the current SQL builder: if your database schema declared foreign key constraints between tables, then in the screen where you select the columns for your query, you should also see the list of related tables at the bottom of the view. Tapping the related tables and selecting the columns in the related table to include will automatically create the join to the other table.

Rob suggests several improvements concerning more the query builder than the SQL Editor (the name of this topic is somehow missleading).

I particularly like the idea to add joins to the query builder: I often use a DB where the foreign keys have not been declared (too bad for me). It would be usefull to be able to create the logical relations (and keep them) in DataGlass.

I also share the concern about the query builder being a popup... It would be much nicer to use all the available screen surface (you are either viewing the design of the query or the result)

Besides to improvements already suggested, including larger editing area and the possibility to store queries, the possibility to format the query with carriage returns would be nice. Of course having syntax highlighting would also be nice.

Finally it would be nice to be able to browse database objects while editing queries - here database objects include tables, views, stored procedures and functions.

I also will be using the query editor a lot.
Besides having a larger proportion of the screen available for the query editor and the ability to store queries, it would also be nice to be able to browse the database objects while editing the query. Objects here would in addition to tables and views include functions and stored procedures.
Another small fix would be the ability to add new lines to the queries.

I agree with the above. The main use I have for this product is to write ad-hoc queries on the fly. I would love a more fully featured Custom SQL Query window so that I can type in complex queries without using the guy. Carriage returns are essential for this though. Syntax coloring would be nice too.

I also want to second a more fully featured SQL editor. I am impressed with the product in general, except for the extremely limited query editor.

Main requirements:
1. Larger editing surface with multiple line and non-proportional font
2. Access to db objects (tables, columns) and means to insert object names into query being constructed
3. Syntax highlighting would be nice, but top priority

As others have said, a more robust editor screen would be nice. I would even settle for a better way to import queries that are already developed. I have many queries that I use on a daily basis developed on my PC that I would like to import into this tool. As far as I can tell, cut and paste is the only way and the bookmarks are connection specific. So, if you have multiple databases that you runthe same query against (like test and production) you have to have the bookmark defined in both. Something akin to the snippets in SQLDeveloper would be ideal. Those can be accessed from any connection and they are actually stored in an XML file so that they can be edited from outside the interface if you so desire.

I just purchased MySQL Mobile Database Client for use on the iPad. I like everything about the app, except for the query writing/building/management. Unfortunately writing a custom query is next to impossible. I generally am writing long custom queries across multiple tables.

The current issues I have with the query editor:
1) The popup is too small for long queries.
2) Impossible to format a custom query. I can't add line line breaks to the query.
3) No syntax highlighting

I can live without syntax highlighting, but 1 and 2 are a must for this app to be usable for me. Currently I use another app to write my query and paste into the tiny SQL Query popup.

I would love to see this fixed. Then this app would be the one and only database app I need.

I work with enterprise level oracle databases that have well over 100,000 tables in a single schema. The provided query builder is unusable in this environment so I must have access to an advanced SQL editor.

What I'd like to see added to this app is an advanced user mode where I can get a split screen SQL editor and a database result grid at the bottom. I can type my queries in (multi-line fixed width font is essential) and then execute and see the results immediately.

SQL Syntax highlighting and autocomplete would be a bonus. Also the ability to specify a default schema would be good, so I don't have to prefix all my table names with schema-name.table.

In the existing query builder, it would be helpful if you could narrow the list of tables with a search filter (if this is already an option, I'm not sure how to use).