Hwdb notes

hwdb refers to the web application I am developing for LinuxMCE to provide a web accessible place to put hardware compatibility lists for things that work in LinuxMCE.

Basic UI principles:

• No deliberate page refreshes.
• Anything you drill down into, shows up right where you are, pushing other page elements out of the way.

Schema

schema: the additional rails bits for timestamps etc are not shown.

manufacturer

id
manufacturer name
url
(taggable)
created_at date
modified_at date 

hardwareentry

manufacturer_id integer
model string
description text
mfgurl string
wikiurl string
workrating integer (1-5, 1 DOESN'T, 5 WORKS WELL)
created_at date
modified_at date
acts_as_taggable

Items to show on the main screen

• Search Box, which expands to show newest entries.
• Recently Created Hardware Entries (10 newest entries)
• Recently Modified Hardware Entries (10 most recently modified entries)
• Add a New Hardware Entry

Partials

Partials refer to snippets of commonly rendered items across the application. The most common bit, being a hardware entry partial.

Hardware Entry

• Icon
• Name
• Rating (Both # and color)

Clicking on name, expands hardware entry to show:

• Description
• Manufacturer's URL
• Wiki Page URL
• Notes
• Attachments

More to come.