🗄️ PV-COM + MySQL

Save every weighing to MySQL automatically

PV-COM reads the weight from your RS-232, USB, or HID scale and inserts it directly into your MySQL database with date, time, and any fields you need. No programming, no scripts, no manual intervention. PV-COM® is also known as PVCOM or PV COM.

✓ No SQL programming
✓ Local or cloud MySQL
✓ Customizable fields
MySQL — table: pesajes_pvcom
mysql> SELECT * FROM pesajes_pvcom ORDER BY id DESC LIMIT 5;
ID
Weight
Date/Time
Unit
Operator
1005
12.340
2026-07-09 10:42
kg
Juan P.
1004
25.780
2026-07-09 10:41
kg
Juan P.
1003
08.450
2026-07-09 10:39
kg
María L.
1002
31.200
2026-07-09 10:37
kg
María L.
1001
17.890
2026-07-09 10:35
kg
Juan P.
LAST INSERT EXECUTED BY PV-COM
INSERT INTO pesajes_pvcom
(peso, fecha_hora, unidad, operario)
VALUES (12.340, NOW(), 'kg', 'Juan P.');
● PV-COM inserting in real time · COM3

The technology behind it

How does PV-COM connect the scale to MySQL?

PV-COM acts as a direct bridge between the scale and your database. It reads the weight, waits for stability, and executes the INSERT automatically.

⚖️
Your scale
RS-232 · USB · HID
Any brand
200+ models
→ Serial
frame
⚙️
PV-COM
Reads · Filters
Waits for stability
Runs INSERT
→ SQL
INSERT
🗄️
MySQL
Local · LAN · Cloud
Configurable table
Complete record
PV-COM runs the INSERT automatically every time it detects a stable weight on the scale
💡

Stability filter: PV-COM doesn't save just any reading — it waits until the scale's indicator confirms the weight is stable before running the INSERT. This ensures MySQL only holds real weighing records, not transient or in-motion values. The stability threshold is configurable.

MySQL features

Total control over your weighing log

PV-COM has specific options to manage how and when data is saved to MySQL.

⚡

Automatic INSERT for every weighing

Every time the scale stabilizes a weight, PV-COM automatically runs an INSERT into your MySQL table. No buttons, no manual confirmations, no operator intervention.

Automatic · Real time
🕐

Automatic timestamp

Every record includes the exact date and time of the weighing using MySQL's NOW(). Never lose track of when each product or batch was weighed.

NOW() · Date · Time
🔧

Configurable table and fields

You define the name of your table and which columns PV-COM uses. You can integrate it into an existing table in your database without creating a new one.

Existing table · Custom fields
🌐

Local or remote MySQL

PV-COM connects to MySQL on localhost, on a local network (LAN), on a remote server, or in the cloud (AWS RDS, Google Cloud SQL, DigitalOcean, etc.).

Local · LAN · Cloud
🔄

Continuous or trigger mode

Save weighings in continuous mode (every X seconds) or only when a significant weight change is detected. Ideal for process-control scales or batch control.

Continuous · Event-based
📋

Compatible with MariaDB

In addition to MySQL, PV-COM is compatible with MariaDB, the most popular open-source alternative and the one used by many shared hosting servers.

MySQL · MariaDB

Data structure

Fields PV-COM can save to MySQL

Configure which columns to include in your table based on your business needs. You can use all the fields or only the ones you need.

Field SQL type Description Status
peso DECIMAL(10,3) Numeric weight value read from the scale Required
fecha_hora DATETIME Exact date and time of the weighing (NOW()) Required
unidad VARCHAR(5) Unit of measure: kg, g, lb, oz Optional
operario VARCHAR(100) Name or code of the operator who performed the weighing Optional
codigo_producto VARCHAR(50) Code or reference of the weighed product Optional
numero_bascula TINYINT Scale identifier (useful with multiple scales) Optional
puerto_com VARCHAR(10) COM port the scale is connected to (COM1, COM3…) Optional
campo_extra VARCHAR(255) Any additional custom field you need Customizable
🔧

Do you already have a table? No problem. PV-COM can integrate with a table that already exists in your database. During remote installation, our technician maps PV-COM's fields to your existing table's columns. You don't need to create a new table if you already have a data structure.

Use cases

What is saving weighings to MySQL good for?

A complete historical record of weighings opens up possibilities that manual data entry could never offer.

🏭 PRODUCTION CONTROL

Batch traceability

Record the weight of each batch produced with a timestamp. Check at any time how much was produced, when, and who weighed it.

📦 LOGISTICS

Shipment control

Save the weight of every package or box shipped. Generate load reports by date, customer, or destination directly from MySQL.

♻️ RECYCLING & WASTE

Material log by supplier

Every incoming material is recorded with weight, date, and supplier. Simplifies settlement and inventory control of recycled material.

🐄 AGRICULTURE

Animal weighing history

