Turso ordinal ORDER BY/GROUP BY fix
Fixed SQLite-compatible ordinal ORDER BY and GROUP BY handling through COLLATE and parentheses, with regression coverage.
View PR #6700Open source reliability and bug fixing
I help database, devtool, and AI infrastructure teams reproduce correctness issues, write regression tests, fix failing CI, and submit focused pull requests that maintainers can review quickly.
Real merged work matters more than a list of tools. These examples show correctness debugging, test coverage, production guards, and product implementation across active open-source projects.
Fixed SQLite-compatible ordinal ORDER BY and GROUP BY handling through COLLATE and parentheses, with regression coverage.
View PR #6700Found and fixed a savepoint rollback/cache invalidation correctness bug, added deterministic simulator coverage, and received the project reward.
View PR #6626Prevented DETACH on databases with active transactions and added SQL regression tests for read and write transaction behavior.
View PR #6521Gated schema changes while Turso write transactions are open, preserving shared memory accelerators and adding a regression test.
View PR #10940Added API key scopes, expiry, org/project bindings, validation checks, and production storage guards with test coverage.
View PR #176Built a unified Keeper Explorer and Faucet interface with a Flask backend and deployment-ready UI work. Received a 1,000 RST project reward.
View PR #2342Academic background only. The engineering formation gave me a scientific base for analysis, experiments, materials systems, and structured problem solving.
Studied chemistry at Ibn Zohr University in Agadir, building a scientific base for analysis, experimentation, and problem solving.
Completed a Master's in Materials Engineering and Technology, focused on ceramics and cement, at Ibn Tofail University in Kenitra.
Separate from formal education, this is the practical product-building work behind my OSS profile: client delivery, e-commerce websites, WordPress customization, digital market research, and AI-assisted full-stack web apps.
Delivered practical digital work for clients, turning unclear personal or business needs into structured, polished assets ready to use.
Built WordPress and e-commerce websites, handled domains, content, store structure, publishing, and developed small plugins or custom features for specific workflows.
Explored domains, online resale workflows, and crypto research to understand pricing, demand signals, risk, positioning, and how digital assets create value.
Use AI-assisted coding to build full-stack web apps with Node.js, React, TypeScript, APIs, and Vercel, then apply the same workflow to OSS fixes, tests, and merged PRs.
These are the offers that fit your proof of work and builder background: small, clear scopes where the client gets a working output, evidence, or a reviewable fix.
Turn vague bug reports into a minimal reproducer, root-cause note, focused patch, and regression test.
Best for open-source teams and devtool projects.
Build small web apps, dashboards, internal tools, calculators, and MVPs with React, TypeScript, Node.js, APIs, and Vercel.
Best for founders who need a usable product fast.
Set up or improve WordPress and e-commerce sites, including structure, product pages, domains, plugins, and small custom features.
Best for local businesses and online sellers.
Take a product idea and turn it into a working prototype with clean UI, basic backend logic, deployment, and iteration-ready code.
Best for testing ideas before a full build.
Check backend flows, data handling, transactions, validation, schema changes, and edge cases that can break production behavior.
Best for apps where correctness matters.
Debug failing checks, isolate flaky behavior, clean test assumptions, and add focused tests that make fixes easy to verify.
Best for teams with failing CI or fragile tests.
The goal is not to send a big patch. The goal is to make the bug obvious, make the fix reviewable, and leave maintainers with less work than before.
Start with the smallest failing case I can prove locally.
Use reference behavior, logs, CI output, or documentation to pin down expected behavior.
Write the root cause in plain language before changing too much code.
Keep the patch small, direct, and aligned with the existing codebase.
Add a test that fails before the fix and passes after it.
Simple scopes make the work easy to evaluate. Pricing depends on repository size, setup difficulty, and whether the target is public or private.
$250 to $600
$600 to $1,500
$1,000 to $3,000
Available for fixed-scope work
I will tell you if I can reproduce it, what evidence I need, and whether it is a good fit for a small PR.