You are here

why don't you include a database manager?

14 posts / 0 new
Last post
walter.accantelli
Offline
Last seen: 17 years 1 week ago
Joined: 2007-11-13 14:50
why don't you include a database manager?

Hi all. I think it would be great if you include in your solution an application for manage database, something like toad or aqua data studio.
It could be very useful.

Regards.

OliverK
OliverK's picture
Offline
Last seen: 3 years 5 months ago
Developer
Joined: 2007-03-27 15:21
OpenOffice.org Base. Part of

OpenOffice.org Base.

Part of the Open Office suite.

Welcome to portable apps!

Too many lonely hearts in the real world
Too many bridges you can burn
Too many tables you can't turn
Don't wanna live my life in the real world

BuddhaChu
BuddhaChu's picture
Offline
Last seen: 5 months 1 week ago
Joined: 2006-11-18 10:26
Base is an Access clone.

Base is an Access clone. The original poster wants something to manager SQL databases...like do queries and whatnot (I had to Google "aqua data studio" to figure that out).

I blame the original poster for your confusion and making me do work they should have done when they posted. A better description of what they're looking for is in order.

Cancer Survivors -- Remember the fight, celebrate the victory!
Help control the rugrat population -- have yourself spayed or neutered!

Preacher
Offline
Last seen: 1 year 6 months ago
Joined: 2006-11-13 16:52
Moreover...

...I read the threadstarter as seeking a *standalone* DB app, rather than something that's part of a Suite, as with OpenOffice. The prob w/ Suites, of course, is that they give you EVERYthing, when you only want SOMEthing(s)...

Por ejemple, I use OO, but the only apps I've ever used in that suite have been Writer, Calc, and Draw. No need for a DB or Presentation App for me personally. It'd be great if I could save some space on my thumb by deleting those other 2 apps that I never use - but at present, it ain't possible

If we/John could come up w/ a way to run OO piecemeal - being able to only have *some* of the apps on our drives, w/o having to have the WHOLE Suite on our thumbdrives (a "cafeteria Office Suite", as it were), that'd be Schweeet!...

"I don't hate cats...as long as they stay on the freeway, where they belong."
- Brad Stine

John T. Haller
John T. Haller's picture
Online
Last seen: 39 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
As Stated

... about a hundred times... OpenOffice.org is essentially *ONE* application. It is *NOT* like Microsoft Office where Word, Excel, Powerpoint, etc are individual applications. OpenOffice.org is a single application. Check Task Manager when Word and Excel are running, you'll see Word and Excel. Check task manager when Write, Calc and Impress are running, you'll just see soffice.bin and soffice.exe running, the same as when only Write is running.

So, everyone say it with me... "Selecting only to install individual apps in OpenOffice.org DOES NOT SAVE A WORTHWHILE AMOUNT OF SPACE, so I will STOP ASKING TO BE ABLE TO INSTALL INDIVIDUAL APPS."

I've done tests and published the results of the size difference (you'll only save a grand total of 9MB), I've answered the question dozens of times, it's even mentioned right on the OpenOffice.org Portable homepage. Why is it so difficult for people to grasp this?

https://portableapps.com/support/openoffice_portable#custom_install

Sometimes, the impossible can become possible, if you're awesome!

Preacher
Offline
Last seen: 1 year 6 months ago
Joined: 2006-11-13 16:52
Yo, John...

... I personally hadn't run across the info you provided in this post until now, so I can honestly say I didn't know about this "hundred times" (or even ONCE) thing.

As such, I apologize for any frustration this has caused you, and I hope you accept said apology.

That said, the threadstarter's question still stands:
Is there a (standalone) DB app/manager that runs portably?
(including it on the PA.com site or Suite is a separate question, natch...).

The answer is YES, because I've run across such an app before. However, since I'm quite happy to just run OO, I didn't make note of the name of, or a DL link for, said app.

But if he's determined to find such a proggy, he can surely do some web research and uncover one or more such apps. I'd suggest portablefreeware.com as a starting place for him.

"I don't hate cats...as long as they stay on the freeway, where they belong."
- Brad Stine

