Errong Leng | Faith & Code — Reflections on Scripture and Software

Righteousness in Christ How often do we try to earn God’s approval with our own goodness? Helping others, going to church, trying to live a “good life”—all of these efforts, though well-intentioned, cannot make us righteous before a perfectly holy God. The Bible tells us that righteousness is not something we can achieve on our own. Abraham, the father of faith, was counted righteous because of his trust in God, not because of his flawless life. Paul, with all his discipline and religious accomplishments, realized that without Christ, all his efforts were worthless in God’s eyes. The good news is this: Christ Himself becomes our righteousness. Salvation is not about personal goodness; it’s about trusting in Jesus, who covers our sins and makes us right before God. Faith is the instrument through which we receive this gift—it’s the hand that reaches out to Christ, not the source of righteousness itself. Once we believe, we are fully accepted in Christ. This freedom allows u...

基督里的义 我们常常尝试靠自己的善行赢得上帝的认可：帮助别人、去教会、努力过“好”的生活——这些努力虽然出于好意，但都无法让我们在完全圣洁的上帝面前称义。 圣经告诉我们，义不是我们自己能达到的。信心之父亚伯拉罕因相信上帝而被算为义，并不是因为他过着完美的生活。保罗拥有极高的纪律和宗教成就，却意识到，没有基督，他的一切努力在上帝眼中都是无价值的。 好消息是： 基督自己成为我们的义 。救恩不是靠个人的善行，而是信靠耶稣，他为我们担当罪，使我们在上帝面前称义。信心是我们接受这一恩典的工具——是伸出的手，而不是义本身的来源。 一旦我们相信，我们就在基督里完全被接纳。这自由让我们顺服上帝，不是为了赢得认可，而是出于爱与感恩。每一件善行、每一次服事，都是源于我们已经在基督里得到的义，而不是为了争取称义。 要点总结： 义唯有基督而来。 信心是接受义的途径，而非义的来源。 人的努力无法在上帝面前称义。 在基督里生活带来自由、爱与荣耀上帝的渴望。 今天，让我们安息在这个真理里：我们在上帝眼中的接纳，不取决于我们做了什么，而是基于基督已经为我们成就的一切。

When Warning Is Love The sermon began with a strong declaration from the book of Jude: “Woe to them.” The message unfolded around one central truth—our spiritual direction matters, and the path we walk ultimately reveals where we are headed. Through examples from history, images from nature, and references to ancient writings, the sermon kept returning to the same point: what appears appealing, easy, or harmless is not always life-giving. Discernment is necessary, even in places that feel familiar and safe. One idea that stayed with me was the warning about hidden danger. Not every influence that feels encouraging or comfortable actually leads toward spiritual growth. Some voices sound pleasant but gradually shift our focus away from what is true. This raised simple but honest questions for reflection: Is faith in my life a habit or a living reality? Do I welcome correction, or only affirmation? Am I growing, or merely maintaining appearances? The sermon also used viv...

当警告也是一种爱 这次讲道从犹大书的一句严肃宣告开始：“他们有祸了。”整段信息围绕一个核心展开——人所走的道路，最终都会显明方向与结局。 讲员从历史人物、自然图像和古代文献三个角度，一次次回到同一个重点：远离神的生命，看起来可能吸引人、轻松甚至合理，但最终是空的，也是危险的。 让我印象最深的是关于“隐藏危险”的提醒。那些看起来没有问题、甚至让人感觉舒服的声音，并不一定真正带来生命。有些影响不会立刻显出破坏力，却会慢慢让人偏离方向。 这让我开始反思：信仰对我来说，是习惯，还是生命？是外在参与，还是内在真实？我是否愿意接受提醒，还是只愿听让人轻松的话？ 讲道也用了许多自然界的比喻：没有雨的云、不结果子的树、漂流不定的星。这些画面都指向一个共同点——外表存在，却没有真正的生命供应。听到这里，很难不问自己：我的生命有没有带来一点真实的果子？ 关于审判的信息听起来不轻松，但整篇信息给我的感受不是压迫，而是认真。真正关心人的提醒，不只是安慰，也包含警醒。因为如果方向错了，再轻松的路也不会带到正确的地方。 这次听道留下的一个简单祷告是：愿意被提醒，愿意被修正，也愿意继续走在正确的方向上。 信仰不是一次决定，而是每天的道路。

