2025-04-14

43 篇热帖

2. The path to open-sourcing the DeepSeek inference engine (github.com)

Production-tested AI infrastructure tools for efficient AGI development and community-driven innovation - open-infra-index/OpenSourcing_DeepSeek_Inference_Engine at main · deepseek-ai/open-infra-index

6. DolphinGemma: How Google AI is helping decode dolphin communication (blog.google)

Dolphin researchers are using Gemma and Google Pixel phones to try to decipher how dolphins talk to one another.

8. Adipose tissue retains an epigenetic memory of obesity after weight loss (www.nature.com)

Reducing body weight to improve metabolic health and related comorbidities is a primary goal in treating obesity1,2. However, maintaining weight loss is a considerable challenge, especially as the body seems to retain an obesogenic memory that defends against body weight changes3,4. Overcoming this barrier for long-term treatment success is difficult because the molecular mechanisms underpinning this phenomenon remain largely unknown. Here, by using single-nucleus RNA sequencing, we show that both human and mouse adipose tissues retain cellular transcriptional changes after appreciable weight loss. Furthermore, we find persistent obesity-induced alterations in the epigenome of mouse adipocytes that negatively affect their function and response to metabolic stimuli. Mice carrying this obesogenic memory show accelerated rebound weight gain, and the epigenetic memory can explain future transcriptional deregulation in adipocytes in response to further high-fat diet feeding. In summary, our findings indicate the existence of an obesogenic memory, largely on the basis of stable epigenetic changes, in mouse adipocytes and probably other cell types. These changes seem to prime cells for pathological responses in an obesogenic environment, contributing to the problematic ‘yo-yo’ effect often seen with dieting. Targeting these changes in the future could improve long-term weight management and health outcomes. Stable epigenetic changes indicate the existence of an obesogenic memory in mouse adipocytes that primes cells for pathological responses in an obesogenic environment and potentially contributes to the problematic ‘yo-yo’ effect often seen with dieting.

12. Zig's new LinkedList API (it's time to learn fieldParentPtr) (www.openmymind.net)

Karl Seguin's Blog - A mix of coding and creative writing

13. SQLite File Format Viewer (sqlite-internal.pages.dev)

SQLite 文件格式查看器

SQLite 文件格式查看器是一种专门用于检查和解析 SQLite 数据库文件(.db 或 .sqlite)内部结构的工具。它允许用户以低级别、直观的方式探索数据库的物理存储布局,超越了 SQL 接口的抽象层,直接查看底层文件格式的组织方式。

核心目的与功能

该工具的主要目的是帮助开发者、数据库管理员、数字取证分析师和研究人员:

  1. 故障诊断与调试:当数据库文件损坏或查询结果异常时,直接检查原始页面和结构可以定位问题根源。
  2. 深入学习与教育:通过可视化展示,直观理解 SQLite 的 B-Tree 结构、页面类型(表叶页面、索引内部页面、溢出页面等)以及数据编码方式。
  3. 安全与取证分析:恢复已删除的数据片段,分析数据库历史记录,或验证文件的完整性。
  4. 开发与测试:检查数据库引擎的输出,验证自定义存储引擎或工具的正确性。

主要结构与内容展示

典型的查看器会将数据库文件分解为以下几个层次进行展示:

  • 文件头(File Header):展示最开头的 100 字节,解读关键字段,如页大小、文件格式版本、编码方式、保留空间大小等。
  • 页面列表与视图:将文件按固定大小的页(通常为 4KB)进行切分。用户可以逐页浏览,并查看每页的头部信息,如页类型、自由块偏移、单元格数量、最右指针等。
  • 页面类型解析:详细展示不同类型页面的结构:
    • B-Tree 表叶页面:存储实际的行数据。工具会解析页面的单元格,将每个单元格展示为行记录,并可以解码其序列化的值(根据列的亲和性:整数、浮点数、文本、BLOB、NULL)。
    • B-Tree 索引内部页面:展示索引键的排列和子页面的指针。
    • 溢出页面(Overflow Pages):展示当一行数据过大无法完全存放在一个页面中时,数据如何链式存储在多个页面中。
    • 空闲页面(Free Pages):标记数据库中未被使用的页面。
  • 模式与内容浏览:从系统表(sqlite_master)中解析出所有表、索引、视图和触发器的 SQL 定义,并允许用户以表格形式浏览实际数据,同时提供该数据在底层页面中的存储位置链接。
  • 十六进制与文本视图:提供页面的原始十六进制转储,并尝试将其中部分区域解码为可读文本(ASCII/UTF-8),便于观察原始数据字节。

