this post was submitted on 22 Apr 2024
136 points (93.6% liked)

Programmer Humor

19606 readers
1007 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 1 year ago
MODERATORS
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev
136
Guess what my favourite language is: (lemmy.world)
submitted 7 months ago by merari42@lemmy.world to c/programmer_humor@programming.dev
28 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] eran_morad@lemmy.world 5 points 7 months ago (1 children)

Bruh, this looks cool af. Seriously has me wondering whether I should port my shit from SQLite to duckDB.

[โ€“] bobburger@fedia.io 4 points 7 months ago

I love duckDB, my usual workflow is:

  • initially read my data from whatever source (CSV, relational database somewhere, whatever)
  • write it to one or more parquet files in a directory
  • tell duckdb that the directory is my data source

Then duckdb treats the directory just like a databese that you can build indexes on, and since they're parquet files they're hella small and have static typing. It was pretty fast and efficient before, and duckdb has really sped up my data wrangling and analysis a ton.