Sign up to save your podcasts
Or
Share HPR4251: Dave and MrX turn over a new leaf
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
HPR4251: Dave and MrX turn over a new leaf
This show has been flagged as Explicit by the host.
Introduction
Hosts:
Morriss
We recorded this on Saturday September 14th 2024. This
time we were at Swanston Farm, a place we had previously visited for
lunch in March 2024.
After lunch we adjourned to Dave's car (Studio N) in the car
park, and recorded a chat. The details of why it is Studio N
instead of Studio C is mentioned in the chat itself!
Preparing this show has taken longer than usual this time
- apologies!
Topics discussed
old Citroën C4
Picasso) self-destructed. It was a diesel car and one of the fuel
injectors failed and destroyed the engine management system as it died.
It wasn't worth repairing!
vehicle). The price of nearly new EV cars is fairly good in the UK
at this time in 2024, so it seemed like a good opportunity to get
one.
braking
kWh), but is convenient
per hour) but will be cheaper with a night tariff (£0.085 per kWh versus
£0.25 per kWh normal rate)
electricity to charge an EV at home
Apocalyptic Inventor (TPAI)" and recently shared one of the
latest videos with MrX. The channel owner collects
discarded items from scrapyards in Germany, or buys old bits of
equipment, and gets them working again.
Machine Adventure! Bring her Home! / Gantry Build
Plasma Cutting Table from Scrap!
and received some training in databases.
(comma-separated values) file from the OFCOM (Office of
Communications, UK) website containing their Wireless Legacy
Register, which contains licensees and frequencies with longitude
and latitude values. A means of interrogating this file was sought,
having found that spreadsheets were not really very good at handling
files of this size (around 200,000 records).
in shows hpr2698
and hpr2752
by Mr.
Young. It allows a CSV file to be interrogated in quite a lot of
detail from the command line. However, with a file of this size it was
still quite slow.
Using the SQLite Browser it was
simple to load this CSV file into a database and gain rapid access to
its contents. SQLite databases may also be queried through a
command-line interface which can also be run on a Raspberry Pi, phones,
tablets and on a ChromeBook.
tool:
image. Dave generates coloured text from his meal database (HPR show hpr3386 ::
What's for dinner?, this being a later enhancement), then captures
the output and sends it to a Telegram channel shared with his
family.
wttr.in with Archer72
on Matrix.
text colours. It can be installed from the GitHub copy, and maybe from
some package repositories.
exports) variables called red, green,
etc.
echo "${red}Red text${reset}"
arguments, a colour name (as a string) and a message. The script
encloses the message argument in a colour variable and a reset. The
colour name argument is used in a redirection to turn red
into the contents of the variable $red.
better to use in terms of features, but are reluctant to learn a new
interface!
Ranvoo Aice Lite Review
where the weather was good.
period.
attending too, as will Ken.
conference in Paris.
off-grid, decentralized, mesh network built to run on affordable,
low-power devices
to have dried up.
printer has a scanner and FAX capability. An HPR show
was done in 2015 describing how it was set up to use a Raspberry Pi to
make it available on the local network.
which was mentioned on HPR show
3197. This was dropped onto concrete, and didn't appear damaged at
the time, but it apparently received internal damage and eventually fell
apart.
Links
(electric vehicle)
braking
SQLite Fast
Birth of SQL & the Relational Database
JOIN Types Poster (Steve Stedman)
to Fake a Database Design - Curtis Poe (Ovid)
ops-oriented people and anyone who loves the terminal. Similar programs
are sometimes called "Terminal Multiplexers".
Provide feedback on this episode.
View all episodes
By Hacker Public Radio
4.2
3434 ratings
This show has been flagged as Explicit by the host.
Introduction
Hosts:
Morriss
We recorded this on Saturday September 14th 2024. This
time we were at Swanston Farm, a place we had previously visited for
lunch in March 2024.
After lunch we adjourned to Dave's car (Studio N) in the car
park, and recorded a chat. The details of why it is Studio N
instead of Studio C is mentioned in the chat itself!
Preparing this show has taken longer than usual this time
- apologies!
Topics discussed
old Citroën C4
Picasso) self-destructed. It was a diesel car and one of the fuel
injectors failed and destroyed the engine management system as it died.
It wasn't worth repairing!
vehicle). The price of nearly new EV cars is fairly good in the UK
at this time in 2024, so it seemed like a good opportunity to get
one.
braking
kWh), but is convenient
per hour) but will be cheaper with a night tariff (£0.085 per kWh versus
£0.25 per kWh normal rate)
electricity to charge an EV at home
Apocalyptic Inventor (TPAI)" and recently shared one of the
latest videos with MrX. The channel owner collects
discarded items from scrapyards in Germany, or buys old bits of
equipment, and gets them working again.
Machine Adventure! Bring her Home! / Gantry Build
Plasma Cutting Table from Scrap!
and received some training in databases.
(comma-separated values) file from the OFCOM (Office of
Communications, UK) website containing their Wireless Legacy
Register, which contains licensees and frequencies with longitude
and latitude values. A means of interrogating this file was sought,
having found that spreadsheets were not really very good at handling
files of this size (around 200,000 records).
in shows hpr2698
and hpr2752
by Mr.
Young. It allows a CSV file to be interrogated in quite a lot of
detail from the command line. However, with a file of this size it was
still quite slow.
Using the SQLite Browser it was
simple to load this CSV file into a database and gain rapid access to
its contents. SQLite databases may also be queried through a
command-line interface which can also be run on a Raspberry Pi, phones,
tablets and on a ChromeBook.
tool:
image. Dave generates coloured text from his meal database (HPR show hpr3386 ::
What's for dinner?, this being a later enhancement), then captures
the output and sends it to a Telegram channel shared with his
family.
wttr.in with Archer72
on Matrix.
text colours. It can be installed from the GitHub copy, and maybe from
some package repositories.
exports) variables called red, green,
etc.
echo "${red}Red text${reset}"
arguments, a colour name (as a string) and a message. The script
encloses the message argument in a colour variable and a reset. The
colour name argument is used in a redirection to turn red
into the contents of the variable $red.
better to use in terms of features, but are reluctant to learn a new
interface!
Ranvoo Aice Lite Review
where the weather was good.
period.
attending too, as will Ken.
conference in Paris.
off-grid, decentralized, mesh network built to run on affordable,
low-power devices
to have dried up.
printer has a scanner and FAX capability. An HPR show
was done in 2015 describing how it was set up to use a Raspberry Pi to
make it available on the local network.
which was mentioned on HPR show
3197. This was dropped onto concrete, and didn't appear damaged at
the time, but it apparently received internal damage and eventually fell
apart.
Links
(electric vehicle)
braking
SQLite Fast
Birth of SQL & the Relational Database
JOIN Types Poster (Steve Stedman)
to Fake a Database Design - Curtis Poe (Ovid)
ops-oriented people and anyone who loves the terminal. Similar programs
are sometimes called "Terminal Multiplexers".
Provide feedback on this episode.
More shows like Hacker Public Radio
View all
Security Now (Audio)
1,971 Listeners
Off The Hook
117 Listeners
No Agenda Show
5,938 Listeners
The Changelog: Software Development, Open Source
283 Listeners
LINUX Unplugged
265 Listeners
BSD Now
89 Listeners
Open Source Security
43 Listeners
Late Night Linux
154 Listeners
The Linux Cast
35 Listeners
Darknet Diaries
7,864 Listeners
This Week in Linux
36 Listeners
Linux Dev Time
21 Listeners
Hacking Humans
314 Listeners
2.5 Admins
92 Listeners
Linux Matters
20 Listeners