duckdb is a generational technology innovation. insanely good ergonomics, great performance, it's awesome.
Can confirm: together with `dbt` and `rill` I'm able do to [this]( https://github.com/idesis-gmbh/GitHubExperiments/blob/master... ) on my laptop.
DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
11–20 of 54 posts
Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#12DuckDB also runs in Excel, by the way, via the free xlwings Lite add-in that you can install from the add-in store. It’s using the Python package and allows to write scripts, custom functions, as well as use a Jupyter-like notebook workflow.
Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#13Earlier quoted context omitted.
Can confirm: together with `dbt` and `rill` I'm able do to [this]( https://github.com/idesis-gmbh/GitHubExperiments/blob/master... ) on my laptop.
Why did you pick rill?
Edit: still realizing that I can't use markdown on HN...
Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#14Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#15Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#16duckdb is a generational technology innovation. insanely good ergonomics, great performance, it's awesome.
Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#17Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#18Did they finally enable full SIMD or keep insisting its okay not to have it?
"Performance Does DuckDB use SIMD? DuckDB does not use explicit SIMD (single instruction, multiple data) instructions because they greatly complicate portability and compilation. Instead, DuckDB uses implicit SIMD, where we go to great lengths to write our C++ code in such a way that the compiler can auto-generate SIMD instructions for the specific hardware. As an example why this is a good idea, it took 10 minutes to port DuckDB to the Apple Silicon architecture."
Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#19Data engineer here: I use this all the time. It's amazing. For most of the data the sizes we often deal with it's perfect.
Interested here: for me it works for out of core work. Where is the limit? On a related note: do you need to handle concurrency restrictions?
Re: DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
#20Did they finally enable full SIMD or keep insisting its okay not to have it?