{"items":[{"id":"01a16652-3db1-7fc5-aa4c-82cbe96686bd","slug":"how-to-store-times-with-time-zones","title":"How should software store times so they stay correct when time zone rules change?","excerpt":"Daylight-saving rules and UTC offsets change by government decision. Storing only an offset or an abbreviation leads to wrong local times later.","language":"en","status":"published_answered","topic_tags":["dates-and-times","time-zones","software-engineering","standards"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.209Z","updated_at":"2026-10-23T01:13:48.209Z","last_activity_at":"2026-10-23T01:13:48.209Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/how-to-store-times-with-time-zones","api_url":"https://opendont.com/api/v1/questions/01a16652-3db1-7fc5-aa4c-82cbe96686bd"},{"id":"01a16652-3da5-7caf-96c8-4ffca724ce8d","slug":"por-que-o-pao-cresce","title":"Por que a massa de pão cresce e para que serve a etapa de prova?","excerpt":"Receitas pedem para deixar a massa descansar até dobrar de volume e depois fazer a prova. O que acontece quimicamente nesse tempo?","language":"pt-BR","status":"published_answered","topic_tags":["ciencia-dos-alimentos","panificacao","fermentacao","culinaria"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.197Z","updated_at":"2026-10-23T01:13:48.196Z","last_activity_at":"2026-10-23T01:13:48.196Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/por-que-o-pao-cresce","api_url":"https://opendont.com/api/v1/questions/01a16652-3da5-7caf-96c8-4ffca724ce8d"},{"id":"01a16652-3d97-721b-a239-a09c5b200820","slug":"difference-between-maillard-and-caramelization","title":"What is the difference between the Maillard reaction and caramelization?","excerpt":"Recipes use \"caramelize\" for onions, steak and sugar alike. Are these the same chemical process?","language":"en","status":"published_answered","topic_tags":["food-science","cooking","chemistry","browning"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.182Z","updated_at":"2026-10-23T01:13:48.182Z","last_activity_at":"2026-10-23T01:13:48.182Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/difference-between-maillard-and-caramelization","api_url":"https://opendont.com/api/v1/questions/01a16652-3d97-721b-a239-a09c5b200820"},{"id":"01a16652-3d88-7230-b80c-248ae1853386","slug":"when-was-the-great-wave-made","title":"When did Hokusai make The Great Wave off Kanagawa?","excerpt":"Museum records date the Great Wave as ca. 1830-32, 1830/33 or ca. 1831. Which is right, and why do they differ?","language":"en","status":"published_answered","topic_tags":["art-history","japanese-prints","hokusai","museums"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.167Z","updated_at":"2026-10-23T01:13:48.167Z","last_activity_at":"2026-10-23T01:13:48.167Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/when-was-the-great-wave-made","api_url":"https://opendont.com/api/v1/questions/01a16652-3d88-7230-b80c-248ae1853386"},{"id":"01a16652-3d78-7b2c-942d-6edfe793d444","slug":"how-to-determine-a-leap-year","title":"How do you determine whether a year is a leap year in the Gregorian calendar?","excerpt":"Many people know the \"every four years\" rule but not the century exception. What is the exact rule and why was it introduced?","language":"en","status":"published_answered","topic_tags":["calendars","history","timekeeping","algorithms"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.152Z","updated_at":"2026-10-23T01:13:48.151Z","last_activity_at":"2026-10-23T01:13:48.151Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/how-to-determine-a-leap-year","api_url":"https://opendont.com/api/v1/questions/01a16652-3d78-7b2c-942d-6edfe793d444"},{"id":"01a16652-3d67-75b4-bb4b-054bcc734f76","slug":"why-do-sources-disagree-on-historical-dates","title":"Why do reliable sources sometimes give different dates for the same historical event?","excerpt":"Biographies and encyclopedias sometimes give birth or event dates that differ by ten or more days, sometimes even in a different year.","language":"en","status":"published_answered","topic_tags":["history","calendars","chronology","source-criticism"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.135Z","updated_at":"2026-10-23T01:13:48.134Z","last_activity_at":"2026-10-23T01:13:48.134Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/why-do-sources-disagree-on-historical-dates","api_url":"https://opendont.com/api/v1/questions/01a16652-3d67-75b4-bb4b-054bcc734f76"},{"id":"01a16652-3d57-7d9a-bc45-abca5aa40733","slug":"o-que-foi-o-tratado-de-tordesilhas","title":"O que estabeleceu o Tratado de Tordesilhas e onde passava a linha?","excerpt":"O tratado é citado como origem da presença portuguesa na América do Sul. O que exatamente ele dizia e por que a linha é desenhada em lugares diferentes?","language":"pt-BR","status":"published_answered","topic_tags":["historia","brasil-colonial","expansao-iberica","tratados"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.119Z","updated_at":"2026-10-23T01:13:48.119Z","last_activity_at":"2026-10-23T01:13:48.119Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/o-que-foi-o-tratado-de-tordesilhas","api_url":"https://opendont.com/api/v1/questions/01a16652-3d57-7d9a-bc45-abca5aa40733"},{"id":"01a16652-3d43-7ff5-b9e9-a66211faea42","slug":"qual-e-a-equacao-da-fotossintese","title":"Qual é a equação global da fotossíntese e de onde vem o oxigênio que as plantas liberam?","excerpt":"A equação aparece em quase todo livro de biologia, mas costuma gerar dúvidas sobre a origem do O2 e sobre a glicose como produto.","language":"pt-BR","status":"published_answered","topic_tags":["biologia","fotossintese","bioquimica","plantas"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.099Z","updated_at":"2026-10-23T01:13:48.098Z","last_activity_at":"2026-10-23T01:13:48.098Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/qual-e-a-equacao-da-fotossintese","api_url":"https://opendont.com/api/v1/questions/01a16652-3d43-7ff5-b9e9-a66211faea42"},{"id":"01a16652-3d33-7b47-b76d-936ae4890414","slug":"what-is-the-evidence-for-plate-tectonics","title":"What is the evidence that continents and ocean floors move?","excerpt":"Continental drift was rejected for decades before plate tectonics became accepted. Which observations made the difference?","language":"en","status":"published_answered","topic_tags":["geology","plate-tectonics","earth-science","history-of-science"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.083Z","updated_at":"2026-10-23T01:13:48.082Z","last_activity_at":"2026-10-23T01:13:48.082Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/what-is-the-evidence-for-plate-tectonics","api_url":"https://opendont.com/api/v1/questions/01a16652-3d33-7b47-b76d-936ae4890414"},{"id":"01a16652-3d20-7301-99a0-5b6904c8fbd5","slug":"o-que-diz-a-terceira-lei-de-kepler","title":"O que diz a terceira lei de Kepler e como usá-la?","excerpt":"A lei relaciona o tempo que um planeta leva para dar uma volta ao Sol com o tamanho da órbita. Qual é a relação exata e quando ela foi formulada?","language":"pt-BR","status":"published_answered","topic_tags":["astronomia","fisica","mecanica-orbital","historia-da-ciencia"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.063Z","updated_at":"2026-10-23T01:13:48.062Z","last_activity_at":"2026-10-23T01:13:48.062Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/o-que-diz-a-terceira-lei-de-kepler","api_url":"https://opendont.com/api/v1/questions/01a16652-3d20-7301-99a0-5b6904c8fbd5"},{"id":"01a16652-3d0f-743f-9f7a-7d62c4d575ce","slug":"how-is-the-metre-defined","title":"How is the metre defined today, and why is the speed of light exact?","excerpt":"The speed of light is often quoted as exactly 299 792 458 m/s. Is that a measurement or a definition, and what changed in 2019?","language":"en","status":"published_answered","topic_tags":["metrology","si-units","physics","speed-of-light"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.047Z","updated_at":"2026-10-23T01:13:48.046Z","last_activity_at":"2026-10-23T01:13:48.046Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/how-is-the-metre-defined","api_url":"https://opendont.com/api/v1/questions/01a16652-3d0f-743f-9f7a-7d62c4d575ce"},{"id":"01a16652-3cfc-7d27-987d-c5beaa6fb40a","slug":"por-que-trocar-de-porta-no-monty-hall","title":"No problema de Monty Hall, por que vale a pena trocar de porta?","excerpt":"Depois que o apresentador revela um bode, muita gente acha que sobram duas portas com 50% cada. Qual é a probabilidade correta e de que hipóteses ela depende?","language":"pt-BR","status":"published_answered","topic_tags":["probabilidade","matematica","paradoxos","estatistica"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.028Z","updated_at":"2026-10-23T01:13:48.027Z","last_activity_at":"2026-10-23T01:13:48.027Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/por-que-trocar-de-porta-no-monty-hall","api_url":"https://opendont.com/api/v1/questions/01a16652-3cfc-7d27-987d-c5beaa6fb40a"},{"id":"01a16652-3ce7-7694-9d7e-5d40a3798f1a","slug":"why-are-there-infinitely-many-primes","title":"Why are there infinitely many prime numbers?","excerpt":"A classic result says the primes never run out. What is the shortest correct argument, and what is commonly misunderstood about it?","language":"en","status":"published_answered","topic_tags":["mathematics","number-theory","prime-numbers","proofs"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:48.007Z","updated_at":"2026-10-23T01:13:48.006Z","last_activity_at":"2026-10-23T01:13:48.006Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/why-are-there-infinitely-many-primes","api_url":"https://opendont.com/api/v1/questions/01a16652-3ce7-7694-9d7e-5d40a3798f1a"},{"id":"01a16652-3cd5-748f-b0e2-a788f78abb6c","slug":"quais-metodos-http-sao-idempotentes","title":"Quais métodos HTTP são idempotentes e o que isso significa na prática?","excerpt":"Ao projetar uma API ou um cliente com retentativas automáticas, é preciso saber quais requisições podem ser repetidas sem efeito adicional.","language":"pt-BR","status":"published_answered","topic_tags":["http","idempotencia","apis-web","padroes-ietf"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:47.989Z","updated_at":"2026-10-23T01:13:47.988Z","last_activity_at":"2026-10-23T01:13:47.988Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/quais-metodos-http-sao-idempotentes","api_url":"https://opendont.com/api/v1/questions/01a16652-3cd5-748f-b0e2-a788f78abb6c"},{"id":"01a16652-3cc3-75a3-86f1-56b05f0def5b","slug":"how-to-build-a-job-queue-in-postgresql","title":"How can multiple workers pull jobs from one PostgreSQL table without blocking each other?","excerpt":"Several worker processes poll a shared jobs table. With plain SELECT ... FOR UPDATE they wait on each other and throughput collapses.","language":"en","status":"published_answered","topic_tags":["postgresql","job-queues","concurrency","databases"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:47.971Z","updated_at":"2026-10-23T01:13:47.970Z","last_activity_at":"2026-10-23T01:13:47.970Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/how-to-build-a-job-queue-in-postgresql","api_url":"https://opendont.com/api/v1/questions/01a16652-3cc3-75a3-86f1-56b05f0def5b"},{"id":"01a16652-3c90-72ce-ae76-798172697194","slug":"how-to-retry-non-idempotent-api-calls-safely","title":"How can a client safely retry a request that creates or charges something?","excerpt":"A request timed out and the client does not know whether the server performed it. Retrying might create a duplicate; not retrying might lose the operation.","language":"en","status":"published_answered","topic_tags":["distributed-systems","api-design","idempotency","retries"],"provenance_class":"editorial_seed","as_of":"2026-10-21T00:00:00.000Z","published_at":"2026-10-23T01:13:47.907Z","updated_at":"2026-10-23T01:13:47.898Z","last_activity_at":"2026-10-23T01:13:47.898Z","approved_contribution_count":0,"canonical_url":"https://opendont.com/questions/how-to-retry-non-idempotent-api-calls-safely","api_url":"https://opendont.com/api/v1/questions/01a16652-3c90-72ce-ae76-798172697194"}],"next_cursor":null,"request_id":"req_lDxmzdSSnA0Hsrqz"}