As a suggestion for 5.0 having a scripted DB migration system would make upgrading much easier. Something like what Asterisk now uses (Alembic https://pypi.python.org/pypi/alembic) would be ideal, as it works in a DB agnostic manner and you would just have to ensure that there is a driver for the DB you wish to use. That way you would just update the definition script and select the target when you run the updater, and would allow kamailio a greater choice in backing DB's as once the script is written assuming a driver is available for you RDBMS the schema would be successfully ported. This would do away with maintaining separate MySQL, Postgres, Oracle, MSSQL scripts as well. The only issue I can think with a system like this is in the situation where hardcoded SQL strings are in the source and use a RDBMS specific function as that could cause some "fun" in debugging...
Hello,
kamcli tool is a good candidate for such feature, it is python and quite modular:
- https://github.com/asipto/kamcli
Adding migrating db feature was one of my goals for this tool, but lack of time didn't allow me to dig much into python, as I am not using this programming language that often. Maybe others can jump on board and help here.
Cheers, Daniel
On 02/03/16 18:21, Tim Chubb wrote:
As a suggestion for 5.0 having a scripted DB migration system would make upgrading much easier.
Something like what Asterisk now uses (Alembic https://pypi.python.org/pypi/alembic) would be ideal, as it works in a DB agnostic manner and you would just have to ensure that there is a driver for the DB you wish to use.
That way you would just update the definition script and select the target when you run the updater, and would allow kamailio a greater choice in backing DB’s as once the script is written assuming a driver is available for you RDBMS the schema would be successfully ported.
This would do away with maintaining separate MySQL, Postgres, Oracle, MSSQL scripts as well.
The only issue I can think with a system like this is in the situation where hardcoded SQL strings are in the source and use a RDBMS specific function as that could cause some “fun” in debugging…
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
On 03/03/2016 04:30 PM, Daniel-Constantin Mierla wrote:
Hello,
kamcli tool is a good candidate for such feature, it is python and quite modular:
Adding migrating db feature was one of my goals for this tool, but lack of time didn't allow me to dig much into python, as I am not using this programming language that often. Maybe others can jump on board and help here.
Seems like a nice feature!
-
Daniel-Constantin Mierla -
Tim Chubb -
Victor Seva