SQLite VS Flying Logic

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: 12 months 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

Somewhat related is _Flying Logic_, which was ostensibly made to to enable ToC-type thinking processes at Northop Grumman. https://flyinglogic.com/ For a period in my life I was very taken by the promise of a node-based graph visualisation of projects, enabling you to quickly track dependencies, constraints, next steps, redundancies and so on. - Source: Hacker News / 12 days ago

Just as a data point. This feature of one-note (text boxes where you click) is the single reason I’m looking for something else. I absolutely hate any interface that has me fiddle with layout when I’m trying to focus on semantics. Not that this should impact Obsidian much, since I assume the canvas thing is optional there, just a data point. Related to infinite canvas _do_ checkout “The Humane Environment” [1] it... - Source: Hacker News / over 1 year ago

Flying Logic comes to mind as a possible tool for organizing your analysis and analyzing relationships between notes and attributes ("aspects"), though FL is not a note-taking software. Source: over 1 year ago