Discover and read the best of Twitter Threads about #duckdb
Most recents (3)
How is #DuckDb going to be used inside a company? My head can't think beyond it being used for local development. Can it really replace a DWH without being distributed?
If it does go beyond local, I do have a few things to ponder upon, 🧵
If it does go beyond local, I do have a few things to ponder upon, 🧵
1. Search and Discovery: Where are users going to find artifacts inside the DuckDB cluster (eventually)? We'll need a catalog interface to surface this portion. The metadata of the artifacts in the data model (database, table) needs to be consistent across the cluster.
2. How is privacy handled? What if someone downloads sensitive data onto their laptop and it is stolen thus opening up a data breach? My paranoia comes from working on Data infra for GDPR, and CCPA. Access control should be implemented and enforced.
Finally took the time to figure out what the duck is #DuckDB and why I should care.
There’s a lot of technical jargon that gets thrown and I wish there was a plain English explanation of why analysts should be excited.
Here’s my attempt at doing exactly that (1/🦆)
There’s a lot of technical jargon that gets thrown and I wish there was a plain English explanation of why analysts should be excited.
Here’s my attempt at doing exactly that (1/🦆)
#DuckDB brands itself as SQLite for analytics. If you’re like me you’ve probably heard of SQLite somewhat superficially.
Little did I know that SQLite was a low-key game-changing piece of software.
Little did I know that SQLite was a low-key game-changing piece of software.
SQLite removes the complexity of client server databases (think Oracle, SQL Server) and instead stores the database in a single file. This file is stored locally on your disk which makes reads and writes very fast, and the database extremely portable and lightweight.
How to use R with DuckDB (so you can turbo charge your data queries and handle big data effortlessly)
#rstats #bigdata #duckdb
1.
#rstats #bigdata #duckdb
1.
DuckDB is a fantastic tool currently seeing a rapid rise in the data world.
It is designed for rapid analytical queries and works brilliantly with big data.
Best of all you can use it directly in tools like #rstats, #python, #java and others.
Let's see how it works in R.
2.
It is designed for rapid analytical queries and works brilliantly with big data.
Best of all you can use it directly in tools like #rstats, #python, #java and others.
Let's see how it works in R.
2.
You can install DuckDB straight from the console with install.packages("duckdb").
Unlike some other big data tools it is entirely self-contained.
This means no extra ongoing maintenance - your IT department will thank you for that.
3.
Unlike some other big data tools it is entirely self-contained.
This means no extra ongoing maintenance - your IT department will thank you for that.
3.
