파이리(Py-E-Li)

I like BPF, Rust, Emacs, Python and Linux so much.
I am maintaining #RedBPF:

[Arpit Bhayani @arpit_bhayani]

SQLite has about 155,800 lines of code, and its test suite has roughly 92 million lines. That is ~590x more test code than actual code 🤯

This is the level of testing you need for a real production database. Here are some types of tests they run.

Out-of-memory tests - SQLite cannot just crash when memory runs out. On embedded devices, OOM errors are common. They simulate malloc failures at every possible point and verify that the database handles them gracefully.

I/O error tests - Disks fail. Networks drop. Permissions change mid-operation. SQLite inserts a custom file system layer that can simulate failures after N operations, then verifies that no corruption occurs.

Crash tests - What happens if power cuts out mid-write? They simulate crashes at random points during writes, corrupt the unsynchronized data to mimic real filesystem behavior, then verify the database either completed the transaction or rolled it back cleanly. No corruption allowed.

Fuzz testing - They throw malformed SQL, corrupted database files, and random garbage at SQLite. The dbsqlfuzz tool runs about 500 million test mutations every day across 16 cores.

100% branch coverage - Every single branch instruction in SQLite's core is tested in both directions. Not just 'did this line run', but 'did this condition evaluate to both true AND false'.

Databases are really unforgiving :)

By the way, if you want to go deeper, I recommend reading the official SQLite documentation on their testing strategy. The doc is pretty practical and deep.

Have linked it below.

[Python Developer @PythonDvz]

Types of Databases

[Alex Xu @alexxubyte]

Popular Backend Tech Stack.

You do not need everything. Choose whatever tech or tools work best for you.

[Alex Xu @alexxubyte]

Top 5 common ways to improve API performance.

[Neo Kim @systemdesignone]

How SQL JOINs work

(explained in 2 mins or less):

[프로그래밍 책 인용 봇 @book_quote_bot]

이 책은 리팩터링과 패턴의 결합에 대한 것이다. 이 책에서는 설계 초기 단계부터 패턴을 적용하는 것보다 기존 설계를 개선하는 데 패턴을 사용하는 것이 더 낫다고 말한다. <패턴을 활용한 리팩토링>

[Linux Inside: The Ideal Blog for Sysadmins & Geeks @tecmint]

22 #Linux Networking Commands for Sysadmin

https://t.co/z3pvuraJJC

Follow @tecmint for more Linux tips. 🚀

[Shalini Goyal @goyalshaliniuk]

Confused between ML, NLP, Generative, and other AI models?

Here’s a quick breakdown of the 6 most important types of AI models you must understand in 2025 👇

1. Machine Learning Models
They learn from labeled and unlabeled data to classify, predict, and detect patterns. Think decision trees, SVMs, and XGBoost.

2. Deep Learning Models
Neural networks built for unstructured data like images, audio, and text. Includes CNNs, RNNs, Transformers, and GANs.

3. NLP Models
Focused on understanding and generating human language - used in chatbots, summarizers, and assistants like GPT and BERT.

4. Generative Models
These models create, from text to images to music. Powered by models like GPT-4, DALL·E, and StyleGAN.

5. Hybrid Models
Combine the best of rule-based and neural AI. Perfect for use cases needing both reasoning and context awareness (e.g., RAG pipelines).

6. Computer Vision Models
Built for images and videos. Used in object detection, facial recognition, and medical scans - powered by models like YOLO and ResNet.

Each AI model has its strengths and knowing which one fits your use case is half the battle. Save this guide as your cheat sheet!

[파이리(Py-E-Li) @py3eli]

In Emacs, `M-m` is bound to `back-to-indentation`, which moves the cursor to the first non-whitespace character on the line.

[파이리(Py-E-Li) @py3eli]

Nice article on enhancing Linux security: https://t.co/MLdJvTz5sU

[파이리(Py-E-Li) @py3eli]

I learned about ZeroMQ today. It offers many interesting features, and I'm quite satisfied with it.

[Security Trybe @SecurityTrybe]

Linux Security ( Defensive vs Offensive)

[Piyush Itankar @_streetdogg]

What does the CPU internally do? Check out the animation...

The dance goes like -
1. Fetch
2. Decode
3. Execute
4. Memory Access
5. Write Back

See it in action here: https://t.co/PUztTJkl8o

[LetsDefend @LetsDefendIO]

Useful Wireshark Filters for SOC Teams

[파이리(Py-E-Li) @py3eli]

I just finished setting up my System76 Oryp5 laptop with Fedora 40, NVIDIA, and System76 software. Fan control is working properly now, so it’s quiet. The only issue left is that I can't use my external keyboard and trackball connected to the external monitor.

[파이리(Py-E-Li) @py3eli]

system76-power adds `alias nvidia off` to its modprobe configuration, which prevents the NVIDIA driver from working. What the

[파이리(Py-E-Li) @py3eli]

While upgrading Fedora from 39 to 40, it got corrupted and failed to boot. I was reminded that using Linux as a desktop sometimes feels like penance. I’ve been using Linux as a desktop since 2002, but even after two decades, I still don’t consider myself an excellent Linux user.

[파이리(Py-E-Li) @py3eli]

I last used this laptop two years ago. During those two years, I became fully accustomed to macOS, so I feel uncomfortable using the touchpad on this laptop. When I scroll in the browser with two fingers, the scrolling moves down too quickly.

[파이리(Py-E-Li) @py3eli]

I am upgrading Fedora from version 35 to the latest version, one step at a time. I am currently on version 38, with two versions left to go.

[파이리(Py-E-Li) @py3eli]

@thatstraw I love Linux and use it every day, but I don't have much to say about it when talking with people in the IT industry. It's strange… I definitely love it, yet I find myself with nothing to say.