Who is this buying guide for?

Developer running several local databases

You run one or more local database processes alongside your development environment and want to match the memory and storage to your workload. The PostgreSQL Global Development Group describes, among other things, how the database uses memory buffers.

Administrator managing shared test data

You want to be able to restore local data and, if it contains personal data, restrict access appropriately on the shared workstation. The PostgreSQL Global Development Group describes various backup and recovery methods.

User with limited shared desk space

You’re looking for a small computer with screen connections and other ports to suit your workspace. Check how noisy it is in the setup you plan to use, too; Lenovo PSREF, HP Netherlands and ASUS describe different configurations and connectivity options.

What should you look for?

What to consider What to look for when buying Who is this for?
Memory and simultaneous tasks Work out which database processes and other programmes will run at the same time. Compare the installed RAM, upgrade options and processor for the exact configuration. If I run several databases alongside my development environment, I want to match the configuration to that combination. Around 33% of consumers make memory and the specific processor configuration their top priority.
Storage and recovery Check the SSD capacity and any upgrade options for the specific model. Also choose a backup method and test that you can restore the database; PostgreSQL distinguishes between SQL dumps, file-system-level backups and continuous archiving, among other options. I want to be able to restore my local database files if something goes wrong; a second drive on its own isn’t a recovery plan. Around 27% of consumers make data retention and recovery their top priority.
Access on a shared workstation Establish whether the data includes personal information and who is allowed to use the computer and database. The Dutch Data Protection Authority says that appropriate access protection depends on the purpose and context of the processing. If several people use the same workstation, I want to specify who can access the database data. Around 20% of consumers make restricted access their top priority.
Space, connections and what’s included Check the dimensions, ports, network connection and included components of the exact configuration. Also consider the ventilation clearance needed and how noisy the computer is in your intended setup. I want the computer to fit on the shared desk and connect to my existing screens and peripherals. Around 20% of consumers make desk fit and a complete package their top priority.

Common buying mistakes

  • Assuming a second SSD is a complete backup

    Extra internal storage gives you more space, but it doesn’t in itself explain how you can restore a database. PostgreSQL documents various backup methods; choose one that suits your data and recovery needs.

    Decide on a backup and recovery method, then test restoring your data before counting extra internal storage as a solution.

  • Comparing mini PCs by family name alone

    Within the ASUS NUC 14 Pro family, complete mini PCs and kits differ, and processors and included components also vary between configurations.

    Compare the full model number, processor and the components actually included with the configuration you’ve chosen.

    A kit may require extra setup if components need to be selected or installed separately.

  • Confusing a security feature with properly configured access controls

    A computer feature won’t automatically set access permissions for the database. If an organisation processes personal data, it must restrict access appropriately for that processing.

    Decide who is allowed to use the data and configure access accordingly. The Dutch Data Protection Authority emphasises that the measures needed depend on the purpose and context.

    User management and appropriate security measures take time to set up and maintain.

Brands to consider

Lenovo

ThinkCentre Tiny configurations are worth considering if expandability and a clearly specified business configuration matter to you.

  • For the ThinkCentre M70q Gen 5 configuration 12TN0017EZ, Lenovo PSREF lists 16 GB DDR5, a 512 GB NVMe SSD, support for two SSDs and three years of on-site service.
  • These features apply to the configuration listed; other M70q models may differ. The specifications aren’t a database benchmark.

HP

The Pro Mini 400 G9 configuration 6D494EA#ABH is a compact business model with a clearly specified setup.

  • HP Netherlands lists an Intel Core i5-12500T, 16 GB RAM, a 512 GB SSD and Windows 11 Pro for this configuration.
  • HP’s general claims about performance and security aren’t an independent assessment of database workloads or noise levels.

ASUS

The NUC 14 Pro family lets you choose between a complete mini PC and a kit you can configure yourself.

  • ASUS distinguishes between complete mini PCs and kits in this family, including kits without a pre-installed operating system.
  • The processor, memory and included components vary by model. Check the full model number and what’s included in the package.

MSI

