This example, originally written by Giuseppe Costanzi, demonstrates how to use the wx.ListCtrl* widget with an SQLite 3 database, including:
- Create SQLite database
- Insert records
- Update records
- Delete records
- Sort records
…
*Note: If you are using a large database, a virtual list control is highly recommended.
-
Original source for python 2.7 and wxpython Classic 3.0.2:
List_of_employees_v0.0.1.zip (6.4 KB) -
Source updated for python 3.11.9 and wxpython Phoenix 4.2.3 without data sorting:
List_of_employees_v0.0.2.zip (24.7 KB) -
Source updated for python 3.11.9 and wxpython Phoenix 4.2.3 with data sorting:
List_of_employees_v0.0.3.zip (27.2 KB)
This application is cross-platform compatible and has been successfully tested on the following operating systems:
- Windows 10/11 | Python 3.11.9 |
wxPython 4.2.3 | wxWidgets 3.2.6 - Linux Mint 21 | Python 3.10.12 |
wxPython 4.2.1 gtk3 | wxWidgets 3.2.2.1 - MacOS Sequoia 15 | Python 3.12.4 |
wxPython 4.2.2 | wxWidgets 3.2.6
Regards