i should be working (but i'm fixing my computer).

I spent the entire [lost] day rewriting the code for my php/website bookmark database. But hey! What are Sundays for?

...

The results are found here. Which isn't pretty, is it?

I look at the page at the link and I can't make any sense of it. Just these columns of unsorted and seemingly un-useful info.

So, I imagine it would be even useless-er for someone who is not me.

But, the amazing elegance is that a lot of the links I frequently visit or occasionally visit are in the list -- and easy to retrieve by a simple query at the top of the list. Select a keyword, a part of a site name, a word of description, even part of a date and the the incoherent list becomes a concise, focused list.

Well, there are a lot of entries at the moment with no links. This is due to the fact that in my re-write I decided to have the php code construct the links instead of embedding complete link code in the database. It's much easier to create and maintain this way, but all of my old links are now unreadable until I edit them. Fairly tedious project. If I had more links, it would be essential to write some php code just to do the conversion.

But, I'm listening to some tunes and making the updates, so not too bad a job.

The page at the link above is the "public" version, of course. My private version accesses the same database, but each entry has a clickable button for editing and there is a button for a "new" entry as well. Actually, I use a split browser screen and drag links from the top window to the entry box in the bottom window.

Today's project was a significant re-write. I noticed that I was building up a lot of links in my normal Firefox bookmarks, which is not organized or useful. But, faster.

So, I wanted to "faster" the entry of data into the system. That way, all of my bookmarks are readily sortable, can be queried, etc. Bookmark entry is not quite as fast as simply using the browser's bookmarking capability -- though probably not slower than sorting bookmarks into folders and the like.

I also advanced my programming understanding, designing some chunks of the code to be reusable, since I wanted to re-order some of the forms for normal data entry as opposed to the way I use the links in ordinary use. I noticed I was then having to maintain to separate pages of code, so it seemed better to create some shared code.

I also have some sorting options (eg., by site or by description). These are only marginably useful as far as I can tell, but seemed like a good idea. In any event, I did not incorporate the sorting capability into the public version.