Re: Question about Clickhouse DB to Store Accounting

Alan DeKok via Freeradius-Users <[email protected]> Thu, 5 Mar 2026 18:49:24 -0500

Newsgroups	gmane.comp.freeradius.user
Message-ID	<[email protected]>

On Mar 3, 2026, at 3:53 PM, Ibrahim Almahfooz <[email protected]> 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.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

signature.asc (application/pgp-signature, 833 B)