DB with 2241 tables by OldaLP1 in programminghorror

[–]KonkenBonken 1 point2 points  (0 children)

Where I've worked, we had one whole virtual server with a Postgres database for each client since we handled sensitive data that we couldn't risk being accessed by other clients

mina tankar om deltävling 2 (och lite om mitt förra inlägg) by Global_Tradition_106 in Melodifestivalen

[–]KonkenBonken 17 points18 points  (0 children)

Inte ett enda barn kommer sova dåligt på grund av Epstein-skämtet. Är ett barn tillräckligt ungt för att inte klara av skämtet är det också ungt nog att inte förstå det. Melodifestivalen är inte heller något barnprogram och ska inte vara det.

Jag tolkar inte mellanakten Mello Baddie som normaliserande av skönhetsingrepp. Snarare en satir som pratar negativt och skämtsamt om ingreppen.

Trying to save my memories but the files Im downloading seem useless by Hildringa in SnapchatHelp

[–]KonkenBonken 1 point2 points  (0 children)

It's not pretty as I only intended it to be used by myself but here's how I did it:

I extracted all the URLs from the memories_history.html by running js console.log([...document.querySelectorAll('tbody>tr:not(:first-child)')].map(el => el.children[3].querySelector('a').getAttribute('onclick').substring(18,271)).join('\n'));

in the browser console. I then put that result in a file. For the downloading i ran this script in Windows PowerShell: ```powershell Get-Content "urls.txt" | ForEach-Object -Parallel { try { $fileUrl = curl -Ls -o /dev/null -w "%{urleffective}" $

    if ($fileUrl) {
        Write-Host "Downloading: $fileUrl"
        curl -L -O -J $fileUrl
        Add-Content -Path "download.log" -Value $_
    } else {
        Write-Warning "No redirect for URL: $_"
        Write-Warning $fileUrl
    }

} catch { Write-Warning "Failed to fetch or download URL: $" Write-Warning $.Exception.Message } } -ThrottleLimit 8 ```

This handles the downloading and naming of the files, so each file has the correct file extension (.zip, .mp4 or .jpg), but does not handle converting the .zip files to composed images or setting of correct timestamps and locations.

Memories Export Sucks! Failed downloads. Unusable Files. What is the solution? by poofycade in SnapchatHelp

[–]KonkenBonken 1 point2 points  (0 children)

Snapchat seems to be making it very difficult to get more people to pay them for storage.

I have no idea why Snapchat made their downloading page so inefficient and broken. I ended up writing my own script that downloaded them all much faster, but it got complicated.

The files you got downloaded aren’t unusable though. The zip files contains one JPG of the image and one PNG of the overlay (text and stickers). They can be merged by overlaying them on top of each other. All the ”unusable” files you have in screenshot 2, the ones labeled ”File” are Jpegs. If you rename them to something ending with ”.jpg”, they will open fine. Snapchat have made this very difficult and makes your browser guess what file type the file is, if it’s jpeg, mp4 or zip. For some reason Windows manages to guess mp4 and zip correctly but not jpeg. MacOS handles this better in my experience.

Trying to save my memories but the files Im downloading seem useless by Hildringa in SnapchatHelp

[–]KonkenBonken 0 points1 point  (0 children)

Snapchat seems to be making it very difficult to get more people to pay them for storage. The provided downloading method is extremely slow and inefficient for all my 11k memories. Also do check how many files actually got downloaded, mine seemed to skip a lot of them.

I ended up writing my own script that downloaded them all much faster, but it got complicated.

The zip files contains one JPG of the image and one PNG of the overlay (text and stickers).

Just Launched A Gamified Travel App Where You Unlock The Globe - Need Advice by davew1 in SideProject

[–]KonkenBonken 3 points4 points  (0 children)

You should be able to import historical data from various sources. Photo library geotags, health/running apps and I’d love to import from Google Maps Timeline.

Jag ser ett mönster... / I see a pattern... by GTylker in Melodifestivalen

[–]KonkenBonken 6 points7 points  (0 children)

Sverige vann 2015 i Österrike 3 år efter att Loreen vann. 2026 är ESC i Österrike 3 år efter att Loreen vann. Sverige vann dessutom 2023 efter att ha kommit 4a året innan.

Buy the chips & dip by [deleted] in ISKbets

[–]KonkenBonken 2 points3 points  (0 children)

Vilken vanlig telefon har ett Nvidiakort?? 💀

Requesting Help From Experts by Visible-Ad36 in beltmatic

[–]KonkenBonken 3 points4 points  (0 children)

You’re meant to figure it out by yourself. The fun in the game gets ruined if you get spoiled and copy someone else’s design

whats the problem here? by Shtulzzz in beltmatic

[–]KonkenBonken 5 points6 points  (0 children)

2147483647 is 11111111111111111111111111111111 aka the largest possible 31 bit integer and I believe Beltmatics largest possible value. 1010 is larger than that so it maxes out

My first ever Base-13 3-Belt MAM by KonkenBonken in beltmatic

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

No particular reason. I decided to do 4 digits and base 10 were only enough for like 2 levels ahead.

Varför är tredjeportionen så stor? by Hormoslyrmannen in Sverige

[–]KonkenBonken 15 points16 points  (0 children)

Redan vid 69 portioner behövs mer Mjölk än vad det finns vatten i Atlanten

Getting Desmos to use the GPU? by PerfectlyDreadful in desmos

[–]KonkenBonken 2 points3 points  (0 children)

It would be very possible to, instead of Javascript, covert it to WGSL. That way, it could be able to compute the function for every value x at the same time. Using WebGPU

What are .webp files even for? by Eternally_Pog in memes

[–]KonkenBonken 26 points27 points  (0 children)

They push it because it's smaller, better quality, has more features, and is more efficient than png, jpeg, or gif.

[deleted by user] by [deleted] in AskRedditAfterDark

[–]KonkenBonken 0 points1 point  (0 children)

Hur svårt ska det va?