My cat likes to be included in all activities, from gardening to iot tinkering… as long as it doesn’t make much noise

My cat likes to be included in all activities, from gardening to iot tinkering

… as long as it doesn’t make much noise

I don’t want to get up now #caturday

I don’t want to get up now #caturday

That’s a new one, is this vibe -calling?Someone actually left me a voice message with“hello sir Rossolini how are you?”office sounds...

That’s a new one, is this vibe -calling?

Someone actually left me a voice message with

• “hello sir Rossolini how are you?”
• office sounds for over two minutes, the operator having shut up

That’s my voice mail, did you expect me to pick up the entire time

No clue who they are, btw

AI critics have been saying boththat these companies are not profitable, when talking about their economics and business models;that these...

AI critics have been saying both

• that these companies are not profitable, when talking about their economics and business models;
• that these companies are making huge profits, when talking about their (lack of) ethics

Which is it?

@analog_ashley @grimalkina I was listening to the dire wolf episode and the score/index discussion reminded me of my recent failure to...

@analog_ashley @grimalkina I was listening to the dire wolf episode and the score/index discussion reminded me of my recent failure to properly calibrate my diy sensors 😅

(That isn’t my main takeaway from the episode)

See
https://infosec.exchange/@GuillaumeRossolini/114369430917001167

Me, trying to change the email in my profile on a website in this modern ageThe field is greyed out, so I’m going to their support...

Me, trying to change the email in my profile on a website in this modern age

The field is greyed out, so I’m going to their support page

That’s a tiny form in the margin but ok, I write my request and submit

An interstitial comes up, asking me to review this entry in their FAQ in case it solves my request before I bother the humans, and I think great, I needed a tutorial for the edit button

But of course

• it isn’t a simple link that I can open in another tab, no, it’s a button that replaces the entire form
• the FAQ entry is a single sentence that says “simply contact us”

😭

/cc @sean

I’ve spent the better part of the day trying to install python2 on RaspberryOS (bookworm, freshly flashed)I don’t even want it for...

I’ve spent the better part of the day trying to install python2 on RaspberryOS (bookworm, freshly flashed)

I don’t even want it for myself, it’s just a dependency for a project who didn’t build it into their .deb file (probably with good reason)

Attempt 1

(2 hours)

Didn’t know it would take that long, timed out

Attempt 2

(2 hours)

Of course it didn’t resume, but started over although this time I used a tmux session

Failed for a missing dependency that wasn’t identified early on

Attempt 3

(ongoing)

We’ll see…

#RaspberryPi

Let’s say that my cat jumped on the desk and settled in the nook of my armThen perhaps I face planted in her sun-warmed fur That’s when...

Let’s say that my cat jumped on the desk and settled in the nook of my arm

Then perhaps I face planted in her sun-warmed fur

That’s when I discovered that despite being over 40, I can still see clearly up close if my eyelids are half closed

While y’all are here, could you check this outIt’s for her healthhttps://infosec.exchange/@GuillaumeRossolini/113675368243834641Thanks

While y’all are here, could you check this out

It’s for her health

https://infosec.exchange/@GuillaumeRossolini/113675368243834641

Thanks

@FediTips Hi, is there a way to tag a post in several languages (for translation purposes)?For example when I’m talking to an English...

@FediTips Hi, is there a way to tag a post in several languages (for translation purposes)?

For example when I’m talking to an English audience but I’m quoting a French text, what’s the etiquette there?

Perhaps I should tag in French in that case

Cat helping me work 😆

Cat helping me work 😆

Second winter with my hybrid heat pump (installed August 2023), here are the gas graphsThe month of January is single handedly keeping my...

Second winter with my hybrid heat pump (installed August 2023), here are the gas graphs

The month of January is single handedly keeping my emissions and my bill higher than I’d like for the entire year, but even so, I like the new trend

Of course the electricity graphs have a similar shape, though not as dramatic, and 2022-2023 were flat the entire time

Heat pumps work great, just don’t rely on the overall energy bill getting much lower

#HeatPump

