selawdivad
I’m a Christian, a dad, an open source fan. I have a blog: https://daviewales.com/
Can I suggest duckdb?
You can start out writing SQL directly on top of CSV and Parquet files.
But then if you want/need to do something more complicated, you can import duckdb
into Python, keep running the SQL you already wrote, convert it to a Pandas or Polars dataframe, transform it, then query the result in SQL.
Hanukkah of Data by the Visidata team was fun.
I’d suggest maybe stick with Godot 3 until 4.1 comes out. I just started playing with 4, and hit a bug where Godot will hard crash whenever you try to view the Terrains tab if you’ve created terrain sets, used them in your scene, then deleted the terrain sets.
Also, Godot 4 doesn’t have as good support for older systems due to the new Vulkan backend. I worked around this by switching to the mobile renderer which works better on my old hardware.
The first step is to make sure your hardware is supported. I’ve found the linux hardware database to be invaluable getting new systems configured. The site is overwhelming at first, but the easy path is to just click the big ‘Probe your computer’ button and follow the instructions. Once you’ve done a probe, you’ll get a web-page with a listing of all your computer’s hardware and the support status. Even better, you get links to additional drivers or kernel modules required to get stuff working which isn’t supported out of the box.
Organic Maps is the maintained fork of Maps.me. See the wikipedia article for details.
I have a git repository in ~/dotfiles
, and symbolic link the ones I want as I need them. I’ve only just started tracking my dotfiles and I’m not super disciplined with it yet, so I still have slightly different setups on each system.
I just use the KeePassXC password generator. :)
One of the first real programs I wrote was a program to display telemetry data from a CAN bus. I was on the solar car team at uni, and we wanted to be able to view the data from the various systems live during the race. The CAN network was connected to a CAN-ethernet converter, which sent UDP packets over a wireless ethernet link to our lead car. I had no experience with networking, or UDP or CAN at all, but I had some documentation and a lot of free time, so I got to work.
Each device on the CAN network had a bit mask to identify it.
For example, the bit mask for the motor controller might have been 0x1200
.
This meant that any packet starting with 0x12
belonged to the motor controller.
For example, 0x1201
was one type of message, and 0x1202
another type, but both belonged to the motor controller.
There was specific logic for each device on the network, so you needed to first figure out which device owned a packet using the bit mask, then apply the relevant logic to decode the packet.
Looking back, I realise the correct way to approach this would be to have a list of bit masks:
0x1200
0x1300
0x1400
Then simply bitwise & any incoming packet with 0xff00
, and lookup the result in the list of bit masks.
Not knowing better however, what I actually did was create a giant dictionary of every possible packet value, so I could lookup any packet and determine which system it came from. This was so repetitive that I had to make use of my newfound super-power – vim macros – to complete the 8000 line dictionary…
Excerpt from real code below:
{
0x102:
{
'name': 'SHUNT_CMU_STATUS_TEMPERATURE_AND_VOLTAGE_1_2',
'data':
[
'cell_0_voltage',
'cell_1_voltage',
'cell_2_voltage',
'cell_3_voltage',
],
'unpack_string': 'intle:16, intle:16, intle:16, intle:16'
},
0x103:
{
'name': 'SHUNT_CMU_STATUS_TEMPERATURE_AND_VOLTAGE_1_3',
'data':
[
'cell_4_voltage',
'cell_5_voltage',
'cell_6_voltage',
'cell_7_voltage',
],
'unpack_string': 'intle:16, intle:16, intle:16, intle:16'
},
}
My 3 year old daughter has a 2010 MacBook running AntiX. She knows how to boot it, press Enter on the dual-boot screen, and is getting close to being able to select Stardew Valley from the app menu. She also enjoys playing GCompris.