drewdru/fastdrewdru

backend for https://github.com/drewdru/sitedrewdru

Hi there 👋

☺️ My name is Andrew and I'm a Software Engineer. I have more than 6 years of experience in Full Stack Web Development.
🤩 As Front-end Web Developer I prefer to use TypeScript(Vue, React), HTML, CSS(Less, Bootstrap/Material).
🧑‍💻 As Back-end Web Developer I prefer to use NodeJS(Nestjs), Python(FastApi, Django/DRF, Flask), ORM(SQLAlchemy, Prisma, TypeOrm, Sequelize), SQL(PostgreSQL, MongoDB), Nginx, Docker, MQTT(Redis, RabbitMQ, Kafka).
🤓 I like to grow my professional skills and learn something new.

🎓 I'm a Master of Computer Science

2016-2018

Siberian State Aerospace University
Master of Computer Science (MSCS), Computer science
Faculty: Information and Telecommunications
Specialty: Artificial Intelligence

2012-2016

Siberian State Aerospace University
Bachelor of Computer Science (BCompSc), Computer science
Faculty: Information and Telecommunications
Specialty: Software Engineering

📫 How To Hire Me

• [email protected]
• Telegram
• Upwork
• LinkedIn
• CV Ovsyannikov A.K..pdf

⚡ My Skills

Operating Systems	Linux, Windows
Development languages	Python, JS/TS, C#, Go
Frameworks	Node(Express, Nest, Prisma, TypeORM), Vue/Nuxt, React, Angular, Python(FastAPI, Django/DRF, Flask, SqlAlchemy)
DBMS/MQTT/ORM	PostgreSQL, MongoDB, MySQL, Redis, RabbitMQ, Kafka, DynamoDB, Prisma, SQLAlchemy, TypeORM, Sequalize, DjangoORM
Others	Celery, Docker, Nginx, Git, Google Cloud Platform, AWS(Amplify, Lambda, S3, Cognito), WebRTC, SocketIO

🔬 My Experience

November 2022 - to date

Full-stack Developer | UDev
🔗 https://udev.dev/
⚡ Skills: TS, Nodejs(NestJs, Prisma), Python(FastAPI, SqlAlchemy), SocketIO, React, PostgreSql, Docker, Kafka, MongoDB, GCP

🛠 Description

• Participated in development of: Tumeke, music streaming service for smart speakers, online broadcasting and media information exchange service.
• Added: Alice's ability to play background music on smart speakers using NLP command processing; authentication API; selection of participants in stand-up rooms with the ability to reduce the wait time; project migration from Python to NodeJs; visualization of Ergonomic Posture Risk Assessment Calculation Results, raw SQL optimization.

---

July 2021 - March 2022

Full-stack Developer | Altermeliora
🔗 https://altermeliora.com/
⚡ Skills: Node(NestJS), React.js, Python(Django), Google Cloud Platform, PostgreSql, Redis, Docker

🛠 Description

• Participated in development of: a payment platform for selling courses and products.
• Added: products' form; logic of discounts and promo codes; generation of sales reports; settings for payment systems; tax calculation for sellers; delivery of goods using Shiptor and ChinaDivision API; payment systems Bluesnap, Fondy, Paypal, YooMoney; Email Delivery Service SendGrid; form that creates hierarchy of categories; auto-registration of users on Club after a successful payment; enablement to create different auto-registration scripts; calories' calculation; data synchronization between platforms; CRM and Club multilingual interface.

---

July 2020 - to date

Full-stack Developer | Freelance
🔗 My Account on Upwork
⚡ Skills: Node(Nest, express), Python(Flask, FastAPI, Tornado), SqlAlchemy, Vue.js,Nuxt, Vuetify, React, WebRTC, Angular, AWS(Amplify/Lambda/DynamoDB/Cognito),GraphQL, RabbitMQ, Docker, C#(ASP.NET 6), PostgreSql, MongoDB, Minio, socketio,Keycloak

🛠 Description

