inmysocks (version: awoo) @inmysocks@awoo.space

Well, that just took the analysis time down from about 30-50 seconds per article to 2-10 seconds per article.

Optimizing loops can make a difference when you are dealing with 50000 inputs.

I continue my battle with SQL for the third day in a row.

But progress is being made!

semi-related note:

The checks in these two if statements

if index % 500:
foo

and

if index % 500 == 0:
foo

are the logical negations of each other, at least in languages where any positive non-zero number evaluates to true.

So remembering that '==0' is important.

This is the first time I have used tabbed terminal windows and it hasn't seemed terrible.

I have an sql shell open in one terminal and the python environment using the sql database in the other.

I see how this could be useful.

I have successfully defeated sql for the night. I am sure that tomorrow it will be back for revenge.

The gear doesn't have even sized spokes all the way around. I am not sure if this is because of backlash or the input svg. I haven't checked the image closely.

@theoutrider ...

wat

I could make this table have 301 columns instead of being about 1.3 times the size it needs to be.

But then I really don't want to type out the command to create a table with 301 columns.

I am bad at database schema stuff.

Bleh. Now I have to think about sql database schema.

I don't wanna!

Grumble, this whole 'having to eat' thing is a pain.

It is easy to ignore the principle of not duplicating data unnecessarily until you end up with a 42 gig output from an input that was about 200mb.

So now I guess it is time to set up mysql.

My laser cutter can scale things, so I am playing with that.

And you know, testing to make sure that cuts are repeatable and everything.

#Engineering

I feel like I should apologise o the very concept of coding, and to everyone who helped me learn to code, for the quality of what I am currently writing.

So I am sorry.

@ekaitz_zarraga I have looked into it a bit, but I have never made anything practical. It is one of the million things that I have been hoping to do at some point.

And now I have a CNC, laser cutter and 3d printer to play with, so I am planning on doing much more physical hardware stuff.

@envgen in my experience hitting a window of a car that is too close or about to hit you is rather effective.

Both in that it generally gets them to stop and in that the person driving the car is generally suitably freaked out that they may be more careful in the future.

@jond I am a bit worried that the steppers I have aren't powerful enough to drive it, but getting a more powerful stepper should be simple enough.

Either way it will be interesting.

The difference between using this backlash suppression stuff I made and not using it is surprising. It isn't completely perfect, but now unless you know exactly what to look for the effects of backlash aren't noticeable.

Next we have to test cutting precision parts and make sure that they work too. Anything with 90 degree turns should work just fine.

And we may switch from a belt to a worm screw for the x axis which should greatly reduce the amount of backlash. #Engineering

@envgen please don't die. I would be very sad.

Because yes, everything in the world is about me.

I spent all day first figuring out that the problem with the laser cutter was backlash and not some weird rounding in my code, then the rest trying to implement some compensation for it. I finally succeeded but my brain was melted by the first part so it took way too long to implement and I still need to add some some smoothing so that the compensation doesn't add weird jumps into lines.

#Engineering

I used the laser cutter. It took a long time but then I realised that I hadn't cleaned the lens, so it should hopefully take much less time in the future.

For scale, the pieces of wood it is cut out of is 3mm think and A4 sized.

LASER CUTTER!!!

#Engineering