Request for sample wxGrid-SQLite application

wxPython Users
#1

Hi,

I know this is 'a bit of an ask/cheeky' but is anyone willing to provide a working sample of a wxpython frame with a grid that presents the data from a table stored in an sqlite database.

I have spent months trying to nut this one out but have not found any good tutorials or resources that fill in the gaps. I have learned how to connect databases and manipulate various open source databases (e.g. sqlite, postgresql) using python but can't seem to figure out how to populate a grid in a window (rather than text boxes representing individual fields in a record).

Essentially all I want in the example is the skeleton of how to open a table, allow changes in the grid and to save the data back again. Once I have the basic commands I will be able to experiment and thrash out the other functionality (hopefully).

Any help would be appreciated.

···

--
Cheers Simon

    Simon Cropper - Open Content Creator / Website Administrator

    Free and Open Source Software Workflow Guides
    ------------------------------------------------------------
    Introduction http://www.fossworkflowguides.com
    GIS Packages http://gis.fossworkflowguides.com
    bash / Python http://scripting.fossworkflowguides.com

#2

I can’t say I have a working example yet, but this is exactly what I’ve been working on. I have multiple tables, some of which originate in wx.TextCtrl, and some of which originate in Grid Cell Controls. In no case does the data go directly from the control to the database, there is always an intermediate step of placing the data in a list prior to using the sqlite3 execute method. My main struggle is with the intensive validation routines I need to apply – some are simple validators, others require methods to evaluate certain fields with respect to other fields prior to allowing them to be saved.

I’ve been pulling my hair out for weeks, and now that I’ve gone bald, it seems like my main breakthrough came only today, and I got some of the grid controls to do what I wanted.

I’m attaching my still-incomplete panel that contains individual fields plus a grid, although the database functions and the initial frame and app setups are in different modules.

It’s very primitive, the Python implementation and the overall design are far from elegant, and I’m frankly a bit embarrassed to post it, but it does at least seem to be working as far as it’s gotten so far. With luck, you may find some value in it.

rungrid.py (31.5 KB)

···

On Friday, June 1, 2012 9:07:26 PM UTC-7, Simon Cropper wrote:

Hi,

I know this is ‘a bit of an ask/cheeky’ but is anyone willing to provide
a working sample of a wxpython frame with a grid that presents the data
from a table stored in an sqlite database.

I have spent months trying to nut this one out but have not found any
good tutorials or resources that fill in the gaps. I have learned how to
connect databases and manipulate various open source databases (e.g.
sqlite, postgresql) using python but can’t seem to figure out how to
populate a grid in a window (rather than text boxes representing
individual fields in a record).

Essentially all I want in the example is the skeleton of how to open a
table, allow changes in the grid and to save the data back again. Once I
have the basic commands I will be able to experiment and thrash out the
other functionality (hopefully).

Any help would be appreciated.

–
Cheers Simon

Simon Cropper - Open Content Creator / Website Administrator



Free and Open Source Software Workflow Guides

------------------------------------------------------------

