2025-07-23 –, Main Room 3
TidierDB.jl is a 100% Julia implementation of the dbplyr and duckplyr R packages, and similar to Python's ibis package.
The main goal of TidierDB.jl is to bring the syntax of Tidier.jl to multiple SQL backends, making it possible to analyze data directly on databases (or locally) without copying the database/file into memory.
TidierDB supports 12 different database backends (DuckDB, ClickHouse, Postgres, databricks, Snowflake, Oracle...) and multiple sql dialects. This means that knowing TidierData syntax for Dataframes immediately gives a user to the ability work with data on any of the supported backends without learning sql or new syntax.
With DuckDB as the default backend, .parquet, .json, .csv, iceberg, delta, geoparquet, and google sheets data can all be analyzed without ever reading the data into memory, regardless of size.
TidierDB supports complex queries, equi and non equi joins, joining queries, grouped window functions, sql views etc.
Since TidierDB leverages non standard evaluation, every sql function and any user defined function
can be effortlessly blended directly into TidierDB @mutate and @summarize calls.
