338 Commits

Author SHA1 Message Date
Carl-Gerhard Lindesvärd
56b01ca6d8 feat: support filter by numbers 2025-12-02 23:33:41 +01:00
Carl-Gerhard Lindesvärd
8b31e4cfba fix: add conditionally clickhouse options 2025-11-27 14:59:11 +01:00
Carl-Gerhard Lindesvärd
ae09748e4e fix: unique report count 2025-11-27 13:38:32 +01:00
Carl-Gerhard Lindesvärd
620904b4d4 fix: view profiles, improve chart service 2025-11-27 13:12:14 +01:00
Carl-Gerhard Lindesvärd
b421474616 feat: report editor
commit bfcf271a64c33a60f61f511cec2198d9c8a9c51a
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Wed Nov 26 12:32:40 2025 +0100

    wip

commit 8cd3b89fa3
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Tue Nov 25 22:33:58 2025 +0100

    funnel

commit 95af86dc44
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Tue Nov 25 22:23:25 2025 +0100

    wip

commit 727a218e6b
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Tue Nov 25 10:18:26 2025 +0100

    conversion wip

commit 958ba535d6
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Tue Nov 25 10:18:20 2025 +0100

    wip

commit 3bbeb927cc
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Tue Nov 25 09:18:48 2025 +0100

    wip

commit d99335e2f4
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Mon Nov 24 18:08:10 2025 +0100

    wip

commit 1fa61b1ae9
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Mon Nov 24 15:50:28 2025 +0100

    ts

commit 548747d826
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Mon Nov 24 13:17:01 2025 +0100

    fix typecheck events -> series

commit 7b18544085
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Mon Nov 24 13:06:46 2025 +0100

    fix report table

commit 57697a5a39
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Sat Nov 22 00:05:13 2025 +0100

    wip

commit 06fb6c4f3c
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Fri Nov 21 11:21:17 2025 +0100

    wip

commit dd71fd4e11
Author: Carl-Gerhard Lindesvärd <lindesvard@gmail.com>
Date:   Thu Nov 20 13:56:58 2025 +0100

    formulas
2025-11-26 12:33:41 +01:00
Carl-Gerhard Lindesvärd
790801b728 feat: revenue tracking
* wip

* wip

* wip

* wip

* show revenue better on overview

* align realtime and overview counters

* update revenue docs

* always return device id

* add project settings, improve projects charts,

* fix: comments

* fixes

* fix migration

* ignore sql files

* fix comments
2025-11-19 14:27:34 +01:00
Carl-Gerhard Lindesvärd
dcc0d0df18 fix: funnel for milliseconds difference 2025-11-17 13:56:39 +01:00
Carl-Gerhard Lindesvärd
da59622dce fix: overall perf improvements
* fix: ignore private ips

* fix: performance related fixes

* fix: simply event buffer

* fix: default to 1 events queue shard

* add: cleanup scripts

* fix: comments

* fix comments

* fix

* fix: groupmq

* wip

* fix: sync cachable

* remove cluster names and add it behind env flag (if someone want to scale)

* fix

* wip

* better logger

* remove reqid and user agent

* fix lock

* remove wait_for_async_insert
2025-11-15 22:13:59 +01:00
Carl-Gerhard Lindesvärd
84fd5ce22f fix: metric chart total count 2025-11-12 23:15:20 +01:00
Carl-Gerhard Lindesvärd
e613a4e01c fix: dont count session events for current billing period 2025-11-12 14:57:03 +01:00
Carl-Gerhard Lindesvärd
723ba3ef6c add: admin cli 2025-11-12 14:57:02 +01:00
Carl-Gerhard Lindesvärd
9cafd61b25 feat: new billing and restrict access when trial has ended
* fix: simply billing

* fix usage graph

* imporve billing more + supporter prompt on self-hosting

* revert service change

* revert query builder

