Database schema for a file organizer

This page summarizes the projects mentioned and recommended in the original post on /r/Database

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • calibre

    The official source code repository for the calibre ebook manager

    I would like the content of the database to be easily imported and exported to be used with calibre, stash, stash-box, beets, etc… but at the same time I wouldn’t want to make the database too complicated. So I don’t know if I should add all information from books, movies, music, etc to the file entity or if I should make it it’s own entity. The same for album, tv shows, etc I don’t know if I should use collection only. I want to save as much information from those databases as possible, and then do an ETL to use the same information with those programs. Are there any other programs I should look at?

  • stash

    An organizer for your porn, written in Go. Documentation: https://docs.stashapp.cc

    I would like the content of the database to be easily imported and exported to be used with calibre, stash, stash-box, beets, etc… but at the same time I wouldn’t want to make the database too complicated. So I don’t know if I should add all information from books, movies, music, etc to the file entity or if I should make it it’s own entity. The same for album, tv shows, etc I don’t know if I should use collection only. I want to save as much information from those databases as possible, and then do an ETL to use the same information with those programs. Are there any other programs I should look at?

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • stash-box

    Stash App's own OpenSource video indexing and Perceptual Hashing MetaData API

    I would like the content of the database to be easily imported and exported to be used with calibre, stash, stash-box, beets, etc… but at the same time I wouldn’t want to make the database too complicated. So I don’t know if I should add all information from books, movies, music, etc to the file entity or if I should make it it’s own entity. The same for album, tv shows, etc I don’t know if I should use collection only. I want to save as much information from those databases as possible, and then do an ETL to use the same information with those programs. Are there any other programs I should look at?

  • terminusdb

    TerminusDB is a distributed database with a collaboration model

    Not sure if you are committed to SQL, but TerminusDB, an immutable store, seems to meet your design parameters: https://github.com/terminusdb/terminusdb

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts