I haven't gotten any answers (or even any views of my question), so here's my very non-authoritative answer, based on some googling and some testing of one of the programs.
There's a comprehensive list of NoSQL databases here: http://nosql-database.org/
So you can search that web page for ".net" or "c#", and get a complete (and quite large) list of ...
For this I'd seriously consider using mongodb even though you say this on a single machine for local access. In addition to your requirements, you probably want to think about ease of backup, etc. - I'd hate to loose a few thousand records, never mind hundreds of thousands or millions....
It is nosql. It has Java drivers/connectors. It works with JSON ...
Finally I found it. It uses Cassandra as an in-memory embedded server. The libraries are written on Java and they are available on Maven.
Take a look at CockroachDB. You're talking big data and the platform needs to support serious scaling.
It's probably good out of the box and it has a good open source community.
Grafana works with InfluxDB by default.
Grafana reporter can generate reports from the Dashbords.
Now you can simply use cron with curl/wget to download the files and place them at the desired location.
Your reluctance to write own software is understandable, however libraries like Python Pandas or matplotlib could be used to write a high level script ...
I feel it would be irresponsible to recommend something based on the little details provided, but since my thoughts didn't fit in a comment, I'll post it here.
For the OLTP use-case: if you think Postgres is a good fit feature-wise and for your development team, and the only concern you have is scaling, the metrics you should consider are the operational ...
If you are able to represent your object as JSON, then consider using Postgres and its jsonb (“JSON binary”) data type.
This type accepts your JSON input, and then parses it to represent that JSON document in its own internal binary format. This special format allows Postgres to index elements you specify.
So you get the flexibility of semi-...
Without knowing more about your use cases, it is pretty hard to make a proper suggestion here. Quite some DBMS fit the use case you describe, but may be totally wrong for other use cases.
Furthermore, I have to add that BigData requires some in-depth knowledge and experience to set up the chosen DBMS properly. Please make sure that you understand the ...
Apparently you say you need geographic/geospatial information features. In that case, your choice is either:
Pay large fees to a commercial company like Oracle, or
Use the free-of-cost open-source PostGIS system built on Postgres, the world's most advanced open-source database.
YugaByte DB is an open-source cloud-native database for mission-critical applications. YugaByte DB supports two popular NoSQL APIs, Apache Cassandra Query Language (CQL) and Redis, in a wire-compatible fashion. It supports single-row ACID (with multi-row transactions coming soon), and has been extensively tested in a number of real-world use cases. Automatic ...
You can use firebirdsql database.
Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of ...
If I were given this task I would turn to Openresty, you do not even need the whole shebang, just lua-nginx-redis driver for lua-nginx-module, under Ubuntu/Debian installing lua-nginx-redis will install all the nginx parts you need. And of course you'll need Redis. This tutorial is extremely close - it does an internal redirect based on the user agent. ...
What I was looking for is called Embedded Database. According to wikipedia:
An embedded database system is a database management system (DBMS)
which is tightly integrated with an application software that requires
access to stored data, such that the database system is "hidden" from
the application’s end-user and requires little or no ...
You can do that with MongoDB:
Fetch first 100 from cursors
create new cursor, skip 100 and fetch the next 100
Skipping is done via https://docs.mongodb.com/manual/reference/method/cursor.skip
MongoDB is open source.
I used to manage informations like these.
I used PostgreSQL, where you have the advantage of a relational db and Nosql.
You can store in a single record, normalized data, like import data, an id, etc.. and an array, or a json, or even an Hstore.
Plus: it has native compression.