Using sophia as append-only storage

[barrachri]

Hi, I'd like to try using sophia as append-only storage for a queue system.

Basically I want to save:

| id | topic | timestamp | message

does this use case fit with sophia?

[pmwkaa]

Hi. Sure, especially if your key will be monotonically increasing (like timestamp).

[barrachri]

Thanks, would it better to use a single db file or one for each topic?

Keys will monotonically increase for each topic.

[pmwkaa]

I think one big database could be better in terms of resource utilization, but that depends on use case mostly and how keys are distributed.

[barrachri]

I'll be happy to share the first implementation here, a feedback would be more then welcome :)

[pmwkaa]

Sure) i'll take a look