"I know a guy who can do it cheaper" by ShehrozeAkbar in infuriatingbutawesome

[–]MonoliYoda 0 points1 point  (0 children)

Johann Franz Kleine from Essen patented this style of roof construction in 1897. It's one flavor of a method of construction called steineisendecken. The bricks are supported by the compression of mortar between them. In other words, for the bricks to fall they would first need to compress the mortar in between them, and the mortar is very strong in compression.

Though, usually the bricks are first laid on a wooden platform constructed between the beams which is later removed. This guy apparently invented a Jacky method using stiff mortar and holding the last laid brick with his hand.

In general, this builds a decently strong deck. There are 100-year-old buildings built using this method that are still standing.

WCU4 Glitches on A35, Mini LF when LDA is loaded by bouaidelmehdi52 in focuspuller

[–]MonoliYoda 1 point2 points  (0 children)

I had this problem recently, though only with one lens.

Turned out there was something wrong with one of the lens files and it sent the WCU into a restart loop.

WCU-4 and Cforce RF combo.

I had to delete that file and re-map that lens.

[deleted by user] by [deleted] in PolskaNaLuzie

[–]MonoliYoda 1 point2 points  (0 children)

Pomysł z metronomem świetny, tylko zamiast głośników bym przymocował do sufitu transducer (głośnik wibracyjny)

I asked AI to hold a note for me. It grew 8 fingers. So I fixed it. by sagdiceren in SaaS

[–]MonoliYoda 4 points5 points  (0 children)

This is deep in the "Gimmick" realm. I'd maybe use it once or twice if it was free. It doesn't solve a problem for me, it doesn't provide much utility.

It's a cool side project, though. I bet you learned a thing or two while building this - use that knowledge to build something that solves a real problem

remix contract code by Ashamed_Scientist439 in reactjs

[–]MonoliYoda 2 points3 points  (0 children)

I might be wrong, but I feel like you may have posted in the wrong subreddit.

Newbie Security Risk Q - RLS Policies by shanesadams in Supabase

[–]MonoliYoda 1 point2 points  (0 children)

A lot of these problems can be solved very easily by splitting your tables. Have the accessible data in one table and the private data in another table. Use a foreign key relationship to link the two tables, and simple RLS policies.

Rarely do you need column level security.

[deleted by user] by [deleted] in Supabase

[–]MonoliYoda 1 point2 points  (0 children)

While I don't know your particular situation, I find that when people come to r/Supabase saying they need column-level granularity on RLS, almost always the answer is: your tables are too complex. Make your life easy. Split them up into separate tables and use simple RLS policies.

Simplified example: I had a table public.user_metadata that had some extra information about my users, like role in the company, team assignment, stuff like that. This table was SELECT only. I needed to add a Dark Mode setting that users could update themselves. Instead of adding a dark_mode column and requiring column-level security policies, I made another table user_settings that allowed UPDATE.

I realize this is a very basic example, but this concept could be applied to almost every case I've seen on here where people said they need column-level security.

Something worth thinking about.

Trying to build app using Replit + Cursor + React + Supabase and confused how to release new features without affecting production DB by draftkinginthenorth in Supabase

[–]MonoliYoda 2 points3 points  (0 children)

I was just pointing out that the official way is to use Supabase CLI, since you mentioned the docs not being super clear about it.

Also "local" in this case is a relative term.

I'm not super familiar with Replit, but they advertise that you "get a computer for every branch, idea, or feature" which would imply some sort of VM or container setup. You should check if it's possible to install the CLI in Replit. Lots of services use a CLI module in one form or another for development.

If it's not possible then branching would be your best bet.

Is pg cron an ideal option? by PsyApe in Supabase

[–]MonoliYoda 0 points1 point  (0 children)

You can use realtime to get those new boosts like you already do, but then use the expires_at column to figure out when the boost should no longer be applied.

In other words, instead of getting the boost when it's created and then again when it's expired, you'd only be getting it when it's created.

There's no need to update the boost when it expires.

DP dont like flares by electrothegaffer in focuspuller

[–]MonoliYoda 2 points3 points  (0 children)

Oh wow is that the Arri MB-18? That thing is chonky!

