Pat Gunn (dachte) wrote,
Pat Gunn

Midnight Olives

I couldn't sleep, so I programmed. I finished up with the time-related stuff.Here, take a look:

pgunn=# select * from timeimage;
timeid | name | starttime | stoptime | imageurl
1 | Dawn | 0 | 359 | http://localhost/time_dawn.jpg
2 | Morning | 360 | 719 | http://localhost/time_morning.jpg
3 | Evening | 720 | 1079 | http://localhost/time_evening.jpg
4 | Dusk | 1080 | 1440 | http://localhost/time_dusk.jpg
(4 rows)

Not a terrible way to handle this stuff, and if I make new pictures so I havemore than 4 times, I can easily upload them without changing any code. Moreimportantly, it works. At some point, I'll probably BLOB-ize those images so they don't actuallylive on the filesystem. If I ever open my blogging software to others runningit on MY system (a possibility), perhaps each user will have their owntime icons. At that point, I'll need to create a new journalowner table,and create a foreign key from here into there. It'd actually be pretty easy.Of course, anyone will be free to download my code and run it on their sites.The only reason it's not up now is that I don't want to be repackaging itanytime I make a little change, and it's still fluid to the point where I don'tcare at all if I lose everything in my test databases, or need to redo somestuff that means reimporting everything.

However, at this point, after I check the security stuff, and get boththe retrieval of entries to a file and the backup command working,I'll start using it for everyday journaling, and stop using netdiary.One of the other things pushing me to get this new version working is thatit takes way too long to upload all the static html files via scp every time Imake a new entry :)

Oh, some stuff:Pics someone else took from the Hypatia GatheringGrab a full mp3 track, legally, from Firewater's latest CD

Finally, an irritant: Sites that use other sites for images and javascript,except the other sites are unreliable so it breaks EVERYONE who uses theirservices every so often. Yahoo is broken for me right now thanks to


Tags: blog

  • Nashville Equlibrium

    Today at 16:45 I am running the Random Distance Run, which five years ago I managed to score second-worst of the people who finished. I imagine…

  • Technically Civilised

    Today I moved my lamp, tea kettle, and cup to my new office - this means that my office is technically civilised (not fully because I don't have…

  • Lost and Sought

    While checking up on our test boxes in the CMCL, I heard a quiet knock on the door, and faced Marcel, Kwan-Jin, and a contractor coming to check out…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded