Database Management (Project Libraries)

Unlike older software that saves projects as individual files (e.g., MyProject.prproj or MyProject.aep), Oraphim is built entirely on SQL Databases (called Project Libraries).

When you make a cut on the timeline, you are not writing to a file; you are sending a query to a database. This architecture is what allows Oraphim's famous Live Save feature to operate instantly without ever freezing the software.

Types of Databases

1. Local Database (DiskDB)

This is the default setting. Oraphim creates a hidden SQLite database folder on your local hard drive.

• Use Case: Solo editors working on a single machine.
• Backup Strategy: You must manually back up the entire database folder to an external drive.

2. Network Database (PostgreSQL)

A robust server architecture.

• Use Case: Multiple editors collaborating on the exact same timeline simultaneously (Cloud Collaboration).
• You install a PostgreSQL server on a dedicated machine in your studio (or use Oraphim Cloud), and all client computers connect to it via an IP address.

Managing the Database

To open the Database Manager, click the Project Library icon in the upper left corner of the Home screen.

Backing up a Database

It is critical to regularly back up your entire database, not just individual projects.

1. In the Project Library panel, click the Information (i) icon next to your database name.
2. Click Back Up.
3. Select a destination. Oraphim will compress every single project, timeline, and setting inside the library into a single .resolve.diskdb file.

Restoring a Database

If your computer crashes and you lose everything:

1. Reinstall Oraphim.
2. Open the Project Library panel.
3. Click the Restore button.
4. Select your backup .resolve.diskdb file. All your projects will instantly reappear.

Optimizing a Database

After months of heavy editing, deleting projects, and duplicating timelines, the SQL database can become fragmented, causing Oraphim to launch slowly.

1. Click the Information (i) icon.
2. Click Optimize. Oraphim will reorganize the SQL tables, dramatically speeding up save and load times.