You are here

SqlDbx

8 posts / 0 new
Last post
DeMarfey
Offline
Last seen: 2 years 2 weeks ago
Joined: 2011-04-05 16:26
SqlDbx

Hello,

At work, I use SqlDbx personnal edition every Day to request my Oracle and SQL Server database.

I get it at www.sqldbx.com
On there website, I read this:

"SqlDbx is a standalone executable file, so no installation is necessary. Furthermore, SqlDbx does not install or modify anything on the user's computer."

"SqlDbx uses one Registry entry to store configuration. Registry key located in HKCU\Software\SqlDbx. Other then that SqlDbx does not modify anything else."

Do you thing you can make it compliant with the PA standart ?

Thanks for your work

Rapscallion
Offline
Last seen: 3 years 10 months ago
Joined: 2008-11-18 16:19
You might want to try this

You might want to try this out until someone can get around to looking at SqlDbx.

It amazes me that on the internet you can be anything you want, and yet so many people still choose to be idiots.

DeMarfey
Offline
Last seen: 2 years 2 weeks ago
Joined: 2011-04-05 16:26
Yes, I already use database

Yes, I already use database browser portable but I prefer the SqlDbx UI.

SqlDbx have more feature than database browser portable.

3D1T0R
3D1T0R's picture
Offline
Last seen: 3 years 4 months ago
Developer
Joined: 2006-12-29 23:48
I took a quick look; Here are my findings:

That statement regarding it's Portability is only partially true; only as far as the Registry is concerned is it correct, AFAICT (but I only took a cursory glance) the only place it modifies the Registry is in HKCU\Software\SqlDbx; However, the Registry is not the only part of the computer which should not be modified in order for an app to be Portable; other than the Registry key it uses, I also noticed that it creates a folder (named "SqlDbx") in the user's "My Documents" folder, as well as one in "C:\Documents and Settings\UserName\Local Settings\Application Data" (in WinXP, IDK what in Vista/7) folder (also named SqlDbx).

All three of those will need to be taken care of (either by moving things to and from the host computer on every run, or by somehow disabling the Registry portion and redirecting the files, if that's possible) before it can truly be called Portable.

I won't be taking this on, but I thought I'd look at it to try to help whomever decides to (if someone does, that is).

~3D1T0R

Chris Morgan
Chris Morgan's picture
Offline
Last seen: 9 years 5 months ago
Joined: 2007-04-15 21:08
Those parts aren't hard:
[RegistryKeys]
sqldbx=HKCU\Software\SqlDbx

[DirectoriesMove]
localappdata=%LOCALAPPDATA%\SqlDbx
documents=%DOCUMENTS%\SqlDbx

I am a Christian and a developer and moderator here.

“A soft answer turns away wrath, but a harsh word stirs up anger.” – Proverbs 15:1

3D1T0R
3D1T0R's picture
Offline
Last seen: 3 years 4 months ago
Developer
Joined: 2006-12-29 23:48
Yes, Reason:

The reason I said "either by moving things to and from the host computer on every run, or by somehow disabling the Registry portion and redirecting the files, if that's possible" was so that someone would look into whether there is some way to tell the program to use folders on the flash drive instead of the users' Documents folder and and also not to use the registry; if that's possible it would be a better alternative to having the launcher copy/move them every run (as your suggestion does).

P.S. I know how to do that much with PAL, but it'd be better for someone who's actually planning on using SqlDbx to make it Portable, so that it'll get some ‘internal’ testing as well, thus I won't be taking this on.

~3D1T0R

DeMarfey
Offline
Last seen: 2 years 2 weeks ago
Joined: 2011-04-05 16:26
PAL

PAL is a good solution for my needs.

I have just try to make one, and everything seems to be OK.

I think the directories you find on your local drive are created the first time SqlDbx is running on your computer because the general options are empty !

sqldbxdeveloper
Offline
Last seen: 13 years 5 months ago
Joined: 2011-06-17 23:27
Next version

Next release of SqlDbx will have option to be 100% portable compliant

Log in or register to post comments