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

Fun fact: We've implemented binary embedding search [1] without the need for a specialized vector database. Instead, we create dimensional tokens like 'embedding_0_0', 'embedding_1_0', and so on, and we harness the robust capabilities of Tantivy [2]. We're really satisfied with the exceptional quality and performance this approach yields. Moreover, Tabby remains a single binary, integrating all these components... - Source: Hacker News / 10 days ago

| Hm, I am interested, but I would love to use it as a rust lib and just have rust types instead of some json config... Yes that's how you use tantivy normally, not sure which json config you mean. `tantivy-cli` is more like a showcase, https://github.com/quickwit-oss/tantivy is the actual project. - Source: Hacker News / 25 days ago

Tantivy - a full-text indexing library written in Rust. Has a great Performance and featureset. - Source: dev.to / 5 months ago

By this I presume you mean build a search index that can retrieve results based on keywords? I know certain databases use Lucene to build a keyword-based index on top of unstructured blobs of data. Another alternative is to use Tantivy (https://github.com/quickwit-oss/tantivy), a Rust version of Lucene, if building search indices via Java isn't your cup of tea... - Source: Hacker News / 5 months ago

We also implemented our schemaless columnar storage optimized for object storage. The inverted index and columnar storage are part of tantivy [0], which is the fastest search library out there. We maintain it and we decided to build the distributed engine on top of it. [0] tantivy github repo: https://github.com/quickwit-oss/tantivy. - Source: Hacker News / 6 months ago