Post AdMYgo2JQfLfYVmk1Q by stefano@mastodon.bsd.cafe
(DIR) More posts by stefano@mastodon.bsd.cafe
(DIR) Post #AdImWqnEPidhnrnpQ0 by stefano@mastodon.bsd.cafe
2023-12-29T12:43:17Z
0 likes, 3 repeats
As I grow older, I find myself increasingly appreciating setups that are simple, effective, replicable, and reliable. Seeing dependable solutions that steer clear of databases and favor files always sparks a heartfelt enthusiasm in me, turning into a smile on my face. #TechSimplicity #ReliableSolutions #FileBasedSystems #IT
(DIR) Post #AdIoSe0UD7Eeti7mhk by fedops@fosstodon.org
2023-12-29T13:04:55Z
1 likes, 0 repeats
@stefano I'm exactly the same!
(DIR) Post #AdIqKnfwZw6cTZu4Zc by oblomov@sociale.network
2023-12-29T13:25:54Z
0 likes, 0 repeats
@stefano fun fact: this is one of the things that is holding me back from self-hosting an ActivityPub instance of any kind: I can't find one that relies on plain files rather than a DB for storage.
(DIR) Post #AdIr8yxusRz3yDEr0C by stefano@mastodon.bsd.cafe
2023-12-29T13:34:59Z
0 likes, 0 repeats
@oblomov I'm trying snac2 at https://snac.bsd.cafe and seems quite interesting. https://codeberg.org/grunfink/snac2
(DIR) Post #AdItNRs4P3Mda9WuHo by oblomov@sociale.network
2023-12-29T13:59:59Z
0 likes, 0 repeats
@stefano oh interesting, I'll keep it under consideration.
(DIR) Post #AdJ32w8cCxQV2uMWsS by humbird0@mstdn.party
2023-12-29T15:48:21Z
0 likes, 0 repeats
@stefano I don't think I would mind a database if it's also a file that I can download and backup.
(DIR) Post #AdJ3G0nOCbKVFvfWt6 by stefano@mastodon.bsd.cafe
2023-12-29T15:50:43Z
0 likes, 0 repeats
@humbird0 I think that databases are useful (or needed) for many operations. But we don't always need a database, and moving (closed) files is a joy, also when performing backups
(DIR) Post #AdM32lyiZ2Y50iXCim by 0x1eef@mastodon.bsd.cafe
2023-12-31T02:32:27Z
0 likes, 0 repeats
@stefano I agree. I am working on a web application that I want to be easy to use, and easy to install. It was a bit diffilcult to rely solely on the filesystem, so I settled on SQLite3.
(DIR) Post #AdMYgo2JQfLfYVmk1Q by stefano@mastodon.bsd.cafe
2023-12-31T08:27:03Z
0 likes, 0 repeats
@0x1eef sqlite3 can be a good choice. But when small apps with a couple of tables and a buch of columns (and some hundreds of records) require MySQL or PostgreSQL, I think it's pure overhead