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

  • Still alive

    Been feeling a bit nostalgic. Not about to return to LiveJournal - their new ownership is unfortunate, but I wanted to briefly note what's been up…

  • Unplugging LJ

    It's about time I pulled the plug on the LJ version of my blog: 1) I'm much more active on G+ than I am with general blogging. I post many times a…

  • Mutual Trust

    I don't know which should be considered more remarkable: That a cat should trust a member of a far larger and stronger species that it can't…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded