Search

So I have some .opus files thst I want to convert to .mp3. I used ffmpeg CLI with a script from https://ottverse.com/convert-all-files-inside-folder-ffmpeg-batch-convert, I used the wav to mp3 one but put opus instead of wav. The output is always in the same folder, and I want it to go to another, how can I do it? (windows 10)

SOLUTION: https://lemmy.world/comment/6337795

EDIT: With thanks to u/[email protected], I have a solution for cleaning up the one table that is growing ridiculously in size and that is the activity table. A TRUNCATE activity; command cleaned that right up. A word of caution is in order because the Lemmy instance must be shutdown completely and only the postgres container running if you're using docker.

As a new Lemmy admin, I think I really need to learn PostgreSQL administration because I need a way to keep my database from ballooning in size and there are no management tools built yet for it. Would someone be so kind as to recommend a good website for learning PostgreSQL? This would also help me maintain my mastodon instance.