Using examples, this project is just a quick reminder of the main SQL commands you need to know to work effectively in the data professions. The SQL queries are made with DuckDB and written in a ...

This example loads data to a vector layer from an SQL geometry data source. Once you edit vector layer items, changes are saved to the data source. Assign this object to the VectorItemsLayer.Data ...

This example is almost identical to text based individual column example and provides the same functionality, but in this case using select input controls.. After the table is initialised, the API is ...

DataTables example Server-side processing. There are many ways to get your data into DataTables, ... ordering etc actions that DataTables performs are handed off to a server where an SQL engine (or ...