Building single page applications with ClickHouse

Adopting a "client only" architecture for web applications can simplify development and enable faster iteration by reducing the need for complex backend infrastructure and simplified scalability. This approach has been popularized by Firebase, particularly through its Firebase Realtime Database, which introduced browser-based access with security rules that could be managed via tokens, including anonymous authentication tokens. ClickHouse can also be deployed in this architecture with a little configuration, allowing developers to directly query the database from the client side while ensuring the database remains secure and isn't overwhelmed with requests. Key features of ClickHouse that enable it to be used in a client-only architecture include an HTTP interface & REST API, output formats, query parameters, role-based access control, restrictions on query complexity, and quotas.