<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Henning,<div class=""><br class=""></div><div class="">So, for the default config, it only has the option for: WITH_MYSQL. I was wondering if a WITH_PGSQL would be accepted.</div><div class=""><br class=""></div><div class="">As for the kamdbctl scripts, there are a few things I’ve noticed:</div><div class=""><br class=""></div><div class="">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:</div><div class=""><br class=""></div><div class=""><a href="https://github.com/reperio/kamailio/tree/postgres_uuid" class="">https://github.com/reperio/kamailio/tree/postgres_uuid</a></div><div class=""><br class=""></div><div class="">The other reason is that for cockroachdb, using gen_random_uuid() is documented to be more <a href="https://www.cockroachlabs.com/docs/stable/create-sequence.html" class="">efficient</a> (in addition to being a preference).</div><div class=""><br class=""></div><div class="">As for cockroachdb, I have a tracking branch (based on the uuid branch) that seems to be working well:</div><div class=""><br class=""></div><div class=""><a href="https://github.com/reperio/kamailio/tree/cockroach" class="">https://github.com/reperio/kamailio/tree/cockroach</a></div><div class=""><br class=""></div><div class="">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: <a href="https://www.cockroachlabs.com/docs/stable/functions-and-operators.html" class="">https://www.cockroachlabs.com/docs/stable/functions-and-operators.html</a>. I will have to dig deeper into the lcr module to see where/if this is an issue.</div><div class=""><br class=""></div><div class="">Thanks!</div><div class=""><br class=""></div><div class="">~Noah</div><div class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Aug 20, 2020, at 2:23 PM, Henning Westerholt <<a href="mailto:hw@skalatan.de" class="">hw@skalatan.de</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Hi Noah,<br class=""><br class="">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.<br class=""><br class="">What do you mean by default configuration?<br class=""><br class="">Cheers,<br class=""><br class="">Henning<br class=""><br class="">-- <br class="">Henning Westerholt - <a href="https://skalatan.de/blog/" class="">https://skalatan.de/blog/</a><br class="">Kamailio services - <a href="https://gilawa.com" class="">https://gilawa.com</a> <br class=""><br class="">-----Original Message-----<br class="">From: Noah Mehl <<a href="mailto:noahmehl@gmail.com" class="">noahmehl@gmail.com</a>> <br class="">Sent: Thursday, August 20, 2020 6:35 PM<br class="">To: Henning Westerholt <<a href="mailto:hw@skalatan.de" class="">hw@skalatan.de</a>><br class="">Cc: Kamailio (SER) - Users Mailing List <<a href="mailto:sr-users@lists.kamailio.org" class="">sr-users@lists.kamailio.org</a>><br class="">Subject: Re: [SR-Users] CockroachDB and Kamailio<br class=""><br class="">Henning,<br class=""><br class="">Thanks for the reply! I am testing away. I will update with my findings.<br class=""><br class="">That being said, some things might be slightly different. Should I add a cockroachdb option to the kamdbctl and default configs as a PR?<br class=""><br class="">~Noah<br class=""><br class=""><blockquote type="cite" class="">On Aug 20, 2020, at 2:35 AM, Henning Westerholt <<a href="mailto:hw@skalatan.de" class="">hw@skalatan.de</a>> wrote:<br class=""><br class="">Dear Noah,<br class=""><br class="">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.<br class=""><br class="">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.<br class=""><br class="">Cheers,<br class=""><br class="">Henning<br class=""><br class="">--<br class="">Henning Westerholt - <a href="https://skalatan.de/blog/" class="">https://skalatan.de/blog/</a> Kamailio services - <br class=""><a href="https://gilawa.com" class="">https://gilawa.com</a><br class=""><br class="">-----Original Message-----<br class="">From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of Noah <br class="">Mehl<br class="">Sent: Wednesday, August 19, 2020 10:13 PM<br class="">To: sr-users@lists.kamailio.org<br class="">Subject: [SR-Users] CockroachDB and Kamailio<br class=""><br class="">Has anyone been down this path before? We are trying to test this out and the results are pretty promising so far.<br class=""><br class="">I realize the lack of Stored Procedures and Triggers make this untenable for many Postgres based implementations.<br class=""><br class="">Thanks!<br class=""><br class="">~Noah<br class="">_______________________________________________<br class="">Kamailio (SER) - Users Mailing List<br class="">sr-users@lists.kamailio.org<br class="">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users<br class=""></blockquote><br class=""></div></div></blockquote></div><br class=""></div></body></html>