Script Storage

Owned by Jonathan Muse
Last updated: Oct 15, 2024 by Shane Smith
3 min read

'Virtualization of a SIL™ script' means that a script may be stored either on disk (default) or in the database (optional).

This may seem like an odd functionality, but in short time, we're preparing a bold move: carrying the whole scripts to the database, performing a backup on the server, then moving to another one and doing restore, that will restore all the scripts in the right places. You will have the opportunity to move them back to files on the target system. This functionality is the first step toward this goal.

In addition to the architecture that is flexible enough so we can add any type of storage, storing files in the database is very important feature.

SIL Home Directory

The most important, the SIL™ Home Directory indicates the path on the server that is used to store your programs. That directory must exist and the default is created when our apps are first installed. Charset represents the charset used when your programs are stored and interpreted. It is the default charset, and is used in all the text file operations if not specified otherwise.

Database Storage

Advantages of Storing Scripts in the Database

  • Files management in case of moving an installation

  • Theoretically safer storage (we hope you backup your database)

  • Disk remains clean

Disadvantages of Storing Scripts in the Database

  • Accessing a source before putting it to the cache has a small performance penalty

  • Accessing it outside of our SIL™ editor may be harder

Disk Storage

Advantages of Storing Scripts on the File System

  • Scripts can be versioned and backed up by using a Git repository on the file system

  • Script performance is generally faster

  • Scripts are easier to access

Disadvantages of Storing Scripts on the File System

  • Scripts may be less secure (not that it may be an issue)

  • Slightly harder to migrate

So which one should I choose?

Generally, we suggest you go with the file system. Its faster and easy. There can be more advantages to being able to access the file system that just storing scripts, but that is for another guide.

However…

If the file system is not configured to 100% Atlassian’s guidelines the nodes may be slow to share files across them. Most of the time this is not an issue and users do not notice. However, when editing scripts across the nodes it may take a few seconds for them to propagate. Storing the scripts in the database may help alleviate some of those issues.

Configuring Script Storage

Power Apps Configuration → General → SIL Storage

The above setting is used just for files that will be created. Files may be individually moved between storages using the SIL Manager editor. If unsure, use File System.

Important

Only SIL™ scripts are stored in the database storage as of now. Other configuration files, like mail templates, are not. We plan to change that, too.

Switching Storage Types

New to SIL 5.x, a utility has been added to migrate the scripts between the database and the file system. Please not the above warning, only SIL scripts are stored in the database. It is common for experienced scripters to use many other types of files like, HTML, JavaScript, CSV, text, etc.

More Configuration Guides

 

Peacock