How one developer replaced cron-based rankings with a static SQL sort key

·1 views

A developer building a 1,000-tile auction board needed tiles ranked by time-decaying "heat" without running any scheduled recomputation jobs. By expressing exponential decay mathematically, they showed that each tile's full payment history can be compressed into just two values: a combined payment score and a timestamp. Taking the logarithm of the heat formula reveals that the time-dependent term is identical across all rows and therefore irrelevant to ordering, leaving a static constant called rank_key that only changes when a payment occurs. Storing rank_key in the database and indexing it means a simple ORDER BY query always returns a correct real-time ranking with no background processing. The post also covers numerical stability pitfalls, choosing appropriate time units to preserve floating-point precision, and concurrency risks when using Cloudflare Durable Objects.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Strong CSS architecture starts with defining what CSS should never do

A DEV Community article argues that the foundation of robust CSS architecture lies not in defining capabilities, but in declaring explicit exclusions upfront. The author illustrates how design token systems quietly accumulate misuse — such as storing application state inside CSS custom properties — because nothing in the system is built to refuse such decisions. Without predefined boundaries, stylesheets gradually absorb logic and state that belong elsewhere, making systems harder to maintain over time. The piece contends that exclusions are not gaps in architecture but its most durable component, acting as guarantees rather than limitations. A system that never defines what it will not do, the author warns, will eventually be pressured into doing everything.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer releases open-source npm package for Bangladesh geographic data

A developer has published an open-source npm package called @olism/bd-geo, providing structured geographical data for Bangladesh in JavaScript and TypeScript. The package covers the country's full administrative hierarchy, including divisions, districts, upazilas, areas, and villages. It is designed to eliminate the need for individual developers to source, clean, and maintain their own Bangladesh location datasets. Potential use cases include address forms, e-commerce delivery systems, real-estate platforms, and location-based applications. The project is available on npm and GitHub, and the author is actively seeking community feedback and contributions to improve the dataset and documentation.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

GDPR, HIPAA, SOC 2: What Regulated Industries Must Know About Password Managers

Organizations in regulated industries such as healthcare, finance, and tech must ensure their password managers comply with frameworks like GDPR, HIPAA, and SOC 2, as non-compliance can carry severe legal and financial penalties. GDPR, which covers any entity processing EU residents' personal data, mandates features such as zero-knowledge architecture, data portability, breach notification within 72 hours, and signed data processing agreements with vendors. HIPAA applies to healthcare organizations and their business associates, requiring that any password manager storing credentials linked to protected health information meet strict encryption and access control standards. SOC 2 provides a third-party audit framework validating that a service provider's security controls meet defined trust principles, offering organizations independent assurance of a vendor's security posture. When evaluating a password manager, key compliance indicators include AES-256 encryption, role-based access controls, audit logging, data residency options, and documented incident response procedures.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Good CSS Architecture Requires Defining What CSS Should Never Do

Strong CSS architecture depends not just on what a system can do, but on explicitly deciding what it must never do. Without declared exclusions, systems tend to accumulate unintended responsibilities over time, such as storing application state inside design tokens. A custom property tracking modal state looks syntactically identical to a spacing token, yet represents a fundamentally different concern that CSS has no business managing. Since browsers cannot distinguish between the two, the refusal must come from deliberate architectural decisions made in advance. Systems that define clear boundaries and exclusions are more maintainable and resilient than those that only react after problems emerge.

0 comments Read more at DEV Community