Re: [pysqlite] variable number of fields updates

Gerhard Häring wrote:

> Short answer. Use an ORM - I recommend SQLAlchemy.
> 
> Long answer: you can also build your own, half-assed solution :-P

I was afraid of that.  your advice makes sense if I was writing a database
intensive program.  Here's the quandary for me.  from what I've seen an ORM is
an order of magnitude larger than what I'm talking about building.  an ORM
carries the burden of hours or days of trying to figure out how the ORM works
and to get it to do what you want to do without learning yet another god-awful
code base.  the learning is not just a one time event.  I don't use SQL enough
that I remember much between uses and need to relearn a significant portion
every time.  If you add the complexity of an ORM on top, the reeducation time
becomes pretty significant.

In the meantime, I think I worked out a solution which is to use a very limited
record creation with the minimum information necessary and always write all the
data all the time when I do updates on any field.


---eric