DEV Community

Super Funicular profile picture

Super Funicular

superfunicular.com

Joined Joined on 
I Copied a Live SQLite Database and the Copy Had No Tables: WAL Mode Keeps Commits in a Second File
superfunicular profile

I Copied a Live SQLite Database and the Copy Had No Tables: WAL Mode Keeps Commits in a Second File

#sqlite #python #database #backup
Comments
10 min read

Want to connect with Super Funicular?

Create an account to connect with Super Funicular. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Why Does My Phone Security Camera Video Look Smeary at Night? Noise Reduction, Edge Sharpening, and What Actually Helps
superfunicular profile

Why Does My Phone Security Camera Video Look Smeary at Night? Noise Reduction, Edge Sharpening, and What Actually Helps

#android #camera #privacy #security
Comments
8 min read
#!/usr/bin/env python3 -u Worked Under python3 and Failed as ./prune.py: What Linux Does With a Shebang Line
superfunicular profile

#!/usr/bin/env python3 -u Worked Under python3 and Failed as ./prune.py: What Linux Does With a Shebang Line

#bash #linux #python #debugging
Comments
8 min read
rm *.mp4 Said Argument list too long and Deleted Nothing: What execve Counts That the Shell Does Not
superfunicular profile

rm *.mp4 Said Argument list too long and Deleted Nothing: What execve Counts That the Shell Does Not

#bash #linux #debugging #tutorial
1
Comments 1
8 min read
Why Does My Phone Security Camera Show Less of the Room? Video Stabilization Crops the Edges, and a Fixed Camera Doesn't Need It
superfunicular profile

Why Does My Phone Security Camera Show Less of the Room? Video Stabilization Crops the Edges, and a Fixed Camera Doesn't Need It

#android #camera #privacy #security
Comments
8 min read
Rewriting a JSON File in Place Let My Reader See It Half-Written: Temp File, fsync, os.replace and Three Traps
superfunicular profile

Rewriting a JSON File in Place Let My Reader See It Half-Written: Temp File, fsync, os.replace and Three Traps

#python #linux #debugging #tutorial
Comments
9 min read
Two Files Named café.mp4 in One Folder: How Unicode Normalization Defeats a Copy Script's Skip Check
superfunicular profile

Two Files Named café.mp4 in One Folder: How Unicode Normalization Defeats a Copy Script's Skip Check

#python #unicode #linux #debugging
Comments
9 min read
How to Check an Old Phone's Battery Before Using It as a Security Camera: Your Backup in a Power Cut, No App to Buy
superfunicular profile

How to Check an Old Phone's Battery Before Using It as a Security Camera: Your Backup in a Power Cut, No App to Buy

#android #security #privacy #beginners
Comments
8 min read
SQLite Ignored My ON DELETE CASCADE: Foreign Keys Are Off Until Each Connection Turns Them On
superfunicular profile

SQLite Ignored My ON DELETE CASCADE: Foreign Keys Are Off Until Each Connection Turns Them On

#sqlite #python #database #debugging
Comments
8 min read
Why Does an ffmpeg Contact Sheet Skip the Person in a Camera Clip? What thumbnail and fps Each Pick
superfunicular profile

Why Does an ffmpeg Contact Sheet Skip the Person in a Camera Clip? What thumbnail and fps Each Pick

#ffmpeg #linux #bash #tutorial
Comments
10 min read
Your Camera Phone Gets No Annual Notice of Change: A Once-a-Year Review for a Phone Nobody Opens
superfunicular profile

Your Camera Phone Gets No Annual Notice of Change: A Once-a-Year Review for a Phone Nobody Opens

#android #privacy #mobile #security
Comments
4 min read
Should You Turn On Developer Options to Keep an Old Phone Security Camera Recording With the Screen Off? Six Settings Checked Against Android's Docs
superfunicular profile

Should You Turn On Developer Options to Keep an Old Phone Security Camera Recording With the Screen Off? Six Settings Checked Against Android's Docs

#android #privacy #security #mobile
Comments
9 min read
rm Freed Nothing and df Stayed Full: Finding the Process Still Holding a Deleted Camera Clip
superfunicular profile

rm Freed Nothing and df Stayed Full: Finding the Process Still Holding a Deleted Camera Clip

#linux #bash #tutorial #devops
Comments
9 min read
Two Files 100 Nanoseconds Apart Got the Same Timestamp in the Browser: JSON.parse and Integers Past MAX_SAFE_INTEGER
superfunicular profile

Two Files 100 Nanoseconds Apart Got the Same Timestamp in the Browser: JSON.parse and Integers Past MAX_SAFE_INTEGER

