What is MIME type "application/x-audacity-project+sqlite3"?

A MIME type is a string that tells browsers and other tools how to handle a particular kind of file.

application/x-audacity-project+sqlite3 marks a file that stores an Audacity project. It uses an SQLite3 database to keep audio project data.
This MIME type saves details such as track layouts, edits, effect settings, and other session data.

Files with this MIME type are stored in the AUP and AUP3 formats.
The use of SQLite3 ensures the project data is organized and robust, which helps in reloading projects accurately.

Key facts and use cases include:

For more technical details, check out the SQLite Official Site or Audacity Team page.

Associated file extensions

.aup, .aup3

Usage Examples

HTTP Header

When serving content with this MIME type, set the Content-Type header:


    Content-Type: application/x-audacity-project+sqlite3

HTML

In HTML, you can specify the MIME type in various elements:


    <a href="file.dat" type="application/x-audacity-project+sqlite3">Download file</a>

Server-side (Node.js)

Setting the Content-Type header in Node.js:


    const http = require('http');    
    
    http.createServer((req, res) => {    
      res.setHeader('Content-Type', 'application/x-audacity-project+sqlite3');    
      res.end('Content here');    
    }).listen(3000);

Associated file extensions

.aup, .aup3

FAQs

How do I open a file with the MIME type application/x-audacity-project+sqlite3?

You need to use Audacity 3.0 or later to open these files. This MIME type specifically identifies the newer AUP3 project format, which functions as a single, self-contained SQLite database. You cannot open these files with standard media players like VLC or Windows Media Player.

Why can't I play an AUP3 file in my web browser?

Browsers do not support rendering Audacity project files directly because they contain complex editing data rather than a simple audio stream. To play the audio on a website, you must open the project in Audacity and use File > Export to save it as a web-standard format like MP3 or WAV.

What is the difference between AUP and AUP3 files?

Older AUP files were XML-based and required a separate _data folder containing thousands of small audio chunks. The newer AUP3 format (identified by application/x-audacity-project+sqlite3) combines the project structure and audio data into a single SQLite3 database file, making it much easier to move, share, and backup.

How do I configure an Apache server to serve Audacity project files?

To ensure browsers handle the file correctly, add the MIME type definition to your .htaccess or httpd.conf file. Add the line: AddType application/x-audacity-project+sqlite3 .aup3. This prevents the server from misidentifying the file as generic binary data.

Can I manually edit the SQLite database inside an AUP3 file?

While it is technically possible to open an .aup3 file with a generic SQLite database browser, doing so is highly discouraged. Modifying the internal tables manually can easily corrupt the project structure, rendering it unreadable by Audacity.

Why is my application/x-audacity-project+sqlite3 file so large?

These files contain uncompressed audio data (often PCM) for every track in your project to ensure high quality during editing. Unlike compressed formats such as MP3, the database stores the full fidelity audio, resulting in significantly larger file sizes.

What should I do if I receive a 'Corrupt Database' error when opening the file?

Since application/x-audacity-project+sqlite3 is an SQLite database, it can sometimes be recovered using database tools. Audacity has built-in recovery tools, but if those fail, advanced users can sometimes use the sqlite3 command-line tool with the .recover command to salvage the data.

General FAQ

What is a MIME type?

A MIME (Multipurpose Internet Mail Extensions) type is a standard that indicates the nature and format of a document, file, or assortment of bytes. MIME types are defined and standardized in IETF's RFC 6838.

MIME types are important because they help browsers and servers understand how to process a file. When a browser receives a file from a server, it uses the MIME type to determine how to display or handle the content, whether it's an image to display, a PDF to open in a viewer, or a video to play.

MIME types consist of a type and a subtype, separated by a slash (e.g., text/html, image/jpeg, application/pdf). Some MIME types also include optional parameters.

How do I find the MIME type for a file?

You can check the file extension or use a file identification tool such as file --mime-type on the command line. Many programming languages also provide libraries to detect MIME types.

Why are multiple MIME types listed for one extension?

Different applications and historical conventions may use alternative MIME identifiers for the same kind of file. Showing them all helps ensure compatibility across systems.