Re: choosing a lightweight database

2019-01-17 Thread John Nemeth
On Jan 17, 1:44pm, Robert Elz wrote: } } Date:Wed, 16 Jan 2019 19:10:54 -0800 } From:John Nemeth } Message-ID: <201901170310.x0h3asgp014...@server.cornerstoneservice.ca> } } | If you're using the package, then it is: } | } | mysqld=YES mysqld_

Re: choosing a lightweight database

2019-01-16 Thread Michael van Elst
k...@munnari.oz.au (Robert Elz) writes: >Date:Wed, 16 Jan 2019 19:10:54 -0800 >From:John Nemeth >Message-ID: <201901170310.x0h3asgp014...@server.cornerstoneservice.ca> > | If you're using the package, then it is: > | mysqld=YES mysqld_datadir="/usr

Re: choosing a lightweight database

2019-01-16 Thread Robert Elz
Date:Wed, 16 Jan 2019 19:10:54 -0800 From:John Nemeth Message-ID: <201901170310.x0h3asgp014...@server.cornerstoneservice.ca> | If you're using the package, then it is: | | mysqld=YES mysqld_datadir="/usr/local/mysql" But doesn't that put all d

Re: choosing a lightweight database

2019-01-16 Thread John Nemeth
On Jan 17, 9:15am, Robert Elz wrote: } } Date:Wed, 16 Jan 2019 08:21:02 -0800 } From:John Nemeth } Message-ID: <201901161621.x0ggl2pk007...@server.cornerstoneservice.ca> } } | MySQL is quite simple to setup, } } How does one tell it exactly where the database shou

Re: choosing a lightweight database

2019-01-16 Thread Robert Elz
Date:Wed, 16 Jan 2019 08:21:02 -0800 From:John Nemeth Message-ID: <201901161621.x0ggl2pk007...@server.cornerstoneservice.ca> | MySQL is quite simple to setup, How does one tell it exactly where the database should be stored? My database is currently just flles, wi

Re: choosing a lightweight database

2019-01-16 Thread John Nemeth
On Jan 16, 1:12pm, Greg Troxel wrote: } John Nemeth writes: } } > } If it turns out your data size or query/update rate is too much, I would } > } use postgres. I know you said you don't want a process, but unlike } > } mysql postgres is really easy to set up. } > } > It would be nice to g

Re: choosing a lightweight database

2019-01-16 Thread Steffen Nurpmeso
r...@reedmedia.net wrote in : |Any recommendations on a lightweight database (no extra server process) |to use with dynamic website? I have written a LMDB backend for bogofilter, and am using it since about mid of July 2018. (It is not yet released, but done.) It took a week to learn using LMD

Re: choosing a lightweight database

2019-01-16 Thread tlaronde
On Wed, Jan 16, 2019 at 01:12:15PM -0500, Greg Troxel wrote: > John Nemeth writes: > > > } If it turns out your data size or query/update rate is too much, I would > > } use postgres. I know you said you don't want a process, but unlike > > } mysql postgres is really easy to set up. > > > >

Re: choosing a lightweight database

2019-01-16 Thread matthew sporleder
On Wed, Jan 16, 2019 at 1:12 PM Greg Troxel wrote: > > John Nemeth writes: > > > } If it turns out your data size or query/update rate is too much, I would > > } use postgres. I know you said you don't want a process, but unlike > > } mysql postgres is really easy to set up. > > > > It woul

Re: choosing a lightweight database

2019-01-16 Thread Greg Troxel
John Nemeth writes: > } If it turns out your data size or query/update rate is too much, I would > } use postgres. I know you said you don't want a process, but unlike > } mysql postgres is really easy to set up. > > It would be nice to get rid of some of the FUD around here. > MySQL is qui

Re: choosing a lightweight database

2019-01-16 Thread matthew sporleder
On Wed, Jan 16, 2019 at 11:32 AM John Nemeth wrote: > > On Jan 16, 11:03am, Greg Troxel wrote: > } r...@reedmedia.net writes: > } > } > Around 200 attributes, but not all for each. > } > > } > Also I have key/values like > } > FOO-notes="for supplementing text for FOO" > } > And description and d

Re: choosing a lightweight database

2019-01-16 Thread John Nemeth
On Jan 16, 11:03am, Greg Troxel wrote: } r...@reedmedia.net writes: } } > 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 te

Re: choosing a lightweight database

2019-01-16 Thread Greg Troxel
r...@reedmedia.net writes: > 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

Re: choosing a lightweight database

2019-01-16 Thread Ron Georgia
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 si

choosing a lightweight database

2019-01-15 Thread reed
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