lnk.to Progress Modest
I keep messing with how the database table should work, and I had a hard time figuring out how to create a new key within a class referring to an object that I am hash-tieing to the lnkto table with Tie::DBI, but the good news is, that I’ve actually gotten started. It is a little frustrating at the moment, but the knowledge that I am building a class that will make writing the actual web site so much easier is good for morale.
Oh, and I have tuned the rewrite rule so that it will be easier to add static HTML and additional cgi files to the site, because only URLs that match \w+ will get redirected:
<IfModule mod_rewrite.c> RewriteEngine on RewriteRule ^/(\w+)$ /redirect.cgi?key=$1 </IfModule>
http://lnk.to/foo will be handled by redirect.cgi?key=foo
http://lnk.to/foo.html will read foo.html
Back to table concerns …
# DROP TABLE lnk; CREATE TABLE lnk ( -- Unique numeric ID (auto-increment) `id` INT UNSIGNED NOT NULL auto_increment, -- The URL key. Not unique perse, but would be unique per chainId -- Can be null, when we're first creating the Lnk. `key` VARCHAR(16), -- The payload. Definately not null! `url` TEXT NOT NULL, -- "publication date" of an item `pubDate` DATETIME, -- date item added to Lnkto `addDate` DATETIME NOT NULL DEFAULT 'NOW()', -- HTML TITLE tag but should be user-editable `title` VARCHAR(128), -- META description `description` TEXT, -- We'll eventually handle "add from feed" type chains ... -- 'hilite' is an idea where you could hilite a Lnk into your own chain -- ... basically a reference thingus `source` ENUM('feed', 'manual', 'hilite') DEFAULT "manual" NOT NULL, -- Which chain we belong to. For now, only 0 `chainId` INT UNSIGNED DEFAULT 0 NOT NULL, -- Numeric ID of "author" which will ref another table, with author -- name, email, etc. Can be useful for "tipping" and some day crafting -- suggested reading `authId` INT UNSIGNED DEFAULT 0 NOT NULL, -- For classic lnk.to, we like to keep score, which is roughly +1 per -- clickthrough, divided by 2 every night. `score` FLOAT UNSIGNED DEFAULT 1 NOT NULL, UNIQUE ( `id` ) );
It is a work in progress.
Oh, and Firefox “tab sessions” rock, because you can create a “dev” window with a bunch of appropriate tabs in there, and then save that tab set in a session when you go home, and reload it the next day. A great complement to the screen command!
Another note, it may be a very healthy work style to comment on progress here in the morning, and let the hindbrain think about things during the day. I do the dev work “after work” at the office, after 3pm, when my shift formally ends. (Though, I’ll still kick the occasional work ticket when I need a break.)