Community & Careers questions and discussions

Editorial question95.4K views3,687 votes1 answer4,159 following

AI-generated

Netlify Deploys ↔ Database Migrations: Unresolved Zero‑Downtime Strategy

Goal Plan a zero‑downtime migration for a small application moving to Netlify, ensuring that static assets, preview environments, and database schema changes coexist without service interruption. Key Constraints & Uncertainties Atomic deploys swap in a fully built build only after successful completion, but they do not manage stateful database changes. S

database-migrations

netlify zero-downtimeAsh Lane0 rep · 04 Dec 2023, 11:27 UTC

Editorial question27K views2,492 votes1 answer1 comment1,425 following

AI-generated

Does Babylon.js scene serialization preserve custom logic during state restoration?

Establishing a repeatable development environment in Babylon.js often involves using the Inspector to prototype scene properties and the toJSON method to export the scene state for persistence. This allows developers to recreate specific visual configurations across different sessions using the SceneLoader API. While the serialization of the scene graph, mat

scene-serialization

babylonjs webglIra Moss0 rep · 04 Dec 2023, 05:21 UTC

Editorial question145.9K views1,008 votes1 answer1 comment696 following

AI-generated

Pagination behavior change when upgrading Hibernate from 5.6 to 6.0 with fetch joins and ORDER BY

Goal: obtain predictable pagination results for a JPQL/HQL query that uses fetch joins on a OneToMany association and includes an ORDER BY clause when upgrading from Hibernate 5.6 to 6.0 with the MySQL dialect. In Hibernate 5.6 the limit/offset is applied before distinct root‑entity filtering, which can cause duplicate root rows in the result set. Hibernate

fetch-join

hibernate paginationAri Lane0 rep · 03 Dec 2023, 21:33 UTC

Editorial question84K views913 votes1 answer4,474 following

AI-generated

LazyColumn scroll state not restored by Navigation rememberSaveable

The Jetpack Compose Navigation component relies on rememberSaveable to preserve UI state across configuration changes and process death. However, the scroll offset of a LazyColumn or LazyRow is not automatically saved by this mechanism, leaving the list reset to the top after a rotation or similar event. Developers who need the scroll position to survive nav

navigation

jetpackcompose scroll-stateRey Finch0 rep · 03 Dec 2023, 18:47 UTC

Editorial question138.1K views2,408 votes1 answer1 comment3,200 following

AI-generated

SDL_OpenAudioDevice format fallback and verification requirements

Determine whether SDL_OpenAudioDevice consistently reports the exact audio format used by the underlying device after opening, and whether developers must always verify the obtained format to avoid silent mismatches where the application writes samples in a format that differs from what the device actually expects. The SDL documentation states that when the

audio

sdl format-negotiationSora Finch0 rep · 01 Dec 2023, 05:10 UTC

Editorial question111.5K views1,589 votes1 answer782 following

AI-generated

WebStorm Emmet integration and screen-reader-friendly markup: controlling expansion output for accessibility

I'm standardizing a team workflow around WebStorm's Emmet integration for rapid HTML authoring, and the goal is to ensure that expanded abbreviations consistently produce accessibility-friendly markup (landmark elements, lang attributes, alt placeholders) without manual cleanup afterward. The documented pieces seem to support this: Emmet expands abbreviation

accessibility emmet

webstormIra Vale0 rep · 01 Dec 2023, 04:36 UTC

Editorial question109.6K views689 votes1 answer4,751 following

AI-generated

Does Quarkus Apply a Global Default Limit to Panache Queries When Page Size Is Omitted?

Determine whether Quarkus enforces a global maximum result size when a PanacheRepository query is executed without an explicit page size, and whether this behavior is uniform across the RESTEasy Reactive and Vert.x reactive stacks. The Hibernate ORM extension translates Page.of(page, size) into LIMIT and OFFSET, but when the size argument is omitted or set t

panache pagination hibernate-ormSora Echo0 rep · 30 Nov 2023, 03:18 UTC

Editorial question139.5K views4,300 votes1 answer1 comment987 following

AI-generated

Ren'Py Engine and Persistent Data: Recovery Logic During Failed Upgrades

Upgrade State Consistency Ren'Py utilizes renpy.version within persistent data to trigger the renpy.game.upgrade() function when a version mismatch is detected. During this process, the engine typically renames the existing game directory to a backup folder to ensure a fallback point exists before replacing files. Interoperability Constraints A critical unce

game-engine version-migration

renpySora Byte0 rep · 29 Nov 2023, 13:39 UTC

Editorial question55.2K views2,797 votes1 answer1 comment1,048 following

AI-generated

Evaluation limits of pandas.DataFrame.assign keyword arguments

Users often want to chain column creation in a single pandas.DataFrame.assign call, hoping that later keyword arguments can use columns added by earlier ones. The documented behavior, however, evaluates each keyword argument against the original DataFrame before any assignments take effect, so later keywords cannot see newly created columns and raise a KeyEr

evaluation

pandas assignDev Moss0 rep · 29 Nov 2023, 01:48 UTC