关键特性与选项

  • 只读操作:安全地打开文件进行分析,不会修改原始数据。
  • 搜索功能:在页面数据、文本内容或特定值中进行搜索。
  • 页面摘要与统计:提供整个数据库的空间使用统计,如页面总数、各类型页面数量、空闲空间大小等。
  • 导出功能:可将页面数据或解析结果导出为文本或 CSV 格式以便进一步分析。
  • 兼容性:支持不同版本的 SQLite 文件格式。

应用场景

  • 开发者检查数据库应用程序生成的 .db 文件内部状态。
  • 数据库恢复专家尝试从受损文件中提取信息。
  • 安全研究人员检查移动设备或应用程序提取出的数据库文件。
  • 学生和教育者用于理解数据库存储引擎的工作原理。

总之,SQLite 文件格式查看器是一个强大的底层分析工具,它通过图形化或结构化的方式,将数据库文件的物理组织透明化,为高级用户提供了远超 SQL 语句的洞察力和控制力。

14. Canadian math prodigy allegedly stole $65M in crypto (www.theglobeandmail.com)

Andean Medjedovic says he hopes his case will be dropped as American regulators have pulled back on cryptocurrency-related enforcement since U.S. President Donald Trump’s inauguration

17. Implementing DeepSeek R1's GRPO algorithm from scratch (github.com)

Implementing DeepSeek R1's GRPO algorithm from scratch - policy-gradient/GRPO-Zero

18. Kezurou-Kai #39 (www.bigsandwoodworking.com)

Kezurou-kai #39 in Itoigawa, Niigata, a handplaning contest where competitors use Japanese planes to take ultra thin shavings of wood

20. How to Bike Across the Country (www.brooks.team)

如何骑行穿越全国:实用指南

骑行穿越全国是一项宏大的冒险,需要周密的计划、充分的准备和坚定的毅力。以下是完成这一旅程的关键步骤和考虑因素。

一、前期规划与准备

  • 路线规划:确定起点、终点和主要途经点。可选择横跨东西海岸的经典路线(如美国的66号公路或横跨大陆分水岭路线),或定制个性化路线。使用地图工具(如Google Maps、Komoot、Ride with GPS)规划每日行程,考虑地形、海拔、道路类型和补给点。
  • 行程与时间:估算总里程(通常为3000-5000公里或更多),根据个人体能设定每日骑行距离(建议初学者从60-80公里/天开始)。为休息日、恶劣天气和观光留出缓冲时间。整个旅程通常需要数周到数月不等。
  • 预算与资金:列出主要开支项,包括装备、食物、住宿(露营、青旅、旅馆)、维修、保险和应急资金。寻找赞助、众筹或工作假期计划以支持旅程。

二、装备选择与检查

  • 自行车:选择适合长途旅行的自行车(如旅行车或加固的山地车)。确保车架尺寸合适,并进行专业调试。
  • 驮运系统:使用结实的前后驮包或拖车,均匀分布重量以保证稳定。
  • 核心装备
    • 维修工具:备用内胎、补胎工具、多功能工具、便携打气筒、备用刹车片和链条油。
    • 导航与通信:手机(配防水袋)、备用电池/充电宝、GPS设备、纸质地图。
    • 住宿与炊具:轻便帐篷、睡袋、防潮垫、小型炉具和餐具(若计划露营)。
  • 衣物:选择速干、分层的衣物,适应多变天气。必备骑行裤、雨具、防晒帽和夜间反光衣。

三、体能训练与适应

  • 渐进式训练:出发前数月开始系统训练,逐渐增加骑行距离和负重,特别注重长距离爬坡训练。
  • 试骑与调整:进行多次连续几天的长途试骑,测试装备、调整车辆设定和骑行节奏,习惯长时间骑行的感觉。