August 2022 - November 2022:

• Participated in development of: assessment system with gamification for company Cibirlan.
• Marked up layouts of: page for creating scheduled tournaments.
• Added: automatic filling of rooms; the logic of launching tournaments, assigning roles and teams; game chat.

April 2022 – March 2022, July 2020 – September 2020:

• Participated in development of: the video surveillance system.
• Marked up layouts of: admin panel.
• Added: customizable dashboard, widgets, pipelines.

April 2021 – June 2021:

• Participated in the development of: MVP of freight transportation.
• Marked up layouts of: admin panel.
• Added: authorization; geocoding via here.com; data visualisation on a map.

February 2021 – April 2021:

• Participated in development of: I-EXP projects.
• Added: API for user authorization; Telegram bot notifications about user actions; data generation methods for neural network training; pHash calculation; search by similar images; microservice architecture; tasks queue.

November 2020 – December 2020:

• Participated in development of: website security analysis system.

---

June 2020 - to date

Full-stack Developer | PonyLand
🔗 https://pony.land
⚡ Skills: Vue.js, Nuxt.js, ASP.NET, ASP.NET MVC, Entity Framework, .NET Framework, Game Development, Unity, .NET Core, Apache Kafka, Minio, Node.js, C#, PostgreSQL, Redis

🛠 Description

• Participated in development of: the MMORPG game Pony.Land, music streaming service for smart speakers, online broadcasting and media information exchange service.
• Developed: Pony.Land website, SSO authorization and authentication logic, DDOS attack and botnet protection algorithms, GibberishClassification trash message classification, flood and spam protection algorithms with detection of similar messages from different users, NN to filter out profanity, threats and vulgarity, API for custom character textures.
• Implemented: Google recaptcha, hCaptcha, sendGrid for sending messages and validating email clients.

---

August 2018 - October 2020

Full-stack Developer | YLab Development
🔗 https://ylab.io/
⚡ Skills: Python(Django/DRF, Flask), Go, AngularJS, Vuejs, PostgreSql, Redis, Celery, Docker

🛠 Description

1. ECN.Broker, Esplanade MS
   • Marked up layouts of: admin panel; user account; traders' training pages; landing pages; WordPress pages; email templates.
   • Added: authorization; API MetaTrader 4; Telegram bot notifications about user actions; DB migrations; DB backups; payment systems RBK.money, Accentpay, and Interkassa; referral program; WYSIWYG Quill editor for news; API Claws&Horns; google visualization charts; API IndigoSoft; forex calculators; RAMM copy trading; Email Delivery Service SendGrid; API Bpilot for contract specification.
2. B2B-export
   • Marked up layouts of: admin panel; user account; email templates.
   • Added: form that creates hierarchy of categories; bulk import of products; ABBY translation API.
3. Carreta
   • Added: bulk import of prices.
4. TeachLearnLanguages
   • Added: API ipstack.com; S3Storage for images; bulk import of prices.
5. Internal and other projects
   • Implemented crawling sites for analyzing product prices (scrapy + selenium).
   • Developed a system for aggregating CSV/XLS reports, set up validation of files and user data, implemented text field recoding, distribution of reports in Clickhouse + MSSql.
   • Added: product prices crawler; system for aggregating CSV/XLS reports; data decoder; Optical Character Recognition system.

---

September 2016 - February 2018

Software Engineer | Aigeo
🔗 http://aigeo.ru/
⚡ Skills: Python(Django/SQLAlchemy), AngularJS, OpenLayers 3, PostgreSQL

🛠 Description

• Developed a web application: Aigeo References; Aigeo References Map; Medical Areas(mirror); Normalizer for normalizing the address.
• Added: Medical Areas as module to Med-monitor(mirror);
• Extended: Geonode API for Aigeo servieces.

fastdrewdru's Issues

use pydantic BaseSettings

use pydantic BaseSettings

fastDrewDru/fastdrewdru/db.py

Line 13 in 31a7be6

