In 2 days, after 23 months, we get Robert Citek back as a speaker!
On Thurs, he'll speak on 2 different, unrelated topics.
Two tutorials/demonstrations.
One is on the *ubiquity of Linux environments in the cloud, *many for free.
And one is on "Duck DB".
*DuckDB* is an open-source
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/Open-source_software&sa=D&source=calendar&usd=2&usg=AOvVaw1OLJSeXrFMR31q0t-uAyk7>
column-oriented
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/Column-oriented_DBMS&sa=D&source=calendar&usd=2&usg=AOvVaw3GWq131Edwzx4eHQU1l_nD>
Relational Database Management System
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/Relational_Database_Management_System&sa=D&source=calendar&usd=2&usg=AOvVaw04bTURrlXg1QsHF5R8IeK9>
(RDBMS).[1]
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/DuckDB%23cite_note-1&sa=D&source=calendar&usd=2&usg=AOvVaw2ozecxPL7O5sO_xCNOTmoy>
It is designed to provide high performance on complex queries against
large databases in embedded configuration,[2]
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/DuckDB%23cite_note-Kamphuis_2020_pp._608%25E2%2580%2593612-2&sa=D&source=calendar&usd=2&usg=AOvVaw1SOW32tlWUeTyfFENYaSR_>
such
as combining tables
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/Table_(database)&sa=D&source=calendar&usd=2&usg=AOvVaw2RY6btzabn9zL1M0qKZVCd>
with
hundreds of columns and billions of rows.
Unlike other embedded databases (for example, SQLite
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/SQLite&sa=D&source=calendar&usd=2&usg=AOvVaw21lCdiKNcBLw3wCL2QE2Gd>)
DuckDB is not focusing on transactional (OLTP
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/OLTP&sa=D&source=calendar&usd=2&usg=AOvVaw2hVKWJ64OLZY_TnFZLmqqW>)
applications and instead is specialized for online analytical processing
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/Online_analytical_processing&sa=D&source=calendar&usd=2&usg=AOvVaw14Lo84zmgAIw70f5cSNOg1>
(OLAP)
workloads.[3]
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/DuckDB%23cite_note-Raasveldt_M%25C3%25BChleisen_2019_pp._1981%25E2%2580%25931984-3&sa=D&source=calendar&usd=2&usg=AOvVaw3iEEO3gt-lsxVL6bBfCcA2>
The project has over 6 million downloads per month.[4]
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/DuckDB%23cite_note-4&sa=D&source=calendar&usd=2&usg=AOvVaw0yAWGZOMOv42PrUEonCxut>
[5]
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/DuckDB%23cite_note-5&sa=D&source=calendar&usd=2&usg=AOvVaw2vX2smEw9j70AWgNaJyTRC>
[6]
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/DuckDB%23cite_note-theregister.com-6&sa=D&source=calendar&usd=2&usg=AOvVaw1Ml-TG3dslwQZJvYcHZ0Y9>
An in-process OLAP database solution,[7]
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/DuckDB%23cite_note-7&sa=D&source=calendar&usd=2&usg=AOvVaw3End9ClQWZNV8PLwcnyZC7>
DuckDB
was first released in 2019.[8]
<https://www.google.com/url?q=https://en.wikipedia.org/wiki/DuckDB%23cite_note-Clark-8&sa=D&source=calendar&usd=2&usg=AOvVaw1X4DC_LmyXKr-ZJKnDqhhc>
DuckDB
version 1.0.0 was released in June 2024,
Both are tutorials/demonstrations rather than slides presentations.
About 20 minutes for each booth followed with about 10 minutes of Q&A.
Presenter: Robert Citek <https://www.sluug.org/bio/Robert_Citek>
6:30pm CDT *Thurs* 20 Nov
