I was able to use llama.cpp and whisper.cpp to help me build a transcription site for my favorite podcast[0]. I'm a total python noob and hadn't really used sqlite before, or really used AI before but using these tools, completely offline, llama.cpp helped me write a bunch of python and sql to get the job done. It was incredibly fun and rewarding and most importantly, it got rid of the dread of not knowing.

0 - https://transcript.fish