My wiki can be scripted using an embedded version of the Janet scripting language, so conceivably one could potentially use it to generate interesting presentations of the Zet. The Zet is included in my static wiki engine. That way, I can configure things in such a way to only partially compile the database if things get too large. Also, I’ve set things up so that TSV files can be broken up into groups. The samples would be contained inside of SQLar archives as small self-contained collections (presumably on some external drive), and then copied into the compiled SQLite database when they are needed to be used. The repo would only manage the metadata, not the samples themselves. The Zet could then be cloned onto a new computer, and then “compiled” into a SQLite database.
![audiofinder split wav audiofinder split wav](https://cdn.trendhunterstatic.com/thumbs/audio-splitter.jpeg)
This allows the Zet to be managed using source control.
![audiofinder split wav audiofinder split wav](https://ae01.alicdn.com/kf/HTB182wmGL1TBuNjy0Fjq6yjyXXad/220v-2-in-8-out-AV-RCA-Video-Audio-Splitter-Selector.jpg)
The Zet can be imported/exported using a tab-separated-value plaintext file.
Audiofinder split wav archive#
Crate makes it easy to automatically import files stored in a SQLar archive into a Zet database. I’ve build a bridge between my Zet and SQLar which is called Crate (inb4 Rust did it first). SQLite also has a strange experimental archive format called SQLar, which I’ve been very intrigued by.
Audiofinder split wav full#
In addition to having an expressive querying language, SQLite also has goodies like full text search which make it a really powerful file format. My Zet and Wiki are both stored as SQLite tables. This provides the baseline for an annotation system and a tagging system. Things can also be things like messages, groups, and references to other things (via the UUID address). One of “things” a thing can be is a file path, presumably pointing to a particular sample. Keys don’t have to be unique, which allows a single item to have multiple attributes. Every “thing” has a UUID4 tag as the key (I use the uuid4 library by rxi to generate these). Using this structure, I can make things and link things to things. The Zet structure is essentially a key/value database with timestamps.
Audiofinder split wav generator#
I’m hoping if I keep at this long enough, these sort of relationships and structures between samples and sounds will naturally form.Ī few weeks ago I started building a Generic Zettelkasten (the “zet”) for myself, which is part of the static wiki generator I built for myself about year or so ago. Over time, this network of connections allows for interesting relationships to emerge. Zettelkastens usually have some sort of cross-referencing capabilities. Well, sample libraries are like that as well. My approach is to try manually catalogue, tag, document, annotate, etc content in a centralized place, and then build out solutions that can integrate with this database format.Ī Zettelkasten is a means for storing and retrieving information in a very granular fashion. The TL DR is that I’m attempting to turn my sample collections into something resembling a centralized Zettelkasten, and storing it in SQLite. It’s still a growing and evolving, but I think I have a pretty solid foundation. This is finally a relevant thread for me.Īfter years and years of thinking about it, I recently decided to take a stab at building a system for organizing and curating my various sample libraries and collections.