Excerpts from Alan Robertson's message of 2018-02-12 19:12:41 -0700:
> So, that's a total of 4 possible methods of storing the data...
> (a) in Neo4j, (b) in Postgres, (c) in flat files, (d) in S3. Of those
> four, only Postgres will provide indexing.
> If on the other hand, we break out big JSON blobs into individual nodes in
> Neo4j, we can search that
> instead (as Michael Hunger suggested).
What about SQLite? It's no worse than flat JSON and gives you transactions
and indexing. The major drawback is that it uses database-level locking,
so writes are going to serialize entirely.
Assimilation mailing list - Discovery-Driven Monitoring