My unpopular opinion

In a startup, hackathon, or whatever, if you have to think about how your product is unique, it's not unique at all.


@codeandthought

3 Ways to Insert Data into PostgreSQL: Sequential, Batch, and COPY

Imagine inserting 1 million rows into your database. You have three strategies:

1. Sequential INSERT: One row at a time
Executes a separate INSERT for each row.
Simple, but slow due to repeated database communication.

2. Batch INSERT: Multiple rows at once
Groups many rows into a single INSERT statement.
1M rows with batches of 1,000 = 1,000 INSERT statements.
Faster because it reduces database round trips and statement overhead.

3. COPY: Bulk data loading
PostgreSQL's optimized mechanism for loading large datasets.
Streams data directly into the database without individual INSERT statements.
Usually the fastest option for massive data ingestion.

One important distinction: server-side COPY FROM reads a file accessible to the PostgreSQL server. \copy in psql reads a client-side file, and COPY FROM STDIN lets applications stream data.

How do we compare them?
Measure their throughput:
Throughput = Total rows inserted / Time (seconds)

@codeandthought

إِنَّ اللَّهَ وَمَلائِكَتَهُ يُصَلُّونَ عَلَى
النَّبِيِّ يَا أَيُّهَا الَّذِينَ آمَنُوا صَلُّوا
عَلَيْهِ وَسَلِّمُوا تَسْلِيمًا
اللهم صلِّ وسلم على سيدنا محمد وعلى آله ..💚💚

Who else thinks this is AI-generated?

https://x.com/Tesla/status/2110913438293647789/video/1

Do you know the 80/20 rule?

Yeah, most of the 80% of things are in the hands of the 20%. Sometimes I feel like this narrows down to 98% or 99% versus 2% or 1%, like intelligence, creativity, and everything of this person; he is 1 in 8B.

Who do you think will be the next Elon Musk in our community?

@codeandthought

Who is up searching for rizq?

Imagine building an application that records everything users do. Someone signs in. Someone clicks a button. Someone completes a purchase. Someone opens a page. Each action produces an event.

For a small application, storing these events is relatively straightforward. But what happens when the application grows and accumulates millions of records?

Will searching become slower? Will the database consume too much storage? Can I still retrieve information quickly? What happens when I need to insert millions of new records?

Okay, I have documented every detail on how I built this in a way that not only you but also your high school graduate Grammy can understand. So, if you wanted to take a look, here is:

[Doc]
[github Repo]

@codeandthought

If you want to understand PostgreSQL and Express, I really recommend taking on this challenge. I think it's more valuable than watching endless tutorials or building a bunch of mini projects.

But there's one thing I want to point out.
At the 100-million-row mark, my PostgreSQL database occupied approximately 20 GB of disk space. And Omarchy was particularly useful for this project because it gave me a Linux-native, terminal-focused development environment.

So, if you're using Windows or working with a PC that has limited free storage, you might face some challenges on the hardware side.
Just something to consider before jumping in.

Omnispot is out: a 1-click mobile hotspot plugin for the Omarchy top bar.
Share your connection over Wi-Fi , monitor connected devices in real time, and toggle it straight from the bar.
Install:

omarchy plugin add https://github.com/NWGKGIT/omnispot.git --enable

GitHub: https://github.com/NWGKGIT/omnispot

Shawarma is a fancy ertb

The goat @codeandthought

Sijemer ik my people 🤩

I've built wealth without reading a book every day.
I've built wealth without making my bed every day.
I've built wealth without journaling every day.
I've built wealth without a 2 hour morning routine every day.
I've built wealth without giving up Netflix every day.
I've built wealth without waiting to marry.
I've built wealth without leverage.

Because the only things you have to do to build wealth are:
1) Find "stuff" that people want
2) Sell it to them for more than it costs you.
3) Do this many times.

There is no "hack" for it.

Alex Hormozi