# TODO: use pydantic BaseSettings

from functools import lru_cache
from typing import Any

from sqlalchemy import MetaData
from sqlalchemy.engine import Engine
from sqlalchemy.ext.asyncio import create_async_engine
from sqlalchemy.ext.declarative import declarative_base

from fastdrewdru import config


# TODO: use pydantic BaseSettings
@dataclass
class DbService:
    metadata: MetaData
    engine: Engine
    Model: Any


# TODO: Use Dependes injections for engine. import metadata?
@lru_cache()
def get_db_service() -> DbService:
    settings = config.get_settings()
    engine = create_async_engine(settings.SQLALCHEMY_DATABASE_URI, echo=settings.DEBUG)
    metadata = MetaData()
    Base = declarative_base(metadata=metadata)
    return DbService(metadata=metadata, engine=engine, Model=Base)
ew file mode 100644
ndex 0000000..d26cd80
++ b/fastdrewdru/exceptions.py

6a65ba9de103830e13f1f35fba0a78248d6005c1

Use Dependes injections for engine. import metadata?

Use Dependes injections for engine. import metadata?

fastDrewDru/fastdrewdru/db.py

Line 21 in 31a7be6

# TODO: Use Dependes injections for engine. import metadata?

from typing import Any

from sqlalchemy import MetaData
from sqlalchemy.engine import Engine
from sqlalchemy.ext.asyncio import create_async_engine
from sqlalchemy.ext.declarative import declarative_base

from fastdrewdru import config


# TODO: use pydantic BaseSettings
@dataclass
class DbService:
    metadata: MetaData
    engine: Engine
    Model: Any


# TODO: Use Dependes injections for engine. import metadata?
@lru_cache()
def get_db_service() -> DbService:
    settings = config.get_settings()
    engine = create_async_engine(settings.SQLALCHEMY_DATABASE_URI, echo=settings.DEBUG)
    metadata = MetaData()
    Base = declarative_base(metadata=metadata)
    return DbService(metadata=metadata, engine=engine, Model=Base)
ew file mode 100644
ndex 0000000..d26cd80
++ b/fastdrewdru/exceptions.py

5212d016624907505ec8a5f51a75897ac6111b2d

Use Dependes injections for engine. import metadata?

Use Dependes injections for engine. import metadata?

fastDrewDru/fastdrewdru/db.py

Line 21 in b897f87

# TODO: Use Dependes injections for engine. import metadata?

    metadata: MetaData
    engine: Engine
    Model: Any


# TODO: Use Dependes injections for engine. import metadata?
@lru_cache()
def get_db_service() -> DbService:
    settings = config.get_settings()
    engine = create_async_engine(settings.SQLALCHEMY_DATABASE_URI, echo=settings.DEBUG)
    metadata = MetaData()
    Base = declarative_base(metadata=metadata)
    return DbService(metadata=metadata, engine=engine, Model=Base)
ew file mode 100644
ndex 0000000..d26cd80
++ b/fastdrewdru/exceptions.py

e3d0e645fd0abca6ccc6881021b8c77394948922

Use jenkins for prod

migrate to FastApi

use pydantic BaseSettings

use pydantic BaseSettings

fastDrewDru/fastdrewdru/db.py

Line 12 in 3219a2f

# TODO: use pydantic BaseSettings

# TODO: use pydantic BaseSettings
@dataclass
class DbService:
    metadata: MetaData
    engine: Engine

bb9995e4de87b44065980c64953d2ec60eb80fbf

Use one session per request

Use one session per request

fastDrewDru/fastdrewdru/utils.py

Line 28 in f250f43

# TODO: Use one session per request

async def get_session(db: DbService = Depends(get_db_service)):
    # TODO: Use one session per request
    async with AsyncSession(db.engine, expire_on_commit=False) as session:
        yield session
ndex e68fb01..115bdda 100644
++ b/main.py

d6a26b7ad2b8deaaf3776b6603d413ea13d7bf31