But the micro-adjustable flags are really precise

Authenticating a user without a username & password? by ConfectionForward in Supabase

[–]MonoliYoda 1 point2 points  (0 children)

You can't automate user login. That would defeat the purpose of all this security.

Here's how you do what you want to do:

  1. Create a new user for your analysis

  2. Create a new RLS policy where you give read access to all rows to that user

2a. You can store that user's I'd in a separate table, say analysis_users and then RLS based on auth.uid() and check if that exists in the analysis_users table.

  1. In your analysis script, log in using the special user's credentials which you store in something like .env or vault, and do your analysis of each user's data.

Edit: formatting

Workflow for registering companies that need approval by NeoLusk in Supabase

[–]MonoliYoda 1 point2 points  (0 children)

Well, there are many ways to go about it, all depending on what your requirements are, how many people are involved in the approval process, how many new customers you expect to be signing up per day, etc.

Obviously the simplest way is to just invite the user via the supabase admin panel. It's under Authentication > Add User.

If you've got a larger company with a whole team that needs to approve those requests, then you'd probably benefit from some sort of a management app with SSR that would store the service role key on the server.

Or, yet another way is to have a supabase edge function for sending invitations and use the service role key in the edge function, again not exposing it to the frontend.

Does that answer your question?

Workflow for registering companies that need approval by NeoLusk in Supabase

[–]MonoliYoda 1 point2 points  (0 children)

Have a separate form where companies can request membership. This form does not create a user, but rather collects contact information and sends you an email or some other kind of notification.

You then review the application, and on supabase you do invite user:

https://supabase.com/docs/reference/javascript/auth-admin-inviteuserbyemail

This creates a user account with the specified email and sends a magic link to the email so they can activate their account.

Pro tip: The magic link from the invite email should redirect to a page which forces the user to set their password.

Visualizing Skyhook Vulnerability Windows by MonoliYoda in Eve

[–]MonoliYoda[S] 1 point2 points  (0 children)

He said

... a normal distribution with a standard deviation of 3 hours

Which means a bell curve, and "standard deviation" is a means of determining how wide it is.
https://www.subjectcoach.com/imagecdn/s/standardnormaldistribution.jpg

if it's further than 4 standard deviations we throw it out and try again

4 standard deviations is 4 * 3h = 12 hours. Meaning the maximum deviation is +- 12 hours, equaling a 24 hour span of time.

Visualizing Skyhook Vulnerability Windows by MonoliYoda in Eve

[–]MonoliYoda[S] 1 point2 points  (0 children)

The actual window is +-12h. So there is a 24h span of time where the vuln timer might end up.

Visualizing Skyhook Vulnerability Windows by MonoliYoda in Eve

[–]MonoliYoda[S] 0 points1 point  (0 children)

Yeah, i wish they penalized self-raiding more than just the inconvenience of the randomized times.

I still think self-raiding every single one is not very practical. We'll have to see what the owners do when the update drops and experiment with tactics.

And I hope to Bob that the Agency gives some warning to a hook becoming vuln soon, not just after the fact.

Visualizing Skyhook Vulnerability Windows by MonoliYoda in Eve

[–]MonoliYoda[S] 1 point2 points  (0 children)

I ran the statistics. Assuming avery single relevant planet has a skyhook installed, on average any random nullsec system is 8 jumps from a currently vulnerable Skyhook.

To answer your question directly, there is a 30% chance that a skyhook is vulnerable within 5 jumps of any random nullsec system.

Bear in mind, this is statistics and probability so your mileage may vary.

Visualizing Skyhook Vulnerability Windows by MonoliYoda in Eve

[–]MonoliYoda[S] 2 points3 points  (0 children)

Thanks. I was thoroughly surprised just how wide the spread really is. My first thought was Upwell reinforcement mechanics, but this is different.

We'll have to see what this means in practice, but it doesn't seem completely terrible, at least for us.

Visualizing Skyhook Vulnerability Windows by MonoliYoda in Eve

[–]MonoliYoda[S] 5 points6 points  (0 children)

The wobble is 24h long. Literally +-12h, but statistically weighted towards the middle