#javascript #json #node #python
Comments
8 min read
Will an Old 3G Phone Work as a Security Camera on Mobile Data? What the E, H and 4G Icons Mean for Offline and Low-Data Setups
superfunicular profile

Will an Old 3G Phone Work as a Security Camera on Mobile Data? What the E, H and 4G Icons Mean for Offline and Low-Data Setups

#android #privacy #security #mobile
Comments
8 min read
flock on a Cron Copy Job: A Background Helper Kept the Lock After the Script Exited
superfunicular profile

flock on a Cron Copy Job: A Background Helper Kept the Lock After the Script Exited

#linux #bash #tutorial #devops
Comments
9 min read
Does Data Saver Cut Off a Phone Security Camera Streaming on Mobile Data With the Screen Off? What Android's Source Checks
superfunicular profile

Does Data Saver Cut Off a Phone Security Camera Streaming on Mobile Data With the Screen Off? What Android's Source Checks

#android #privacy #mobile #kotlin
Comments
9 min read
rsync --delete Emptied the Backup and Exited 0: Testing a Nightly Copy of Camera Clips
superfunicular profile

rsync --delete Emptied the Backup and Exited 0: Testing a Nightly Copy of Camera Clips

#linux #bash #tutorial #backup
Comments
9 min read
Why Did ls Sort clip_10 Before clip_1? Three Orders for One Folder of Numbered Clips
superfunicular profile

Why Did ls Sort clip_10 Before clip_1? Three Orders for One Folder of Numbered Clips

#linux #bash #python #tutorial
Comments
8 min read
Should You Format the SD Card as Internal Storage on an Old Phone Security Camera? What Adoptable Storage Does to Your Recordings
superfunicular profile

Should You Format the SD Card as Internal Storage on an Old Phone Security Camera? What Adoptable Storage Does to Your Recordings

#android #privacy #security #mobile
Comments
9 min read
ffmpeg's silencedetect Found Nothing at -40 dB: Finding the Noises in a Long Recording
superfunicular profile

ffmpeg's silencedetect Found Nothing at -40 dB: Finding the Noises in a Long Recording

#ffmpeg #audio #linux #tutorial
Comments
10 min read
find -mtime +7 Keeps Eight Days: Testing a Cleanup Job for a Folder of Camera Clips Before It Deletes
superfunicular profile

find -mtime +7 Keeps Eight Days: Testing a Cleanup Job for a Folder of Camera Clips Before It Deletes

#linux #bash #tutorial #shell
Comments
9 min read
Why Does My Phone Security Camera Show Dark Rolling Bands Under Tube Lights? 50 Hz Power, Android's Anti-Banding Setting, and What Actually Fixes It
superfunicular profile

Why Does My Phone Security Camera Show Dark Rolling Bands Under Tube Lights? 50 Hz Power, Android's Anti-Banding Setting, and What Actually Fixes It

#android #camera #kotlin #security
Comments
9 min read
ffmpeg's segment_time Is Not a Length: Splitting a Long Recording Into Pieces Without Losing Footage
superfunicular profile

ffmpeg's segment_time Is Not a Length: Splitting a Long Recording Into Pieces Without Losing Footage

#ffmpeg #video #linux #tutorial
Comments
9 min read
Three ffmpeg Filters Looked for a Person Crossing a Still Camera's View. One Found Them
superfunicular profile

Three ffmpeg Filters Looked for a Person Crossing a Still Camera's View. One Found Them

#ffmpeg #video #python #security
Comments
9 min read
What If Someone Steals the Phone That Is Your Shop Camera? Android's New Theft Locks Mostly Skip It. Here Is What Still Works
superfunicular profile

What If Someone Steals the Phone That Is Your Shop Camera? Android's New Theft Locks Mostly Skip It. Here Is What Still Works

#android #security #privacy #beginners
Comments
9 min read
Buying a Second-Hand Android Phone to Use as a Shop Security Camera? Four Checks to Do at the Counter Before You Pay
superfunicular profile

Buying a Second-Hand Android Phone to Use as a Shop Security Camera? Four Checks to Do at the Counter Before You Pay

#android #privacy #security #beginners
Comments
8 min read
If Nothing on the Camera Listens, Something Else Has To: Outbound-Only vs. a Local Viewer, and Where the Trust Moves
superfunicular profile

If Nothing on the Camera Listens, Something Else Has To: Outbound-Only vs. a Local Viewer, and Where the Trust Moves

#networking #security #iot #android
Comments
7 min read
What Happens to a Phone's YouTube Live Stream When Mobile Data Drops? enableAutoStop, Stream Health, and the One-Minute Window
superfunicular profile

