It has been a very long first week back from break. I am feeling it this morning.

I got neighbor post navigation working on my microblog and ran into a weird limitation with SQLite.

Adding neighbor navigation

Brian Bennett is a teacher in Buchanan, Michigan.

TIL that #SQLite doesn't allow union queries when there's a limit applied. That stinks.

GitHub

`union_all` creates invalid SQL in SQLite when used with nested subclauses · Issue #8094 · sqlalchemy/sqlalchemy

Describe the bug When using union_all with an SQLite engine, invalid SQL is generated when one of the subclauses has itself a subclause, such as LI...

I have a (slightly?) crazy idea for my second-year chemistry class next year. Instead of running labs on specific days, I want to prepare a year-long lab manual. Students would have a block of time in which to complete a specific number of labs. This does two things: makes my planning easier - I know lab days would _always_ be Tues/Thurs. I can also prep blocks of labs and not do so much day to day lab prep. Any HS #chemistry teachers doing anything like this? #teaching #askfedi

We're using all the tools for today's lab. #chemistry #teaching

I've got some music in minor keys blaring in my room this morning while I set up this enormous lab. I'm really proud of my lab schedule and that I'm able to do so many things with my students. But dang, it's a lot of work. I'm very thankful for my lab assistant this year who helps stage materials and clean up after the fact.

Today in the classroom: First year chem is doing a macroscopic properties lab where they observe/record physical appearance, melting point, and conductivity data for ionic and covalent solids. They'll identify an unknown based on two known samples. Second year chem finished their Charles' Law data collection yesterday and are now extrapolating absolute zero for two different gases and writing up their report. We'll also do some PV=nRT practice questions. #chemistry #teaching :cupofcoffee:

Came home and did a thing today. This is based on a photo I took the other night. The setting sun was framed well with a bonus sun dog to boot. #watercolor #aquarelle #mastoart

My ability to be productive after 2:30 is nonexistent. I'm sitting and starting at this computer knowing that I have things to do to be ready for students but I can't seem to find the mental energy to make them happen.

A student shared a wonderful science meme with me today. #chemistry #science