search

gen-mind / cognix

Opensource private chatGPT for your organization knowledge
https://cognix.ch
Other
12 stars 4 forks source link

Changed CockroachDB to YugabyteDB to use only open source #311

Open FranckPachot opened 3 months ago

FranckPachot commented 3 months ago

YugabyteDB is Open Source PostgreSQL-compatible distributed SQL, so it can be a better choice than CockroachDB for an Open Source software.

I did the minimum change to start YugabyteDB instead of CockroachDB in the docker-compose and let you test if all is ok. If you are interested by this change, there are probably some other modifications in other files

In src/config/yugabytedb_cli.env I've left COCKROACHDB in the variable names to avoid changing it everywhere but it would be better to use POSTGRESQL as it can be used with all PostgreSQL-compatible databases

gsantopaolo commented 3 months ago

Hi @FranckPachot, and thank you for your PR. I'm interested in learning more about YugabyteDB and see if it's a fit for CogniX Let me know where I can find some docs. We are interested in a relational, cloud native, distributed database with a transaction isolation level lower that serializable

looking forward to hearing form you

FranckPachot commented 3 months ago

Hi, yes it's a good fit. YugabyteDB supports all PostgreSQL isolation levels. It is a fork of PostgreSQL plugged on top of a distributed storage (tables and indexes distributed by their key and replicated by Raft). The docs are here: https://docs.yugabyte.com/preview/ If you want, I can explain it on a quick zoom at CET timezone fpachot@yugabyte.com (I'm Developer Advocate)

gsantopaolo commented 3 months ago

It looks like a real cool project.

I need some time to test it out...