YtoMp3

Simple video search bot for telegram that lets the user search for videos on youtube via inline command. Now you can take full advantage of telegrams unlimited free storage and built in mp3 player without having to worry about backing up your songs or loosing them!! Now with added support for mp4 format too !!

Requirements [self hosting]

Inline telegram bot
Bot Tokem from botfather
Youtube V3 API creds

Steps for self hosting

Clone the repo
Run pip install -r requirements.txt
Create an inline bot using botfather ( look here if unsure on the steps )
You will get a bot-token paste that in bot.py and mp3dldr.py and mp4dldr.py
you will need to get your API keys for youtube from here
Put the API creds in yt_search.py
Run bot.py python3 bot.py

Usage

type @botusername in message field and type the video name (might take a few sec for video to appear )
Wait till the video appears and click on it
press the convert to mp3/convert to mp4 button which appears after that
Wait for it to convert
video will be downloaded

PS: This bot is made purely for educational purposes and getting an understanding of the bot api. Certain songs are not meant to be downloaded do check TOS of youtube.

LINK TO REPO

##########################################################################

JAVA APP

An implemetation of a software company database and with added functionalities. Backend implemented in sql and frontend created with java swing using JDBC to connect backend to frontend

link to Project Documentation

Usage Instructions [for linux machines]

Clone the repository copy the src/ folder to your local machine and add the sql dump to your databse

Steps to recover db from sql dump

To recover db from a MySQL dump, enter:

mysql -u [user] -p [database_name] < [filename].sql

Make sure to include [database_name] and [filename] in the path.

It’s likely that on the host machine, [database_name] can be in a root directory, so you may not need to add the path. Make sure that you specify the exact path for the dump file you’re restoring, including server name (if needed).