@overcastfm is this from your app by any chance?I don’t own AirPods, I’m just sitting in a train full of people I don’t know, and...

@overcastfm is this from your app by any chance?

I don’t own AirPods, I’m just sitting in a train full of people I don’t know, and I’ve had this pop up twice in the last half hour

Never mind, since I’m using a CSV buffer I eventually realized that this data format usually translates well into SQL storage…tl;dr...

Never mind, since I’m using a CSV buffer I eventually realized that this data format usually translates well into SQL storage…

tl;dr Today I went from 250ms writing data every 6 second, to 800ms every 5 minute for the same data

After some reading of the SQLite docs, I changed my import method to a simple batch ETL script

I can’t load the data straight from CSV to the final table because not the same fields, and also I like the TAB character as a separator whereas SQLite doesn’t allow it, but I found a way that works well

It’s also really faster (no surprise there) compared to a programmatic method and loops, even with prepared statements

I had the idea that writing to the SDCard for 250ms every few seconds was a bad ideaThat is how long it took for SQLite to insert 1 row in 4...

I had the idea that writing to the SDCard for 250ms every few seconds was a bad idea

That is how long it took for SQLite to insert 1 row in 4 databases, roughly 80ms times 4

(I have four databases because the daily DB, the day before, the day after, and the huge all-time database)

So instead, I added a CSV buffer: incoming readings are appended to a flat file instead of immediately SQLite, and every 5 minutes, one of the nodes takes a hit to commit the CSV into the databases

The CSV append operation takes a few ms, usually 2ms but sometimes 5ms, so I'm happy about this part

The CSV to SQL operation takes about 8s when all 10 nodes are up (50 measurements to 4 databases), so that's a tad slower than I'd want but it happens once every 5 minutes so I guess that's ok?

(every SQL insert now takes about 40ms and there is probably still room for improvement)

And now I can keep a console with watch cat buffer.csv which is great, and more readable than my server logs

Here is a sequence of four batches as a demo (first CSV field is a timestamp, second is the node ID, and the rest are air quality readings from the BME680)

#diy #AirQuality #RaspberryPi #SQLite

I’ve left the router trying to boot up for two weeks now, I think that’s long enoughTime to dig into it#OpnSense #HomeLab

I’ve left the router trying to boot up for two weeks now, I think that’s long enough

Time to dig into it

#OpnSense #HomeLab

Forgot to share the linkhttps://help.instagram.com/contact/767264225370182

Forgot to share the link
https://help.instagram.com/contact/767264225370182

Even being from the EU, it seems we aren’t protected from Meta opting us into its GenAI training by defaultThis is an email after the fact...

Even being from the EU, it seems we aren’t protected from Meta opting us into its GenAI training by default

This is an email after the fact (they already started gathering data), the link to oppose is just one word in the body of this email, and it leads to a web form with a text area to explain our reasons for opposing 🤪

And from the language used, I’d surmise they reserve the right to deny our opposing this (or try to)

#eu #privacy #GenAI

Hi there, I’ve been toying with the idea of making my mesh network of air quality sensors [1] [2] shared across housesThe idea would be to...

Hi there, I’ve been toying with the idea of making my mesh network of air quality sensors [1] [2] shared across houses

The idea would be to eventually trigger alerts when another house in the shared network is having an issue

Since in my case it would be for relatives who live relatively close to each other, I’d probably go with LoRa

But seeing that a dozen sensors produce daily databases that are nearly 3 MiB in size each (and I haven’t started storing events like connects and disconnects yet), I’m starting to have doubts

Thoughts?

[1] https://infosec.exchange/@GuillaumeRossolini/113092226187348913
[2] https://github.com/GuillaumeRossolini/griotte

#iot #diy

The daily database files jumped to 2.6 MiB each since I started triple storing, as a lazy fix to my UTC issueThis is still much bigger than...

The daily database files jumped to 2.6 MiB each since I started triple storing, as a lazy fix to my UTC issue

This is still much bigger than I’d like, but at least it’s a steady file size April 7 to April 18 included, so that’s good

And I can always reduce to 5 minute instead of every minute, or something

#sqlite