Request: AUP3 and/or sqlite documentation

Feedback and Reviews for Audacity 3.x
Forum rules
This board is ONLY for general feedback and discussion about Audacity 3.X.

If you require help, or think you have found a "bug", please post on the forum board relevant to your operating system.
Windows
Mac OS X
GNU/Linux and Unix-like
Post Reply
whbjr
Posts: 121
Joined: Thu Apr 14, 2011 4:20 pm
Operating System: Windows 10

Request: AUP3 and/or sqlite documentation

Post by whbjr » Tue May 25, 2021 10:52 pm

Is there going to be documentation on the AUP3 format, and/or the sqlite database structure?

That would make my tech-oriented mind happy, but what I really want is a way to get at the sort of info contained in the old AUP file:
- How many tracks are in this project?
- Are the track stereo or mono, and what is the bitrate?
- What are the track names?
- How many blocks are in each track?
- Any labels on the track(s)?

Personally, for my electronic music projects, I'll have at least a half-dozen tracks, usually named for the synthesizer patch. It's easy for me to check the AUP files to see which tracks used a given patch, but the only way to do that with AUP3 is to open each project in Audacity. Also, on the occasions when I remembered to add a note to myself via a label ("Adjustable Fade: S-Curve Down: 0db to -10db"), it's easy to find such notes in the AUP files.

So, this is a two-part request: documentation on the AUP3 file, and a program (Python script?) to show the database info. Too much to ask?

- Win

steve
Site Admin
Posts: 81270
Joined: Sat Dec 01, 2007 11:43 am
Operating System: Linux *buntu

Re: Request: AUP3 and/or sqlite documentation

Post by steve » Tue May 25, 2021 11:24 pm

Try examining a project AUP3 file with DB Browser for SQLite.
9/10 questions are answered in the FREQUENTLY ASKED QUESTIONS (FAQ)

whbjr
Posts: 121
Joined: Thu Apr 14, 2011 4:20 pm
Operating System: Windows 10

Re: Request: AUP3 and/or sqlite documentation

Post by whbjr » Wed May 26, 2021 2:05 am

I did - it was not very helpful. Here's what it shows for the data in one of my projects, which opens exactly as expected in Audacity.

The command-line "sqlite3" on Linux says "Error: file is encrypted or is not a database" and the web-based "phpliteadmin.php" says "No table in database."

- Win
Attachments
aup3-browse.png
aup3-browse.png (44.03 KiB) Viewed 78 times

steve
Site Admin
Posts: 81270
Joined: Sat Dec 01, 2007 11:43 am
Operating System: Linux *buntu

Re: Request: AUP3 and/or sqlite documentation

Post by steve » Wed May 26, 2021 9:51 am

I'd assumed from the nature of your question that you had some expertise with SQLite.

It's normal in a closed project for the "autosave" table to be empty.

If you look at the Database Structure you should see something like this:
structure.png
structure.png (158.91 KiB) Viewed 67 times

The "project" table contains the project structure in binary format:
project.png
project.png (156.37 KiB) Viewed 67 times

The "sampleblocks" table contains the audio data:
sampleblocks.png
sampleblocks.png (178.87 KiB) Viewed 67 times

Note that unless / until a format specification for AUP3, it is subject to change at any time without notice. The Audacity developers will make every effort to retain compatibility across Audacity versions, but that does not guarantee compatibility with third party apps.
9/10 questions are answered in the FREQUENTLY ASKED QUESTIONS (FAQ)

whbjr
Posts: 121
Joined: Thu Apr 14, 2011 4:20 pm
Operating System: Windows 10

Re: Request: AUP3 and/or sqlite documentation

Post by whbjr » Wed May 26, 2021 4:13 pm

Steve - Thanks, this is quite helpful!
steve wrote:
Wed May 26, 2021 9:51 am
I'd assumed from the nature of your question that you had some expertise with SQLite.
Yes and no - I know SQL, and I've used phpMyAdmin and the like for many years, but I don't have a lot of sqlite experience. I'm still quite confused about the failure of the Linux-based tools; someday soon I'll try phpLiteAdmin on a Windows server.
Note that unless / until a format specification for AUP3, it is subject to change at any time without notice. The Audacity developers will make every effort to retain compatibility across Audacity versions, but that does not guarantee compatibility with third party apps.
I'd say this is the "real" answer for now, and that's fine - but here's one more vote for a format specification for AUP3!

Thanks again, much appreciated.

- Win

Post Reply