This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
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
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.
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.