Record the weight of each animal or batch in your database. Cross-reference the data with growth, feeding, or sales tables.

🔬 QUALITY & ISO

Auditing and compliance

Generate automatic weighing reports for ISO, HACCP, or GMP audits. MySQL makes it easy to export to Excel, PDF, or quality systems.

💻 DEVELOPMENT

Integration with your software

If you have your own software or custom ERP, PV-COM populates the weighing table and your software queries it with a SELECT whenever it needs the data.

Installation process

Your scale recording to MySQL in under 30 minutes

Remote installation via AnyDesk. Our technician configures the connection to your MySQL server and verifies that the data arrives correctly.

1

Purchase the license

Get PV-COM via PayPal. The process takes 5 minutes.

2

Prepare your MySQL details

Have ready: host, port, user, password, and database name.

3

Remote installation

Our technician connects via AnyDesk, installs PV-COM, and configures the connection to your MySQL server.

4

Live verification

We weigh an object and verify the record appears in your MySQL table in real time.

Video tutorial

See how PV-COM works with MySQL

Full demonstration: from connecting the scale to recording the weight in the database.

Have questions about the setup? Message us on WhatsApp →

Real screenshot

This is what weighings look like in MySQL Workbench

PV-COM saves every weight to the database. Query, export, and analyze your complete weighing history with any MySQL tool.

Scale weights saved in MySQL Workbench with PV-COM

Pricing

One single investment.

No monthly subscriptions. No renewals. Pay once.

PV-COM® — Official product box
$99 USD
One-time payment · Lifetime license
✓ Permanent license (one-time payment), 1 PC
✓ Compatible with RS-232, USB, and HID
✓ Remote installation included
🛒 Buy now

Pay via PayPal (card or PayPal balance)

Frequently asked questions

Scale + MySQL with PV-COM

Everything you need to know before buying.

Do I need to know SQL or programming to use PV-COM with MySQL?
No. PV-COM has a visual interface where you enter the connection details and define the fields. You don't need to write SQL code, scripts, or configure drivers manually. Our technician handles the entire setup during the remote installation included with your license.
Can PV-COM connect to my cloud MySQL database?
Yes. PV-COM can connect to any MySQL server reachable from the PC where the scale is connected: local MySQL, on a LAN, on a VPS server, or in cloud services like AWS RDS, Google Cloud SQL, DigitalOcean Managed Databases, or any hosting with MySQL. You just need port 3306 open and accessible.
Can I integrate PV-COM with a MySQL table I already have?
Yes. PV-COM can be configured to insert data into an existing table in your database. During installation, our technician maps PV-COM's fields to your table's columns. You don't need to create a new table if you already have a data structure.
Is PV-COM compatible with MariaDB?
Yes. PV-COM is compatible with MariaDB, the open-source database derived from MySQL and used by most shared hosting servers. The setup is identical to MySQL.
Can I connect several scales and save each one to MySQL?
Yes. PV-COM supports multiple scales simultaneously. You can configure each scale with its own channel and save the weighings from each one to the same table (differentiated by a field like numero_bascula or puerto_com) or to separate tables.
What happens if the MySQL connection drops?
PV-COM detects the loss of connection and can be configured to temporarily save weighings to a local file (CSV or TXT) while the connection is unavailable. Once MySQL is reachable again, PV-COM can resume recording normally.
Can I build reports from the data saved in MySQL?
Yes. Once the weighings are in MySQL, you can run SELECT queries with any tool: MySQL Workbench, phpMyAdmin, Excel (via ODBC), Power BI, Google Looker Studio, or any software that connects to MySQL. The data is entirely yours and accessible from any tool.

Technical guide

Technical answers about scales and MySQL

How do I save a scale's weight to MySQL?

With PV-COM configured with your MySQL server details, every stable weighing automatically executes an INSERT into the configured table. The record includes the weight, date, time, and any additional fields you've defined. No programming or manual intervention from the operator is required.

What is a scale datalogger with MySQL?

A scale datalogger with MySQL is a system that automatically records every weighing to a database with a timestamp. PV-COM works as a datalogger: it reads the weight from an RS-232 or USB scale and inserts it into MySQL with date, time, and configurable fields, creating a complete, queryable history of weighings.

How do I connect an RS-232 scale to a database?

To connect an RS-232 scale to a MySQL database you need middleware like PV-COM that reads the scale's serial data stream, extracts the weight value, and executes the INSERT into the database. PV-COM does this automatically without the need for custom programming.

Are PVCOM and PV-COM the same thing?

Yes. PVCOM, PV COM, and PV-COM® are the same software from Mavin Colombia SAS. The official name is PV-COM®, but many users search for it as PVCOM or PV COM without the hyphen. If you searched for "PVCOM scale" or "PV COM software," you've come to the right place.

Ready to have a complete weighing history in MySQL?

A lifetime license. Remote installation included. 1 year of support.

Using different software? See all PV-COM integrations →

💬