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

  • Typing in Colours

    (Cross-posted to G+, but it's more of a definitive statement of views so it goes here too) A recent instance of 「Wasted Talent」: here I'm not…

  • Loyalty

    This is meant to address three ideas: Don't blame the victim If you care for me, you'd support me unconditionally Safe zonesAnd to be a topic in…

  • What Do We Owe Each Other?

    One of the central questions in political philosophy, or perhaps one of the most intuitive initial framings, is "what do we owe each other?". I…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded