The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Before creating a table, write down four requirements: how much data it will contain, how it will be read and written, how long it must be kept, and how tenant data will grow and be isolated. Those answers—not architectural preference—help determine whether one table, database partitions, application-level shards, or separate databases for tenants make sense.
1. How much data will the system hold?
Estimate both the rate of new rows and the accumulated total over the retention period. “How many rows arrive each day?” and “How many will remain after a year?” are more useful than an unqualified description such as “high volume.” Include the effect of versioning: if a change creates a new row instead of updating an existing one, superseded values add to the total.
As an Amazon Associate I earn from qualifying purchases.
Make the estimate explicit about its assumptions: expected daily creation, retention duration, and whether updates, retries, or historical versions create additional rows. The point is not to predict growth perfectly; it is to make the scale assumption visible before it silently shapes the schema.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstall2. How will the data be accessed?
Describe the read-to-write ratio and the important query patterns. A workload dominated by writes may call for different operational attention from one dominated by repeated reads. Also note whether particular workloads need separation, and what the application must retrieve: a tenant’s latest state, a time range, an audit history, or some combination.
#1 Best Overall
- Easily store and access 2TB to content on the go with the Seagate Portable Drive, a USB external hard drive
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Pagination belongs in this requirement too. Large OFFSET queries can become increasingly costly, and inserts may shift the page window between requests. Keyset pagination instead continues from a known sort key and can provide bounded pages, but it does not naturally let a user jump directly to an arbitrary page such as page 4,000. Choose based on the navigation users actually need.
3. How long does each row live, and how is it removed?
State the retention period and the removal mechanism. A single retention window applied to whole time ranges may be compatible with dropping old partitions. A legal or product requirement that gives every row its own deletion deadline is different: dropping a monthly partition cannot, by itself, remove each row on its individual schedule.
Rank #2
- Easily store and access 5TB of content on the go with the Seagate portable drive, a USB external hard Drive
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Be precise about the boundary. In one service described by Anton Brilliantov, audit data is split into monthly partitions, and a job drops only partitions wholly older than the monthly cutoff. It retains the current and next partitions, the default partition, and any partition that crosses the cutoff. The author also describes the job as idempotent and says it updates an age gauge even when no partition is removed. These are details of that service’s implementation, not universal requirements.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problems4. How many tenants are expected, and what isolation do they need?
Specify the expected tenant count, how quickly it may grow, and what separation tenants require. Clarify whether tenant data can share tables, whether some tenants need stronger isolation, and how queries will be routed if the data is later divided across databases.
Rank #3
- Easily store and access 1TB to content on the go with the Seagate Portable Drive, a USB external hard drive.Specific uses: Personal
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop. Reformatting may be required for Mac
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Partitioning and sharding place complexity in different layers. Partitions divide data within a database and can be transparent to ordinary query callers. Application-level shards are separate databases; the application must route requests and may need to combine results across shards. A database per tenant is another possible boundary, but increases the number of databases and the work of provisioning, upgrades, monitoring, and operations.
In Brilliantov’s described example, tenant data uses hash partitioning by owner. The article discusses application-level sharding and a database per tenant as possible future directions; it does not claim that the service already runs a shard map or thousands of tenant databases.
Rank #4
- Easily store and access 4TB of content on the go with the Seagate Portable Drive, a USB external hard drive.Specific uses: Personal
- Designed to work with Windows or Mac computers, this external hard drive makes backup a snap just drag and drop
- To get set up, connect the portable hard drive to a computer for automatic recognition no software required
- This USB drive provides plug and play simplicity with the included 18 inch USB 3.0 cable
- The available storage capacity may vary.
Use the four answers to compare storage options
| Option | Where complexity lives | Questions to resolve first |
|---|---|---|
| One table | In the database schema and queries, without a partitioning layer. | Will the dataset remain small and bounded? Do its access patterns and retention needs remain manageable without partitioning? |
| Database partitions | Within one database, through partition keys, partition management, and query behavior. | Can the data be divided along a useful key? Is retention uniform enough to remove whole partitions? What is the consequence of changing the partition key later? |
| Application-level shards | In application routing and, when needed, assembling results from multiple databases. | What determines shard placement? How will queries spanning shards work? What operational capabilities are needed to move or rebalance tenants? |
| Database per tenant | In provisioning and operating many separate databases, as well as routing each tenant to its database. | Does the isolation requirement justify that operational overhead? How will tenant count affect upgrades, monitoring, backups, and administration? |
These options are not a universal progression from “small” to “large.” A small dataset expected to stay small may be best served by one table. Conversely, strict isolation or a tenant-specific requirement can influence the design even before raw row counts become large. Compare each option against the four stated requirements and the behavior the application must support.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Translate requirements into operational checks
A storage decision is easier to maintain when each requirement has a corresponding design choice, mechanism, and signal. For example, a retention requirement should identify the cutoff rule and how operators can tell whether cleanup is keeping up. A tenant-growth assumption should identify what would trigger a routing or isolation change. Avoid treating a design choice as complete if nobody can observe whether its underlying assumption still holds.
Best Value
- [Upgraded Version] - This external hard drive features a mirrored logo stripe combined with a striped anti-slip design, and the rounded corners of the casing make it easier to grip. The stripes also have a heat dissipation function, ensuring stable and fast data transfer.
- 【Ultra-thin and quiet】 - The motherboard adopts JMicron 578 noise-free solution, giving you a quiet working environment. Lightweight and portable size designed to fit in your pocket for easy portability.
- 【Ultra-Fast Data Transfers】 - Pairing this external hard drive with JMicron 578 solution USB 3.0 and USB 2.0 interfaces enables blazing-fast data transfer. It boasts theoretical read speeds of up to 125MB/s and write speeds of up to 103MB/s.
- 【Plug and Play】 - With no software to install, just plug it in and the drive is ready to use.The hard disk chip is wrapped with an aluminum anti-interference layer to increase heat dissipation and protect data.
- 【What You Get】 - 1 x Portable Hard Drive, 1 x USB 3.0 Cable, 1 x User Manual, Gift-type shell packaging ,Three-year manufacturer's warranty and free technical support services.
Versioned data illustrates why this matters. Brilliantov describes a service where domain changes create new versions, current state is derived from historical rows, and domain tables are not physically deleted or destructively updated. In that model, growth is monotonic—even an incorrect value may be superseded rather than erased—so a volume estimate and a retention plan are central inputs, not afterthoughts.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.When this approach is useful—and where it has limits
Writing these requirements first is useful when a storage choice could commit the application to substantial migration or operational complexity. It makes discussions about a single table, partitions, sharding, or tenant isolation answerable with assumptions rather than preference.
- Small, bounded data: If it is expected to remain small, an unpartitioned table may be simpler and entirely adequate.
- Per-row deletion deadlines: Monthly partition removal does not satisfy individual schedules on its own; the deletion mechanism must match the actual requirement.
- Retention granularity: Monthly partitions impose month-sized cleanup boundaries in the described approach.
- Changing partition keys: The key is a consequential design choice; changing it after creation can be costly.
- Versioned history: Keeping superseded rows increases stored data, so estimates must count versions rather than only current records.
- Page-number navigation: Keyset pagination trades arbitrary page jumps for continuation from a known position.
The underlying principle is broader than databases: requirements should settle architecture debates. Brilliantov summarizes it this way: “The general form of this, which I now apply well outside storage: an argument about ‘microservice or module’, ‘CQRS or not’, ‘queue or direct call’ is settled by a line of a non-functional requirement, not by preference.” That is the author’s engineering perspective, not a standards-body rule.
What the project figures do—and do not—show
Brilliantov reports that the project grew from 1,751 lines of code across 35 files and 13 packages on August 10, 2026, to 61,411 lines across 1,540 files and 252 packages at a HEAD dated August 16, 2026. The article also reports 66 migration files containing 1,990 migration lines, and a test-to-code ratio rising from 0.45 to 1.25 in the displayed project snapshot. These are author-reported repository figures, not independent benchmarks or general measures of software quality. They do not establish that a particular storage design performs better than another.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