Introduction               [http://www.fossworkflowguides.com](http://www.fossworkflowguides.com)

GIS Packages               [http://gis.fossworkflowguides.com](http://gis.fossworkflowguides.com)

bash / Python        [http://scripting.fossworkflowguides.com](http://scripting.fossworkflowguides.com)
1 Like
#3

Hi,

Hi,

I know this is 'a bit of an ask/cheeky' but is anyone willing to provide a working sample of a wxpython frame with a grid that presents the data from a table stored in an sqlite database.

I have spent months trying to nut this one out but have not found any good tutorials or resources that fill in the gaps. I have learned how to connect databases and manipulate various open source databases (e.g. sqlite, postgresql) using python but can't seem to figure out how to populate a grid in a window (rather than text boxes representing individual fields in a record).

Essentially all I want in the example is the skeleton of how to open a table, allow changes in the grid and to save the data back again. Once I have the basic commands I will be able to experiment and thrash out the other functionality (hopefully).

Any help would be appreciated.

You might want to look at Dabo - http://dabodev.com/

Mike and I had put some sample application together to show how to work with a database and wxPython, also it does not use a grid but instead uses a ObjectListView (a wrapper around wx.ListCtrl). https://bitbucket.org/driscollis/medialocker

I personally don't like to let user edit data in a grid, but if that is a must IIRC you can configure the OLV to allow cell editing.

We didn't use Dabo, instead used SQLAlchemy to access the database, which I can only recommend. In my view it simplifies data access a lot and has lots and lots of very nice functionality and the support provided by Michael Bayer is just incredible.

Werner

···

On 02/06/2012 06:07, Simon Cropper wrote:

#4

Dave,

Lots of code.

To date I have been pushed to look at wxPyGridTableBase

() and it looks as if it
might do the job.
Personally, it seems cumbersome to have to collect all your data and
insert them in a grid only to back track before reinserting them
back into a database. I sort of expect after years and years of having 4 generation
database languages that you could point to a datasource and get the
data automatically managed by a library. Obviously I am a bit naive
here. Sometimes I feel I must be reinventing the wheel, other people
must access tables and allow the user to manipulate the data. Does
everyone rewrite the code from scratch? On 02/06/12 16:08, llanitedave wrote:

···

http://wiki.wxpython.org/wxPyGridTableBase

  I can't say I have a working example yet, but this is

exactly what I’ve been working on. I have multiple tables, some
of which originate in wx.TextCtrl, and some of which originate in
Grid Cell Controls. In no case does the data go directly from the
control to the database, there is always an intermediate step of
placing the data in a list prior to using the sqlite3 execute
method. My main struggle is with the intensive validation
routines I need to apply – some are simple validators, others
require methods to evaluate certain fields with respect to other
fields prior to allowing them to be saved.

    I've been pulling my hair out for weeks, and now that I've

gone bald, it seems like my main breakthrough came only today,
and I got some of the grid controls to do what I wanted.

    I'm attaching my still-incomplete panel that contains

individual fields plus a grid, although the database functions
and the initial frame and app setups are in different modules.

    It's very primitive, the Python implementation and the

overall design are far from elegant, and I’m frankly a bit
embarrassed to post it, but it does at least seem to be working
as far as it’s gotten so far. With luck, you may find some
value in it.

    On Friday, June 1, 2012 9:07:26 PM UTC-7, Simon Cropper wrote:

      Hi,




      I know this is 'a bit of an ask/cheeky' but is anyone willing

to provide

      a working sample of a wxpython frame with a grid that presents

the data

      from a table stored in an sqlite database.




      I have spent months trying to nut this one out but have not

found any

      good tutorials or resources that fill in the gaps. I have

learned how to

      connect databases and manipulate various open source databases

(e.g.

      sqlite, postgresql) using python but can't seem to figure out

how to

      populate a grid in a window (rather than text boxes

representing

      individual fields in a record).




      Essentially all I want in the example is the skeleton of how

to open a

      table, allow changes in the grid and to save the data back

again. Once I

      have the basic commands I will be able to experiment and

thrash out the

      other functionality (hopefully).




      Any help would be appreciated.




      --

      Cheers Simon




          Simon Cropper - Open Content Creator / Website

Administrator

          Free and Open Source Software Workflow Guides


          ------------------------------          ------------------------------


          Introduction               [http://www.fossworkflowguides.com](http://www.fossworkflowguides.com)


          GIS Packages               [http://gis.fossworkflowguides.com](http://gis.fossworkflowguides.com)


          bash / Python        [http://scripting.fossworkflowguides.com](http://scripting.fossworkflowguides.com)

–

  To unsubscribe, send email to

or visit


   -- Cheers Simon
Simon Cropper - Open Content Creator / Website Administrator
Free and Open Source Software Workflow Guides
------------------------------------------------------------
Introduction GIS Packages bash / Python

wxPython-users+unsubscribe@googlegroups.com
http://groups.google.com/group/wxPython-users?hl=enhttp://www.fossworkflowguides.comhttp://gis.fossworkflowguides.comhttp://scripting.fossworkflowguides.com

#5

POINT 1 (reposted from another post on the python users list)

I have investigated Dabo.

Dabo is OK but is like a big wizard.

You fix you underlying data structure then it creates basic menus,

data entry screens, etc. The basic stuff is OK but you need change
the
underlying code to customize the screens and you are bound to use
the
classes created by the developers (you can create you own but all
sorts
of interactions can happen apparently, and although it can be done,
care
needs to be taken to avoid conflicts – the recommendation by the
developers to is use the existing classes whenever possible).

On top of this the project is not being developed any more. What is

there, is what is there. The developers occasionally jump on the
forums
to propose a solution to an interesting problem but state that no
further development will be happening. The community is still active
however and there are a number of devotees.

POINT 2

I will look at the use of the ListCtrl but the preference would be

for a active editable grid.

POINT 3

SQLAlchemy does look good. The problem for me is not getting the

data from a database into a list it is how do I get it to be able to
be browsed in a window/frame in a grid similar to browsing a table
in dbase, foxpro, etc.

The objective eventually is to create a data mining application that

allows tables from a variaty of sources (csv, lists, dbf, MySQL, VFP
tables, PostgreSQL, sqllite) to be opened in grids - inspected,
filtered, merged, etc and the results sent to a table. I have seen
similar java apps like sqlworkbench
and I have seen something called than has a similar objective (although they
have gone the statistics route).

···

http://dabodev.com/
https://bitbucket.org/driscollis/medialocker
http://www.sql-workbench.net/Orangehttp://orange.biolab.si/


   -- Cheers Simon
Simon Cropper - Open Content Creator / Website Administrator
Free and Open Source Software Workflow Guides
------------------------------------------------------------
Introduction GIS Packages bash / Python

http://www.fossworkflowguides.comhttp://gis.fossworkflowguides.comhttp://scripting.fossworkflowguides.com

#6

Hi,

···

http://objectlistview.sourceforge.net/python/features.html

  POINT 3

  SQLAlchemy does look good. The problem for me is not getting the

data from a database into a list it is how do I get it to be able
to be browsed in a window/frame in a grid similar to browsing a
table in dbase, foxpro, etc.

  The objective eventually is to create a data mining application

that allows tables from a variaty of sources (csv, lists, dbf,
MySQL, VFP tables, PostgreSQL, sqllite) to be opened in grids -
inspected, filtered, merged, etc and the results sent to a table.
I have seen similar java apps like sqlworkbench
and I have seen something called than has a similar objective (although they have gone the
statistics route).
http://sqlkit.argolinux.org/
http://www.sql-workbench.net/Orangehttp://orange.biolab.si/

#7

Simon,

It would probably be worth taking a few days to look at the web2py application framework.

www.web2py.com

It is an awesome framework for web applications that do what you are talking about, but the

components within the framework don’t require that the application actually be web-based.

So rather than rendering the views via html (with embedded python code), you might be

able to render the same data via wxPython.

There is a database abstraction layer (DAL) that removes you from SQL statements, while

still allowing you to use customized SQL, and also allows you to inspect SQL statements

generated by the abstraction layer. Very helpful. I believe multiple data sources can be

incorporated into the model, transparent to the application, though I’ve not done it myself. But

the point is, the DAL is independent of the web-nature of web2py as a whole.

Anybody involved with web development and who is a Pythonista should check out web2py!

But even those who are developing non-web apps can find useful components.

Take a look.

(It’s fun just to be able to generate a multi-user database driven web-applicaiton within an hour

of downloading webwpy!)

Rufus

Rufus V. Smith
www.linkedin.com/in/rufusvsmith
rufusvsmith@gmail.com
860-884-8136

···

----- Original Message -----

From:
Simon Cropper

To: wxpython-users@googlegroups.com

Sent: Saturday, June 02, 2012 3:02 AM

Subject: Re: [wxPython-users] Request for sample wxGrid-SQLite application

On 02/06/12 16:30, Werner wrote:

Hi,

On 02/06/2012 06:07, Simon Cropper wrote:

Hi,

  I know this is 'a bit of an ask/cheeky' but is anyone willing to provide a working sample of a wxpython frame with a grid that presents the data from a table stored in an sqlite database.

  I have spent months trying to nut this one out but have not found any good tutorials or resources that fill in the gaps. I have learned how to connect databases and manipulate various open source databases (e.g. sqlite, postgresql) using python but can't seem to figure out how to populate a grid in a window (rather than text boxes representing individual fields in a record).

  Essentially all I want in the example is the skeleton of how to open a table, allow changes in the grid and to save the data back again. Once I have the basic commands I will be able to experiment and thrash out the other functionality (hopefully).

Any help would be appreciated.

You might want to look at Dabo - http://dabodev.com/

Mike and I had put some sample application together to show how to work with a database and wxPython, also it does not use a grid but instead uses a ObjectListView (a wrapper around wx.ListCtrl).  [https://bitbucket.org/driscollis/medialocker](https://bitbucket.org/driscollis/medialocker)


I personally don't like to let user edit data in a grid, but if that is a must IIRC you can configure the OLV to allow cell editing.

We didn't use Dabo, instead used SQLAlchemy to access the database, which I can only recommend.  In my view it simplifies data access a lot and has lots and lots of very nice functionality and the support provided by Michael Bayer is just incredible.

Werner

POINT 1 (reposted from another post on the python users list)
I have investigated Dabo.
Dabo is OK but is like a big wizard.
You fix you underlying data structure then it creates basic menus, data entry screens, etc. The basic stuff is OK but you need change the underlying code to customize the screens and you are bound to use the classes created by the developers (you can create you own but all sorts of interactions can happen apparently, and although it can be done, care needs to be taken to avoid conflicts – the recommendation by the developers to is use the existing classes whenever possible).
On top of this the project is not being developed any more. What is there, is what is there. The developers occasionally jump on the forums to propose a solution to an interesting problem but state that no further development will be happening. The community is still active however and there are a number of devotees.
POINT 2
I will look at the use of the ListCtrl but the preference would be for a active editable grid.
POINT 3
SQLAlchemy does look good. The problem for me is not getting the data from a database into a list it is how do I get it to be able to be browsed in a window/frame in a grid similar to browsing a table in dbase, foxpro, etc.
The objective eventually is to create a data mining application that allows tables from a variaty of sources (csv, lists, dbf, MySQL, VFP tables, PostgreSQL, sqllite) to be opened in grids - inspected, filtered, merged, etc and the results sent to a table. I have seen similar java apps like sqlworkbench http://www.sql-workbench.net/ and I have seen something called Orange http://orange.biolab.si/ than has a similar objective (although they have gone the statistics route).


   -- Cheers Simon
Simon Cropper - Open Content Creator / Website Administrator
Free and Open Source Software Workflow Guides
------------------------------------------------------------
Introduction [http://www.fossworkflowguides.com](http://www.fossworkflowguides.com)
   GIS Packages [http://gis.fossworkflowguides.com](http://gis.fossworkflowguides.com)
   bash / Python [http://scripting.fossworkflowguides.com](http://scripting.fossworkflowguides.com)

–
To unsubscribe, send email to wxPython-users+unsubscribe@googlegroups.com
or visit http://groups.google.com/group/wxPython-users?hl=en

#8

Simon,

···

http://www.turbogears.org/2.2/docs/
http://www.pylonsproject.org/

http://code.google.com/p/formalchemy/
http://www.turbogears.org/2.2/docs/extensions.html

http://www.python-camelot.com/

#9

Lots of web-based applications. Not really what I was looking for
but I will review all to see if they can be used – I can always use
a localhost.

To date the sqledit/sqlkit appears to be the most interesting.
···

http://www.turbogears.org/2.2/docs/
http://www.pylonsproject.org/

http://code.google.com/p/formalchemy/
http://www.turbogears.org/2.2/docs/extensions.html

http://www.python-camelot.com/

wxPython-users+unsubscribe@googlegroups.com
http://groups.google.com/group/wxPython-users?hl=en


   -- Cheers Simon
Simon Cropper - Open Content Creator / Website Administrator
Free and Open Source Software Workflow Guides
------------------------------------------------------------
Introduction GIS Packages bash / Python

http://www.fossworkflowguides.comhttp://gis.fossworkflowguides.comhttp://scripting.fossworkflowguides.com

#10

As a follow-up I have found some code for using SQLite here…

The project was buried in the list of projects that use wxPython.

Funny how searching similar lists on the python site, sqlite site
and sourceforge site I did not find this project. Anyway it is a
basic skeleton that can be used.
I have also been impressed with the suggestion of SQLKit/SQLEdit
mentioned. Although not using wxPython, it reaffirms my impression
that all database work should actually use SQLAlchemy (just for the
ease of acquiring and using a wide variety of relational databases).
I am still searching for some good examples of people using the
wxPyGridTableBase ().
In my travels though I have found a what looks like a great
alternative to SQLWorkbench written in Python+wxPython. It is called
Picalo (). I also found a great tutorial showing how to use wxPython with
SQLAlchemy and ObjectListView
().
Coupled with the links provided elsewhere in this thread using
ObjectListView to present tabular data seems to be better
alternative to wx.Grid as it is better supported, implemented and .

···

http://sourceforge.net/projects/sqlxpress/

http://wiki.wxpython.org/wxPyGridTableBase

http://www.picalo.org/

http://www.blog.pythonlibrary.org/2011/11/10/wxpython-and-sqlalchemy-an-intro-to-mvc-and-crud/documented


   -- Cheers Simon
Simon Cropper - Open Content Creator / Website Administrator
Free and Open Source Software Workflow Guides
------------------------------------------------------------
Introduction GIS Packages bash / Python

http://www.fossworkflowguides.comhttp://gis.fossworkflowguides.comhttp://scripting.fossworkflowguides.com

#11

Have you considered using Dabo (www.dabodev.com). It was designed to ease the associations between wxpython widgets/controls and data.

Johnf

···

On 06/01/2012 09:07 PM, Simon Cropper wrote:

Hi,

I know this is 'a bit of an ask/cheeky' but is anyone willing to provide a working sample of a wxpython frame with a grid that presents the data from a table stored in an sqlite database.

I have spent months trying to nut this one out but have not found any good tutorials or resources that fill in the gaps. I have learned how to connect databases and manipulate various open source databases (e.g. sqlite, postgresql) using python but can't seem to figure out how to populate a grid in a window (rather than text boxes representing individual fields in a record).

Essentially all I want in the example is the skeleton of how to open a table, allow changes in the grid and to save the data back again. Once I have the basic commands I will be able to experiment and thrash out the other functionality (hopefully).

Any help would be appreciated.

#12

John,

Yes. Being Visual Foxpro Developer myself Dabo was the obvious choice as it was created by two people that were themselves originally well known VFP developers and who developed Dabo in response to their needs for a RAD environment in Linux.

Several points make this project unsuitable (in my mind)...
1. The project is not being developed anymore. Ed Leafe and Paul McNett are providing bug fixes but my conversations with them clearly indicates that they were not developing the package anymore. A quick review of the website indicates most things are years old.
2. The project is designed to create desktop applications. That is, you design a database and it creates a basic skeleton of an application for you that you can customize. It excels at this.
3. All customization, as is always their nature, are hybrids between the new developer and the existing classes. Most problems posted on the Dabo forum when I was evaluating the project were asking for help to get customizations to "play well" with the established code.
4. I need greater flexibility to query a database and present its contents in a grid. As Dabo requires you to specify the initial database structure prior to screen/application creation, it does not lend itself to adhoc on the fly database connections and data presentation. This could probably be done but required a developer to push and pull a significant amount of code to get it to work within the existing 3-Teired Design Framework that Dabo is based on.

···

On 04/06/12 23:54, fabiani.john@gmail.com wrote:

On 06/01/2012 09:07 PM, Simon Cropper wrote:

Hi,

I know this is 'a bit of an ask/cheeky' but is anyone willing to
provide a working sample of a wxpython frame with a grid that presents
the data from a table stored in an sqlite database.

I have spent months trying to nut this one out but have not found any
good tutorials or resources that fill in the gaps. I have learned how
to connect databases and manipulate various open source databases
(e.g. sqlite, postgresql) using python but can't seem to figure out
how to populate a grid in a window (rather than text boxes
representing individual fields in a record).

Essentially all I want in the example is the skeleton of how to open a
table, allow changes in the grid and to save the data back again. Once
I have the basic commands I will be able to experiment and thrash out
the other functionality (hopefully).

Any help would be appreciated.

Have you considered using Dabo (www.dabodev.com). It was designed to
ease the associations between wxpython widgets/controls and data.

Johnf

--
Cheers Simon

    Simon Cropper - Open Content Creator / Website Administrator

    Free and Open Source Software Workflow Guides
    ------------------------------------------------------------
    Introduction http://www.fossworkflowguides.com
    GIS Packages http://gis.fossworkflowguides.com
    bash / Python http://scripting.fossworkflowguides.com

#13

Hi,

Just for fun, I wrote a simple application that can load up a simple SQLite database and display its table data using the ObjectListview widget: http://www.blog.pythonlibrary.org/2012/06/04/wxpython-and-sqlalchemy-loading-random-sqlite-databases-for-viewing/

I didn’t get it to work with Mozilla’s places database yet, but I suspect I could get it to with a little tweaking. Anyway, it’s a proof-of-concept that should at least show you one approach for it.

···

Mike Driscoll

Blog: http://blog.pythonlibrary.org

1 Like
#14

1. Maybe - but we continue to get major changes and improvements. I find it strange that Ed and Paul would take the time to make major changes to code if they considered the package dead. The biggest issue I see is actually wxPython not advancing with the rest of the python world. Recently, wxPython for python 3.x was announced so I think we will see Dabo support for python 3.x soon after wxPython for python 3 becomes stable. If you are concerned with the age of the code - then be very concerned with wxPython because the basic code has been around for many years with little change. And just like Dabo, Robin has made many improvements over the years. After thought: Paul is making his living using Dabo! why would he not improve the code as long as he is making a living using it?

2. "it creates a basic skeleton of an application" - It sounds like you used AppWizard. I never use AppWizard nor do I use ClassDesigner. I just hand code my stuff. And I use both Dabo classes and direct wxPython widgets. I have had issues recently with all the new performance changes and new data rules. But I believe they are fixed at this time. BTW you realize that you have to hand code wxPython!

3. OK - but how was that different then the questions on UT (Universal Thread - VFP programmers home)

4. I've heard that from someone in the past. I have no idea why you believe that about Dabo. I use direct sql statements constantly, create dynamic connections to MySql, MsSQL, and Postgres all the time. About 40% of my grids use dynamic datasets. In fact my lookup grid data is always dynamic. "push and pull a significant amount of code" - again I don't understand. It takes at the most two lines of code to make a connection to any database. If you make a dynamic connection to a database - just create the sql to retrieve the dataset and update the grid. It is not difficult - at least in my mind.

The biggest issue I find with Dabo is the lack of good Doc's. The biggest issue for new users has been AppWizard and ClassDesigner. AppWizard was written to demo Dabo - not an example of how to code a Dabo application. All the IDE's have some sort of 30 second way of creating a demo app (VFP, Ruby on Rails, QT, etc..) and AppWizard was that simple demo. Like with VFP very few used the demo way to creating apps. ClassDesigner was written to assist users in creating UI's. Although I do NOT use ClassDesigner I believe you can create very good UI's and complete programs.

I hope you will revisit Dabo and ask me how to do things. At first the learning curve is high (just as it is with wxPython) but soon it will become very easy. I currently have a student that has picked up Dabo in two days. He is the exception but that does tell you it can be done in a short time.

Johnf

···

On 06/04/2012 04:58 PM, Simon Cropper wrote:

Yes. Being Visual Foxpro Developer myself Dabo was the obvious choice as it was created by two people that were themselves originally well known VFP developers and who developed Dabo in response to their needs for a RAD environment in Linux.

Several points make this project unsuitable (in my mind)...
1. The project is not being developed anymore. Ed Leafe and Paul McNett are providing bug fixes but my conversations with them clearly indicates that they were not developing the package anymore. A quick review of the website indicates most things are years old.
2. The project is designed to create desktop applications. That is, you design a database and it creates a basic skeleton of an application for you that you can customize. It excels at this.
3. All customization, as is always their nature, are hybrids between the new developer and the existing classes. Most problems posted on the Dabo forum when I was evaluating the project were asking for help to get customizations to "play well" with the established code.
4. I need greater flexibility to query a database and present its contents in a grid. As Dabo requires you to specify the initial database structure prior to screen/application creation, it does not lend itself to adhoc on the fly database connections and data presentation. This could probably be done but required a developer to push and pull a significant amount of code to get it to work within the existing 3-Teired Design Framework that Dabo is based on

#15

Werner,

I am interested too in dealing data in tabular form. I am not familiar wirh ObjectListView. Does it allow to easily hide some data for the user or use more human comprehensive informations and keep the data ID in the back?

To be more clear, my data model is split in several tables. On core table cotains foraign keys. I want to present the text in front of this key in the bind table. (exemple: a user ID corresponding to name - first name)
In reverse, in case of modification / update we can select only user in the data base. So a drop down list is need in order to return the corresponding user ID. But can it be done in a grid or in an ObjectListView?

EDIT: thaught I found out some documentation with the GridCellEditor. But I have to look how it works and how put it in practice. Any exemple of use?

Last but not least, the links you provide seems not valide, break or malicius. Can you update?

Alexis