Per Server Custom Prefixes in Discord.py with PostgreSQL and asyncpg

[@CodeWithSwastik]

I forgot to mention in the video but you'll need to pip install asyncpg if you don't already have it installed! Also when the video get's 100 likes I'll upload the code on github, so make sure to like!

[@ProgrammerAyush]

You gonna upload the source code to GitHub to spoonfeed like your server?

[@SmokxeeOP]

1 like to go

[@clues8012]

Can u do economy with asyncpg

[@Paper1988]

it's already got 100 likes 😂

[@tasoulman]

Code please, aahahhahahaha

[@fureai9143]

Well, this method only works when you wanna host postgres on localhost. Since postgres is a server based db, it needs to be hosted, so I recommend hosting it on a vps such as DigitalOcean or MS Azure. If you host the db on vps, then you need to provide `ssl = 'require'` kwarg while declaring the connection. Hosting services like Heroku provide a postgres add-on which basically adds a DATABASE_URI to your environment variables. *Note:* There is no way of using postgres without hosting it, so you gotta pay or link cc in order to use a vps to host it. Heroku is one of the free options but it has its own limits, so consider linking your credit card to enjoy free vps for some time!

[@ProgrammerAyush]

POV: Swas is trying to flex his discord server

[@isaiahstone2574]

All my code is correct and it says the connection was successful but when i go to change the prefix i get an error saying guilds does no exist

[@meizufluxx]

This tutorial *does* work, but this method will query Postgres on every single message the bot receives. The proper way to do this is to write a caching system where you don’t need to query the database every message.

[@conos1765]

This is pretty pog

[@diogoredondo8363]

Can you make a tutorial on warn command pls

[@GoldenJan]

Can you do this wiith cogs too? i'm currently stuck in trying to implement this...

[@KillerZM]

How do I connect it to an external database?

[@nishilsheth9076]

Please make a video like this for MongoDB and please use motor with it!

[@meizufluxx]

Postgres makes more sense for discord bots as most of the data you will store is relational

[@nishilsheth9076]

@@meizufluxx I need a cloud database so I think MongoDB would be the best choice

[@meizufluxx]

@@nishilsheth9076 why do you need a cloud database? Installing postgres on a server is super simple

[@nishilsheth9076]

@@meizufluxx oh. I just do not want to host the database or my discord bot. Could you show me how to do it? Like a yt link?

[@nishilsheth9076]

@@meizufluxx I am using replit. Can I use replit to connect to that database?

[@0nyxamv]

How to change prefix from dashboard?

[@rpbricks255]

Can you please do a tutorial on a levelling system as I feel it is a subject which does not get that much attention?

[@yoavvishne7179]

Swastik, where can I host my bot if I am using postgresql?

[@DalvinNotFound]

bruh i am getting a error saying `asyncpg.exceptions.UndefinedTableError: relation "guilds" does not exist` when i try to mention and use help or change prefix

[@gdkid]

make a table called guilds

[@orangegamer]

A warnsystem with pg would be cool

[@dts2716]

This is like SQLite, isn't aiosqlite good?

[@SymphonicMelody]

its pogg

[@thegenocide8631]

pog New video

[@makiyu3236]

it finally happened!! Death to JSON as db :gura_wink:

[@geruchslostlost927]

Thank you ❤

[@nikunjgupta3345]

Can we run pgadmin4 just on its website, I mean browser or do we need to install and run it? Btw pog vid

[@gdkid]

You need to install it

[@GH05TYPLAYz]

wheres part 4

[@rushanchess]

Can you make a video on how to create a web server using Python

[@rushanchess]

Nice 👏

[@redhawk3385]

Make sure you set guild_id in your database to be a primary key, not doing this will inserts a new entry every time you insert

[@bruceonion]

I am just vibin with Mod

[@tapu_]

And that's how you end up with 2000 character long prefix

[@mightyzain9032]

IS THERE ecomany part 5 ??

[@CodeWithSwastik]

Well it will start from Part 1 again lol

[@mightyzain9032]

@@CodeWithSwastik huh why

[@nish1176]

@@mightyzain9032 cuz he screw up and bad video make

[@Cyrus_FG]

Thank You

[@parthiv3255]

how long r u gonna keep makign discord bot tutorials :\

[@ayushanand9417]

until he or discord dies 🤣

[@FrazixOP]

@@ayushanand9417 I don't think discord bot Dev's are gonna stop anytime, because they keep adding any new feature for bots just like the Buttons.

[@SymphonicMelody]

enable text wrapping it would be easier :p

[@rashmichoubey2029]

Make a leveling system (with mongodb) like mee6 (I know how to make it but the custom image you get on leveling up plz show us that....

[@LegendYt4k]

can you make a level up commands like @name has reached level 3. GG!

[@FrazixOP]

I don't know about him but I was working on something like that and I have figured it out how to make a level up thing like mee6 or amari :)

[@clues8012]

I use SQLite3(aiosqlite) lol

[@manwhas]

Me who uses a json file

[@CodeWithSwastik]

💀

[@itsyaboivoid]

We got another one of those

[@mustafatechsolutions]

SWAS UNBAN ME PLSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS I MISS MY 40+ LEVELS!!!!!!!!!!!!!!!!!!!!

[@mustafatechsolutions]

@boomerify because i was being cooler then swas

[@FrazixOP]

@@mustafatechsolutions and wat did it cost?

[@mustafatechsolutions]

@@FrazixOP IT WAS WORTH SWAS'S LIFE