Skip to content
scrambled

Flashcards

..How does optimistic concurrency control work?How does optimistic concurrency differ from pessimistic locking?What are the failure modes of the pre-signed URL upload pattern?What happens when you delete a row that references a PostgreSQL Large Object?What is a flat namespace for file storage and what is the tradeoff?What is a last-writer-wins register?What is a pre-signed URL and why use it?What is fractional indexing?What is long polling and how does it differ from polling and WebSockets?What is MongoDB GridFS and when should you use it?What is PostgreSQL TOAST?What is the difference between `bytea` and `text` for storing files in PostgreSQL?What is the difference between OT and CRDT?What is the ETag + If-Match pattern in HTTP?What is the storage overhead of `bytea` vs `text` for binary data?When designing a file sync service like Google Drive or Dropbox, how would you design file transfers?When should you use PostgreSQL Large Objects over `bytea`?Where do flat namespaces appear in practice?Who generates ETags: The HTTP server or the application?Why did Figma reject OT?Why did Figma reject pure CRDTs?