sqlitebrowser VS Cryptomator

Check out: https://sqlitebrowser.org/

You may also need the SQLite command-line tools from the SQLite website;

First of all, we should point out that SQLite can also easily be manipulated by non-technical users. There are several, excellent open-source SQLite “browsers” or “editors” available that allow for a graphical user interface to manipulate SQLite databases. Two notable examples are, DB Browser and Sqlite Viewer.

db.sqlite is encrypted using SqlCipher. You can open this using tools that support SqlCipher. One such tool is https://sqlitebrowser.org/ (source/releases: https://github.com/sqlitebrowser/sqlitebrowser).

DB Browser for SQLite and SQLiteStudio both exists, not sure if this is what you are looking for.

Have you tried https://sqlitebrowser.org/ ?

DB Browser for Sqlite is an open source GUI for sqlite. You point it to a sqlite file and you can browse tables/insert rows, etc. (Note: nothing is persisted to disk until you save!)

SQLite DB file. You can view the DB contents with https://sqlitebrowser.org/

My recommendation would be to use Sqlite. It pretty simplistic and works well. The program, found here, https://sqlitebrowser.org/ is a UI for Sqlite that can be used for loading or interacting with your data. If your data is in CSV, you can use the UI to parse and load your data file(s).

https://support.mozilla.org/en-US/kb/compacting-folders https://www.crucial.com/articles/about-ssd/should-you-defrag-an-ssd Kind of interesting to poke around Firefox's and other programs sqlite database files, just be cautious. https://sqlitebrowser.org/

KeepassXC or at least cryptomator

Cryptomator is an easy solution for saving things in an encrypted container for efficient upload to the cloud.

I went the other way. I moved everything to the cloud and installed Cryptomator on everybody’s phones. It also registers as a file provider, and seamlessly encrypts everything you put in it.

Use something like Cryptomator (GUI) or Rclone (CLI) to upload your documents encrypted so even Google can't snoop. Completely safe and off site.

Cryptomator - data encryption for all file types and folders

I've only used the desktop client for Cryptomator on Windows but they have a Linux one too. Creates an encrypted folder which you then put in your non-encrypted untrustworthy cloud sync folder (Dropbox, Google Drive, or whatever).

Sorry to be the "grumpy old man", but i don't get it.

In my experience, self hosting usually falls into two categories, people that "just want to host a simple static website", and "host all the things", and both are usually served better by using the cloud.

Most are in the category "i want to learn about self hosting", meaning they have (close to) zero experience, and while self hosting by itself isn't hard, maintaining a secure environment is, and that's where many people fail.

For the "simple static website", you can host it for free pretty much everywhere you like. Github pages, Azure static web apps, and countless others all offer stable, professional cloud servies for free, without the risk of exposing your network to the internet.

For the "host all the things", you see people attempting to mimic and entire data center at home, complete with monitoring, CI/CD and everything, and while i appreciate the learning experience, most people are blissfully unaware of the chore it is to maintain such a thing. Most of these services are better off being in the cloud.

- email is a likely thing people will want to self host, which is also perhaps the most stupid thing to do. First of all, it is a chore to keep your server off of various block lists, and you gain nothing but pain by self hosting it. Email is insecure by design. Every email has at least 2 parties, the sender and the receiver, and with >50% of the worlds recipients running on Google/Microsoft/Yahoo/whatever, your email will get indexed. A much better alternative is letting someone who knows what they're doing host your email, and use a personal domain. That way you can move your MX records if need be, still maintain your email address if changing provider, and let someone else deal with the problems of running the service. If it's privacy you want, use something else, or use encryption. In both cases, self hosting gives you nothing additional.

- cloud storage is another contender, and the most common "excuse" is that cloud hosting is too expensive, and yes, if you plan to store 200TB in the cloud then it is, but maybe instead you need to look at which files are needed when away from home, and use the cloud for those, and leave the rest at home, accessible by VPN if need be. If you need privacy with cloud file hosting, something like Cryptomator (https://cryptomator.org/) is much easier/better than maintaining your own server. (as a side note, you can get around 20TB of cloud storage for €20/month, or roughly the price of the electricity required to run a 4 drive NAS for the same time, but not including cost of hardware).

Not matter your setup at home, you will never create something as resilient as the major cloud datacenters. i.e. OneDrive (paid version) stores your files across multiple geographically separated data centers, using erasure coding, so if one data center dies, your files are still available in another center, and hastily being replicated to a third center. It uses atomic writes (like CoW filesystems, ZFS, Btrfs, APFS, etc) to ensure data written is correct, and has checksumming (inherent in the erasure coding), as well as versioning of files (OneDrive has unlimited file versioning for 30 days rolling), meaning you get at least some ransomware protection.

So in the end, most people are way better served by putting their stuff in the cloud and encrypting it, than they are exposing insecure services from home.

By all means, build the cluster at home as a learning experience, but save yourself some trouble and keep it within your LAN. If you need to access it externally, use a VPN instead. With modern VPNs like wireguard, there is very little overhead, and your data will thank you for it (as will your family as you suddenly have a lot more time to spend with them!).