File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes online query executor Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "online query executor" Watch "online query executor" New topic

online query executor

Kunal Sham

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

Joined: Aug 22, 2010
Posts: 3732

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

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 ( ).
Remote Island

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:
subject: online query executor
It's not a secret anymore!