Context
This PR adds support for git repository information in the analytics system by adding the necessary columns to the ClickHouse database and updating the UI to handle these properties appropriately.
Implementation
Updated .docker/scripts/clickhouse/001-create-tables.sql to include git properties in the schema for new database instances. Migrated package.json's to support new type schema.
Modified apps/web/src/components/task-sharing/TaskDetails.tsx to display git properties when available (message if not).
Added some claude-code typing.
How to Test
Run the migration by rebuilding docker and pnpm. If this still doesn't work try deleting .docker/data/clickhouse
Create a new task in a git tracked repo on Roo Code extension while signed in-- verify this is logged correctly.
* Add messages table to local clickhouse setup
Copied from production, using MergeTree() instead of
SharedMergeTree('/clickhouse/tables/{uuid}/{shard}', '{replica}').
This still only runs on a fresh setup (e.g. rm -rf .docker/clickhouse),
so it's a poor substitute for actual migrations.
* Update .docker/scripts/clickhouse/001-create-tables.sql
Co-authored-by: ellipsis-dev[bot] <65095814+ellipsis-dev[bot]@users.noreply.github.com>
* Add local clickhouse url+password to development env
---------
Co-authored-by: ellipsis-dev[bot] <65095814+ellipsis-dev[bot]@users.noreply.github.com>
Caveats / Deficiencies
This is not a perfect match for the server clickhouse config since we're
using MergeTree() as the engine. It seemed like it was going to be much
more complex to exactly match production, but I may have missed something
obvious.
The create tables sql only seems to be run on a completely fresh install.
