Hi. I’m using InfluxDB to store sales data but have an issue with recording events that happened at the same time.
My database schema looks something like this:
id, type, price, amount, time
id
, price
and amount
are fields. type
is a tag because it is the only value I’m querying on. I’ve added the id
field only to make a sale unique and to know what sale I’ve indexed last.
However, sales can occasionally happen at the same time for the same type with the same amount and price. In that case InfluxDB seems to only store the first event, not the following once.