Where to put SQLite/MDB database in UWP app

[CarloM 3]

Hi,

 

I am trying to generate an appx with Delphi Sydney, but I dont know where deploy database file, reports files,... for read/write.

 

When I compile for Mac use this remote path "Contents\Resources\StartUp\" for DB files, reports,.... 

 

But on Windows I don´t know if exists especial folders.

 

Thank you so much

[Lars Fosdal 1793]

Look at the TPath type in System.IOUtils.- it is cross platform and has a number of methods for getting "special" folders.

 

http://docwiki.embarcadero.com/Libraries/Sydney/en/System.IOUtils.TPath_Methods

 

 

[CarloM 3]

Hi Lars,

 

the question is where I specify data folders under deployment window

 

see image for clarification

 

 

[Lars Fosdal 1793]

Does

%APPDATA%\YourAppName\ 

work?

It resolves to C:\Users\<username>\AppData\Roaming

 

Alternatively,
%LOCALAPPDATA% C:\Users\<username>\AppData\Local
 

[CarloM 3]

It does not work, It creates a %Appdata% folder.

 

I don´t understand it, if I need to use a local MS access DB, where is the correct location path for deploy this file ?

 

[Lars Fosdal 1793]

Where does it create that folder?

 

[Lars Fosdal 1793]

Is the DB supposed to specific for the current user, or do you want a single DB for all users on the machine?

[CarloM 3]

2 minutes ago, Lars Fosdal said:

Where does it create that folder?

 

Yes, Create a folder named %APPDATA%. Not resolve

[CarloM 3]

2 minutes ago, Lars Fosdal said:

Is the DB supposed to specific for the current user, or do you want a single DB for all users on the machine?

at first time, for current user

[Lars Fosdal 1793]

2 minutes ago, CarloM said:

Yes, Create a folder named %APPDATA%. Not resolve

Where is that folder created?

10 minutes ago, CarloM said:

It does not work, It creates a %Appdata% folder.

 

When it creates a folder named %APPDATA% - Where does it create it?
C:\users\username\%APPDATA% ?

C:\%APPDATA% ?

Where is it created?
 

[Lars Fosdal 1793]

If you name it

.\YourAppFolder\

Where is that folder created in the current user's file system?

[CarloM 3]

Just now, Lars Fosdal said:

If you name it

.\YourAppFolder\

Where is that folder created in the current user's file system?

C:\Program Files\WindowsApps\MYAPPNAME_1.0.0.0_x86__ay3z6v4jhrvfp

 

 

[Lars Fosdal 1793]

Which looks like a shared folder - unless that part on the end is a user specific key.

If you install it with a different user - is a new folder C:\Program Files\WindowsApps\MYAPPNAME_1.0.0.0_x86__?????? created, or is the same folder used?

 

Looking at http://docwiki.embarcadero.com/RADStudio/Sydney/en/Deployment_Manager,

all the examples simply uses .\ - so perhaps that is sufficient.

[Der schöne Günther 316]

I honestly don't think the deployment manager is the right tool for this. It's intended to bundle the sqlite template with your app, but not initialize "first run" scenarios.

 

The user files belong in %AppData% and Windows takes care of virtualizing this per user. So all you have to do is, at runtime, take your local .sqlite file and copy it to %Appdata%\... if it's not already there.

[Lars Fosdal 1793]

On the other hand, APPX apps are supposed to be sandboxed - hence moving a file to a different part of the system might not be a good idea?

I could be wrong about this, though.

[CarloM 3]

18 minutes ago, Der schöne Günther said:

I honestly don't think the deployment manager is the right tool for this. It's intended to bundle the sqlite template with your app, but not initialize "first run" scenarios.

 

The user files belong in %AppData% and Windows takes care of virtualizing this per user. So all you have to do is, at runtime, take your local .sqlite file and copy it to %Appdata%\... if it's not already there.

But, copy manually files on first run ? 

 

[Der schöne Günther 316]

Yes, you're in control of what you do there. I think its the most straightforward way.

[Der schöne Günther 316]

7 minutes ago, Lars Fosdal said:

hence moving a file to a different part of the system might not be a good idea?

I don't quite understand what you mean with "different part of the system". Every packaged app gets its own view of the registry and the file system. Here is a good summary:

https://docs.microsoft.com/en-us/windows/msix/desktop/desktop-to-uwp-behind-the-scenes

[Lars Fosdal 1793]

Different part - as in Outside the sand box - but it seems the file system is fully virtualized.

 

A bit odd that you cannot specify %APPDATA% in the deployment system, since that actually is the appropriate path.

 

Write under AppData

Windows 10, version 1903 and later: New files and folders created under the following directories are redirected to a per-user, per-package private location: Local Local\Microsoft Roaming Roaming\Microsoft Roaming\Microsoft\Windows\Start Menu\Programs In response to a file open command, the OS will open the file from the per-user, per-package location first. If this location doesn't exist, the OS will attempt to open the file from the real AppData location. If the file is opened from the real AppData location, no virtualization for that file occurs. File deletes under AppData are allowed if user has permissions.   Windows 10, version 1809 and earlier: Copy-on-written to a per-user, per-app location.

AppData is typically C:\Users\user_name\AppData.

[CarloM 3]

I can't believe the installer can't copy the files directly to the user folder with read and write permissions

[Der schöne Günther 316]

A deployment manager deploys files. It's not an installer.

 

8 minutes ago, Lars Fosdal said:

A bit odd that you cannot specify %APPDATA% in the deployment system

Maybe they will add something like this once RAD Studio will also support MSIX.

[CarloM 3]

As I understand... I need to copy manually files to another folder ?

I'm surprised...

[vfbb 285]

I never tested it, but if you open the System.StartUpCopy.pas you will see that in Windows, always when your program run, it will try to copy files from ExtractFilePath(ParamStr(0)) + '\StartUp\' to TPath.GetHomePath (in windows it is AppData\Roaming\).

 

So, you can try to put in Deployment remote path: .\StartUp\yourapp\database.sqlite3

And to load the database in runtime you can try to use TPath.GetHomePath + '\yourapp\database.sqlite3'

Edited July 7, 2020 by vfbb