Database: the safe that holds your business's most valuable assets

A database is an electronic filing cabinet

Picture a card catalog in an old library: thousands of cards arranged by strict rules, and a librarian who finds the right one in seconds. A database (DB) is the same kind of catalog, just electronic: information is stored in strictly structured tables, and a special program instantly finds, adds, and updates records.

For example, an online store database has a products table (name, price, stock), a customers table (name, phone), and an orders table. The tables are linked: an order “knows” which customer placed it and which products it contains. Thanks to these links, the site can answer queries like “show all orders for this customer in March” in a fraction of a second.

When a visitor opens a product page, the same chain from our server article kicks in: the browser asks the server, the server asks the database, the database returns the name, price, and stock — and the page is assembled “on the fly.” That’s why a price change in the admin panel is instantly visible on the site: the price is stored in just one place — the database.

Why a database is better than Excel

A fair question from a business owner: “I have everything in Excel, and it works fine.” For a startup — it really is fine. Problems start as you grow, and they’re predictable: the file exists in three versions across different employees; two people edit at the same time and overwrite each other’s changes; a manager accidentally deletes a column; searching through thousands of rows lags; and a customer in the spreadsheet isn't linked to their messages or payments.

A database solves this by design: there’s only one, and it’s always up to date; hundreds of people (and programs — the site, bot, CRM) work with it simultaneously without getting in each other’s way; every change can be logged — you can see who changed what; permissions are customizable — a manager sees orders but can’t delete the customer table.

The sign that your business has outgrown spreadsheets: you’ve got “duplicate files” (orders_final_2_NEW.xlsx), employees cross-check data manually, and answering “how much did we sell last month” takes half a day. We have a separate article about this transition — “When Excel and WhatsApp Just Aren't Enough.”

Where the database lives and who works with it

A database is a program on a server, right next to the website’s backend. Popular systems you might have heard of: MySQL, PostgreSQL — both are free and reliable, and they power a huge chunk of the internet. A business owner doesn’t need to choose between them — that’s the developer’s call, and there’s no difference in licensing costs for you.

No employee looks directly into the database — programs interact with it: the site reads products, the bot creates orders, the admin panel shows you reports. People work through user-friendly interfaces, while the database stays “under the hood.”

Backups: the only real insurance

Let’s repeat a point from our hosting article, because it’s worth it: data isn’t lost to hackers, but to a lack of backups. A drive fails, an employee makes a mistake, an update goes wrong — without a backup, any of these turns into a disaster.

What to ask your contractor today: are database backups done automatically (not “manually on Fridays”); how often (for an active store — at least once a day); where they are stored (definitely not on the same server — otherwise they’ll burn with it); and when recovery was last tested. The last point is the most important: a backup you’ve never tried to restore from is a lottery ticket, not insurance.

• Automatically, without human intervention
• At least once a day for live data
• Backups on a different server or in another data center
• Recovery is tested, not just “supposed to work”

Frequently asked questions