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, 🧵
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.
Read 7 tweets
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/🦆)
#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.
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.
Read 14 tweets
How to use R with DuckDB (so you can turbo charge your data queries and handle big data effortlessly)

#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.
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.
Read 10 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!