Who is a mini PC for local databases suitable for?

Developer with a local test database

You run a database alongside your development tools and want enough memory and storage for your own projects. The PostgreSQL documentation covers memory settings and monitoring disk usage.

Home worker with valuable work data

You use a local database for data that you may need to recover. The PostgreSQL Global Development Group recommends backing up databases regularly; the Dutch Data Protection Authority stresses that organisations processing personal data must keep it secure.

User running multiple local services

You expect to run more databases or other local services, so you compare the expansion options for the exact model with what’s included as standard. Manufacturer and model specifications can vary between versions.

What should you look for when choosing?

Choose between a system that’s ready to use and one you can configure yourself. The right option depends on your current workload, plans for future growth and whether you’re happy to arrange components or backups separately.

Fully configured model

Choose this if: you want to get started without buying RAM and an SSD separately, and are looking for a specified Windows configuration.

Bear in mind: the listed specifications apply to the version named; check for yourself whether they suit your database, other software and expected growth.

Expandable or configurable model

Choose this if: the option to expand later or configure the system yourself matters more than being able to start straight away with a complete configuration.

Bear in mind: a stated maximum isn’t the same as installed memory or storage. Check what’s included with the version you choose, and arrange backups separately.

What to consider What should you check? Who is this important for?
Memory for your database and other tasks Check the installed RAM, memory slots and expansion limits for the exact version. Take into account your database and the programmes running at the same time. If you use a database alongside development tools, you’ll want to know how much memory is available for these simultaneous tasks. Around 30% of consumers rank this memory capacity as their top priority.
Storage space and expansion Estimate the size of your current database files and their expected growth; check how many SSDs are installed and what expansion options the version offers. The PostgreSQL documentation explains that tables and indexes use storage space. If you expect your project files to grow, you’ll want to leave enough space and know how to expand it later. Around 30% of consumers prioritise storage space and room to grow.
Backups and recovery Decide how you’ll make backups, where you’ll store them and whether you can restore them. Choose a method that’s suitable for the database you use. If you’re working with data you can’t afford to lose, you’ll want to set up and test a recovery plan in advance. Around 20% of consumers put recoverability first.
Setup and management Check which components and operating system are included with the version, and review the applicable service terms. If you want to spend as little time as possible on installation, it’s important to know how much is already set up and what you’ll need to do yourself. Around 20% of consumers prioritise a complete, clearly specified version.

Common pitfalls

  • Mistaking the maximum memory capacity for the RAM included

    An expansion limit doesn’t tell you how much memory is installed in the version you choose. Lenovo PSREF lists a standard maximum of 32 GB for the ThinkCentre M75q Gen 5 12RQ0040IX; according to the specification sheet, 64 GB is available only through special orders.

    Check the full model code, the supplied configuration and the expansion conditions before ordering.

    You may need to buy and install extra memory separately.

  • Treating extra internal storage as a backup

    A second SSD in the same computer is no substitute for a separate backup and recovery procedure. The PostgreSQL documentation describes different backup methods, each with its own requirements.

    Decide in advance where you’ll keep a copy, and test whether you can restore the database using your chosen method.

    Allow for setting up a separate backup destination and taking time to test recovery.

  • Choosing speed settings without considering the risk to your data

    The PostgreSQL documentation warns that certain non-durable settings can cause data loss or corruption if the system crashes unexpectedly.

    Use these settings only if losing the relevant data would be acceptable; don’t base your decision solely on an expected performance gain.

Brands to consider

HP

The HP ProDesk 4 Mini G1i version reviewed, BY7A0ET#ABH, is a specified mini desktop with Windows 11 Pro, 16 GB RAM and a 512 GB SSD, according to HP Store Netherlands.

  • HP describes the case as compact and lists two SSDs and tool-free access for this product range.
  • Check whether the exact version has a spare storage slot; the manufacturer’s information doesn’t prove database performance.

Lenovo

According to Lenovo PSREF, the ThinkCentre M75q Gen 5 12RQ0040IX reviewed has 16 GB RAM, a 512 GB SSD and Windows 11 Pro.

  • Lenovo PSREF lists two memory slots and support for up to two internal SSDs for this model.
  • The standard memory specification lists a maximum of 32 GB; according to Lenovo PSREF, 64 GB is available only through special orders. This may not apply to other ThinkCentre versions.

