Francis Cao
|
ab58c76b6a
|
change views back to pageviews
|
2024-03-27 11:17:00 -07:00 |
|
Francis Cao
|
c033b0582d
|
create join table and remove subquery from insert
|
2024-03-25 19:13:54 -07:00 |
|
Francis Cao
|
d36bf4396a
|
remove order by in insert select
|
2024-03-25 18:47:02 -07:00 |
|
Francis Cao
|
7c7fd577c3
|
remove test schema from CH migration script
|
2024-03-25 18:33:30 -07:00 |
|
Francis Cao
|
d3ca856521
|
check in clickhouse migration script
|
2024-03-25 16:29:29 -07:00 |
|
Francis Cao
|
cbeefe733f
|
add psql migration
|
2024-03-21 09:30:42 -07:00 |
|
Francis Cao
|
1cf5bd488c
|
remove kafka engine tables
|
2023-12-27 09:22:32 -08:00 |
Brian Cao
|
7b97209d56
|
Fix CH script.
|
2023-09-13 13:27:07 -07:00 |
Mike Cao
|
e4bd314bd6
|
Updates to insights, event data, telemetry.
|
2023-07-23 13:18:01 -07:00 |
|
Francis Cao
|
74bd4d5366
|
add missing semi-colons
|
2023-07-13 16:30:10 -07:00 |
|
Brian Cao
|
1a793572e8
|
update backfill script.
|
2023-07-10 22:29:38 -07:00 |
|
Brian Cao
|
3749e2a70d
|
update to isoutc string value.
|
2023-07-10 16:54:42 -07:00 |
|
Brian Cao
|
0a3ee2277a
|
Fix numeric to number.
|
2023-07-06 21:02:56 -07:00 |
|
Brian Cao
|
be433cd0fd
|
update CH migration.
|
2023-07-05 21:09:16 -07:00 |
|
Francis Cao
|
c901358222
|
rename to job_id
|
2023-06-26 10:32:23 -07:00 |
|
Francis Cao
|
a5582416b3
|
update CH schema with upload_id
|
2023-06-26 08:19:52 -07:00 |
|
Brian Cao
|
b484286523
|
Feat/um 305 unique session ch (#2065)
* Add session_data / session redis to CH.
* Add mysql migration.
|
2023-05-31 21:46:49 -07:00 |
|
Francis Cao
|
d827bf1417
|
update CH kafka engine tables for error handling
|
2023-05-07 23:13:40 -07:00 |
|
Francis Cao
|
95ed8a09aa
|
update CH event to website_event
|
2023-03-29 11:06:12 -07:00 |
|
Francis Cao
|
077fad20ea
|
update skip_broken_messages
|
2023-03-27 12:44:59 -07:00 |
|
Francis Cao
|
14e4a090bb
|
update schema and queries to implement reset_at
|
2023-03-27 11:25:16 -07:00 |
|
Brian Cao
|
be2fc0de8d
|
Fix ch schema.
|
2023-03-23 14:17:32 -07:00 |
|
Brian Cao
|
9979672de5
|
Feat/um 202 event data new (#1841)
* Add event_data base.
* Add url_path.
* Add eventData back.
* Finish event_data relational.
* resolve comments.
|
2023-03-23 14:01:15 -07:00 |
|
Francis Cao
|
ea39f5b431
|
add new event data schema
|
2023-03-22 23:02:37 -07:00 |
|
Francis Cao
|
b0c5899569
|
update prisma / ch filters logic
|
2023-03-20 11:26:45 -07:00 |
|
Francis Cao
|
9321401297
|
schema changes to CH, Postgres, MySQL
|
2023-03-14 17:27:17 -07:00 |
|
Brian Cao
|
82f0bc3d2b
|
remove event_data. (#1804)
|
2023-03-01 16:42:47 -08:00 |
|
Francis Cao
|
55a586fe27
|
add subdivision1/2, cities to query logic
|
2023-02-20 09:04:20 -08:00 |
|
Francis Cao
|
074fa2c5fc
|
add subdivision2 to schema
|
2023-02-16 09:52:07 -08:00 |
|
Francis Cao
|
b6cc6cb655
|
update CH, postgres, MySQL schemas
|
2023-02-15 09:40:49 -08:00 |
|
Brian Cao
|
8732d056dd
|
Dev (#1702)
* Initial Typescript models.
* Re-add realtime data
* get distinct sessions for session metrics
* Add queries for new schema.
* Fix Typo.
* Add some api/team endpoints.
* Fix destructure error.
* Fix getWebsites call.
* Ignore typescript build errors.
* Fix enum issue.
* add clickhouse route to deleteWebsite
* Fix Website auth.
* Updated lint-staged config.
* Add permission checks.
* Add user role api.
* Fix error when updating website.
* Fix isAdmin check. Fix Schema.
* Initial conversion to react-basics.
* Remove user/team transfer from website update.
* delete website in relational query
* Fix login secure token creation.
* Add event type to event.
* Allow user to be added to team with role.
* Updated login form.
* Add Role to TeamUser.
* Add database migration.
* Refactored permissions check. Updated redis lib.
* Feat/um 114 roles and permissions (#1683)
* Auth checkpoint.
* Merge branch 'dev' into feat/um-114-roles-and-permissions
* Add 02 migration.
* Added lib/types.
* Updated schema.
* Updated roles and permissions logic.
* Implement react-basics styles. Fix queries.
* Update website details layout.
* Add 01 migration.
* Fix admin create.
* Update react-basics.
Co-authored-by: Francis Cao <franciscao@gmail.com>
Co-authored-by: Mike Cao <mike@mikecao.com>
Co-authored-by: Mike Cao <moocao@gmail.com>
|
2022-12-12 19:45:38 -08:00 |
|
Francis Cao
|
106dd25594
|
clickhosue: validate string being sent into event_data
|
2022-11-16 11:42:02 -08:00 |
|
Francis Cao
|
6a0d5ee1e6
|
add rev_id to CH schema
|
2022-11-07 18:03:27 -08:00 |
Brian Cao
|
249f02d073
|
fix schema
|
2022-10-11 23:10:32 -07:00 |
|
Brian Cao
|
317d3c6637
|
fix schema script
|
2022-10-11 21:02:15 -07:00 |
|
Francis Cao
|
96add409b6
|
update api to new CH columns
|
2022-10-08 16:12:33 -07:00 |
|
Brian Cao
|
8e068310b8
|
remove CH migration
|
2022-09-12 10:12:17 -07:00 |
|
Brian Cao
|
52e036964b
|
Merge Session/Event/Pageview CH
|
2022-09-12 09:55:34 -07:00 |
|
Brian Cao
|
12704c81e5
|
set experiment.
|
2022-08-31 21:44:49 -07:00 |
|
Brian Cao
|
7c05a54ffe
|
allow event data CH
|
2022-08-30 17:29:30 -07:00 |
|
Francis Cao
|
2715a124de
|
ch init formatting
|
2022-08-22 23:05:22 -07:00 |
|
Francis Cao
|
508e23c52e
|
update clickhouse schema
|
2022-08-16 15:27:59 -07:00 |
|
Francis Cao
|
192dd218cb
|
move kafka logic into own file
|
2022-08-12 09:21:43 -07:00 |
|
Francis Cao
|
55ba7d95ab
|
fix clickhouse date timezone issues
|
2022-08-08 22:09:18 -07:00 |
|
Francis Cao
|
1a84608e2b
|
add Clickhouse migration files. update saveEvent to include event_uuid
|
2022-08-04 20:15:21 -07:00 |