Mnemosyne: List Entries. New Apollo Pictures

Worked on Mnemosyne last night. I have the ability to list all the tags, and list all the entries. It’s looking pretty terrible right now, and the code is very sloppily put together, but some of the core functionality is coming together. Next major steps are going to be adding the edit and delete ability (with some permissions), and linking tags and entries. I was thinking of having a simple text box for tag entry, but maybe it should be a fixed list? A text box might not be restrictive enough.

Added two photos to Apollo. A play with focus. I noticed that the wordpress theme is cutting off my landscape pictures. I’ll need to put that on the list of things to fix.

Start of Mnemosyne, new Apollo picture

Uploaded a new picture to Apollo.

Started on the work for Mnemosyne. Not a whole lot finished. Created the tables for tags, and entries. And created a simple webform for entering entries. The form only takes a title and some text, but I used mysql_real_escape_string() to prevent SQL injection.

There’s also a date stamp behind the scenes.

No styling yet. Need to work on function before fashion. Next task will be to add the tagging ability, and display some entries based on tags, and date.

Also started work on the home page. I want the image to update on click, so users don’t have to reload the page to get a new image. Going to use javascript, eventually jQuery.

Begin Again

Registered for some hosting with Webfaction today. I’ve had a couple of ideas for projects floating around in my head the past few months, but haven’t had the ambition to actually start implementing them. I’m hoping that since now I’m paying for it, I’ll have more motivation.

I have one main page and four projects on the go right now. The main page simply displays an image right now and has links to the four projects. The links to the projects are images, not text. Made with Gimp on a Macbook Pro.


Simple blog, made with WordPress. I found a minimalist theme that I quite like. It will need some tweaking, but for now it will do. I hope to learn some CSS and JavaScript through this blog and all of the other projects. This blog will mainly be used for discussion project updates and the like. I’m thinking of making another WordPress install for posts not related to the site (movies, music, etc.), but four projects on the go is enough for now.

I already hate the styling for the h3 links, but I’ll fix that another day. Just want to get my thoughts down and everything installed for now.


The Apollo project is another simple WordPress blog. Again using the minimalist theme. This one focusing on photography. I bought a new digital SLR when I moved to Amsterdam, and I’ve been meaning to take more pictures. I’ll highlight my favourite ones here. Apollo is the greek god of light (amongst other things), and I figure that’s an appropriate title. All of my sub projects (minus this blog) follow a similar naming pattern.


The Demeter project is the one I’ve been thinking about for the longest time. Demeter is the greek god of the harvest, and the projects aim is to help with choosing where to go for lunch. Usually two or three times a week, some of my co-workers and I will be standing around in the hallway wondering what we should eat. And it would be a big help to new employees or visitors to the office. The project will have listings of places to eat with Google map integration, ratings, price ranges, comments, hours, and other metadata.

The scope for right now is lunch places near the office, but eventually I hope to scale it larger. To roll it out to the other offices, and maybe make it public. I hope to keep the scope relatively small, or if it does grow, then to have silos so that people aren’t bogged down with too many choices. I’m not trying to compete with Yelp, it should be more locally applicable.


The last project I’m planning is called Mnemosyne. Mnemosyne is the greek god of memory. This project is more for myself. I frequently come across little tricks or solutions to problems when I’m programming at my job. I rarely write them down, because if they’re on paper I’ll just lose them, and saving them to a text file misses some features that I feel would have me using it more.

Mnemosyne will be a simple entry submission application with tagging, search, and dates. The key is to keep it simple, but powerful. I don’t want it to be too complex or I’ll never use it, and I don’t want it to be too simple, or it is useless. I’m going to have to try to find a balance.

Just text support for now. I might include image support and others later.

So there we go. That’s everything for now. Hopefully I’ll get around to all of this while still being able to keep my social life.