New: Audacious (June 1, 2023), Platform 25.0 (Apr 07, 2023)
New Apr 14: macOS Portable Drive Support
450+ real apps (49GB), 1.1 billion downloads, Please donate.
Hi
Can anyone recommend a:
generic,
free,
open source
and preferably portable
SQL Query tool that can connect to ideally:
Oracle
SQL Server
MySQL
I understand that true portability will be limited as the middleware and configuration will have to be on the desktop, but it would be nice to just plug and play in the same way that I do with my other apps.
Ross
Java based:
www.aquafold.com
they have a free version, works very well
works fine with my JRE installed on usb mem
What I usually do for MySQL is (from my MySQL installation on my machine) copy mysql.exe from MySQL\bin and run it through a batch file:
mysql -h{host} -u{root} -p{password}
Not sure about Oracle or SQL Server, but this is what I use for MySQL.
PERFECT !!!
AquaFold gives me much more that I was looking for !
portable, free and LOTS of features !!!!
My personal favorite, and one that is always on my USB drive is SquirrelSQL (http://squirrel-sql.sourceforge.net). It is a Java app that will connect to most every RDBMS that has a JDBC driver. The one minor "gotcha" is that you may need a portable copy of the Java JRE, which isn't hard to do. SquirrelSQL comes with both *nix and win32 startup scripts that can be modified slightly to keep the program settings confined to your USB drive, and set a path to the Java JRE on your USB drive.
For example, I made the following change to the squirrel-sql.bat file:
SET TMP_PARMS=--log-config-file "%SQUIRREL_SQL_HOME%\log4j.properties" --squirrel-home "%SQUIRREL_SQL_HOME%" %1 %2 %3 %4 %5 %6 %7 %8 %9
to
SET TMP_PARMS=--user-settings-dir "%SQUIRREL_SQL_HOME%\.squirrel-sql" --log-config-file "%SQUIRREL_SQL_HOME%\log4j.properties" --squirrel-home "%SQUIRREL_SQL_HOME%" %1 %2 %3 %4 %5 %6 %7 %8 %9
Could you possibly tell me how you got JAVA to be protable???? In my testing, John's and most of the users on this forums, Java cannot be made portable because of the registry entries it needs to function.
Would be an interesting thing to know, if you don't mind...
Deuce
"Portable Software: Just the beginning..."
You just have to point it to the right files. It can work fine with JARs. Just not with something like Portable Firefox.
It's true that that you need registry settings to allow things like the Java plugin for browsers to work. However, the java executable and the supporting files are portable if invoked from a command line or batch/shell script. So, for things like the SquirrelSQL startup script, you can reference your JDK dir on your usb drive, make sure the classpath is set to include the correct jars, and it is portable.
In my first post, I mentioned the JRE... Typically, I only ever include a copy of the JDK directory on my USB drive. I'm not sure if making copies of the JRE directory on your USB drive will work just as well, but I don't see why not. The java executable from the JRE or JDK should run fine from the USB drive from the command line or from a batch/shell script.
Visit the Community page
Join our forums