MSI says the PRO DP10 A14MG range is designed for compact business workspaces, with configurable connectivity.

  • MSI lists dual-channel DDR5 support and, depending on the model, support for a third screen via a configurable port.
  • The exact specifications vary by model. Manufacturer information isn’t an independent database or noise test.

Mini PCs at Joybuy

These product picks focus on compact mini PCs for local databases and shared desks. Compare the memory and storage configuration, connections and included components for each model.

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

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

A compact option to consider if you need a wired network connection and have limited desk space.

The listed configuration includes 8 GB DDR4, a 256 GB SATA SSD, a 1G RJ45 port and dimensions of 105 × 113 × 45 mm. Check that the memory and storage are right for the database processes you want to run at the same time.

View at Joybuy
Lenovo Yoga Mini 01IPH11 Copilot+ PC, Intel Core Ultra 5 325, 16GB LPDDR5X, 512GB PCIe 4.0 SSD

Lenovo Yoga Mini 01IPH11 Copilot+ PC, Intel Core Ultra 5 325, 16GB LPDDR5X, 512GB PCIe 4.0 SSD

This configuration is worth comparing if you’re looking for a compact computer with a wired network connection for local tasks.

The description lists 16 GB LPDDR5X, an Intel Core Ultra 5 325, a 512 GB PCIe 4.0 SSD, 2.5GbE and a 0.65-litre chassis. Listed connections include HDMI and Thunderbolt 4; the operating system is Windows 11 Home.

View at Joybuy
Lenovo IdeaCentre Mini, 16GB DDR5, 512GB NVMe SSD

Lenovo IdeaCentre Mini

A compact option to consider if you want to use local databases and other applications in a small workspace.

The configuration described has 16 GB DDR5, a 512 GB PCIe 4.0 NVMe SSD, Gigabit Ethernet and a 1-litre chassis. Windows 11 Home and several screen connections are also listed.

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

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

This configuration is worth comparing if you need several screen outputs and a wired network connection.

The product description lists 16 GB LPDDR4, a 512 GB SSD, a 1G RJ45 port and Windows 11 Pro. Listed video outputs are HDMI 2.0, DP 1.4 and Type-C; dimensions are 128 × 128 × 47,6 mm.

View at Joybuy
Lenovo ThinkCentre M70q Gen 5, Intel Core i7-14700T, 16GB DDR5, 512GB SSD

Lenovo ThinkCentre M70q Gen 5, Intel Core i7-14700T, 16GB DDR5, 512GB SSD

This business mini PC is worth comparing if expandability and a compact setup are important to you.

The description lists an Intel Core i7-14700T, 16 GB DDR5, a 512 GB SSD, two M.2 slots, support for up to 64 GB of memory and Windows 11 Pro. VESA mounting is listed; note that the power adapter isn’t included.

View at Joybuy

Frequently asked questions

How do I work out how much RAM my local database needs?

First, work out which database processes and other applications will run at the same time. The PostgreSQL Global Development Group describes, among other things, the use of memory buffers, but there’s no universal RAM requirement for every local database. Then compare the installed memory and upgrade options for the exact mini PC.

Is a second internal SSD enough for a backup?

No. Don’t assume that a second drive on its own is a restorable backup. Choose an appropriate method and test that you can restore the database. The PostgreSQL Global Development Group describes SQL dumps, file-system-level backups and continuous archiving as different methods.

What do I need to install if I buy a mini PC kit?

Check the exact kit before you order. Within the NUC 14 Pro family, ASUS distinguishes between kits without a pre-installed operating system and complete configurations; memory and storage also vary by model.

What warranty applies in the Netherlands?

When you buy as a consumer, a product must meet the standard you’re entitled to expect. According to the Dutch government, there’s no fixed statutory warranty period in the Netherlands; a manufacturer’s warranty is additional. For a business purchase, don’t assume the same consumer rules apply, and check the contract terms.

Are separate access permissions legally required at a shared desk?

Not simply because the desk is shared. If an organisation processes personal data, it must protect it appropriately; according to the Dutch Data Protection Authority, the access protection needed depends on the purpose and context. So establish what data is being processed and who needs access.