data-nerd.blog

Social Media Diet: how to lose 1000 useless notifications in 30 days

The post discusses the modern problem of feeling overwhelmed by social media and constant news updates. The author raises awareness about the importance of learning what to ignore and setting boundaries to protect one’s time. They endorse the concept of the ‘joy of missing out’ (JOMO), enjoying real-life moments, and prioritizing what really matters instead of trying to keep up with everything.

Disclaimer: This image was generated with DALL-E by OpenAI.

Hey Y’all! I want to share something I’ve been thinking about a lot lately this year. You know how our lives today are basically swamped with social media? Instagram, TikTok, Snapchat, Facebook, Twitter – you name it, we’re on it. And let’s not even get started on the constant stream of ‘breaking’ news. It’s like we’re in an endless cycle of catching up with everything and everyone. But here’s what I’ve started to realize: maybe the real skill isn’t keeping up with everything, but learning what to ignore.

I stumbled upon this idea almost by an accident. At start of a usual workday, I thought, what if instead of making a routine ‘To-Do‘ list, why not make a ‘Not To Do’ list? Like, not to endlessly scroll through my LinkedIn feed just to fill time. Sounds weird, right? But let me tell you, it felt kind pretty great.

Social media is a tricky beast. I’ve lost count of how many times I’ve fallen down the rabbit hole of ‘just one more video‘ and ended up doom-scrolling YouTube shorts my entire evening. So, I’ve been trying to set some boundaries for myself. It’s not about missing out on stuff; it’s more about making sure I have time for things that really matter – like, you know, real life.

And here’s a hard truth I’ve been grappling with: it’s okay to say ‘no’. I used to feel like I had to read every tweet I’m being tagged and reply to every email that came my way. But I’m learning that it’s okay to pass on things that don’t add anything meaningful to my day. It’s not always easy, but it’s definitely freeing.

Heard about the joy of missing out (JOMO). It’s a thing, and it’s actually pretty awesome. Instead of feeling bad about not keeping up with everything, I’ve started to enjoy the moments when I’m not glued to any screen. Whether it’s just sitting quietly, enjoying a good book, or listening to my daughter share her high school drama or making dinner. (I suck at cooking but that’s for another post), these moments feel a lot more meaningful now.

Finally, I’m learning not to stress about notifications. It’s okay not to check every single one. Ignoring the unimportant stuff means I can now make time for what’s more important.

So, as we navigate this world of endless information and distractions, I’m realizing that focusing on what truly matters is key. It’s not about cutting out social media or news entirely, but about choosing what to engage with. And believe me, it’s a journey – one I’m still figuring out everyday. But I can tell you this: it’s definitely worth it. Here’s to finding our focus in the chaos! 🌟🙌

Mastering Data Manipulation with MERGE Command in PostgreSQL 15

Two years back, I wrote a blog post titled “PostgreSQL – Mastering UPSERT“, in which I explored the nuances of the INSERT ON CONFLICT command that allows conditional inserts or updates of rows.

Continuing its database technology innovation, PostgreSQL 15 has introduced an exciting new feature – the MERGE command. This command offers a more versatile approach to INSERT, UPDATE, or even DELETE rows in a table based on specific conditions. In this post, we’ll delve into the intricacies of this new MERGE command.

My talk at Citus Con 2023

I’m excited to be speaking at Citus Con 2023 on April 18-19 on reducing your PostgreSQL costs on Azure managed Postgres.

In my talk, I’ll be sharing tips and tricks that can help you save money without sacrificing performance. Join me at the upcoming conference to learn more about how you can optimize your Azure PostgreSQL deployment and reduce your costs.

https://www.citusdata.com/cituscon/2023/schedule/#od-session-dhawan

Whether you’re just getting started with Azure Postgres or you’re a seasoned pro, my talk will provide valuable insights and tips for optimizing your use of the platform. I’m looking forward to sharing my knowledge with the PostgreSQL community and learning from other experts in the field. See you at Citus Con 2023!

“Sharing your knowledge and learnings about Postgres—or Postgres extensions (like the Citus database extension)—is a useful way to give back to the community. Your talk can help other teams & projects learn from your successes (and mistakes) with Postgres.”
@clairegiordano

Thank Claire, for your inspiring words. They have really motivated me and given me the encouragement I needed for giving this talk. 🙌

2022 – My Year in Books 📚

It’s that time of year when I am excited to share the books I have read! It’s one of the self-created traditions that I look forward to every year.

This year in 2022, I’ve read some great books and watched a few amazing documentaries — some are new releases, some older, but each one of them truly made me a better person this year.

I’ve been posting my “My Year in Books” for last couple of years. I believe that sharing books is an easy way to connect with like minded folks. ❤️

In no particular order- let’s go!

PostgreSQL Advanced Pattern Matching – Beyond LIKE Operator

Whenever you are dealing with pattern matching in PostgreSQL, it is often required to write queries to match string patterns. The conventional wisdom to do pattern match was using the LIKE operator, which is not very effective for many reasons. PostgreSQL now offers more advanced pattern matching options such as SIMILAR TO expressions, POSIX regular expressions, and ANY operator. In this article, we’ll compare the LIKE operator with these other advanced pattern matching features.

Data Science with PostgreSQL – Using the Window frame_clause

This is my 5th (and final) post on Window Function in PostgreSQL series. In previous posts on this topic, I have covered window function basics, using aggregate window functions, ranking window function and value window functions. While you’re here, I’ll recommend to you check the previous posts on this topic.

In this article, we’ll learn a new concept frame_clause. Let’s jump right in!

Data Science with PostgreSQL – Value Window Functions

This far in the Window Function in PostgreSQL series I have covered window function basics, and how to use aggregate window functions and ranking window function. I suggest you check the previous posts out 🙂

In this 4^th post, I’ll show you how to use Value window functions – that can be used to calculate various “value” type aggregations such as Lag, Lead, First_Value and Last_Value within each group of rows referred here as “window” or “partition”.

Data Science with PostgreSQL – Ranking Window Functions

This is 3rd post in my series featuring Window Function in PostgreSQL. In this post, I’ll explain how to use Ranking window functions – that we can use to calculate various aggregations such as Row Number, Rank, and Dense Rank within each window or partition.

Data Science with PostgreSQL – Aggregate Window Functions

Here we go, after weeks for procrastination finally the 2nd post in my series featuring Window Function in PostgreSQL. In this post, I’ll explain how to use Aggregate window functions – that we can use to calculate various aggregations such as average, counts, minimum / maximum values, and sum within each window or partition.

Data Science with PostgreSQL – Window Functions Basics

Window functions are a powerful tool that helps to leverage the power of PostgreSQL for Data Analysis. In this blog series, I will explain what window functions are, why you should use them, types of window functions and finally will introduce you to some basic window functions in PostgreSQL. In the next few post, I’ll go through more advanced window functions and demo some scenarios. So let’s get going.