[<<][sql][>>][..]

Tue Apr 1 21:59:20 EDT 2014

2013 taxes - what did we learn?

- mysql workbench is a nice tool for low-level editing

- for most things though, you want a custom editor:
  i made a "row connect" tool using python pyside qt sql tableview

- didn't figure out how to make html table forms using racket.  harder
  than it seems..

- don't edit generated / converted data.  it's still a pain, but much
  better to put manual entries in a separate table and join it into a
  view.

- when making complex projections, also check complements as:
  select * from tab where key not in (select key from tab_proj);

- writing reports is a pain: take some time for it!

- still didn't figure out a good way to print a simple table to a pdf
  document.  main problem seems to be setting the column widths when
  using wrap-around text.  should be easy to compute by allowing a
  "max lines" wraparound.

[Reply][About]

[<<][sql][>>][..]