Adrian Perea

Data engineer @thinkdatasci. I geek out about tech sometimes

[Adrian Perea @iamperea]

There are many different ways to increase your productivity as a dev.

Here are 7 simple ways you can start doing today!

#100DaysOfCode #productivity

[Adrian Perea @iamperea]

@hi_itsme___ @chrslynnnnn_ did you get any updates from her?

[Peer Richelsen @peer_rich]

Remote work was a mistake. After two years of being fully remote, we're now going back to in-office.

This is a hard task because we need to relocate every team member.

Check out our new headquarter and why we are getting back in person.

A thread 🧵

[Dagster @dagster]

As seen on Reddit...

https://t.co/ywgMde9JZp

[Alex Monahan @__AlexMonahan__]

@DuckDB now supports upserts through the "on conflict" clause!

For now, you just need to install from the latest master branch, but this will be in the next release!
https://t.co/UsxZgHESVg

[Jay Henderson @jay_henderson]

If you're a data nerd, you won't want to miss this article on the shift from the modern data stack to the modern data graph. By @stkbailey.

https://t.co/ye5dOenO01

[Andrew Gazdecki @agazdecki]

@elonmusk @paulg Can you free @acquire for me? 🙏

It would truly make my year.

It’s been unused and suspended.

No worries if not just shooting my shot.

[PythonPH @pythonph]

PyCon PH is back! 🎉

It's been almost 4 years since we hosted PyCon APAC 2019 and went on a strategic pause. Finally, PyCon Philippines is back with the theme "ugnayan", celebrating the connections we formed and continue to build as a community. Stay tuned and see you next year!

[Thinking Machines @thinkdatasci]

Friend or foe? Let’s break down the ways that AI can ⚡supercharge⚡ our decisions to improve our daily lives and how we do business. Follow our blog post series, We’re Better with AI, for more content on becoming an AI-driven organization. Full post at https://t.co/wht10Q147e.

[Alessandro Martinello @ale_martinello]

Without DuckDB our current lead project would not exist. In a closed environment w/o access to internet (cloud) and only python available we need to analyze ~1B transactions + 128M rows dataset (+ several ~5M rows ones).

Once the db is set up, even complex queries take ~15 secs

[Adrian Perea @iamperea]

@__AlexMonahan__ @duckdb @duckdblabs @motherduckdb Thanks!

[Adrian Perea @iamperea]

@duckdb @duckdblabs @motherduckdb can you explain to me how y'all are related?

[Adrian Perea @iamperea]

@hfmuehleisen I watched your CWI talk (https://t.co/tMGVqEc6fL). For the Spark vs Duck DB tests that you did, how did you get data into the duckdb node? I know Spark can do it via its multiple data connectors. Would like to know what a good practice for duckdb would be

[Paul Graham @paulg]

Today I talked to a startup doing so well that they had no current problems that needed solving. Profitable, growing ~20x a year (not a typo), only 9 employees. This is so rare that I didn't know what to do. We ended up talking about problems they might have in the future.

[Adrian Perea @iamperea]

@__AlexMonahan__ @duckdb Thanks a lot!

[Adrian Perea @iamperea]

Hi @duckdb! This is driving me nuts: what is the difference between using a persistent database (e.g. in python: duckdb.connect(database="database.duckdb")) vs saving the contents of a DB using EXPORT and then using IMPORT in subsequent sessions?

[Jacob Matson @matsonj]

based on my tweets yesterday, just wrote up how I increased query performance 80x by using DuckDB instead of postgresql.

https://t.co/ck3eSQJ7a7

[Adrian Perea @iamperea]

💎 ✋️ 💎 ✋️ 💎 ✋️
This is the closest thing the crypto community has to a prayer

[Adrian Perea @iamperea]

I don't know y'all. Clunky yes but seems to be on brand python

[Ali Spittel @ASpittel]

hot take

if __name__ == "__main__":

is one of the clunkiest lines of code tbh

[Alex Monahan @__AlexMonahan__]

The power of @DuckDB and @ApacheArrow:
"We can select 304,851 interesting rows from all 1,547,741,381 in the 10 year dataset in < 3 seconds on a laptop!"
Great demo!