Page 1 of 1
[Solved] Portable setup
Posted: Wed Nov 20, 2019 10:56 pm
by gkick
Hi folks,
Not exactly external data source related...
I read in a post that one can have a complete portable installation of a db on either a stick or external harddisk etc.
Anyone having a setup like this?
I have a portable version of Java and LO, what is the procedure for firing up a db?
Does the stick need to be bootable? If one runs LO from the stick will it be a problem if LO also exists on the c drive?
Will it be sufficient to place the extracted Java and LO in a folder on the stick or do I need some additional config files ?
Thanks
Re: Portable setup
Posted: Sat Nov 23, 2019 1:49 am
by sasa
Hi,
Im using portable instalation on internal hard disk (restricted permission, sharky IT...) so my setup is not 100% portable. This is only for start.
For portable instalation on USB stick (Windows) you can use
PortableApps.
You can find all apps
here, eg. Libreoffice, Java - install and update.
To install eg. Firebird server download zip file (32 or 64 bit) from
here. For database managment you can use
SQL Workbench/J or similar Java tool.
Start database server and managment tool with bat file. For relative path in BAT script read
this.
In LibreOffice before you can use a JDBC driver, you need to add its class path. Choose Tools - Options - LibreOffice- Java, and click the Class Path button. After you add the path information, restart LibreOffice.
Best
Re: Portable setup
Posted: Sat Nov 23, 2019 2:33 am
by gkick
Thanks for that, much appreciated. Also was thinking of portable installation on internal hard disk. In your environment any noticeable degradation in performance compared to standard setup?
cheers
GK
Re: [Solved] Portable setup
Posted: Sun Nov 24, 2019 4:15 pm
by sasa
Hi,
In your environment any noticeable degradation in performance compared to standard setup?
I found no noticeable difference in performance.
Best
Re: [Solved] Portable setup
Posted: Sun Nov 24, 2019 5:36 pm
by Villeroy
sasa wrote:Hi,
In your environment any noticeable degradation in performance compared to standard setup?
I found no noticeable difference in performance.
Best
Where does a portable office suite store its temporary files? Any embedded database is installed to a temporary directory. Database programs writing to USB sticks sounds like a bad idea because these drives have limited read-write cycles.