Henning, So, for the default config, it only has the option for: WITH_MYSQL. I was wondering if a WITH_PGSQL would be accepted.
As for the kamdbctl scripts, there are a few things I’ve noticed: I would prefer UUID vs SERIAL. This actually is a little more annoying when dealing with the SEQUENCE entity in Postgres. The only change required, is to load the pgcrypto extension and switch to uuid instead of SERIAL. I have a tracking branch here: https://github.com/reperio/kamailio/tree/postgres_uuid <https://github.com/reperio/kamailio/tree/postgres_uuid> The other reason is that for cockroachdb, using gen_random_uuid() is documented to be more efficient <https://www.cockroachlabs.com/docs/stable/create-sequence.html> (in addition to being a preference). As for cockroachdb, I have a tracking branch (based on the uuid branch) that seems to be working well: https://github.com/reperio/kamailio/tree/cockroach <https://github.com/reperio/kamailio/tree/cockroach> So far, the only issue in the creation/managment of the schema is: CREATE FUNCTION. But it looks like maybe concat() and random() are already supported by cockroackdb: https://www.cockroachlabs.com/docs/stable/functions-and-operators.html <https://www.cockroachlabs.com/docs/stable/functions-and-operators.html>. I will have to dig deeper into the lcr module to see where/if this is an issue. Thanks! ~Noah > On Aug 20, 2020, at 2:23 PM, Henning Westerholt <h...@skalatan.de> wrote: > > 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 <noahm...@gmail.com> > Sent: Thursday, August 20, 2020 6:35 PM > To: Henning Westerholt <h...@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 <h...@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-boun...@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 >
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users