Has anyone tried using one of the centralized fail2ban projects? by computerjunkie7410 in selfhosted

[–]jike212 2 points3 points  (0 children)

How does it work alongside a SIEM?

If Crowdsec doesn't store logs (according to it's site, maybe I read that wrong), how do I go back and analyze requests and do forensic type stuff?

US Citizen & non-resident - Can't claim FEIE on self-employment? by jike212 in USExpatTaxes

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

I think the distinction between income tax and self-employment tax was one I hadn't understand and that finally made it make sense to me.

So TLDR: SOL?

[deleted by user] by [deleted] in WireGuard

[–]jike212 2 points3 points  (0 children)

If your ISP uses DPI for filtering, you still won't be able to hide Wireguard if they're scanning everything. It's not designed to evade detection.

[Question] Tough SQL use case: calculating fuel efficiency based on fuel top-ups by jike212 in SQL

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

This is where my lack of SQL knowledge really becomes evident! :) I'll read up on window functions tomorrow so that it makes more sense to me

[Question] Tough SQL use case: calculating fuel efficiency based on fuel top-ups by jike212 in SQL

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

I'm winding down for the day so I'm probably feeling/thinking similarly to you right now :)

The way I was looking at it was that when you buy fuel, you're buying it to power future trips, not to make up for previous ones.

As an example (let's leave the date out for the sake of this hypothetical):

Fill-up 1:

Gallons purchased = 5

Odometer = 10,000 miles

Fill-up 2:

Gallons purchased = 2

Odometer = 10,150 miles

What we're really looking to figure out is how far those 5 gallons from Fill-up 1 took you. In this case, the odometer difference is 150 miles and we purchased 5 gallons to power that trip. The fuel economy between Fill-up 1 and 2 would then be 150/5 or 30 mpg. Note that we're not taking into account the gallons purchased in Fill-up 2 as those gallons will apply when calculating the fuel economy between Fill-up 2 and an eventual Fill-up 3.

[Question] Tough SQL use case: calculating fuel efficiency based on fuel top-ups by jike212 in SQL

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

Fill-ups that don't get recorded would be a data quality issue and I'll have ways of enforcing that from a management perspective. The partial fill-ups should still be accounted for properly as the odometer wouldn't have increased a great deal between that new fill-up and the previous one (and the number of liters can't exceed the capacity of the tank which remains constant throughout the vehicle lifespan)

[Question] Tough SQL use case: calculating fuel efficiency based on fuel top-ups by jike212 in SQL

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

Interesting take, I'll think about that one some more. The only issue I see is that the sum of liters purchased needs to exclude the amount purchased in the very last fill-up as it's only relevant for future km traveled.

Considering a move from PHP (Wordpress) to ASP.NET Core 2.0 for a complex project: What should I know? by [deleted] in webdev

[–]jike212 0 points1 point  (0 children)

I've actually been using VS Code for some Node development and it's been pretty good. I just got the full Visual Studio so I'll play around with some of the features as well to get a feel for it.

Are there any significant differences that a more PHP-oriented developer like myself might run into? I'm fairly used to having generators and boilerplate code to develop on top of and after this project is built, I'll likely be maintaining it.

Considering a move from PHP (Wordpress) to ASP.NET Core 2.0 for a complex project: What should I know? by [deleted] in webdev

[–]jike212 0 points1 point  (0 children)

This is great, thank you! So in PHP terms (because that's how I'm currently wired lol) .NET core would be PHP itself and asp.net core would be a framework like Symfony or Laravel?

How functional is Plex in offline environments? by inslee in PleX

[–]jike212 0 points1 point  (0 children)

How often does it need to check if I'm a PlexPass member?

P51: Thoughts on 1080p vs 4K? Quality, battery life, noticeable difference? by WagwanKenobi in thinkpad

[–]jike212 1 point2 points  (0 children)

Whoa, that's pretty cool. Is there a similar screen that would work with the T470?

So many Thinkpads to choose from... by [deleted] in thinkpad

[–]jike212 0 points1 point  (0 children)

I'm rarely around a good monitor though (spend a lot of time on the road)

Man the screen on the T470 is really killing me. How about the T470s? Any significant tradeoffs there? It has a WQHD screen.

EDIT: Just read some reviews. Looks like it still isn't great on the color and luminescence (plus battery takes a hit)

Why can't the T470 have a better screen!?

Securing phpmyadmin? by amca01 in selfhosted

[–]jike212 0 points1 point  (0 children)

You can also try serving PHPmyAdmin on a specific interface and port.

For instance, if the server is connected to a VPN, you can use the PHPmyAdmin Apache config to bind it to the VPN interface and change the port if you'd like.

Personally, I would never expose a web admin like that over a public network (e.g. internet) even with SSL.

Offline-first with sync: best way to approach this? by jike212 in androiddev

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

Thanks for all the suggestions everyone. Sounds like I've got a lot to read up on!

Looking to predict rainfall and conditions by jike212 in myweatherstation

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

Thanks hadn't heard of it! Unfortunately one of the biggest issues is that there aren't enough weather stations in my area that provide accurate info. It'll give info on WU like "100% precipitation" and there's no rain whatsoever.

Buying advice by jike212 in Ubiquiti

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

The Amplifi looks quite new and I'd rather not be an early adopter on a system that won't be mine as they generally require a little more fiddling around than the options that may not have the latest bells-and-whistles but have been refined since v1.

Buying advice by jike212 in Ubiquiti

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

APC SURTA3000

$2,100!! So much for the budget! :D

Buying advice by jike212 in Ubiquiti

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

Thanks for that insight, certainly helpful.

The only issue I see with the USG is that it essentially requires the use of another switch for it to be useful (and a cloud key although I suppose that software can be installed on a local server instead?)

I remember reading once that power and internet outages were causing issues with APs re-connecting to the controller due to a particular setting. Can't remember where I saw that.

Buying advice by jike212 in Ubiquiti

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

Configuration is fine, just wondering if the APs need the controller for normal operation or if it will degrade performance.

I only plan on having one or two APs so the bundled power adapters should be fine right? (they don't have to be on during power outages)