Re: Question about Clickhouse DB to Store Accounting

On Mar 3, 2026, at 3:53 PM, Ibrahim Almahfooz <ibrahim.nezar@sevennet.net> wrote:

We are working on a project to store every accounting start, update and stop for special reporting purposes and we are thinking of using ClickHouse DB due to its capability such as supporting fast analytical queries and great for reporting and BI dashboards.

Are there any concerns or suggestions if we decide to use rlm_sql_unixodbc with it, concerns like compatibility or performance?

It should be fine. The only issue I can see is that ClickHouse DB is designed for analyzing large data sets. So it's likely best suited for long-term RADIUS accounting data. It may be less good at updating the "live" accounting database. Alan DeKok.