rab040ma
Offline
Last seen: 5 months 1 week ago
Joined: 2007-08-27 13:35
I am not familiar with the

I am not familiar with the Base product. If it has the same sort of rudimentary query builder and such that Access has, might it not be able to connect to external databases and do some of what the OP is asking?

Not that a separate DB manager wouldn't be helpful.

The other question is whether a "generic" program would be very useful. I've used WinSQL, which is relatively generic and very helpful, but the product-specific managers do have features that make managing that product's database easier or more complete.

MC

rab040ma
Offline
Last seen: 5 months 1 week ago
Joined: 2007-08-27 13:35
Probably doesn't mean XAMPP

Probably doesn't mean XAMPP either... although that includes an SQL database.

MC

alanbcohen
Offline
Last seen: 5 years 3 months ago
Joined: 2006-01-04 10:47
WinSQL & SQLite as alternatives

Walter,

If your goal is to manage external databases (not on the USB drive), like toad (you mentioned it), which is an Oracle-specific client, I'd suggest you consider an ODBC-compliant editor, like WinSQL, which is portable (but does create registry entries in install. Install to host machine, copy directory to USB drive, uninstall on host). That is what I do. You will still need to install odbc drivers on the machines you use, but that shouldn't be a problem if you are an authorized user of the database anyway.

If you just need something light, SQLite is also portable.

A lot depends on the database engines you are attempting to connect to.

RossGoodman
Offline
Last seen: 3 years 5 months ago
Joined: 2005-12-19 12:51
aqua data studio

Just for info:
http://docs.aquafold.com/ads/6.0/features_4_7.html
aqua data studio CAN be run from your USB simply by copying the installed directory.
I have not checked the licencing but it is listed as "free" but I doubt it is open source.
I'm not a purist so i have not checked if it is "portable" ie leaves no traces.
It is java based and when installed it creates it's own jre in the install directory, which is a bit annoying as I already have one but hey ho!
Getting a bit out of my depth but I "think" that it has it's own JDBC drivers with it so there is no need for ODBC.
Ross

BuddhaChu
BuddhaChu's picture
Offline
Last seen: 5 months 1 week ago
Joined: 2006-11-18 10:26
If it's "free", why is there a whole page for pricing?

Cancer Survivors -- Remember the fight, celebrate the victory!
Help control the rugrat population -- have yourself spayed or neutered!

Preacher
Offline
Last seen: 1 year 6 months ago
Joined: 2006-11-13 16:52
Well...

... I haven't checked out the linky you posted, but it may well be that there's a free version along w/ the various paid versions. The free version would - natch - be of limited functionality compared w/ the paid versions, but IF the free version does what you need it to do, WHY pay $$$ to get more features?..

Avanquest does this for some of their software:
I've been using the free version of "PowerDesk" from them for years, and it does all I need a File Manager to do. Therefore, I'm not interested in paying $$$ to get more features, which I wouldn't use all that often anyway.

Comprendes?...

EDIT:

Now that I've checked the link, we have the answer:
The Free version is an older version of the product, which is why it's free.

Still, if looking for a good File Manager, I'd recommend PowerDesk Standard (free) version.

(and yes, it runs portably, but not nec'lly stealthily...)

Get it here:

http://www.v-com.com/download/download_free.html

"I don't hate cats...as long as they stay on the freeway, where they belong."
- Brad Stine

RossGoodman
Offline
Last seen: 3 years 5 months ago
Joined: 2005-12-19 12:51
Free Vs Paid

They will let you use version 4.7 for free.
The paid for version is now at 6.5.

As this is not open source I would not expect this to be re-distibuted here; but it is one of the tools that I use on almost a daily basis.

I like the fact I can use the same query tool when jumping between all the different database types. For DBA tasks I would always fall back to the vendor supplied tools.

Ross

grannyGeek
Offline
Last seen: 16 years 4 months ago
Joined: 2007-03-14 23:42
SQLiteSpy

maybe worth a look for you personally.
It is a freeware license, not open-source, so it probably will never be added to the suite. But if you use SQL, it might be a solution for you.

http://www.portablefreeware.com/?id=1165#comments

Log in or register to post comments