Hello,
As you may know, several database implementations (PostgreSQL, MySQL, SQLite, …) allow JSON columns.
Has anyone tried to read from, or write data to, such a JSON column using Asterisk ODBC stack ?
Best regards
I was never able with MySQL. I posted about it here Issues with using ODBC to query json response from MySQL. From my limited knowledge of how software interacts with DB’s is it allocates enough memory for the max value of a column. So if say you have a column that is varchar(10) then the code will allocate a minimum for 10 characters. I suspect (this is just a hunch) that my issue is related to Asterisk not knowing/allocating the correct amount of memory.
Ideally, I would split my testings in two:
- using isql/unixodbc and without touching Asterisk
- with Asterisk and its full ODBC stack.
At the moment, I don’t have any running database with a JSON field.
I’ll try to set one if I can.
If someone has any posiive or negative experience on the subject, please, do not hesitate to share it here.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.