Hi Philip, Hi Rasjid,

There are already at least one killer PyXPCOM application with open 
source: Komodo Edit. We, the rest of the public here, just are too lazy 
or too busy to roll things forward. Personally, I am living with plans 
to start work for quality data editing client from exactly 3 years.

@Rasjid:

Like Philip, I am also thinking that right way to building efficient 
databound control for mozilla is to use xul:tree visualizing sqlite 
datacache (client side recordsets):

  1) sqlite recordsets: query to DB (or Data service in general) and 
store resulting recordsets in sqlite table(s). Additionally, make 
mechanism for additional "live" querying during pagination/searching for 
filling the cache tables on demand, for data sources which can support 
this efficient (live) mode of operation (which support offset/page and 
search queries).

  2) Create additional "live" (added and/or appended on demand) tables 
for different (at least main) row orders, because custom view mode of 
xul:tree (which must be used) queries implementation with absolute row 
index like (1,2,3 or 23456) (for first tests you may skip this, using 
sqlite offset selects)

  3) treeview haven't editing, but it is enough to stack xul:tree with 
flaying "editing carets" (like divs with higher z-index in html) for 
different editor types (combo boxes, date/number text fields, etc ...). 
  Believe me - stack approach (editing caret over base view "canvas") 
for data editing, gives you many more possibilities, than out of the box 
scoped MS Access datasheet for example. (By the way, list part of combo 
box of course can also be realized with xul:tree with same databinding 
mechanism as datagrid).

For all work that need to be done for datagrid, there are also tons of 
reference source around - sqlite manager extension [1], modern ajax 
frameworks (for cell editors implementation), etc ...

By the way, datagrid and data bound combo-box are not enough to assemble 
high quality data interfaces - that is the just MS Access level, other 
mandatory "library" (not application specific) components include: 
inter-control mutual data binding/synchronization, drill-down report 
component, and a number of other small things, but anyway, I also think 
that easiest platform to achieve this level is exactly Mozilla/PyXCPOM.

Rasjid (and other data-centric people here), if you are going to start 
something in direction of data bound controls on top of the XUL/PyXPCOM 
you can place your work at Bitbucket [2] or some of other DVCS services 
and I (probably not only) will at least following your work.

Cheers,
Alek

[1] http://code.google.com/p/sqlite-manager/
[2] http://bitbucket.org/. GitHub is great also of course, but Mercurial 
is more appropriate for Mozilla/Python related list and effort, doesn't 
it :-)

Please forgive me the pain from my English :-)

>  
>  I wish you the best and hope you write the killer app that makes  
>  everyone notice PyXPCOM. It'd be nice to see it get more traction and  
>  build a big user base.
>  

_______________________________________________
pyxpcom mailing list
pyxpcom@[...].com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs