Working with databases in Telegram Expert

[emiliar]

In Telegram Expert, databases are a convenient way to structure and store all the information the software works with. They allow you to quickly find the necessary data, edit it, filter it, and reuse it. Databases are presented as tables where each row is a separate record, and the columns are parameters such as ID, usernames, statuses, device parameters, and much more.

What you need to get started​

Before working with databases, make sure you have SQLite Studio installed — this is a simple and free program designed to work with .sqlite format databases. You can find the installer in the Telegram Expert folder — it is usually named sqlite. After launching it, open the necessary database and start working with the data.

Display settings​

To start using the program, open it and then use the «Add database» option to insert the required file created by the software. Then, select a row from the table, double-click it, and go to the «Data» section. After that, the database will open.

One of the common beginner mistakes is wondering why the database appears «empty.» In fact, the data is simply not displayed due to row count limitations on the screen. To fix this, you can set how many records to display at once in the program settings — for example, 1000, 5000, or 20000. The more rows displayed, the more convenient it is to analyze the database as a whole.

This is especially important if you are collecting an audience: the database may contain tens of thousands of records, but you will only see a portion of them if you do not change the limit.

Editing and managing data​

Inside the database, you will see many fields — from usernames to the current processing status. Some of them can be edited manually. For example, if a user in the database is marked as Done (message has already been sent), but you want to send it again, simply change the status to Ready, save the changes (checkmark icon), and Telegram Expert will send the message to this user again.

Here are the main buttons in the SQLite Studio interface:

• Add a new row
  
  
• Delete row
  
  
• Confirm changes
  
  
• Cancel changes
  
  
• Go to the next page
  
  
• Go to the last page
  
  
• Field filter
  
  
• Apply filter

Types of databases in Telegram Expert​

Now let’s look at what data different databases provide.

Parameter generation databases​

If you used the data generation module for account registration, the database will contain parameters that simulate device data:

• APP ID — a numeric key indicating which application the request comes from. Each Telegram client has its own ID: this is like a fingerprint that the server uses to recognize who is making the request. For the desktop version, for example, it's 2040, and for the mobile client — 4.
  
  
• APP Hash — an alphanumeric code, a kind of «secret key» that complements the App ID. It is needed for verification: Telegram checks whether the application that sent the request really has the right to do so.
  
  
• SDK — the SDK version number that simulates the version of the device's software platform. It is usually used to realistically emulate a smartphone or tablet.
  
  
• Device — a text value indicating the model of the virtual device. For example, it could be Samsung Galaxy, Xiaomi Redmi, or any other name.
  
  
• APP Version — indicates which version of Telegram is supposedly being used. This helps create a more realistic simulation so that Telegram does not suspect anything.
  
  
• Lang_Code — a code that defines the interface language of the application. For example, ru for Russian, en for English. It affects how Telegram will display content.
  
  
• System_Lang — the language of the device’s operating system. It may match Lang_Code but not necessarily — you may have Telegram in English and the system in Russian.
  
  
• Lang_Pack — an additional parameter indicating the language pack used by the device. Telegram may use this when adapting the interface and checking the location.
  
  
• TZ_Ofset — time offset relative to UTC. Telegram looks at this value to determine the region the request is coming from.
  
  
• Perf_Cat — a parameter describing the class of the device. Usually, it’s a conditional characteristic of the device’s power, affecting how «heavy» an app it can run. It helps create the illusion of a real device — from a budget smartphone to a high-end tablet.

User parsing databases​

If you collected an audience from chats or comments, the user database will include the following data:

• User_ID — the numeric identifier of a specific participant, which the system uses to track activity.
  
  
• Group_ID — the ID of the group from which the user was taken during parsing, helps determine the data source.
  
  
• MESSAGE_ID — the message number if the collection was done through messages in a public chat.
  
  
• COMMENT_ID — used when parsing through comments under posts in a channel, stores the comment’s ID.
  
  
• Phone — if the phone number is publicly visible, it will be listed in this field.
  
  
• Username — the user's Telegram nickname, may be used for messaging or searching.
  
  
• First_Name — the name specified in the profile, if available for collection.
  
  
• Last_Name — the user's last name from the profile, if it is open.
  
  
• BIO — text added by the user in their bio, if any.
  
  
• Gender — a field indicating gender: M — male, F — female.
  
  
• Photo — flag indicating whether the user has a profile photo: 1 — has photo, 0 — no photo.
  
  
• Premium — shows whether the user has Telegram Premium: 1 — yes, 0 — no.
  
  
• Status — shows the current online status, for example, online, offline, or recently seen.
  
  
• Time — if the user is offline, this indicates the time of their last visit.
  
  
• Invite_Status — internal status for invite: Ready — ready for invitation, Done — already invited.
  
  
• Send_Status — field for tracking whether a message has been sent: Ready — can be sent, Done — already sent.

If group link checking is enabled, the table additionally stores information about each group. Below is an explanation of the parameters that appear in the database:

• ID — the numeric code of the group, which Telegram Expert uses to identify the chat.
  
  
• Username — the community's username, also used as the link if it was found.
  
  
• Count — shows how many users are in the group at the time of collection.
  
  
• Title — the name of the group or channel, which is displayed in the community header.
  
  
• Photo — a flag indicating whether the group has a profile picture: 1 — photo is present, 0 — no photo.
  
  
• Invite — shows whether participants can be invited to this group.
  
  
• Send_Message — indicates if it’s possible to send regular messages.
  
  
• Send_Media — whether media files (photos, videos, documents) can be sent.
  
  
• Send_Stickers — whether stickers are allowed in the chat.
  
  
• Send_Polls — whether the poll creation function is available.
  
  
• Slow_Mode — whether slow mode is enabled (message rate limitation).
  
  
• Scam — a flag indicating if the group is marked as suspicious or a scam (if 1 — the label is present).
  
  
• Type — the group format: for example, a supergroup.
  
  
• Status — current processing status: Ready — the group is ready to use, Done — actions have already been performed.

Telegram Expert stores data in convenient tables where everything is as concise as possible: ones indicate an enabled feature or availability, zeros — its absence. This principle helps quickly sort and filter the necessary rows for further tasks.