Question 1

How to create a PostgreSQL database and connect

Accepted Answer

1. Prerequisites

To follow this tutorial, you will need:

Standard Plan or higher: Database hosting on Square Cloud is a feature available starting from the Standard plan.
Dashboard Access: Your access credentials for the Square Cloud platform.

2. Creating the Database Instance

Access the Square Cloud Dashboard.
Go to the Databases page and select the Create database option.
Name your instance.
Choose PostgreSQL from the list of available databases.
Select the desired RAM and confirm the creation.
After initialization, you will have access to the essential credentials: Host, Port, User, and Password.

Tip: To make things easier, Square Cloud automatically initializes a database named "squarecloud" inside the instance, but you can create your own within the instance.

3. Understanding SSL Certificates

Square Cloud requires encrypted connections to ensure data security. Unlike local connections, here you will need specific certificates provided by the platform.

In your database settings tab, you will find the following download options:

certificate.pem: This is a combined file containing the private key (key) and the certificate (cert). For most connection drivers, this is the only file required.
client-key.key and client-cert.crt: Provided separately for systems or drivers that require i

Question 2

How to host a Discord bot (free, 24/7)

Accepted Answer

1. Prerequisites

Before deploying your bot, make sure you have:

Square Cloud Account: Create your account via the Registration Page (Email or GitHub).
Active Plan: A paid plan is required for hosting. Check the pricing here.

2. Source Code Preparation

For Square Cloud to run your bot correctly, it must be organized and contain the dependency definition file.

Python Example (discord.py)

Make sure you have a requirements.txt file in the root of your project:

discord.py

JavaScript Example (discord.js)

Make sure you have a package.json file in the root of your project:

{
  "name": "my-discord-bot",
  "version": "1.0.0",
  "main": "index.js",
  "dependencies": {
    "discord.js": "^14.0.0"
  }
}

3. Compression and Cleanup (Important)

A common mistake is trying to upload all project files, including cache folders or local dependencies. For a clean and fast deployment, you should create a .zip file containing only the essentials:

What to INCLUDE: .py or .js files, configuration files (.json, .txt), and the dependency file (requirements.txt or package.json).
What to EXCLUDE:
- node_modules/ (Node modules folder)
- __pycache__/ (Python cache)
- .env (Environment variables will be configured in the dashboard)
- .git/ or IDE files (such as .vscode/)

4. Deploying Your Bot

There

Question 3

LoginFailure: Improper token (401) — TOKEN_INVALID: how to fix

Accepted Answer

What this error means

Your Discord bot can't authenticate because its token is missing, wrong, or no longer valid (the Discord API responds with HTTP 401 Unauthorized). Typical messages:

# discord.js
Error [TOKEN_INVALID]: An invalid token was provided.

# discord.py
discord.errors.LoginFailure: Improper token has been passed.

Why it happens

The token was regenerated in the Developer Portal (the old one immediately stops working).
The token was reset or revoked for security.
It's misconfigured — extra spaces or quotes, or the code is reading the wrong variable.

How to fix it

1. Regenerate the token. In the Discord Developer Portal, open your application → Bot → Reset Token, and copy the new value.

2. Update the token where it's stored. Replace it in your .env file or config.json (and in your Square Cloud environment variables, if you use them). Never commit the token to GitHub.

3. Keep the library up to date. npm install discord.js@latest or pip install -U discord.py.

4. Restart the application.

Setting up a bot for the first time? See How to create a Discord bot from scratch and How to host a Discord bot.

Question 4

Sharding on Discord: how to scale your bot (2,500+)

Accepted Answer

Sharding: How to Scale Your Discord Bot on Square Cloud

When a Discord bot grows and reaches the 2,500 server mark, Discord requires it to use a technique called Sharding. Even before reaching this milestone, sharding can be a smart strategy to manage resources and prevent a failure in one server from bringing down the bot's connection across all others.

1. What Is Sharding?

Sharding is the process of splitting your bot's workload into multiple instances or "pieces" (shards). Instead of a single WebSocket connection handling all events from all servers, each shard takes care of a specific subset of servers.

Think of sharding as opening multiple cash registers at a supermarket instead of having just one cashier handling a mile-long line. This avoids processing bottlenecks and improves the bot's responsiveness.

2. Why Use Sharding on Square Cloud?

Hosting a sharded bot on Square Cloud offers strategic advantages:

Error Isolation: If one shard encounters a critical error and crashes, the other shards continue operating normally.
Memory Management: Node.js and Python have memory limits per process. Splitting the bot into shards allows you to make better use of your plan's total RAM.
Discord Limits: Discord enforces a strict limit of 2,500 servers per shard. Without sharding, your bot will stop receiving events once it hits this limit. Learn more here.

3. Technic

Question 5

DBeaver: how to connect to PostgreSQL (SSL)

Accepted Answer

DBeaver: How to Connect to PostgreSQL

DBeaver allows you to intuitively manage your tables, execute complex queries, and visualize data from your PostgreSQL database hosted on Square Cloud. To establish this connection securely, we will use encryption certificates (SSL).

1. Connection Details

Before opening DBeaver, locate the connection URL in your dashboard. You will need to extract the following information:

Host: square-cloud-db-id.squareweb.app (id is your instance ID, which is already included in the copied URL).
Port: The provided numerical port (e.g., 31000).
Database: squarecloud (or the name of the database you created).
Username: squarecloud
Password: The password generated along with the instance.

2. Configuring the Connection in DBeaver

Open DBeaver and click the New Database Connection icon (a plug with a plus sign).
Select PostgreSQL and click "Next".
In the Main tab, fill in the fields with the data collected in the previous step (Host, Port, Database, Username, and Password).

3. Configuring SSL (Mandatory Step)

Square Cloud does not allow connections without SSL for PostgreSQL. To configure it, follow this path within the connection window:

Go to the SSL tab.
Check the Use SSL box.
In the SSL Mode field, select verify-ca or require.
Now, point to the files you downloaded from the dashboard:
- Root Certificate: Select the .pem fil

Question 6

How to keep Discord bots online 24/7

Accepted Answer

How to Keep Bots Online 24/7: Resilience Best Practices

Keeping a bot active 24 hours a day, 7 days a week, requires more than just good hosting. In a production environment, connections drop, APIs fail, and unexpected errors occur. To ensure your bot is truly resilient, you need to design it to anticipate and survive these failures.

1. Resilient Error Handling

The biggest enemy of a bot's uptime is the unhandled exception. If a critical error occurs inside a command or event and is not caught, the bot's process will terminate abruptly.

Defense Strategies:

Global Error Catching: Implement a centralized handler (Global Error Handler) to catch failures in commands before they break the application.
Loop Isolation: If your bot runs background tasks, wrap the internal execution block in control structures (try/except or try/catch) so that a failure in one iteration does not cancel the entire loop.

Resilience example in asynchronous tasks (Python):

import asyncio
import logging

async def my_periodic_task():
    while True:
        try:
            # Heavy logic or API request here
            await perform_critical_operation()
        except Exception as e:
            # Logs the error without crashing the loop or the bot
            logging.error(f"Error in periodic task: {e}", exc_info=True)

        # Waits for the next cycle (e.g., 60 seconds)
        await asyncio.sleep(60)

2. Strict Adherence to Rate Limits

APIs (

Frequently Read Articles

Browse All Categories