| View previous topic :: View next topic |
| Author |
Message |
tfenne
Joined: 16 Nov 2005
Posts: 9
|
 Posted: Wed Nov 16, 2005 4:39 pm Post subject: Feedback on SQLGrinder 2.0 beta 6 |
 |
|
I just downloaded beta 6, the first time I've checked in on SQLGrinder in quite some time. I have to say, it looks awesome! For almost three years now I've been looking for a SQL tool that is as good as those on the PC/Windows side, but integrates nicely into the mac environment. I think SQLGrinder 2.0 will be it!
Now onto my issues  The main thing I'm having problems with is auto-complete. Right now it seems to be ok completely keywords, but column and/or table name completion doesn't work at all for me. My environment is:
- Mac OS X 10.4.3 (G5 iMac)
- Java 1.4.2 and 1.5.0 are available (not sure which SQLGrinder picks up)
- Connecting to: Oracle 10G Enterprise Release 10.1.0.3.0
Is this a known problem in beta 6, or perhaps just with Oracle 10g? Any ideas on what I could try to get this working?
I have some feedback in common with other posts I read here. I think the main one would be to make some of the shortcut-keys user definable. Things like execute selection/query/block I'm very used to using control-return, because that's what other tools I've used do. For completion, control-space is hardwired muscle memory for me - using escape feels very strange. Seems like no single setup will suit everyone, but if the major shortcuts could be user-definable I think everyone would be happy.
One other nit is that command-left-arrow and command-right-arrow don't go to beginning and end of line like in most Cocoa apps...but strangely enough command-shift-arrow selects to end of line.
Like I said at the top, awesome effort! When I can download a copy that has completion working for me (and preferably by hitting control-space), I'll be sending a check your way for $59! Cheers,
-t |
|
| Back to top |
|
 |