What Happens to a Phone's YouTube Live Stream When Mobile Data Drops? enableAutoStop, Stream Health, and the One-Minute Window

#android #youtube #streaming #mobile
Comments
9 min read
The Camera-Trap Data Standard Starts With When the Camera Was Running, Not What It Saw
superfunicular profile

The Camera-Trap Data Standard Starts With When the Camera Was Running, Not What It Saw

#android #python #opendata #wildlife
Comments 1
8 min read
Re-Muxing a Phone Video With ffmpeg Kept Where It Was Shot and Dropped When
superfunicular profile

Re-Muxing a Phone Video With ffmpeg Kept Where It Was Shot and Dropped When

#ffmpeg #privacy #android #video
Comments
7 min read
The National Archives Will Take Phone Video as a Permanent Record. Its List Names the Codec, Not the File Extension
superfunicular profile

The National Archives Will Take Phone Video as a Permanent Record. Its List Names the Codec, Not the File Extension

#android #video #ffmpeg #archiving
1
Comments 1
7 min read
California Wrote a Windshield Exemption for Dashcams, and a Phone That Records the Whole Drive Does Not Fit Its Definition
superfunicular profile

California Wrote a Windshield Exemption for Dashcams, and a Phone That Records the Whole Drive Does Not Fit Its Definition

#android #dashcam #privacy #law
Comments
8 min read
Is My Phone Security Camera Exposed to the Internet on IPv6? A Local-Only, No-Cloud Check for Jio and Other IPv6 Networks
superfunicular profile

Is My Phone Security Camera Exposed to the Internet on IPv6? A Local-Only, No-Cloud Check for Jio and Other IPv6 Networks

#android #ipv6 #security #privacy
5
Comments 5
10 min read
Your Camera Phone Asks for Its Address Back Every Few Hours. Here Is the Conversation.
superfunicular profile

Your Camera Phone Asks for Its Address Back Every Few Hours. Here Is the Conversation.

#android #networking #iot #beginners
Comments 1
6 min read
Should You Leave the SIM Card in an Old Phone Security Camera? A Dual-SIM Guide for Offline, Wi-Fi and Mobile Data Setups
superfunicular profile

Should You Leave the SIM Card in an Old Phone Security Camera? A Dual-SIM Guide for Offline, Wi-Fi and Mobile Data Setups

#android #privacy #security #mobile
Comments
9 min read
This week on @Digital_Nomad_Media — 13 new clips (2026-W39)
superfunicular profile

This week on @Digital_Nomad_Media — 13 new clips (2026-W39)

#diginomad #youtube #indiedev #digicam
Comments
2 min read
Which Faults Actually Disqualify an Old Phone From Camera Duty? A Triage List, Including the One We Get Wrong
superfunicular profile

Which Faults Actually Disqualify an Old Phone From Camera Duty? A Triage List, Including the One We Get Wrong

#android #mobile #hardware #security
Comments
7 min read
The Loopback Line: Why a Phone Serving Its Own Camera Page Gets Fewer Browser APIs Than localhost
superfunicular profile

The Loopback Line: Why a Phone Serving Its Own Camera Page Gets Fewer Browser APIs Than localhost

#android #webdev #security #privacy
Comments
11 min read
The Offence Is the Listening, Not the Recording: A Real Estate Commission's Own Answer on Cameras During a Showing
superfunicular profile

The Offence Is the Listening, Not the Recording: A Real Estate Commission's Own Answer on Cameras During a Showing

#privacy #android #security #legal
Comments
9 min read
Why Your Phone Security Camera Uses Mobile Data on Shared Wi-Fi - Captive Portals, Explained
superfunicular profile

Why Your Phone Security Camera Uses Mobile Data on Shared Wi-Fi - Captive Portals, Explained

#android #networking #security #privacy
Comments
9 min read
This week on @Digital_Nomad_Media — 25 new clips (2026-W38)
superfunicular profile

This week on @Digital_Nomad_Media — 25 new clips (2026-W38)

#diginomad #youtube #indiedev #digicam
Comments
3 min read
The State's Own Poster Has a Box for Hidden Cameras: Connecticut's Monitoring Law and a Phone on a Shelf
superfunicular profile

The State's Own Poster Has a Box for Hidden Cameras: Connecticut's Monitoring Law and a Phone on a Shelf

#privacy #android #security #legal
Comments
9 min read
Your Phone Camera's Frame Rate Never Reaches the File - What Android Actually Writes Into an MP4 Timeline
superfunicular profile

Your Phone Camera's Frame Rate Never Reaches the File - What Android Actually Writes Into an MP4 Timeline

