Submitted by echelon on 2022/05/31 12:17

Could you please add supports for embedding files & folders in the infoqube database?, instead of only link/shortcut to the files.

Comments

Hi echelon,

First a warm welcome from the IQ Community !

w.r.t. embedding files and folders, it isn't part of the IQ's philosophy. The NTFS database is optimized to handle those and IQ is tuned to use this.

If you can, please describe what you're trying to achieve and we'll see it can be done within IQ.

Pierre_Admin
IQ Designer

Hello, thanks for the warm welcome :-)

Mostly it's for portability and singular database file which containing the most important files for me.

EssentialPIM is already done these but I more inclined to use infoqube, mostly I use files embedding are for my linux daemons config (text files) & compressed archive files (rar,zip) which I work with, sure we can use linked/shortcut but it quite tedious in exchange of portability or embedding it inside database which is singular, so for backup we only needs to backup one file (database), in addition we can encrypt the database file. 

If using shortcut incase of hardware storage failure not only we lost it all but also we need to remember and statically storing it based on the fixed path, these are problematic if the paths are inside portable storage which are the drive letter changing time to time (windows is pretty inconsistent about portable drive letter assignment).

Does infoqube is using sqlite as the backend database file? or custom one?.

Hi echelon,

Thanks for the details. To manage files, IQ provides with these facilities (and more, but these are the first that come to mind)

  1. .Files folder. By default in the same folder as the IQBase. Backing up is then as simple as zipping up 1 file and 1 folder. Instead of backup, cloud service sync is also possible (Dropbox et al)
  2. Windows shortcuts to files and folders will auto-resolve if these are moved
  3. "Smart" file search. Will look in alternate paths for files (same path, different drive, same relative path, etc)
  4. Support for relative paths
  5. Easy Text file import (with file path saved in the IQBase
  6. Doc pane can show an Explorer like view of files and folders (so each item can show a different drive path)

IQ uses MS Jet for its storage engine

HTH !

Pierre_Admin
IQ Designer

Ok, pretty comprehensive 'shortcut' or 'filepath' indeed, I haven't had the chances to dive down into IQ features yet.

About the "IQBase" term, does it means "..\Users\username" or "..\AppData" folder in the IQ portable version?.

For working with cloud backup/sync, should I backup whole IQ portable folder and apps/dependencies or just that IQBase above?.

Suggestions