# demos

**Repository Path**: edge006/demos

## Basic Information

- **Project Name**: demos
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-04-02
- **Last Updated**: 2026-04-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Bitswired Tutorials Repository

Complete source code and documentation for projects featured on
[Bitswired YouTube channel](https://youtube.com/@bitswired).

## Project Index

| Project                                  | Description                                                                                                | Links                                                                                                 |
| ---------------------------------------- | ---------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------- |
| **Introduction to MCP with SQL Agent**   | Build an AI SQL agent using MCP to interact with a SQLite database through natural language.               | [Video](https://youtu.be/cxl3tPWLOQ8) • [Code](projects/introduction-to-mcp-with-sql-agent/README.md) |
| Control Asyncio Concurrency              | Master concurrency in Python asyncio using Locks and Semaphores to manage tasks and API calls              | [Video](https://youtu.be/ZO74-pZLr1w) • [Code](projects/python-concurrency-guards/README.md)          |
| How To Upsert Properly (SQL)             | Learn different approaches to implementing upsert operations using SQLAlchemy's async features with SQLite | [Video](https://youtu.be/d0Dv7r3JuWA) • [Code](projects/upsert-with-on-conflict/README.md)            |
| 10 Advanced Tailwind Tricks from Shadcn  | Learn powerful styling patterns and advanced techniques for building React components with Tailwind CSS    | [Video](https://youtu.be/9z2Ifq-OPEI) • [Code](projects/10-tailwind-tricks-from-shadcn/README.md)     |
| Flatten Directories for AI Code Analysis | Transform entire codebases into LLM-friendly single files with path context preservation                   | [Video](https://youtu.be/Q9-DpH0D4vg) • [Code](projects/flatten-dir-for-ai/README.md)                 |
| Full API Type Safety with OpenAPI-Fetch  | Achieve complete type safety between FastAPI backend and React frontend with automatic type generation     | [Video](https://youtu.be/qgyCB39hlRM) • [Code](projects/full-api-type-safety/README.md)               |

_Subscribe to [Bitswired](https://youtube.com/@bitswired) for more tutorials._

## Contributing

1. Fork the repository
2. Create your feature branch
3. Submit a pull request

## License

MIT License - See [LICENSE](LICENSE) file for details.