aspose file tools*
The moose likes JDBC and the fly likes online query executor Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "online query executor" Watch "online query executor" New topic
Author

online query executor

Kunal Sham
Greenhorn

Joined: Apr 30, 2011
Posts: 2
Can somebody suggest any online SQL executor? I have a local database (MYSQL and Oracle) in my environment and I want to query those databases, installing big product for querying in my laptop makes it slow and I rarely need to query. So I don't want to install some big product for database query.
I tried using SQL developer but that is big product when the requirement is to use rarely. I would like to know any online SQL executors available in the web
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

That's probably going to be problematic. How would the online service connect to your local database to perform the queries there?

SQL Developer doesn't install itself, you just unpack it and run it. True, it takes ages to start, but it should not slow down your laptop when you do not use it. It also uses about 300 MB of virtual memory right after start on my system, which can be a lot if you're constrained on memory.

I use Sql*Plus to run a few queries really quick. It is a console application (running in the "DOS window") and you can start it using sqlplus.exe. If you have a local installation of the Oracle database, the tool is somewhere there. MySQL has a similar tool (or so I believe).

You could try some alternatives to SQL Developer - such as TOAD - but I don't use them, so don't know whether they would actually start faster or use less memory.
Zachary Pry
Greenhorn

Joined: Aug 09, 2011
Posts: 18
I agree with Martin - it would be a challenge.

I would offer to use remote Database instead of local. This way saved memory can be spend on comfortable development environment.

I know that Amazon RDS supports both MySQL and Oracle, but as far as I remember they don't have free/dev plans available.
Heroku has some free options available. Also they have free plans for both PostgreSQL and MySQL, but no Oracle unfortunately.

Hope it helps.


Open-source JDBC Library - Midao JDBC ( www.midao.org ).
Remote Island
Greenhorn

Joined: Jul 09, 2013
Posts: 1
Here you go RedSQL. This is online tool and doesn't require any installation and is for multiple database. Use chrome and Mozilla for better performance.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: online query executor