Benraouane Soufiane

# Base Onchain Metrics by month ## Tags - Base - l2 ## Brief description This metric calculated using the superchain subproject on the opensource-observer directory/repository (base_trace table). I classified...

# Number of Farcaster users per month ## Tags - farcaster - optimistic ## Brief description This IM calculated from farcaster subproject from the profile database, where the number of...

# Optimism Onchain All the time Metrics ## Tags - OP - OPTIMISM - OPTIMISTIC - L2 ## Brief description I used the classic sql selection from the optimism_traces table...

# Optimism Onchain 6 Months Metrics ## Tags - OP - OPTIMISTIC - OPTIMISM ## Brief description This metric calculated using the superchain subproject on the opensource-observer directory/repository (optimism_traces table)....

Create CryptoCheckout.md

4

#### Project Abstract Secure simple decentralized crypto payments gateway. The merchant must provide a valid DOT address when generating merchant ID in order to receive DOT payments (the only thing...

[bounty] Video/Voice LLM for Timeline

1

Use voice/video understanding to auto-label and summarize timeline chunks. eg - [ ] Combine transcript timestamps with visual content (e.g., scene changes) - [ ] Auto-tag segments with: - [...

[bounty] Video LLM for Search

1

Enable more powerful search using visual and audio context. eg - [ ] Use Video LLMs like: - [ ] [Video-LLaMA](https://github.com/DAMO-NLP-SG/Video-LLaMA) - [ ] [Video-ChatGPT](https://github.com/OpenGVLab/Video-ChatGPT) - [ ] [MiniGPT-4 +...

[bounty] Voice LLM Integration for Meetings

1

Use voice LLM to transcribe/summarize audio from meetings. eg - [ ] Use Whisper or OpenAI's Whisper API to transcribe audio. - [ ] Pipe transcriptions to an LLM (e.g.,...

fix: use ALTER COLUMN for varchar length changes instead of DROP/ADD

42

## Summary Some column changes follows drop/add path which leads to data loss (reported in this issue: #3357), this PR that edit the drop/add' guard to pass through it only...