Fakercel

u/Fakercel




r/SwitchPirates•

Just my luck I got into switch pirating today and foolishly updated the latest system version before I went through the process of creating backup. So it's on 21.0.0 and atmosphere only works with 20.5

Now I'm stuck on the new version and have to wait out the new atmosphere version before I can continue.

How long does it normally take? Would it be worth trying to downgrade my firmware manually?

19

r/Supabase•

Hey so I've recently included a new feature in my webapp which does intensive geometric calculations in my rpc functions. These functions occasionally time-out due to hitting limits. And when they do, the rest of my supabase calls seem to get throttled for a while.

My app goes from running smoothly, to users not being able to use any of the server functions like logging in, or accessing data.

https://preview.redd.it/pe5duhhndlvf1.png?width=2095&format=png&auto=webp&s=a3123bd8c99ef74bc52be2038b5221ff5a114f32

Here's a picture of after getting throttled running a function that times out due to the load.

My errors range from 502s, 503s, 521s, 522s, 525s etc. But basically timeouts, or server

33

r/mapbox•

I recently updated my mapbox project from 1.x to 3.x, and everything went smoothly except for the way mapbox renders my stacking lines.

Overlapping lines used to be obvious in the old version of mapbox where overlapping sections would reduce their opacity so you could see where it overlaps.

In the new version a fixed opacity value is applied to everything in the layer.

Example provided below, the 2nd version is how it used to work which was good for me. And now it works like the 3rd version making no distinction in overlaps.

https://preview.redd.it/vmpqde4oopjf1.png?width=642&format=png&auto=webp&s=ddecd6b3c88ed07c0191ea106e07e24f53d98001

https://preview.redd.it/fqkig9vuopjf1.jpg?width=

12

r/mapbox•

Hey guys I've built a farming mapping a tracking service over the last 2 years, and one of our most regular complaints is that the satellite data for regional areas in Australia is just too old. Anywhere from 6-10 years in some cases.

I'm looking for some advice on sourcing more up to date satellite maps I could easily integrate into mapbox and how you would go about doing it.

Any advice would be much appreciated! Cheers.

32

r/Poe_AI•

I enjoy using poe, because it puts all of the work on the browser and is usually the fastest snappiest ui to use for llms.

But today every question I ask, even with low context, goes between your request is failing. And then starts answering me afterwards.

And all medium to higher level context questions which it used to handle with ease are failing.

I've never had as many issues using it compared to today, maybe they added a bunch of limits to save on resources.

10

r/Supabase•

Hey guys, I'm encountering a weird issue with my supabase project.

I track a bunch of farming vehicles live on a map. They all broadcast their locations to each other and listen to locations via realtime.

They also occasionally post updates or inserts to their historical and current locations for persistence.

So the issue I am having is where the same user will be able to, update their vehicle state / historical coordinates via supabase insert just fine.

But the live broadcast location keeps returning 401.

https://preview.redd.it/lo3zwg33l72e1.png?width=1082&format=png&auto=webp&s=4305292b863243165e45f3aaa44ffb7226d6eea3

This is leading to some weird behaviour in my program. Wher

32

r/Supabase•

Hello guys as it says in the title, I'm having a problem with my auth token refresh requests.

https://preview.redd.it/wrpcw883w61e1.png?width=1712&format=png&auto=webp&s=a160ad1406546c6158a7af5c0a024f9d6da8409e

You can see, the auth requests is way above my rest or real-time requests which is the actual data my website is using.

https://preview.redd.it/a4wzjwvbw61e1.png?width=1318&format=png&auto=webp&s=09674fdbf6b6b2d449725f6923f8ba6f178ec206

All of the request are token refresh requests which hit the rate limit.

I'm having hard time figuring out exactly what is causing the token refresh spam.

But my best guess is that I have users uploading their location to the database very quickly

60

r/PostgreSQL•

Hello I am building an application using supabase which stores a bunch of coordinate data from farmers.

As they are driving around the field anywhere from 1-15 farmers, could be recorded 1 datapoint per second.

Even on moderately busy farms with like 4-5 farmers, these data-points add up really quickly potentially up to millions of points of coordinates.

I store them all in one table called trail_data, and run queries to select all of the coordinates that are associated with a particular farmers map.

trail_data table

My problem is that now running get queries on this

839

r/Supabase•

https://preview.redd.it/znretklropqd1.png?width=1792&format=png&auto=webp&s=7305c69b0761921d396c0a4f5cb8efb23970a3b5

I am running a realtime farming fleet management service using supabase.

Today I had 4-5 out in the field they all send around 1 real-time gps update per second which amounts to around 3 realtime calls throughout the database per second per user.

This load was causing some problems with the server and it seemed to be crashing.

I'm trying to investigate the source, but don't really know where to start. I checked Response error reports, and looking at the invoked requests I see tonne of refresh token requests, like far more than 1 per second Real time updates.

Is it nor

620

r/Supabase•

https://preview.redd.it/56oza241ckkd1.png?width=2059&format=png&auto=webp&s=4134836ee753f1253d87989849782b5f74ec65bd

Starting today all day, my authentications have been getting spammed constantly multiple times per second by a single user activating auth requests through a refresh token or something.

It's always the same ip. I am wondering how I can block this user or ip?

Status429

MethodPOST

Timestamp2024-08-24T07:16:48.129

ZIP

Address: 49.192.209.252

Origin

CountryAU

Client@supabase/[email protected]

I've gone into api and restricted this ip: 49.192.209.252

but it doesn't seem to have done anything, maybe be

714

r/PWA•

https://preview.redd.it/bv5oethxq8ad1.jpg?width=720&format=pjpg&auto=webp&s=2ba3a801578c771626e218ebcc5d10eb83d1af68

Hey Guys I've recently switched from cloudflair pages hosting to vercel, so that I can make use of the web-push library.

However I've noticed that unless I have the PWA installed from *.vercel.app the notifications don't appear as 'true' notifications and instead as chrome notifications.

My source website is skanfarming.com.au which is where people install the PWA from, however for some reason all the notifications are being sent through from the vercel hosted page.

I underlined the source in the image, does anyone know how I could manually se

20

r/PWA•

Hey guys, this might be a dumb question, but wondering how you handle having your marketing page as your landing page for PWA. Vs having the dashboard which returning users will primarily be interacting with.

I'd like for the marketing page to prompt people to install the app, but after they've installed the app it should open with login / dashboard as the default.

14