...

• SQLiteBrowser
  • I've used this and it works fine.

Best practices

How/when to use particular data types

• Enum data types
  • Use reference tables
    • http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/
    • IIRC this is what was done at ServiceFusion

How/when to use ER Diagrams

• https://news.ycombinator.com/item?id=31255800
  • There're some good comments in there from people who have done a lot of ER diagrams talking about the best ways to use an ER diagram and the best software to do it with.

...