tfenne
Joined: 16 Nov 2005
Posts: 9
|
| Posted: Thu Nov 17, 2005 12:03 pm Post subject: Update: completion kinda-working |
|
|
So I left SQLGrinder open over night, and noticed that when I started using it this morning that my SQL columns were getting syntax highlighted appropriately! Completion now kinda works, but it's extremely slow.
If I were to guess as to the cause, I'd say that SQLGrinder has cached the table/column information for the entire database - not just the current schema. The database I'm connecting to has about 60 users/schemas, and many of them are pretty large, containing hundreds of tables and views. Then there's all of Oracle's V$ GV$, dba_ views etc. So I thin kit's probably trying to scan a ridiculously large set of information to do the syntax highlighting and completion (even just using the editor is very sluggish now).
Is there any way to trim down the set of completion information that the editor uses? |
|
| Back to top |
|
|
michaeldupuis
Site Admin
Joined: 15 May 2003
Posts: 1427
Location: Lewiston, ME
|
| Posted: Thu Nov 17, 2005 1:46 pm Post subject: |
|
|
| Quote: | | So I left SQLGrinder open over night, and noticed that when I started using it this morning that my SQL columns were getting syntax highlighted appropriately! Completion now kinda works, but it's extremely slow. |
Your guess is correct, it was fetching the ENTIRE schema, which is what Oracles driver returns. It's the only one that does this, so because of that, you actually want to specify both your SID and database name, ie, enter AAPL:SCOTT for the database name rather than the SID of AAPL. This is MUCH faster. This will be documented once the beta is completed.
| Quote: | | ne other nit is that command-left-arrow and command-right-arrow don't go to beginning and end of line like in most Cocoa apps...but strangely enough command-shift-arrow selects to end of line. |
I was smacking my forehead when I finally figured out why this wasn't working: I unknowingly used these commands to navigate the buffers, forgetting that they were already used. In the next beta, these keys will work again, and forwards and backwards in the buffer will use command-shift-left, etc.
-- Michael |
|
| Back to top |
|
|
tfenne
Joined: 16 Nov 2005
Posts: 9
|
| Posted: Sat Nov 19, 2005 7:45 am Post subject: |
|
|
| michaeldupuis wrote: | | Your guess is correct, it was fetching the ENTIRE schema, which is what Oracles driver returns. It's the only one that does this, so because of that, you actually want to specify both your SID and database name, ie, enter AAPL:SCOTT for the database name rather than the SID of AAPL. This is MUCH faster. This will be documented once the beta is completed. |
I've tried several permutation of this but have not managed to get it working. I've tried on the oracle databases at work, doing as you suggest putting SID:USERNAME for the database name. I've tried it with all upper case, and all lower case. I've tried creating a really simple schema/user with a single table in it using a username with no special characters in it (all our work users are foo_dev, foo_qa etc.). But no dice. The connection works fine, and SQLGrinder seems to think it has the completion data (the menu option comes alive almost right away), but completion and syntax highlighting doesn't recognize or offer up any table/column data.
Any ideas on how I can debug this further? Is there a way to make SQLGrinder log more about it's interactions with the database so I can figure out what's going on? Thanks,
-t |
|
| Back to top |
|
|
michaeldupuis
Site Admin
Joined: 15 May 2003
Posts: 1427
Location: Lewiston, ME
|
| Posted: Sat Nov 19, 2005 8:02 am Post subject: |
|
|
| Quote: | | Any ideas on how I can debug this further? Is there a way to make SQLGrinder log more about it's interactions with the database so I can figure out what's going on? |
Well just to reiterate, the spec works like this: normally you'd just use the SID, say something like AAPL, or DEVDB to connect, correct. Then you'd browse to a database, say SCOTT, or PROJECT. Instead use devdb:scott. I don't think things are case sensitive. Also did you try the "Reload keywords" command in the "Editor" menu? You can also try deleting the keyword cache, which is found in ~Library/Caches/SQLGrinder, called DatabaseKeywordCache.
-- Michael |
|
| Back to top |
|
|
tfenne
Joined: 16 Nov 2005
Posts: 9
|
| Posted: Tue Nov 22, 2005 8:58 am Post subject: |
|
|
| michaeldupuis wrote: | Well just to reiterate, the spec works like this: normally you'd just use the SID, say something like AAPL, or DEVDB to connect, correct. Then you'd browse to a database, say SCOTT, or PROJECT. Instead use devdb:scott. I don't think things are case sensitive. Also did you try the "Reload keywords" command in the "Editor" menu? You can also try deleting the keyword cache, which is found in ~Library/Caches/SQLGrinder, called DatabaseKeywordCache.
-- Michael |
I tried your suggestions, and still cannot seem to get it to work. Just for grins, here's what I have in my connection settings:
user: reseq_dev
password: ••••••••
Driver: Oracle 10g
Host: magnesium
Database: meddev10:reseq_dev
Port 1521
Auto-built URL: jdbc:oracle:thin:@magnesium:1521:meddev10
Does that look right to you? Can you elaborate a bit more about how you are fetching the information? I'm quite familiar with Oracle, and have just been playing around the the JDBC metadata interfaces for other reasons, so if I knew what was going on, I might be able to help figure out why it's not working. Cheers,
-t |
|
| Back to top |
|
|
michaeldupuis
Site Admin
Joined: 15 May 2003
Posts: 1427
Location: Lewiston, ME
|
| Posted: Wed Nov 23, 2005 8:14 am Post subject: |
|
|
Hm, do you mean it still takes forever to load, but does at some point?
When the SID and name are specified, the fetch from the database is done using those qualifiers, rather than the empty string or null qualifiers (which work for most drivers). So, essentially the SID is used in the JDBC URL and the extension used to fetch schemas when doing JDBC calls like getTables(), etc.
-- Michael |
|
| Back to top |
|
|
tfenne
Joined: 16 Nov 2005
Posts: 9
|
| Posted: Wed Nov 23, 2005 8:59 am Post subject: |
|
|
| michaeldupuis wrote: | | Hm, do you mean it still takes forever to load, but does at some point? |
Sorry, I should have been more specific. I left it overnight again just to see what would happen, but this time it never seemed to get a set of completion words. The syntax highlighting isn't on for schema elements, and hitting escape yields only database key words. I double-checked that I have the syntax highlighting preference on, and I do. On some windows I have, the "Reload Keywords" option becomes enabled very quickly (some times it's already enabled when I check it right away). Other times it never seems to get enabled.
Is there any way to turn up the debug logging or some equivelant to see what's going on?
-t[/i] |
|
| Back to top |
|
|
michaeldupuis
Site Admin
Joined: 15 May 2003
Posts: 1427
Location: Lewiston, ME
|
| Posted: Wed Nov 23, 2005 9:05 am Post subject: |
|
|
| Did you try removing the keyword cache file? |
|
| Back to top |
|
|
tfenne
Joined: 16 Nov 2005
Posts: 9
|
| Posted: Wed Nov 23, 2005 9:31 am Post subject: |
|
|
| michaeldupuis wrote: | | Did you try removing the keyword cache file? |
Yeah, I tried that before. I just redeleted it (quit the app, delete, restart and connect) and still no joy. One clarificatoin - the window that had the "Reload Keywords" grayed out was actually disconnected. I'd left it overnight and it had dropped the connection and I didn't notice this morning.
-t |
|
| Back to top |
|
|
|
