if you find something that does not work with the default PostgreSQL schema from kamdbctl, create an issue. It some cases it is just a matter of formatting and it can work for PostgreSQL and CockroachDB. This is probably the easier path, from an maintenance point of view.
--
Henning Westerholt -
https://skalatan.de/blog/
Kamailio services -
https://gilawa.com
-----Original Message-----
From: Noah Mehl
noahmehl@gmail.com
Sent: Thursday, August 20, 2020 6:35 PM
To: Henning Westerholt
hw@skalatan.de
Cc: Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
Subject: Re: [SR-Users] CockroachDB and Kamailio
Henning,
Thanks for the reply! I am testing away. I will update with my findings.
That being said, some things might be slightly different. Should I add a cockroachdb option to the kamdbctl and default configs as a PR?
~Noah
> On Aug 20, 2020, at 2:35 AM, Henning Westerholt
hw@skalatan.de wrote:
>
> Dear Noah,
>
> it was probably not discussed on the public list, at least I don't remember it. Cockroachdb claims to be compatible with PostgreSQL, so it should work with this DB Kamailio module.
>
> If you encounter issues, report on this list, or open a bug report if its something related to problems in the Kamailio db_postgres module.
>
> Cheers,
>
> Henning
>
> --
> Henning Westerholt -
https://skalatan.de/blog/ Kamailio services -
>
https://gilawa.com
>
> -----Original Message-----
> From: sr-users
sr-users-bounces@lists.kamailio.org On Behalf Of Noah
> Mehl
> Sent: Wednesday, August 19, 2020 10:13 PM
> To: sr-users@lists.kamailio.org
> Subject: [SR-Users] CockroachDB and Kamailio
>
> Has anyone been down this path before? We are trying to test this out and the results are pretty promising so far.
>
> I realize the lack of Stored Procedures and Triggers make this untenable for many Postgres based implementations.
>
> Thanks!
>
> ~Noah
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users@lists.kamailio.org
>
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users