Do you support or do you have any plans to support the ability to read/write files to DuckDB. There is an ODBC driver is that the best solution? So far have been unable to get the ODBC driver to work and Easymorph doesn't display any errors when trying to create table or insert data.
Importing from DuckDB should work if you use the "Other SQL" dialect and the ODBC driver from DuckDB. Note that the "Other SQL" dialect only allows writing custom SQL queries. The visual query builder is not available for this dialect. Also, make sure you use the 64-bit ODBC driver, not the 32-bit one.
For other operations to work, such as export to DuckDB and creating tables, we should add support for the DuckDB SQL dialect. It won't work with the "Other SQL" dialect. Unless DuckDB's dialect is ANSI-compliant - in this case you can try using the ANSI:SQL dialect.
We see many advantages to supporting duckDB and the various extensions it provides. One extension that could really help Easymorph is the Spatial extension that supports GDAL and would allow reading/writing of gis files and enable spatial operations ie find all the records within 1km of a location. All using relatively straightforward SQL syntax
The ODBC driver is interesting in that you don’t actually need a file to read/write from. It can create an in memory virtual instance that can connect to a wide variety of data sources.
1 Like