DuckDB - add support (by plugin)

KrzysztofDusko / JustyBase

SQL editor/IDE

GNU General Public License v3.0

9 stars 0 forks source link

DuckDB - add support (by plugin) #333

Open KrzysztofDusko opened 3 weeks ago

KrzysztofDusko commented 3 weeks ago

DuckDB DuckDB is a fast in-process analytical database DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs

KrzysztofDusko commented 2 weeks ago

Thanks to https://github.com/Giorgi/DuckDB.NET. basic support id done. For in memory: for persistent mode

KrzysztofDusko commented 2 weeks ago

possibilities and performance with DuckDB are crazy..

SELECT 
    T2.ENGLISHDAYNAMEOFWEEK
    , COUNT(DISTINCT T1.PRODUCTKEY)
    , COUNT(1)
    , SUM(COUNT(1)) OVER ()::INT AS GLOBAL_COUNT
    , (SUM(COUNT(DISTINCT T1.PRODUCTKEY)) OVER ())::INT AS WINDOW_TEST
FROM 'D:\tabela.parquet' T1
JOIN 'D:\DIMDATE.CSV' T2 ON T1.DATEKEY = T2.DATEKEY
GROUP BY 
    T2.ENGLISHDAYNAMEOFWEEK