Updates on the TableView / DataGrid

[israel-dryer]

I'm working on the TableView / DataGrid features right now and thought I'd share some exciting new features that will be in v2. This widget alone will allow you to create a simple app with CRUD operations and persistent storage in just a few lines of code.

Forms Included

I've added a new Form and FormDialog widget that is integrated into the table. What does this mean? It means you get a very easy and built-in way to add and edit data.

FYI - This very much still in development, so things may ultimately look or act differently...

Consider this example. I'm adding an empty dataset... but, I'm defining the shape of the columns.. and the shape of the Form.

With this small amount of code, I get a fully functional data grid with a form, backed by a SQLite database.

app = ttk.Window(themename="dark", size=(1200, 800))

columns = [
    {"text": "EmployeeNumber", "key": "EmployeeNumber", "anchor": "w"},
    {"text": "CompanyName", "key": "CompanyName"},
    {"text": "Employee", "key": "Employee", "required": True},
    {"text": "Description", "key": "Description"},
    {"text": "StartDate", "key": "StartDate", "dtype": "date"},
    {"text": "YearsOfService", "key": "YearsOfService", "dtype": "int"},
]

start = time.perf_counter()
grid = DataGrid(
    app,
    columns=columns,
    rows=[],
    page_size=200,
    show_yscroll=False,
    allow_export=True,
    export_options=['page', 'selection'],
    allow_edit=True,
)
grid.pack(fill="both", expand=True, padx=5, pady=5)

app.mainloop()

Query & Search

The searchbar, when activated, includes some search strategies that you can use. As before, the default search will search ALL columns.

Traditional search with options

Powerful SQL-based search

However, if you need something more surgical... you can use a SQL query.

Context Menus

I'm updating the context menus for headers & cells. However, I'm also working on an idea for a customizable toolbar, which could be very useful. Global table functions could be place there optionally instead of hiding everything behind a context menu.

Datasources

Several datasources are supported, including SQLite for in-memory and local storage (makes it easy to create a quick persistent application).

Also will support generic objects, CSV, TSV, JSON, and a few others.

Plug-ins will be provided by myself or the community down the road to support more robust data grid functionality. But, initially, I want to get the basics out there and then upgrade it from there.

Speed & Performance

Things are speeding up a lot.

Here are some benchmarks:

Preparing 2,000,997 records
DataGrid build time: 2.437s for 2,000,997 rows

Preparing 10,989 records
DataGrid build time: 0.268s for 10,989 rows

More to come

There are a lot of great features coming. As I said, I'm working out the features at this very moment, so I thought I'd share with you some of what's going on.

Let me know your thoughts as well as your ideas for this widget.

[rojalator]

Some features that would be handy (you've probably already thought of them):
Entire form read-only (so just for display), individual fields read-only.

[israel-dryer]

For sure. Individual fields can control the editor type, validation, disabled, read-only, visibility and really anything else the field widget exposes.

[israel-dryer]

Grouping

Added Group by This Column feature, which will automatically sort and group by the selected column.

Column Chooser

Added a column chooser to make hide columns in bulk easier (though you can set the default visibility in config).

Column Filters

I'm experimenting with column level filters. This one still needs some thought though because on very large datasets it would be quite unusable without some kind of paged remote operations. However, maybe just a simple search box to search a specific column, or perhaps this works for "Enum" type values. Could also adds some smart filter types for numbers, dates, etc...

[TheDemonGuard]

Thank you for the heads up. Grouping is really useful feature.