December 21st, 2007


The solstice, and a solar ephemeris ical source

Today at 10:08pm PST (20071222T060800Z) is the Southern Solstice.

About a year ago, as an exercise in learning the iCal data format, I hand built an ICS file that contains the days and times of all the Solar Ephemeris events, that is, the Solstices, Equinoxes, Perihelions, and Aphelions, from 1990 to 2020.

If you are running Outlook or Mac iCal, you can import it by clicking on or importing from this link.

If you are using Google Calendar put "Solar Ephemeris" in the gcal search box and hit the "Search Public Calendars" and add it to your calendar set.

Writing another storage engine, "Pig Engine"

I've started hacking together another storage engine. It's one I've wanted to write since before I wrote my AWSS3 engine.

I'm calling it "pig", because it's going to eat inodes like a pig eating corn.

Each table, row, and element is a filesystem directory. Each element directory contains a file that has the current value, and also a set of version files of the value, thus the table will contain it's entire history. The table directory contains a copy of the .FRM, to enable discovery. Storage engine API events write entries into a logging directory.

As it is, it's not very "useful", in that it's not fast, and it beats the filesystem half to death.

But, on the other hand, it's going to be useful to me for in three ways:

It's a good exercise in writing a more fully featured SE than my AWSS3 SE.

I think it will be a better "example" engine than the stock example engine, in that it will actually store data in an understandable form, and will be logging SE API calls.

And I'm going to modify it to store to HTTP, HTTP/DAV, and to AWS S3/SDS.