If you are using python as a "front end," the TinyDB package is lightweight and very nice. Think of it as a Mongodb light. Stores data as a JSON. You can add various extensions and has an excellent API. https://tinydb.readthedocs.io/en/latest/index.html
Philosophy of TinyDB TinyDB aims to be simple and fun to use. Therefore, two key values are simplicity and elegance of interfaces and code. These values will contradict each other from time to time. In these cases , try using as little magic as possible. In any case don’t forget documenting code that isn’t clear at first glance. (https://tinydb.readthedocs.io/en/latest/contribute.html#philosophy-of-tinydb) On 1/15/19, 9:48 PM, "netbsd-users-ow...@netbsd.org on behalf of r...@reedmedia.net" <netbsd-users-ow...@netbsd.org on behalf of r...@reedmedia.net> wrote: Any recommendations on a lightweight database (no extra server process) to use with dynamic website? It is not a lot of data. Currently stored in ~1000 flat files (all stored in git) and could easily be converted to JSON or XML for readable text store. Each file ranges between 7 and 184 unique (per file) values. When done maybe I will have around 10,000 keys and 500,000 attributes like: 1342-rolley-lake-provincial-park flush-toilet=yes 1342-rolley-lake-provincial-park drinking-water=yes 1342-rolley-lake-provincial-park drive-up-camping=yes 1342-rolley-lake-provincial-park showers=yes 1342-rolley-lake-provincial-park hiking=yes 1342-rolley-lake-provincial-park hiking-notes="Lakeside Loop is a 40 minute hike." 1342-rolley-lake-provincial-park state="British Columbia" 1342-rolley-lake-provincial-park country=ca 1-cedar-ridge-scenic-overlook-dinosaur-valley-state-park flush-toilet=no 1-cedar-ridge-scenic-overlook-dinosaur-valley-state-park drinking-water=no 1-cedar-ridge-scenic-overlook-dinosaur-valley-state-park drive-up-camping=no 1-cedar-ridge-scenic-overlook-dinosaur-valley-state-park showers=no 1-cedar-ridge-scenic-overlook-dinosaur-valley-state-park firepit=no 1-cedar-ridge-scenic-overlook-dinosaur-valley-state-park firepit-notes="Ground fires are prohibited; use backpacking stove." 1-cedar-ridge-scenic-overlook-dinosaur-valley-state-park country=usa 1-cedar-ridge-scenic-overlook-dinosaur-valley-state-park state=tx Around 200 attributes, but not all for each. Also I have key/values like FOO-notes="for supplementing text for FOO" And description and direction fields with sentences. The values may be free form text, numbers, boolean yes/no (some values are links to other files). I generate static webpages easily from this (and can dynamically generate webpages easily). Storing this in Berkeley DB would be easy. But I want an easy way to search everything like: country=ca province=alberta elevation>=1524 meters cost<=5 or keyword searches against description fields. Any thoughts on lightweight no database server ideas? I may just use sqlite. Minimal dependencies would be great. Thanks