四、行程管理与日常生活

  • 住宿选择:灵活组合露营(节省开支)、沙发客、青旅和廉价旅馆。
  • 饮食与补给:携带高热量零食和饮用水。规划好沿途城镇进行补给,注意营养均衡,补充蛋白质和碳水化合物。
  • 日常节奏:尽早出发以利用白天时间,中午避开最热时段,保持规律的休息和进食。傍晚寻找安全的营地或住处。

五、安全与应急

  • 法律与保险:了解沿途地区的交通规则,特别是自行车路权。购买涵盖意外伤害和行李丢失的旅行保险。
  • 健康与安全:携带基础急救包,注意防晒和补水。告知家人朋友你的行程并定期报平安。注意交通安全,尤其在车辆密集的路段。
  • 风险应对:了解基本车辆维修技能。存储重要证件的电子副本。学习应对极端天气(如暴风雨、酷热)的基本方法。

六、心态与精神准备

  • 保持灵活:计划可能因天气、伤病或机械故障而改变,保持开放和适应的心态。
  • 享受旅程:这不仅是体力挑战,更是心灵的探索。欣赏沿途风景,与当地人交流,记录你的经历。

骑行穿越全国是一次改变人生的体验。成功的秘诀在于细致的规划、可靠的装备、扎实的训练以及积极的心态。出发前,确保每一步都经过深思熟虑,然后,享受车轮上的自由。

21. Why Everything in the Universe Turns More Complex (www.quantamagazine.org)

A new suggestion that complexity increases over time, not just in living organisms but in the nonliving world, promises to rewrite notions of time and evolution.

22. How much oranger do red orange bags make oranges look? (alexanderell.is)

Look at this orange: Now look at this orange: It’s the same orange. But, look how much more orange it looks with the red mesh on top of it: If you buy bags of oranges (at least at many places in the US), they frequently come in this red mesh bag. This bag makes the oranges look more orange. Oranger. Here’s what that looks like at a local grocery store1:

23. Concurrency in Haskell: Fast, Simple, Correct (bitbashing.io)

Yet another programming blog. Thoughts on software and related misadventures.

24. Meilisearch – search engine API bringing AI-powered hybrid search (github.com)

A lightning-fast search engine API bringing AI-powered hybrid search to your sites and applications. - meilisearch/meilisearch

26. Show HN: Zero-codegen, no-compile TypeScript type inference from Protobufs (github.com)

🛫 Zero-codegen, no-compile TypeScript type inference from protobuf messages - nathanhleung/protobuf-ts-types

28. Hacktical C: practical hacker's guide to the C programming language (github.com)

A practical hacker's guide to the C programming language. - codr7/hacktical-c

30. NoProp: Training neural networks without back-propagation or forward-propagation (arxiv.org)

Abstract page for arXiv paper 2503.24322: NoProp: Training Neural Networks without Full Back-propagation or Full Forward-propagation

31. Writing my own dithering algorithm in Racket (amanvir.com)

My journey implementing a new dithering algorithm in the Racket programming language.

33. Don't sell space in your homelab (2023) (grumpy.systems)

Hanging out in subreddits like /r/homelab, /r/servers, and /r/datahoarder, I see this question asked too many times: I have extra space in my home server, how …

35. Show HN: Nissan's Leaf app doesn't have a home screen widget so I made my own (kevintechnology.com)

Versatile software engineer who loves improving developer productivity.

36. Fibonacci Hashing: The Optimization That the World Forgot (probablydance.com)

I recently posted a blog post about a new hash table, and whenever I do something like that, I learn at least one new thing from my comments. In my last comment section Rich Geldreich talks about his hash table which uses "Fibonacci Hashing", which I hadn't heard of before. I have worked a lot…

37. Exwm: Emacs X Window Manager (github.com)

Emacs X Window Manager. Contribute to emacs-exwm/exwm development by creating an account on GitHub.

40. Show HN: Resurrecting Infocom's Unix Z-Machine with Cosmopolitan (christopherdrum.github.io)

(updated April 28, 2025 to reflect new info from comments on the Hacker News post)

42. Scientists: Protein IL-17 fights infection, acts on the brain, inducing anxiety (medicalxpress.com)

Immune molecules called cytokines play important roles in the body's defense against infection, helping to control inflammation and coordinating the responses of other immune cells. A growing body of evidence suggests that some of these molecules also influence the brain, leading to behavioral changes during illness.