I’d like to look into the features of notion more, but I can’t help but wonder why it isn’t more common to see people using a local SQLite database, or any other self hosted database, to serve as a personal knowledge base management system. A lot of the paid solutions I’ve seen seem to bend over backwards to offer a limited subset of the features that are trivially available in an actual database. Has anyone tried ou…
I started with excel a lot of year ago, migrated to access and now i'm trying nixoxdb for android (the only other acceptable alternative was mobidb).
The main problem is the ease to use, you need to create a table for everything you want to store, and nothing support an hybrid free-form AND structured data(while also been able to store files), so the solutions with good text editing are terrible at structured data and viceversa.
Other problem are the ability to sync or even open the database in more than a couple of platform and the ability to access the file embedded in the database from other application (there are others but this are the one that bother me the most).
I'm also evaluating notion, but i really don't want a cloud service since i store basically everything inside my main database and the ability to access years from now is a MUST.
Also i still not have a good solution for my email that are stored mostly in thunderbird and only some message are "exported" to my main database.
I'm thinking of building something myself based on sqlite, .net, dokan/fuse and something similar to syncthing. But it's a big project and i don't have a lot of time
edit: couple of fixes