home  wiki

HardwareDatabase

The old Hardware Database was hopeless at helping people find a device based on a set of criteria. We need a database type application that is able to store all relevant details about various pieces of hardware in an easy to manage (but technically correct) fashion.

Lets start by defining a database schema to store information about various wireless devices. If you know about how wireless devices are put together and know a little about database design, then please help by contributing to the schema design and discussion.

For the time being use this Hardware-Template to create wiki pages for hardware your reviewing. Just switch to edit mode on the page and copy the
content to the clipboard, then paste it into a new page.



TABLES

Hardware

*device
generation (ie 802.11b/g/c) Secondary Primary Key
manufacturer
chipset
antenna_connector
comments
rx_sens
tx_pwr
FOREIGN KEY generation REFERENCES TABLE Generation
FOREIGN KEY manufacturer REFERENCES TABLE Manufacturer
FOREIGN KEY chipset REFERENCES TABLE Chipset

Manufacturer

*manufacturer
website
comments

Chipset

*chipset
generation
manufacturer
driver_location_1
driver_location_2
comments
FOREIGN KEY manufacturer REFERENCES TABLE Manufacturer
FOREIGN KEY generation REFERENCES TABLE Generation


Generation

*802.11?
frequency
TX_RX_speed_1
TX_RX_speed_2
TX_RX_speed_3
TX_RX_speed_4
max_txpower
comments

gen-device-table

*device
*supported_generation
FOREIGN KEY device REFERENCES TABLE Hardware
FOREIGN KEY supported_generation REFERENCES TABLE Generation

connection_type

*device
*type (usb/pci/eth/firewire)
FOREIGN KEY device REFERENCES TABLE Hardware

OS_support

*device
*OS
FOREIGN KEY device REFERENCES TABLE Hardware

same as

*manufacturer
*device

(* = primary key)

Discussion


I think it would work better by abstracting the 'radio' from hardware.
This way we can support : plain cards(just a radio entry), router units (hardware with potentially multiple radios, removable cards), and non-radio devices like antennas.

HardwareDB

Comments welcome! -- Tom Fifield



Version 40 (current) modified Mon, 26 Jul 2021 12:49:29 +0000
[EditText] [Spelling] [Current] [Raw] [Code] [Diff] [Subscribe] [VersionHistory] [Revert] [Delete] [RecentChanges]
> home> about> events> files> members> maps> wiki board   > home   > categories   > search   > changes   > formatting   > extras> site map

Username
Password

 Remember me.
>

> forgotten password?
> register?
currently 0 users online
Node Statistics
building132
gathering192
interested515
operational242
testing216