Adrian Perea (@iamperea) header
Adrian Perea (@iamperea) profile picture

Data engineer @thinkdatasci. I geek out about tech sometimes

Makati, Philippines
Joined October 2019
Photo by Adrian Perea (@iamperea)Photo by Adrian Perea (@iamperea)Photo by Adrian Perea (@iamperea)Photo by Adrian Perea (@iamperea)Photo by Adrian Perea (@iamperea)Photo by Adrian Perea (@iamperea)Photo by Adrian Perea (@iamperea)Photo by Adrian Perea (@iamperea)Photo by 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
1
3
7
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 🧵
213
483
227
3,875
2,359,474
Adrian Perea retweeted
As seen on Reddit... reddit.com/r/dataengineering…
2
4
32
3,584
Replying to @duckdb
@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! duckdb.org/docs/sql/statemen…
2
3
24
1,097
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://teapawt.net/t.co/ye5dOenO01
2
6
379
Replying to @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. – at San Mateo, CA
Hey @elonmusk got Russ Hanneman to weigh in on the suspended @acquire handle for some laughs. For the love of startups please let us use this Twitter handle instead of @acquiredotcom for our rebrand. Just shooting my shot!
6
6
3
99
Adrian Perea retweeted
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!
2
26
6
64
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 thinkingmachin.es/stories/wh….
5
4
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
You’re unable to view this Post because this account owner limits who can view their Posts. Learn more
5
36
Adrian Perea retweeted
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.
182
173
38
5,311
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?
1
1
1
Adrian Perea retweeted
based on my tweets yesterday, just wrote up how I increased query performance 80x by using DuckDB instead of postgresql. dataduel.co/revisiting-data-…
3
16
1
117
💎 ✋️ 💎 ✋️ 💎 ✋️ This is the closest thing the crypto community has to a prayer
1
I don't know y'all. Clunky yes but seems to be on brand python
hot take if __name__ == "__main__": is one of the clunkiest lines of code tbh
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!
Followed up with the 10 year, 1.5 billion row dataset. Duckdb + Arrow filtered through it with ease on a laptop @streamlit code: github.com/gerardrbentley/ub… (No demo because the data is 40 GB 💾 download instructions via s3 in repo)
5
47
Adrian Perea retweeted
Leni ended up with > 14.4M votes in 2016 vs BBM’s 14.1M. Fast forward to 2022: Leni’s only garnering 10M (as of now) vs BBM’s 21M. Despite her numerous efforts/programs matched with his absence in service for the past 6 years. Don’t tell me she lost voters. IT’S NOT ADDING UP.
1,009
35,992
3,550
113,136
Save up for the future but don't forget to live in the moment 💯
Everyone told me that I was stupid for not putting money in my 401k and for blowing my whole paycheck. You know what never depreciates in value? A memory of a sick night at a club. Hows y'alls stocks doing?
Okay naaaaa The RT button colour haf change
350
8,565
60
11,931
NEW BLOG 👀 "The #ProofofStake (#PoS) consensus mechanism deployed by the Cardano #blockchain offers low energy consumption, security, and scalability..." Check out the article in collaboration with CV VC @CV_Labs 👉 https://teapawt.net/t.co/hz1jexnIR0
31
94
8
450
Admittedly, Data Activation is a more intuitive term than Operational Analytics (plus, makes it easier to differentiate/sell 😉). Well played, @HightouchData: hightouch.io/blog/the-data-a…
1
2