Hemmelig.app icon indicating copy to clipboard operation
Hemmelig.app copied to clipboard

Published 20 hours ago • verified publisher icon HemmeligOrg

Database options

Open d-513 opened this issue 1 year ago • 3 comments

Currently it seems that redis is used. This isn't really great for permanent data storage and is an obstacle for selfhosters. Wouldn't it be better to have SQLite or other database be used?

I can make a PR with SQLite support if desired.

d-513 avatar Sep 28 '22 16:09 d-513

Yeah, I mean redis is OK for its usage, but it is costly to use memory as storage.

I have an old branch with sqlite, but havent looked into it for a while.

Sure you can create a PR for this, but then it has to be created as an adapter so it works as redis do today.

bjarneo avatar Sep 29 '22 15:09 bjarneo

Sure, I think I'm gonna use PrismaJS https://www.prisma.io since that allows access to a lot of different db types with the same code

d-513 avatar Sep 30 '22 04:09 d-513

@dada513 sounds reasonable to me 🥂

bjarneo avatar Sep 30 '22 20:09 bjarneo

Interested in having support for other database engines too: we have dedicated mariadb clusters we would like to leverage instead of using redis we do not master.

How can we help? Did you progress @dada513?

Zulgrib avatar Nov 11 '22 10:11 Zulgrib

@Zulgrib, incoming PR for the database setup now. Have a look at that and give me a suggestion for how we could solve it to work for all providers by Prisma.

bjarneo avatar Apr 03 '23 19:04 bjarneo