On 30/10/17 16:31, Nigel Verity wrote: > > I imagine that once the design is finalised and the database populated > it will be used to drive aspects of the HPR website rather than be > directly accessed by lots of people.
That's right. Some fairly simple queries on the whole I think, and not too many. > If that is the case then MySql/Mariadb and PG may both be adding > avoidable complexity in having to be maintained and accessed via a > server process. Sqlite is serverless and stores the data and view > definitions in a single file which can be emailed to anybody who who > might need to work on it. As long as you don't lose track of which is > the "master" and run into data primacy issues it can make life simpler. > > Just an idea - I don't know your concept of use, so this may be irrelevant. That's an interesting thought. In fact, having just listened to "FLOSS Weekly" episode 456 over the weekend, where they interviewed David Barrett about "Bedrock (http://bedrockdb.com/)" I started to wonder about this myself. Certainly food for thought - thanks! Dave -- Dave Morriss, Edinburgh, Scotland, UK | [email protected] _______________________________________________ Hpr mailing list [email protected] http://hackerpublicradio.org/mailman/listinfo/hpr_hackerpublicradio.org