#android #kotlin #video #programming
Comments
10 min read
Android's September 30 Verification Deadline — What "Verified Developer" Does and Doesn't Tell You About an App
superfunicular profile

Android's September 30 Verification Deadline — What "Verified Developer" Does and Doesn't Tell You About an App

#android #privacy #security #mobile
Comments
5 min read
MantaxOtax Didn't Exploit Anything to Watch Your Screen — And That's the Part Worth Reading
superfunicular profile

MantaxOtax Didn't Exploit Anything to Watch Your Screen — And That's the Part Worth Reading

#android #security #privacy #mobile
Comments
5 min read
Every Guide Says "Reserve the Address on Your Router." What If the Router Is Not Yours?
superfunicular profile

Every Guide Says "Reserve the Address on Your Router." What If the Router Is Not Yours?

#android #networking #privacy #mobile
Comments 2
9 min read
The Minimum-Version Floor Is What Actually Retires a Phone, and Nobody Publishes It
superfunicular profile

The Minimum-Version Floor Is What Actually Retires a Phone, and Nobody Publishes It

#android #mobile #privacy #webdev
Comments
4 min read
The Range Header Is the Whole Feature: Serving Recorded Video From a Phone's Own Web Server
superfunicular profile

The Range Header Is the Whole Feature: Serving Recorded Video From a Phone's Own Web Server

#android #kotlin #http #webdev
Comments
8 min read
Break the Sensor, Not the Lamp: The Federal Standard That Checks the Warning Light Before It Tests the Monitor
superfunicular profile

Break the Sensor, Not the Lamp: The Federal Standard That Checks the Warning Light Before It Tests the Monitor

#android #security #privacy #iot
Comments
8 min read
A Phone Camera in an Unheated Room Stops Charging Long Before It Stops Recording
superfunicular profile

A Phone Camera in an Unheated Room Stops Charging Long Before It Stops Recording

#android #mobile #hardware #tutorial
Comments
10 min read
Your Offline Security Camera Is Guessing What Time It Is — How to Check It Before You Need the Footage
superfunicular profile

Your Offline Security Camera Is Guessing What Time It Is — How to Check It Before You Need the Footage

#android #privacy #tutorial #mobile
Comments
7 min read
Android's camera Foreground Service Type Does Not Include the Microphone — and From Android 17 the Audio Failures Are Silent
superfunicular profile

Android's camera Foreground Service Type Does Not Include the Microphone — and From Android 17 the Audio Failures Are Silent

#android #mobile #security #privacy
Comments
7 min read
Your Old Camera Phone Stopped Getting Security Updates. Here's What Still Updates, What Doesn't, and the Line at Android 11
superfunicular profile

Your Old Camera Phone Stopped Getting Security Updates. Here's What Still Updates, What Doesn't, and the Line at Android 11

#android #security #privacy #mobile
Comments
7 min read
This week on @Digital_Nomad_Media — 25 new clips (2026-W37)
superfunicular profile

This week on @Digital_Nomad_Media — 25 new clips (2026-W37)

#diginomad #youtube #indiedev #digicam
Comments
3 min read
Two Keyholders, Twenty Minutes, and Holiday Cover: The Half of a Security Setup That Has No Settings Screen
superfunicular profile

Two Keyholders, Twenty Minutes, and Holiday Cover: The Half of a Security Setup That Has No Settings Screen

#android #security #privacy #iot
Comments
6 min read
From 12 September 2026, EU Connected Products Must Be Accessible by Design - What That Asks of Cloud Cameras
superfunicular profile

From 12 September 2026, EU Connected Products Must Be Accessible by Design - What That Asks of Cloud Cameras

#privacy #android #security #iot
Comments
5 min read
Your Android App Is Localized. The Web UI It Serves Is Not: Accept-Language, dir, and the Screen That Is Switched Off
superfunicular profile

Your Android App Is Localized. The Web UI It Serves Is Not: Accept-Language, dir, and the Screen That Is Switched Off

#android #kotlin #webdev #i18n
Comments
8 min read
How to Get Recordings Off an Old-Phone Security Camera Without a Cloud Account - and the Folder That Traps Them
superfunicular profile

How to Get Recordings Off an Old-Phone Security Camera Without a Cloud Account - and the Folder That Traps Them

#android #privacy #tutorial #mobile
Comments
6 min read
A 24/7 Phone Camera Fills a 128 GB Card in 28 Hours, and the Write Speed You Paid For Is Only Guaranteed on Empty Space
superfunicular profile

A 24/7 Phone Camera Fills a 128 GB Card in 28 Hours, and the Write Speed You Paid For Is Only Guaranteed on Empty Space

#android #mobile #tutorial #performance
Comments
12 min read
loading...