title: Simplest way to create a tiny database app in linux
body: <p>I'm looking to create a very small cataloguing app for personal use (although I'd open source it if I thought anyone else would use it). I don't want a web app as it seems like overkill to have an application server just for this - plus I like the idea of it being standalone and sticking it on a USB stick.</p>
  
  <p>My Criterea:</p>
  
  <ul>
  <li>Interface must be simple to program. It can be curses-style if that makes it easer to code. My experience with ncurses would suggest otherwise, but I'd actually quite like a commanline UI.</li>
  <li>Language doesn't really matter. My rough order of preference (highest first):
  
  <ul>
  <li>Python</li>
  <li>C</li>
  <li>C++</li>
  <li>Java</li>
  <li>I'll consider anything linux-friendly</li>
  </ul></li>
  <li>I'm thinking sqlite for storage, but other (embeddable) suggestions welcome.</li>
  </ul>
  
  <p>Has anyone done this sort of thing in the past? Any suggestions? Pitfalls to avoid?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>Ok, it looks like python+sqlite is the early winner. That just leaves the question of which ui library. I know you get tkinter for free in python - but it's just so ugly (I'd rather have a curses interface). I've done some GTK in C, but it looks fairly un-natural in python. I had a very brief dabble with wxwidgets but the documentation's pretty atrocious IIRC (They renamed the module at some point I think, and it's all a bit confused).</p>
  
  <p>So that leaves me with pyqt4, or some sort of console library. Or maybe GTK. Thoughts? Or have I been too hasty in writing off one of the above?</p>