[SR-Users] CockroachDB and Kamailio

[Henning Westerholt]

Hi Noah,

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.

What do you mean by default configuration?

Cheers,

Henning

-- 
Henning Westerholt - https://skalatan.de/blog/
Kamailio services - https://gilawa.com 

-----Original Message-----
From: Noah Mehl <noahmehl at gmail.com> 
Sent: Thursday, August 20, 2020 6:35 PM
To: Henning Westerholt <hw at skalatan.de>
Cc: Kamailio (SER) - Users Mailing List <sr-users at 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 at 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 at lists.kamailio.org> On Behalf Of Noah 
> Mehl
> Sent: Wednesday, August 19, 2020 10:13 PM
> To: sr-users at 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 at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users