MINISFORUM

The manufacturer presents the UM890 Pro as an expandable mini PC, listing support for up to 96 GB of memory and two 2.5G network ports.

  • The stated expansion options may be useful if you want more memory capacity later.
  • The manufacturer’s specifications don’t tell you how much memory is installed in a particular version, nor do they provide measured database performance; check exactly what’s included.

Beelink

The European manufacturer’s website lists two M.2 PCIe 4.0 SSD slots for the SER8 8745HS.

  • The listed internal SSD slots may be worth considering when comparing expansion options.
  • A performance comparison published by Beelink isn’t independent verification or a basis for ranking this model higher.

Joybuy products for local databases

This selection includes mini PCs for local databases, from fully configured systems to a barebone version you can set up yourself.

SOYO Y5Pro mini PC with Intel Core i5 8250U/8350U, 8 GB DDR4 and 256 GB SATA SSD

SOYO Y5Pro Mini PC, Intel Core i5 8250U/8350U, 8 GB DDR4, 256 GB SATA SSD

Could suit a local database used alongside other work software, if the listed memory and storage configuration meets the demands of your workload.

The product name lists 8 GB DDR4, a 256 GB SATA SSD, Windows 11, Bluetooth 5.2 and Wi-Fi 5.

View at Joybuy
Lenovo Yoga Mini 01IPH11 Copilot+ PC with 16 GB LPDDR5X and 512 GB SSD

Lenovo Yoga Mini 01IPH11 Copilot+ PC, 16 GB LPDDR5X, 512 GB PCIe 4.0 SSD

Could suit anyone combining a database with development tools and looking for a pre-specified memory and SSD configuration.

The product name lists 16 GB LPDDR5X, a 512 GB PCIe 4.0 SSD and Windows 11 Home. According to the product information, the memory is soldered and expandable to a maximum of 32 GB.

View at Joybuy
SOYO M5 mini PC with AMD Ryzen 4300U, 16 GB LPDDR4 and 512 GB SSD

SOYO M5 Mini PC, AMD Ryzen 4300U, 16 GB LPDDR4, 512 GB SSD

Could suit anyone looking for a version with a stated memory and SSD capacity for a local database alongside work software.

The product name lists 16 GB LPDDR4, a 512 GB SSD and Windows 11 Pro.

View at Joybuy
FIREBAT R3 mini PC with AMD Ryzen 5 7430U, 16 GB RAM and 512 GB SSD

FIREBAT R3 Mini PC, AMD Ryzen 5 7430U, 16 GB RAM, 512 GB SSD

Could suit home working with a local database running alongside other tasks, provided the listed configuration meets your needs.

The product name lists 16 GB RAM, a 512 GB SSD and Wi-Fi 6.

View at Joybuy
MSI Cubi NUC 1MG-237BEU barebone mini PC, 0.84 litres, black

MSI Cubi NUC 1MG-237BEU Barebone, 0.84 litres, black

Could suit anyone who wants to configure the system themselves rather than choose a fully specified setup.

The product name lists a 0.84-litre barebone version with Intel 150U. The product information says you’ll need to configure the operating system and the required software; check which components are included with this version.

View at Joybuy

Frequently asked questions

How much RAM and SSD storage do I need for a local database?

There’s no one-size-fits-all amount for every local database. Assess your dataset and the programmes running at the same time, then compare your requirements with the installed memory, available storage and expansion options for the exact version.

Can I back up an important database to a second internal SSD only?

No. A second internal SSD on its own isn’t a separate recovery solution. Set up a backup method that suits your database, keep a copy in a separate location and test that you can restore it. The PostgreSQL Global Development Group describes methods including dumps, file-system-level backups and continuous archiving; these methods aren’t interchangeable.

What are the rules on cooling-off periods and warranties in the Netherlands?

For many distance purchases, consumers have 14 days to change their mind, according to the Dutch government; whether this applies depends on the purchase. The Dutch government also says that the seller must provide a solution if there’s a problem with a product. For business purchases, check the applicable contract terms, as consumer rules don’t automatically apply to every business purchase.

Can I store personal data in a local work database?

Using a local computer doesn’t automatically exempt you from security obligations when storing personal data. The Dutch Data Protection Authority says that organisations processing personal data must keep it secure; the appropriate measures depend on the circumstances. So make sure you also agree the setup of a work database with your organisation.