What is Hackers' Pub?

Hackers' Pub is a place for software engineers to share their knowledge and experience with each other. It's also an ActivityPub-enabled social network, so you can follow your favorite hackers in the fediverse and get their latest posts in your feed.

0

SQL 튜닝 공부 기록

인덱스를 이용한 스캔은 조건에 맞는 데이터가 '소량'일 때 유리한 것 같다. 조건에 맞는 데이터가 너무 많은데 인덱스로 접근하게 되면 랜덤액세스가 너무 많아서 오히려 성능이 떨어질 수도 있다. 물론, 이런 경우 옵티마이저가 알아서 풀스캔을 적용하는 경우도 있다.

인덱스를 처음 배울 때에는 '데이터를 빠르게 접근하는 수단'으로만 이해했는데, 뽑아야 하는 데이터가 적을 때 더 유용성이 크다는 건 이제 이해했다.

1
0

"We have monotonically expanded copyright since 1976, so that today, copyright covers more kinds of works, grants exclusive rights over more uses, and lasts longer.
And today, the media industry is larger and more profitable than it has ever been, and also – the share of media industry income that goes to creative workers is lower than it has ever been"
theguardian.com/us-news/ng-int

0

Abigail Spanberger gets it. Upon being sworn in she immediately issued an executive order requiring police to stop cooperating with . She also refused to kiss Nazi boot on rights.

Throwing trans people under the bus was depraved and ineffective against the original Nazis and nothing has changed.

wjla.com/news/local/governor-a

Charlotte Clymer says "Abigail Spanberger was told to throw trans youth under the bus during her campaign. She refused to do so. She won the election by 15%. A dominant victory. A landslide. She was just sworn in as the 75th Governor of Virginia, the first woman to lead the state." Then there's a picture of her and her family at the swearing in ceremony.
0
0
0
0
0
0
1
1
1
0
0
0

A newborn in Gaza, 27 days old, died on Saturday from severe cold, the Palestinian Health Ministry confirmed, raising the number of children who have died of hypothermia this winter to eight.

The infant, Aisha Ayesh al-Agha, was brought to Nasser Hospital in Khan Younis, but medical staff said it was already too late to save her, The Guardian reports.

This comes amid a wider collapse of maternal and neonatal care, with war-driven shortages of fuel, medical supplies, and shelter forcing mothers into life-threatening choices.

Recent reports from Physicians for Human Rights, alongside the University of Chicago Law School’s Global Human Rights Clinic and Physicians for Human Rights-Israel, reveal staggering figures between January and June 2025: 2,600 miscarriages, 220 pregnancy-related deaths, 1,460 premature births, and thousands of infants needing intensive care.

Gaza has recorded 17,000 births in early 2025, a 41% drop from the same period in 2022, as displacement camps swell and living conditions deteriorate.

0
1
0
0
1
0
0
0

A thought that popped into my head when I woke up at 4 am and couldn’t get back to sleep…

Imagine that AI/LLM tools were being marketed to workers as a way to do the same work more quickly and work fewer hours without telling their employers.

“Use ChatGPT to write your TPS reports, go home at lunchtime. Spend more time with your kids!” “Use Claude to write your code, turn 60-hour weeks into four-day weekends!” “Collect two paychecks by using AI! You can hold two jobs without the boss knowing the difference!”

Imagine if AI/LLM tools were not shareholder catnip, but a grassroots movement of tooling that workers were sharing with each other to work less. Same quality of output, but instead of being pushed top-down, being adopted to empower people to work less and “cheat” employers.

Imagine if unions were arguing for the right of workers to use LLMs as labor saving devices, instead of trying to protect members from their damage.

CEOs would be screaming bloody murder. There’d be an overnight industry in AI-detection tools and immediate bans on AI in the workplace. Instead of Microsoft CoPilot 365, Satya would be out promoting Microsoft SlopGuard - add ons that detect LLM tools running on Windows and prevent AI scrapers from harvesting your company’s valuable content for training.

The media would be running horror stories about the terrible trend of workers getting the same pay for working less, and the awful quality of LLM output. Maybe they’d still call them “hallucinations,” but it’d be in the terrified tone of 80s anti-drug PSAs.

What I’m trying to say in my sleep-deprived state is that you shouldn’t ignore the intent and ill effects of these tools. If they were good for you, shareholders would hate them.

You should understand that they’re anti-worker and anti-human. TPTB would be fighting them tooth and nail if their benefits were reversed. It doesn’t matter how good they get, or how interesting they are: the ultimate purpose of the industry behind them is to create less demand for labor and aggregate more wealth in fewer hands.

Unless you happen to be in a very very small club of ultra-wealthy tech bros, they’re not for you, they’re against you.

0
0
0
1
0
0
1
2
1
0
0
1
0
0

(我家採行的)教養準則裡面,我覺得最難的是「溫柔而堅定」。

老婆或是岳母常常會心軟而放棄原則。但對我來說倒是毫無困難,或許是因為我本人有點冷血的關係。

我一概堅守:講好的規矩就該遵守。就算兒子在我面前大哭崩潰,我也不會答應他的要求。但同時我也不會怒吼、發飆,只是靜靜地抱著他、安撫他。

0
1
1
0
1
0
0
0
0
1
0

(我家採行的)教養準則裡面,我覺得最難的是「溫柔而堅定」。

老婆或是岳母常常會心軟而放棄原則。但對我來說倒是毫無困難,或許是因為我本人有點冷血的關係。

我一概堅守:講好的規矩就該遵守。就算兒子在我面前大哭崩潰,我也不會答應他的要求。但同時我也不會怒吼、發飆,只是靜靜地抱著他、安撫他。

0
0
1
0
1
0
0
0
0