Skip to content

Instantly share code, notes, and snippets.

Rust + SQLite Project Knowledge Base & Code Review Guide

⚠️ CRITICAL AI CAPABILITY WARNING ⚠️

As an AI, I can make code suggestion mistakes. Especially when I have no idea about the solution, I nevertheless make a hallucinated suggestion instead of saying "I don't know". The error ratio is much higher for newer libraries because I am not trained on them.

However, I am very good at finding anti-patterns and code that smells.

AI Strengths ✅

  • Excellent at detecting anti-patterns and code smells

Why AI Agents Keep Failing: What 2025 Research Really Shows

Despite all the hype and billions of dollars invested, new research from 2025 shows that AI agents fail way more often than companies want to admit. Simple tasks? They do okay. But when things get complicated, these systems crash and burn - with failure rates jumping from 5% to over 80% depending on what you ask them to do.

Bottom Line: AI agents work fine for easy stuff, but they're nowhere near ready for the big promises companies are making. Real businesses are struggling to make them work, and the whole AI investment boom might be heading for a major reality check.

The Massive Failure Problem: Numbers Don't Lie

Scientists at top universities put AI agents through serious tests in 2025, and the results were pretty shocking. They tested six of the "best" AI systems - including the ones companies brag about the most - on thousands of different problems.

@umuro
umuro / rust-review-expert.md
Created July 15, 2025 18:31
Rust Review Expert

Unified Project Knowledge Base

Reviewed by Claude.ai

This comprehensive document consolidates all project knowledge for Rust development with SQLite, functional programming patterns, and code review guidelines.

Code Review Guidelines

Review Structure

Start your reviews by "Reviewed by Claude.ai" before the other content.

@umuro
umuro / tclwrust.md
Created November 9, 2023 20:00
Tcl with Rust

Implementing Rust functions and calling them from Tcl scripts involves a multi-step process. Here's a high-level overview of how you can achieve this:

  1. Writing Rust Code: Start by writing the desired functions in Rust. You'll need to compile this Rust code into a shared library (.so on Unix-like systems, .dll on Windows).

  2. Creating a C Interface: Rust functions must be exposed with a C-compatible interface (using extern "C"), because most other languages including Tcl can easily interface with C code.

  3. Building a Shared Library: Compile your Rust project with cargo to create a shared library. Make sure to use the appropriate target for your operating system.

  4. Interfacing with Tcl: Tcl can interface with C code using the Foreign Function Interface (FFI) mechanism. You'll use the load command in Tcl to load the shared library.

@umuro
umuro / tcltest.md
Created November 9, 2023 19:35
tcltest

The tcltest package is a framework for writing and running automated tests in Tcl. It is designed to support tests for core Tcl commands, Tcl library procedures, and Tcl applications. Here's an overview of how tcltest works and some of its key features:

Key Features of tcltest:

  • Test Case Definition: Tests are defined using a specific syntax that outlines what the test will do, the expected result, and any setup or cleanup that's needed.
  • Assertions: tcltest allows you to write assertions to compare expected results against actual results.
  • Test Discovery: It can automatically find and run test cases that are defined in files with a specific naming convention.
  • Test Isolation: Each test is run in isolation to prevent side effects between tests.
  • Result Reporting: The framework provides detailed reports on test outcomes, including passes, failures, and errors.
@umuro
umuro / 000-cot.txt
Last active November 9, 2023 19:24
infinite cot prompt
Imagine three different experts are answering this question. They will brainstorm the answer step by step reasoning carefully and taking all facts into consideration. All experts will write down 1 step of their thinking, then share it with the group. They will each critique their response, and the all the responses of others. They will check their answer based on science and the laws of physics. Then all experts will go on to the next step and write down this step of their thinking. They will keep going through steps until they reach their conclusion taking into account the thoughts of the other experts. If at any time they realise that there is a flaw in their logic they will backtrack to where that flaw occurred . If any expert realizes they're wrong at any point then they acknowledges this and start another train of thought. Each expert will assign a likelihood of their current assertion being correct. Continue until the experts agree on the single most likely answer. Experts A, B, and C, your task is to c
@umuro
umuro / sqlite-w-rust.md
Created October 27, 2023 22:38
Using SQLite with Rust

Here's a step-by-step process of how you can work with SQLite in a Rust project:

  1. Choose a Library:

    • rusqlite: This is a popular choice for working with SQLite in Rust. It provides a safe and comfortable wrapper around the SQLite C API.
    • diesel: While not SQLite-specific, Diesel is a powerful ORM (Object-Relational Mapping) and query builder for Rust that supports SQLite, among other databases.
  2. Install the Library:

    • Add the library to your Cargo.toml file.
@umuro
umuro / Docker Cheatsheet.md
Last active March 24, 2017 23:28
Docker commands

#RUN

docker run hello-world
docker run docker/whalesay cowsay boo
docker run -it ubuntu bash

#LIST

docker images
@umuro
umuro / Phoenix Cheatsheet.md
Last active September 2, 2017 01:44
Elixir Cheatsheets

Keybase proof

I hereby claim:

  • I am umuro on github.
  • I am umur (https://keybase.io/umur) on keybase.
  • I have a public key ASCDmpjT3ec7yNc555RFep9wNlsAQp1XiUthgJ0B63AzuAo

To claim this, I am signing this object: