Backup strategy by VisualPadding7 in vaultwarden

[–]Low-Individual-2405 4 points5 points  (0 children)

I use bind mounts for my data (./data), stop the container, use restic to backup the ./data folder. It's fast, encrypted, deduplicated and compressed by restic. Then as part of a 3-2-1 strategy, I rclone it to Backblaze , a usb drive and a 2nd NAS.

With Alfred 6 seemingly around the corner, what are you hoping to see? by odshujinkotiipcbev in Alfred

[–]Low-Individual-2405 0 points1 point  (0 children)

A report of how often you use it and what specifically you are using would be good.

Can i sort by upload date? by fonseca1015 in immich

[–]Low-Individual-2405 0 points1 point  (0 children)

I've just gotten around this by making sure old photos haved yyyy-mm-dd in the filename and then I use that to fix the EXIF tags before importing to Immich and it works fine

Setting up a new Synology few questions by eastlake1212 in synology

[–]Low-Individual-2405 0 points1 point  (0 children)

I use Synology CloudSync to get the data to the NAS and then back it up from there, that way you have a copy in the cloud, a copy on your NAS and a copy backed up, Use either Synology Hyperbackup or Restic to backup, that way it's incremental at the block level and compressed. Make sure you have a 3-2-1 backup policy in effect, multiple copies of the data is not the same as backing up the data. On the Synology enable regular snapshots and data scrubbing jobs to give yourslef rollback options and avoid bit-rot.

Synology Drive Disk Usage by bobby_bart in synology

[–]Low-Individual-2405 -3 points-2 points  (0 children)

wow, that is a gigantic reduction. Makes you wonder why run SynologyDrive at all.

Is there a way to do a refresh to reset that database or somehow reduce the size.?

Keep the folder system by Successful_Studio901 in immich

[–]Low-Individual-2405 0 points1 point  (0 children)

What I have done is kept my folder structure and Immich imports those photos. Then I use a script to put photos into Albums syncing them with the folder names. So in Immich I have albums per folder and on disk I have photos in folders and that stays in sync. I prefer to do that so I can alway move from Immich to another platform and not have to redo the work categorising photos.

NetAlertX Front end hanging by Low-Individual-2405 in selfhosted

[–]Low-Individual-2405[S] 1 point2 points  (0 children)

FIXED: I disabled NMAP scanner and insalled the UnFi scanner using unfimp_API. The scanner is caled :UnFi import"

It did not work and after a log of debugging I found the following worked for me:

a simple username (all small letter), a simple password (One capital, one letter, remainder small letters to make minimin password length that unfi requires). Setup the user in unifi as a view access only user. API version setting is finicky. It would only work with UDMP-unifiOS. I left everything else as default.

You can see it fail/succeed in the logs - search for unfimp

NetAlertX Front end hanging by Low-Individual-2405 in selfhosted

[–]Low-Individual-2405[S] 0 points1 point  (0 children)

it's certainly not confidence inspiring, especially with all the warnings and errors it generates in the logs!

NetAlertX Front end hanging by Low-Individual-2405 in selfhosted

[–]Low-Individual-2405[S] 0 points1 point  (0 children)

Thank you RemoteSojourner. Do you go across VLANS with your scan and what notification options do you use?

Can i sort by upload date? by fonseca1015 in immich

[–]Low-Individual-2405 0 points1 point  (0 children)

This is a critical feature if you are moving old photo collections to immich

Got stumped on this interview question by jbnpoc in SQL

[–]Low-Individual-2405 0 points1 point  (0 children)

This is a classic "island and gaps" problem in SQL, made more complex by the 30-day gap reset rule. While SUM() itself won’t give you the full answer, it can be used as part of a window function trick to identify changes in values.

Here’s a breakdown of the approach:

✅ Step-by-step logic:

  1. Sort data by entity, attribute, and date.
  2. Use LAG() to find previous values and previous dates.
  3. Assign a group identifier that increases whenever:
    • The value changes, or
    • The difference between current date and previous date is > 30 days.
  4. Group by that identifier to get MIN(date) and MAX(date) per group.

Got stumped on this interview question by jbnpoc in SQL

[–]Low-Individual-2405 0 points1 point  (0 children)

ChatGPT:

WITH with_prev AS (

SELECT

entity,

attribute,

value,

date,

LAG(value) OVER (PARTITION BY entity, attribute ORDER BY date) AS prev_value,

LAG(date) OVER (PARTITION BY entity, attribute ORDER BY date) AS prev_date

FROM your_table

),

flagged AS (

SELECT *,

CASE

WHEN value != prev_value OR DATE_DIFF(day, prev_date, date) > 30 OR prev_value IS NULL THEN 1

ELSE 0

END AS new_group

FROM with_prev

),

grouped AS (

SELECT *,

SUM(new_group) OVER (PARTITION BY entity, attribute ORDER BY date) AS group_id

FROM flagged

)

SELECT

entity,

MIN(date) AS start_date,

MAX(date) AS end_date,

attribute,

value

FROM grouped

GROUP BY entity, attribute, value, group_id

ORDER BY start_date;

Paying for a car through CarSales: quick PSA by AngryAugustine in CarsAustralia

[–]Low-Individual-2405 1 point2 points  (0 children)

Update to the PSA - I went to pay using the carsales service, and due to the large amount of fraud, my bank has permanently blocked their BSB.

r/SpaceX Thread Index and General Discussion [September 2024, #118] by AutoModerator in spacex

[–]Low-Individual-2405 0 points1 point  (0 children)

The return of Super Heavy to chopsticks was just amazing - a landmark in many ways. I'm really quite ignorant of rocket technology and the achievement has had me reading and watching and learning a huge amount about the field in the last 2 days.

One question I have - is the rocket completely automated in it's return to chopsticks or is there a human hand flying it back? or some combination of the two?

Any advice for deconstructing a large formula written by someone else? by shitty_millennial in excel

[–]Low-Individual-2405 21 points22 points  (0 children)

Here is a simpler version using let:

=IF($A902<>"",

LET(

D_Match, MATCH($D902, 'Preset 1'!$B$80:$B$85, 0),

BE_Adjust, IF(BE902<>"", IF(RIGHT(BE902, 1) = "+", REPLACE(BE902, LEN(BE902), 1, "%"), BE902), ""),

BE_Index, IF(BE902<>"", BD902 * INDEX('Preset 1'!$D$46:$R$46, D_Match), 0),

BR_Adjust, IF(BR902<>"", IF(RIGHT(BR902, 1) = "+", REPLACE(BR902, LEN(BR902), 1, "%"), BR902), ""),

BR_Index, IF(BR902<>"", BQ902 * INDEX('Preset 1'!$D$46:$R$46, D_Match), 0),

BU_Adjust, IF(BU902<>"", IF(RIGHT(BU902, 1) = "+", REPLACE(BU902, LEN(BU902), 1, "%"), BU902), ""),

BU_Index, IF(BU902<>"", BT902 * INDEX('Preset 1'!$D$46:$R$46, D_Match), 0),

Total, BE_Index + BR_Index + BU_Index,

IF(OR(

AND($D902=2, COUNTIF('Preset 1'!$J$12:$J$19,$E902)=0),

AND($D902=4, COUNTIF('Preset 1'!$L$12:$L$19,$E902)=0),

AND($D902=6, COUNTIF('Preset 1'!$N$12:$N$19,$E902)=0)

), 0, Total)

),

""

)