/blog

Two days, two milestones.

After a week with the new blog yesterday today sees a full month with the Journal, a 31 day streak and still going strong. The decision to gamify it seems to be paying off.

There's nothing really earth-shattering in there, just thoughts as they happen but I hope it will become a mix of morning pages and daily log.

As I've said before, having these multiple levels of writing all held on the site is quite empowering. The blog is the public face but there are layers beyond where ideas can grow, eventually bubbling up to the surface. The Journal is where ideas are seeded, they are transplanted to the Garden as needed and, once ready, put on display.

It's a good arrangement.

Ann Althouse today celebrates 17 years of blogging with a record of posting every day, that's 6210 days.

Impressive.

I started blogging back in 2003 but have taken so many breaks that it's really only been like 12 years in total. I've never committed to posting every day so am always in awe of people like Ann and Seth Godin who do.

OK, that's not good. Somehow there was a SQL injection and a post was overwritten with spam.

I've restored it but I need to find out how this has happened so it can't happen again. I've been reworking a number of prepared SQL statements so I'm not sure how this has occurred.

Liked: Why can't I write code inside my browser?...

"So I can write code inside my spreadsheet, but not inside my browser? WTF."

Back to the SQL injection, I was missing a close() command for one of the database queries so don't know if that would have been an avenue of attack.

What's annoying is that apart from the comments everything else is dependent upon me being logged in. The statement to write new comments has been correctly prepared from the beginning.

I'm nervous about what I'm going to wake up to in the morning.