DB-serverless blog/CMS software suggestion?
4. Blog-like interface (reverse-chronological list of posts).
Comments can be moderated before posting.
Can upload and post photos.
Posts can be made private or public, bonus if they can also be made restricted (can give people an account to look at some stuff that we don't want to make fully public).
Here's the kicker: since we don't intend for these to be big traffic things (mostly personal, with some family/friends looking at some stuff), I'd rather not install a full-on database server. So something that supports SQLite or a flat file sort of system is what I really want. I've been trying a number of the SQLite-supporting systems in Wikipedia's list of CMS softwares, but I have yet to find one that quite captures all of the wish list above. Basically, I'm just looking to see if anyone out there is more familiar with the sea of CMS/blog software out there and happens to know of something that might fit the bill.
Any advice appreciated.
I'd rather not install a full-on database server.
How much less work/resources are there in running a light database engine versus a full blown database engine, especially when it's just a tiny amount of data?
Seems silly picking the engine first, and then the application.
Pick the CMS/Blog that has the features you want or need, then install whatever engine it requires.
It's all cost the same, so what difference does it make?
Drupal 7 supports sqlite, as long as you don't expect much traffic you're fine,
Drupal may be a bit heavyweight for us, but I'll check it out, thanks!
It's my minimalist nature spilling into my admin. Partly it's security (a service not running is a service that can't be exploited), and partly it's practical (a service not running is a service that doesn't have to be administered). I'm not 100% against installing a "real" database engine, it just doesn't seem like it should be necessary in this case, so I'd prefer to explore other options first.
Partly it's security (a service not running is a service that can't be exploited)
Agreed. But c'mon, something like MySQL is even used in the enterprise. All you have to do is keep your system up to date and you're fine (2 commands at most). Make sure that MySQL is listening on localhost only and you're even better. A little blog for you and your girlfriend isn't Fort Knox.
partly it's practical (a service not running is a service that doesn't have to be administered)
For a low traffic site, MySQL is set it and forget it. In this case, it's install it and forget it (1 command at most).
IMO, those limitations that you placed on the system will actually cause you more work than to just go with Drupal/MySQL and be done with it.
Just kidding, but what a load of crap (your self imposed restrictions).
Instead of picking something mainstream with the features you need, you're piddling around trying to find some boutique app that probably doesn't exist.
We're talking web apps, not some hippie fixie bike, minimalist doesn't mean "better".
> IMO, those limitations that you placed on the system will actually cause you more work than to just go with Drupal/MySQL and be done with it.
@funkytastic: I'm not sure what the minimalist approach seeks to achieve. I can install Drupal 7 on a LAMP stack with all the features and security the OP needs in under 20 minutes (15 minutes if I type fast). So again, what does the minimalist approach seek to achieve? How about being a minimalist in the amount of time taken to get what you need with the features you need?
2) Whip something up in
… err, sorry, was getting into the spirit a little bit there.~~
It satisfies all the requirements in the original post, and supports SQLite. Thanks to everyone who chimed in with suggestions!