[Pyobjc-dev] SQLite and PyObjC

[John V. <ve...@co...>]

I'm hoping to write a Cocoa application with PyObjC that uses an sqlite
database.  I will want browse views that show (multilple row) results of a
query, as well as forms for data entry or editing, and output of reports in
pdf format.  I need to develop on Leopard intel, and run on Tiger PPC.
(I've looked at a couple of other approaches, but they each have problems,
and I aesthetically like the idea of PyObjC with Cocoa.  Thanks to the
PyObjC developers!)

I'm probably in way over my head.  But here are a couple of initial
questions:

1.  Which is better to use for the sqlite interface, the Xcode interface to
sqlite, or the Python interface?  If Xcode is better, how the heck can I
find some documentation? Googling or searching in the developer
documentation hasn't gotten me there yet.  Probably because I don't know
the right search words. The amount of Apple documentation is enormous.

Also, some documentation that won't be too hard to translate to use with
PyObjC?

2. For display of tabular query results, is NSTableView the "best" way to
go?   I've had a quick scan of the "Understanding the NSTableView Class,
and a look at one of the examples, and I'm overwhelmed.  I don't need to
edit this in place.  One alternative would appear to be formatting into
columns in Python, and use some form of NSBrowser or NSTextView.

I think I can handle input and edit forms.  If I can convince myself that I
can handle using sqlite in the Model, and some form of browser as a view,
I'll press on!

Thanks,

John Velman