INCATools / semantic-sql

SQL and SQLite builds of OWL ontologies
https://incatools.github.io/semantic-sql/
BSD 3-Clause "New" or "Revised" License
37 stars 3 forks source link

Add a duckdb export or convert base layer to duckdb #82

Open cmungall opened 4 months ago

cmungall commented 4 months ago

Duckdb has a lot of advantages over sqlite

In theory there is no particular reason for a duckdb export. You can just point duckdb at any of the semsql builds and it works. But there are some oddities that occur and it would be better to have a dedicated duckdb export

This could be a simple mirror of the sqlite. However, there is the opportunity to take advantage of increased expressivity. For example, we could have tables like

CREATE TABLE term_info (
   id VARCHAR,
   label VARCHAR,
   aliases VARCHAR[],
   ....
)