一次数据清理引发的教训：缺失外键索引导致 DELETE 性能问题 最近在做一次数据清理（data purge）时，我遇到了一个之前没有预料到的问题。 从业务逻辑上看，这只是一个很普通的 DELETE 操作，根据条件删除历史数据而已。 但实际执行时， DELETE 语句几乎卡住了 。 没有报错，看起来也在运行，但迟迟没有完成。 问题出在哪里？ 在 DBA 的帮助下，我们开始从数据库层面分析这个问题。 最终发现，真正的原因是： 部分外键（Foreign Key）字段缺少对应的索引。 在 Oracle 中，当对父表执行 DELETE 操作时，数据库需要检查子表中是否存在 引用该记录的外键数据。 如果外键列没有索引，Oracle 就只能对子表做全表扫描。 当数据量变大时，这种全表扫描会极大地拖慢 DELETE 操作， 甚至导致长时间锁表，看起来就像 SQL “卡住”了一样。 解决方案 在确认问题后，我们为所有缺失的外键字段补充了索引（涉及多个关联表）。 效果非常明显： DELETE 操作执行速度大幅提升 锁定时间明显缩短 数据库整体负载显著下降 SQL 没变，数据没变，只是补了索引，结果却完全不同。 如何定位缺失的外键索引 DBA 使用下面的 SQL 来检查哪些外键约束没有对应的索引。 以下示例中，schema 名、表名和索引名均已做匿名处理。 WITH fk_constraints AS ( SELECT c.table_name, c.constraint_name AS fk_name, LISTAGG(c.column_name, ', ') WITHIN GROUP (ORDER BY c.position) AS fk_columns FROM dba_cons_columns c JOIN dba_constraints k ON k.constraint_name = c.constraint_name WHERE k...

A Lesson Learned: Slow DELETE Caused by Missing FK Indexes Recently, I was working on a data purge task. The logic itself was simple: delete old records based on certain conditions. I had done similar work before, so I did not expect any major issues. However, this time the DELETE operation got stuck . No errors were reported, but the SQL just kept running without making progress. What Happened? With help from our DBA, we started investigating the issue at the database level. After some analysis, we identified the root cause: Several foreign key (FK) columns were missing supporting indexes. Because of this, every DELETE on a parent table forced Oracle to perform full table scans on related child tables to validate referential integrity. As data volume increased, the performance impact became severe. The Fix After adding indexes on the missing foreign key columns (across related tables), the results were immediate: DELETE operations completed much faster ...

权力会消逝，但神永存 今天下午的讲道提醒我： 人类的权力是短暂的，但神的权能永远长存 。 尼布甲尼撒王拥有强大的帝国、财富和军队， 但他内心仍然惧怕，因为他知道自己只是一个人。 他梦见一尊由金、银、铜、铁和泥土组成的像， 这说明即使最强大的王国， 最终也会衰败和消逝 。 这教导我们： 神震动人虚假的安全感 。 我们可能信靠金钱、地位或政府， 但这些都不是永恒的， 它们会像梦中的像一样被毁灭。 然而，神也 显明真正的意义 。 但以理和他的朋友们祷告、信靠神， 而不是依靠人的智慧。 神向他们启示了梦和梦的解释： 那块击碎像的石头， 象征 神永恒的国度 ， 并在耶稣基督里得以成全。 与人类的权力不同， 神的国永不衰败、永不失败， 不受时间或帝国的影响。 这也提醒我反思： 我把信心放在哪里？ 是在短暂的事物上， 还是在神身上？ 唯有信靠祂， 我才能得到真正的平安和生命的意义。 唯有基督所成就的事才永远长存。 我们的生命和行为有意义， 是因为它们是祂工作和国度的一部分。 阿们。

Power Fades, God Remains Today’s sermon reminded me that human power is temporary, but God’s power lasts forever . King Nebuchadnezzar had a great empire, wealth, and armies, yet he was afraid because deep inside he knew he was only human. His dream of the statue made of gold, silver, bronze, iron, and clay showed that even the strongest kingdoms will fall and fade . This teaches us that God shakes false security . We may trust money, positions, or governments, but these things are not eternal. They can be destroyed, just like the statue in the dream. But God also reveals real meaning . Daniel and his friends prayed and trusted God instead of relying on human wisdom. God revealed the dream and its interpretation: the stone that destroys the statue represents God’s eternal kingdom , fulfilled in Jesus Christ. Unlike human power, God’s kingdom never fades, never fails, and is not threatened by time or empires. This calls me to ask myself: Where do I put my confidence...

听道反思：我是“做梦的人”，还是“挖掘的人”？ 今天听完犹大书的信息，有一个问题一直在我心里回响： 我是在依靠神的话，还是在依靠自己的感觉？ 犹大并没有把假教师描述成不属灵或不敬虔的人，反而称他们是“依靠自己梦的人”。问题不在于他们有没有属灵经历，而在于他们把经历当成了权柄。 这让我反思自己。很多时候，我也是凭感觉做决定——只要我觉得平安、舒服、有把握，就认为这是从神来的。但今天的信息提醒我：感觉不是根基，神的话才是。 从人的角度看，罪不是抽象的，它真实地污染我们自己。而这种污染，并不只来自明显、公开的罪，也来自日常生活中看似无害的习惯。 比如不断刷抖音、短视频，随意浏览网页，让大量碎片化、刺激性的内容充满我们的眼睛和思想。没有人强迫我们这样做，但久而久之，这些内容正在塑造我们的欲望，使我们对神变得迟钝。我们每天所“消费”的内容，从来都不是中立的，不是在塑造我们，就是在扭曲我们。 从神的角度看，不顺服从来不是小问题。当我选择按自己的方式生活，其实是在把主权从基督手中拿走，放在自己身上。我口里承认祂是主，生活中却常常自己当王。 从天使的角度看，更让我感到羞愧。连天使都不敢轻看神的权柄，而我却有时用“现在是恩典时代”来为自己的不顺服辩护。犹大提醒我，这不是自由，而是骄傲。 但感谢神，信息没有停留在责备中。耶稣已经成全了律法。律法不再是控告我的审判官，而是在基督里，成为引导我如何生活的蓝图。 当撒但控告我时，我的回应不在于我做得够不够好，而在于基督已经为我成就了一切。顺服不再是换取生命的条件，而是已经得着生命后的回应。 今天我被提醒：不要满足于做梦，要甘心挖掘；不要只问“我感觉如何”，而要问“神已经说了什么”。 愿神帮助我继续活在祂话语的权柄之下，让我的生命不再制造属灵的污染，而是因基督的恩典，散发出更新与生命的气息。

Reflection on Jude: Am I Dreaming, or Digging? After hearing today’s message from the book of Jude, one question stayed with me: Am I grounding my life in God’s Word, or in my own feelings? Jude does not describe false teachers as irreligious or unspiritual people. Instead, he calls them those who “rely on their dreams.” The problem is not that they lack spiritual experiences, but that they treat those experiences as their authority. That hit close to home. I often make decisions based on how I feel—peaceful, comfortable, confident—and assume that must mean God is leading me. But today’s message reminded me that feelings are not a foundation. God’s Word is. Jude shows us the consequences of ignoring God’s Word from three perspectives. From the human perspective, sin is not abstract—it pollutes us. And this pollution does not only come from obvious, public sins. It also comes through ordinary, everyday habits. Endlessly scrolling TikTok or short videos, casually browsing...

解决 react-native-tts Android 构建失败：Could not find method jcenter() 在运行 React Native Android 项目时，我遇到了如下构建错误： A problem occurred evaluating project ':react-native-tts'. > Could not find method jcenter() for arguments [] on repository container of type 错误发生在执行以下命令时： ./gradlew app:installDebug 根据错误信息，问题最终定位到了以下文件： node_modules/react-native-tts/android/build.gradle 问题原因分析 jcenter() 已经被 Gradle 官方弃用，并在较新的 Gradle 版本中被移除。 但部分较老的 React Native 第三方库仍然在 Android 配置中使用 jcenter() ，这会直接导致 Android 构建失败。 本次出问题的正是 react-native-tts 这个库。 为什么不能直接改 node_modules？ 直接修改 node_modules 中的代码虽然可以暂时解决问题，但并不可靠。 以下操作都会导致修改丢失： 重新执行 npm install 重新执行 yarn install 删除并重建 node_modules 因此，我们需要一种 可重复、可维护、对团队友好 的解决方案。 正确的解决方案：patch-package patch-package 是一个非常实用的工具，可以让我们对第三方依赖进行补丁修复，并在每次安装依赖时自动应用这些修改。 在 react-native-tts 官方修复之前，这是一个非常稳妥的方案。 修复步骤详解 1. 安装 patch-package npm install patch-package --save-dev 或者使用 Yarn： yarn add patch-package --d...

Fixing react-native-tts Android Build Error: Could Not Find Method jcenter() While running a React Native project on Android, I encountered the following build error: A problem occurred evaluating project ':react-native-tts'. > Could not find method jcenter() for arguments [] on repository container of type The build failed when running: ./gradlew app:installDebug After checking the stack trace, the error clearly pointed to the following file inside node_modules : node_modules/react-native-tts/android/build.gradle Why This Error Happens jcenter() has been deprecated and removed in newer versions of Gradle. However, some older React Native libraries still reference it. In this case, the library react-native-tts was still using jcenter() in its Android Gradle configuration, which caused the build to fail immediately. The Tempting but Wrong Fix You can temporarily fix the issue by directly editing the file inside node_modules — but this so...

iTrans – Fast iPhone Photo & Video Transfer for macOS Do you find Photos.app slow or cluttered when backing up your iPhone photos and videos to your Mac? I built iTrans , a lightweight macOS utility that lets you transfer your media directly into folders on your Mac — fast, simple, and without the extra bloat. How iTrans Works Plug in your iPhone Open iTrans Select photos and videos to transfer Choose the destination folder on your Mac Click transfer — done! iTrans is perfect for quick media backups, organizing photos without importing them into Photos.app, or simply moving videos off your iPhone in a flash. Demo Video Check out this short demo showing iTrans in action: Support iTrans To publish iTrans on the Mac App Store, Apple requires a $99 annual Apple Developer Program fee. If you find iTrans useful and want to support its release, you can contribute here: Support iTrans – Help Publish on the Mac App Store Even if you can't contrib...

January Traffic Snapshot: Faith & Code Across the World As January comes to a close, I want to take a moment to reflect on how Faith & Code — Reflections on Scripture and Software has been read and accessed over the past month. 📈 Overall Engagement In January, the blog recorded 8.89K total pageviews . Traffic remained steady throughout the month, with a notable peak in mid-January, suggesting that certain posts resonated more strongly during that period. Rather than relying on a single spike, the overall pattern reflects consistent readership. 🌍 Global Readership The blog continues to reach readers across the world: It’s humbling to see reflections on faith, confession, and vocation being read across cultures and time zones. 💻 Pageviews by Operating Systems Readers accessed the blog using a wide variety of operating systems: The balance between desktop and mobile platforms reflects a readership engaging both in focused reading and on-the-go moments. 🌐...

关怀就是：彼此认罪 今天下午听了教会关于关怀小组主题的一篇讲道，主题是： 彼此认罪 。 说实话，这不是一个让我觉得“舒服”的主题。 如果要列出我们彼此关怀的方式，这大概不会排在前几名。 向神认罪，我可以理解；向另一个人认罪，就感觉很冒险。 讲道一开始就点出了这个张力。是的，罪最终是得罪神的， 也只有神能赦免罪。这一点没有争议。 但雅各书 5:16 仍然说： “你们要彼此认罪，互相代求，使你们可以得医治。” 让我印象最深的不是“你必须去做”，而是 为什么 要这样做。 不是为了暴露自己，也不是为了情绪宣泄， 而是为了得到 安慰 和 劝勉 。 有时候，我们已经向神认过罪了， 但心里的愧疚感仍然挥之不去。 或者反复跌倒，让人开始怀疑： 我真的悔改了吗？神真的饶恕我了吗？ 这时，有另一个基督徒能把福音再一次对你说出来， 用神的话安慰你，并为你祷告， 这本身就是神赐下的一种医治方式。 讲道也提到，罪是很顽固的。 隐藏它，往往只会让它更强。 把它带到光中，才可能有人陪你一起面对， 给你实际的提醒和帮助。 我也很受提醒的一点是： 关怀不仅是“去认罪”， 也是 如何接住别人的认罪 。 不是论断，不是好奇， 而是温柔、福音，以及把事情带到神面前。 而且，它应该止于你。 最后有一个比喻我很喜欢。 我们的生命像一栋房子，有不同的房间。 不是每个人都能进每一个房间，这很正常。 但不应该有一个永远上锁、谁都不能进的房间。 至少，应该有一个人， 能看见整栋房子。 这不是一件容易的事。 但我离开教会时在想， 也许正是这样的真实和敞开， 神用来带来医治、自由， 以及真正彼此相爱的教会生活。

Caring Is: Confessing Sin to One Another This afternoon’s sermon in our care group series was on a topic that honestly made me a little uncomfortable: confessing sin to one another . It’s not something we usually think of as “caring.” If I’m honest, it probably wouldn’t make my top five ways Christians support each other. Confessing sin to God? Yes. Confessing sin to another person? That feels risky. The sermon acknowledged that tension right away. Of course, God is the one who forgives sin. He’s the one we’ve ultimately sinned against. That part isn’t in question. But James 5:16 still says, “Confess your sins to one another and pray for one another, that you may be healed.” What struck me was why we might do this—not to be exposed, embarrassed, or publicly honest, but to receive comfort and counsel . Sometimes you confess a sin to God and still feel guilty. Or you wonder if your repentance is real. Or you keep falling into the same struggle and start questioning whether...

主日早堂讲道反思：犹大书中的一个必要提醒 今天早堂崇拜中所读的经文出自《犹大书》，为整篇讲道定下了基调。这是一封很短的书信，却分量十足，我们所听到的经文并不让人轻松。 犹大原本是想写一封鼓励人的信，谈论众信徒所共享的“同一救恩”。但他却不得不转而警告教会——不是因为外在的逼迫，而是因为内部的危险。有些人悄悄地混进了教会，口中谈论恩典，生活却是否认耶稣的主权。 讲道中最让我印象深刻的，是犹大从哪里开始说起。他并没有立刻详细描述这些假教师，而是先提醒教会一件我们并不太愿意常常思想的事：审判。 跟随耶稣是美好的，是赐生命的，但并不总是容易的。当顺服开始变得有代价时，其他的声音就显得格外有吸引力：“真的那么重要吗？”“是不是太狭窄了？”犹大的回答既简单又令人不安：是的，这真的很重要。神已经定下一个日子，耶稣要在那一天审判世界。 犹大举了三个圣经中的例子——旷野中的以色列人、悖逆的天使，以及所多玛和蛾摩拉。每一个例子都在提醒我们：转身退后、拒绝耶稣的权柄，或是在罪中安顿下来，最终都会走向同一个方向。 这篇信息并不是为了吓唬人，而是为了唤醒人。信仰只有一条路。假教师常常提供“捷径”，看似更轻松，却无法把人带到他们所承诺的终点。 今天早上的讲道让我心里很沉，却也充满感恩。感恩再次被提醒：耶稣不只是我所相信的救主，更是我当顺服跟随的主。

Morning Sermon Reflection on Jude: A Needed Reminder The Scripture reading from the book of Jude set the tone for this morning’s sermon. It is a short letter, but a weighty one, and the passage we heard was not easy to sit with. Jude originally wanted to write something encouraging about the “common salvation” Christians share. Instead, he felt compelled to warn the church. Not because of pressure from outside, but because of danger from within. People had quietly crept into the church, speaking about grace while living in ways that denied the authority of Jesus. What stood out to me most in the sermon was where Jude begins. Before describing these false teachers in detail, he reminds the church of something we don’t like to think about very often: judgment. Following Jesus is good and life-giving, but it isn’t always easy. When obedience becomes costly, other voices can start to sound appealing. Does it really matter? Isn’t this too narrow? Jude’s answer is simple and uncomf...