* fix: comments
2025-11-11 11:09:11 +01:00
Carl-Gerhard Lindesvärd
a9b9ffa029 fix: add retries with backoff to mixpanel api 2025-11-05 21:41:50 +01:00
Carl-Gerhard Lindesvärd
0663ce6ac8 fix: backfill sessions for imports 2025-11-05 12:52:57 +01:00
Carl-Gerhard Lindesvärd
b8cb13a854 fix: add getReplicatedTableName 2025-11-05 12:13:26 +01:00
Carl-Gerhard Lindesvärd
70682c218f remove async insert 2025-11-05 11:30:26 +01:00
Carl-Gerhard Lindesvärd
212254d31a feat: new importer (#214) 2025-11-05 09:49:36 +01:00
Carl-Gerhard Lindesvärd
b51bc8f3f6 fix: improvements for frontend 2025-11-04 12:26:52 +01:00
Carl-Gerhard Lindesvärd
76b68ba5d7 fix: funnel (filter on profile properties) 2025-10-31 12:19:46 +01:00
Carl-Gerhard Lindesvärd
f454449365 fix: read-after-write issues (#215)
* fix: read-after-write issues

* fix: coderabbit comments

* fix: clear cache on invite

* fix: use primary after a read
2025-10-31 09:56:07 +01:00
Carl-Gerhard Lindesvärd
931188a8ab fix: timezone issue + improvements for funnel and conversion charts 2025-10-30 11:28:08 +01:00
Carl-Gerhard Lindesvärd
ddc99e9850 feat: ignore secret or cors for client 2025-10-29 21:14:43 +01:00
Carl-Gerhard Lindesvärd
bcfb4f25fb fix: option to allow cluster migrations without relying on self hosting env 2025-10-23 10:50:20 +02:00
Carl-Gerhard Lindesvärd
42d0fb8572 fix self-hosting 2025-10-22 11:38:37 +02:00
Carl-Gerhard Lindesvärd
21fc076368 fix: checkout 2025-10-18 10:28:56 +02:00
Carl-Gerhard Lindesvärd
077a47a263 fix: improvements in the dashboard 2025-10-17 18:51:55 +02:00
Carl-Gerhard Lindesvärd
c8bea685db fix: invalidate queries better 2025-10-17 11:01:20 +02:00
Carl-Gerhard Lindesvärd
4ccabc5fa3 fix: overview metrics 2025-10-16 14:42:07 +02:00
Carl-Gerhard Lindesvärd
81a7e5d62e feat: dashboard v2, esm, upgrades (#211)
* esm

* wip

* wip

* wip

* wip

* wip

* wip

* subscription notice

* wip

* wip

* wip

* fix envs

* fix: update docker build

* fix

* esm/types

* delete dashboard :D

* add patches to dockerfiles

* update packages + catalogs + ts

* wip

* remove native libs

* ts

* improvements

* fix redirects and fetching session

* try fix favicon

* fixes

* fix

* order and resize reportds within a dashboard

* improvements

* wip

* added userjot to dashboard

* fix

* add op

* wip

* different cache key

* improve date picker

* fix table

* event details loading

* redo onboarding completely

* fix login

* fix

* fix

* extend session, billing and improve bars

* fix

* reduce price on 10M
2025-10-16 12:27:44 +02:00
Carl-Gerhard Lindesvärd
e7c21bc92c fix: remove old event queue, cleaned up session handling, remove hacks 2025-10-09 09:25:52 +02:00
Carl-Gerhard Lindesvärd
af580333b4 fix: bump groupmq, fix stalled sessions in buffers, improve heavy event count 2025-10-06 22:20:14 +02:00
Carl-Gerhard Lindesvärd
0b4fcbad69 feat: use groupmq instead of bullmq for incoming events (#206)
* wip

* wip working group queue

* wip

* wip

* wip

* fix: groupmq package (tests failed)

* minor fixes

* fix: zero is fine for duration

* add logger

* fix: make buffers more lightweight

* bump groupmq

* new buffers and bump groupmq

* fix: buffers based on comments

* fix: use profileId as groupId if exists

* bump groupmq

* add concurrency env for only events
2025-10-04 21:07:55 +02:00
Carl-Gerhard Lindesvärd
df32bb04a0 feat(api): add insights endpoints 2025-09-08 22:07:09 +02:00
Carl-Gerhard Lindesvärd
52b86682e2 fix: ensure we dont bloat notification table with any other notification than app 2025-09-03 21:39:21 +02:00
Carl-Gerhard Lindesvärd
e5cacb73df fix(api): ensure we always have profile in cache (before inserted to clickhouse) 2025-08-13 20:57:42 +02:00
Carl-Gerhard Lindesvärd
31ccfb8b5f improve: add profile to notifications templates eg {{profile.email}} 2025-08-08 22:38:03 +02:00
Carl-Gerhard Lindesvärd
92d62c3e5c improve: prepare for coolify and general self-hosting improvements (#175)
* fix(self-hosting): improve docker compose, add healthchecks, rename env SELF_HOSTED

* improve(db): improve initial migration when no data exists

* fix(db): misstakes were made

* improve(dashboard): better curl preview depending on project type

* fix(db): fix migrations

* fix(onboarding): ensure we publish event correctly

* wip

* fix: curl preview

* add coolify template

* fix(dashboard): page -> route

* fix

* fix env
2025-06-23 22:21:11 +02:00
Carl-Gerhard Lindesvärd
e3e9e60b25 fix(api): handle profile filters/breakdowns better 2025-06-11 22:31:27 +02:00
Carl-Gerhard Lindesvärd
f59bcfba3c improve(dashboard): better event selector and other improvements 2025-06-05 11:28:06 +02:00
Carl-Gerhard Lindesvärd
5b1e94e9ad fix(api): filter empty values when using sum and average, added min and max 2025-06-04 12:45:26 +02:00
Carl-Gerhard Lindesvärd
92210c1b3f fix(api): broken overview when filter path 2025-06-04 11:32:48 +02:00
Carl-Gerhard Lindesvärd
0d58a5bf0c improve(queue): how we handle incoming events and session ends 2025-06-03 21:19:01 +02:00
Carl-Gerhard Lindesvärd
39775142e2 fix(api): ensure we get correct date format 2025-05-27 09:32:45 +02:00
Carl-Gerhard Lindesvärd
680727355b feature(dashboard,api): add timezone support
* feat(dashboard): add support for today, yesterday etc (timezones)

* fix(db): escape js dates

* fix(dashboard): ensure we support default timezone

* final fixes

* remove complete series and add sql with fill instead
2025-05-23 11:26:44 +02:00
Carl-Gerhard Lindesvärd
ce184b157f fix(api): filter events by profileId for export route 2025-05-21 20:52:26 +02:00
Carl-Gerhard Lindesvärd
2cd358e1bb improve(dashboard): better event details 2025-05-13 23:09:37 +02:00
Carl-Gerhard Lindesvärd
d0e90dfa79 improve(dashboard): make pages page better (ux and features) 2025-04-17 09:27:50 +02:00
Carl-Gerhard Lindesvärd
89ab8d08de improve(api): increase limit 1000, allow both projectId and project_id 2025-04-16 21:40:22 +02:00
Carl-Gerhard Lindesvärd
e2254e78a9 fix(dashboard): breakdowns on profile properties 2025-04-16 20:52:22 +02:00
Carl-Gerhard Lindesvärd
be3c18b677 feature(dashboard): filter on profile properties and support drag n drop for events 2025-04-16 11:08:58 +02:00