Is Supbase a right fit for website tracking applic...
# off-topicd
daman
08/21/2021, 5:27 PMIs Supbase a right fit for website tracking application? Just trying to understand if it fits our needs.
x
Xyo
08/21/2021, 5:36 PMSupabase is Postgres, which isn’t the best for analytics but definitely a good contender
Xyo
08/21/2021, 5:37 PMEspecially since I’ve heard that we might get Timescale on the managed version, potentially
Xyo
08/21/2021, 5:37 PMTimescale makes Postgres sort of fly when it comes to time series data.
Xyo
08/21/2021, 5:38 PMBut yeah, I guess the real question would be if Postgres is fit for your needs - which depends a lot on the complexity of your analytics
d
daman
08/21/2021, 5:40 PMThanks @User ! We have used Firebase in past for a simple website tracking application and found it to work well. My main use case is to store User ID | Page ID| Page URL Visited | Timestamp in a datastore and use it to do certain queries like most visited pages, peak traffic hours.
daman
08/21/2021, 5:42 PMNot sure if Supabase would work well for this use case. We could have thousands of users per minute during campaigns.
x
Xyo
08/21/2021, 5:44 PMWell, thousands of inserts per minute at that data size isn’t really much for Postgres
l
lsunkieder
08/21/2021, 5:44 PMthis is interesting. I am looking into developing something very similar. I was originally going to use Firebase. after a bit of research seemed like fireabse would be quite expensive, hence trying out this
x
Xyo
08/21/2021, 5:44 PMEven the free plan should be able to handle that well
Xyo
08/21/2021, 5:45 PMIs this for ad tracking?
Xyo
08/21/2021, 5:46 PMBut yeah, for that amount of complexity, Postgres is fine. And once (if) we get Timescale, you’ll be able to query data intervals at pretty nice speeds
Xyo
08/21/2021, 5:46 PMObviously if you go selfhosted you can already use Timescale, but I’m gonna assume you’re interested in the managed version.
d
daman
08/21/2021, 5:49 PMYeah managed version. Don't want to handle server complexity. To provide more context we offer an LMS where students do all sorts of activities, Take Lessons, Visit Page, Watch Videos , Replay Videos. Ideally we would want the solution to expand from just website tracking to logging these activities. If it works well we would like to scale to our entire network of thousands of sites.
daman
08/21/2021, 5:50 PMIts difficult to estimate the traffic just yet but it could be well beyond thousands of write per minute if we expand services to offer different event tracking not just pageviews.
x
Xyo
08/21/2021, 5:54 PMWell, it’s Postgres 🤷♂️ spin up a free instance on Supabase and start inserting to benchmark
Xyo
08/21/2021, 5:55 PMIf you really need to squeeze out performance, you can just skip PostgREST and insert directly into Postgres
Xyo
08/21/2021, 5:55 PMThat way you skip the overhead of Kong + PostgREST
d
daman
08/21/2021, 5:56 PMThank you! I am not a developer but this is super helpful and going to pass it onto our team for review.