Yes. A Lightroom catalog file is, after all, just a SQLite database. (Srsly, make a copy of your catalog file, rename it whatever.sqlite and use your favorite SQLite GUI to rip it open and look at the tables and fields). It's just storing the pathame to the RAW file for that file's record in the database. Source: about 1 year ago

I use visidata with a playback script I recorded to open the sheet to a specific Excel tab, add a column, save the sheet as a csv file. Then I have a sqlite script that takes the csv file and puts it in a database, partitioned by monthYear. Source: about 1 year ago

Use the most-used database in the world: https://sqlite.org/index.html. Source: over 1 year ago

With this in mind, I wrote a few versions of this post, but I hated them all. Then I realized that jodliterate PDF documents mostly do what I want. So, instead of rewriting MirrorXref.pdf, I will make a few comments about jodliterate group documents in general. If you're interested in using SQLite with J, download the self-contained GitHub files MirrorXref.ijs and MirrorXref.pdf and have a look. - Source: dev.to / almost 2 years ago

SQLite, by many estimates, is the most widely deployed SQL database system on Earth. It's everywhere. It's in your phone, your laptop, your cameras, your car, your cloud, and your breakfast cereal. SQLite's global triumph is a gratifying testament to the virtues of technical excellence and the philosophy of "less is more.". - Source: dev.to / almost 2 years ago

Some good transcription solutions: https://zapier.com/blog/best-text-dictation-software/#windowsspeech https://otter.ai/ (Haven't actually tried Otter, but it gets a LOT of good reviews.). - Source: Hacker News / about 1 month ago

Of course, there are many existing solutions like Otter.ai or Fathom in the market. But in case you want to build a tool yourself and customize the output of it, then you are on the same page as me. To develop this application, we will use Unbody to convert input video transcriptions into intelligence/generative content and Appsmith to make it easy to design and build the UI of our app without extensive front-end... - Source: dev.to / 7 months ago

This is weird but I wonder if you could use something like https://otter.ai/. Record your notes as you are going. That should give you at least text of all of your welds. You’d still have to punch it later. Seems like there’s got to be a better way to do this. Stopping every time to break your flow sounds like a huge pain in the ass. Curious what you come up with. Source: 7 months ago

Is there any app from otter.ai that you run on personal machine? How does otter.ai process 4 different audio streams? Source: 7 months ago

Job laptop -> 3.5mm aux (this turns into speaker output) -> 3.5mm mic/audio splitter (this turns into microphone input) -> 3.5mm to usb-c adapter (cause my macbook only has 1 3.5mm aux) --> now the personal macbook has a new "mic input" from the job laptop. Which you can use to pipe audio into otter.ai to transcribe audio. You have to manually name them, but they learn in subsequent meetings. Source: 7 months ago