Dibya Sarothi
Dibya Sarothi
Developer ToolsProduction ReadyAugust 2026

Flashy French Flashcard App

Spaced-Practice Desktop Flashcards with Pandas CSV Progress Persistence

3-second auto-flip study timers, manual tap-flip support, and persistent CSV mastery tracking powered by Python, Tkinter, and Pandas.

Flashy French Flashcard App overview
Project Overview

An interactive French-to-English vocabulary flashcard desktop application built with Python, Tkinter, and Pandas. Presents high-frequency French words with a 3-second asynchronous flip timer, allows instant manual flipping on click, and removes mastered words into a persistent words_to_learn.csv file.

Problem Statement

Naive flashcard timers leak overlapping window.after callbacks when clicking rapidly, flipping cards out of sync.

Engineering Rationale

Clean callback cancellation and persistent CSV state management turn a simple deck into a genuinely sticky study tool.

Engineering Objectives

Schedule 3-second automatic card flips and cancel pending timers cleanly on rapid navigation.
Persist unmastered cards automatically to data/words_to_learn.csv via Pandas.
Support manual click-to-flip cards alongside mastered/review buttons.
Architecture Blueprint

System Architecture

Event-driven Tkinter GUI backed by Pandas DataFrame CSV serialization and cancellable timer handles.

01

Cancellable Flip Timer & CSV Persistence

Calls window.after_cancel before queuing every next card and syncs remaining vocabulary back to disk on mastery.

Core & Backend Implementation

  • Pandas DataFrame loading words_to_learn.csv with graceful fallback to initial french_words.csv.
  • Mastered card pruning writing updated progress immediately to disk.

Client & Interface Layer

  • Borderless Tkinter canvas cards transitioning colors between French front and English back.

Data & Schema Design

Engine / Tier: Local CSV Storage (Pandas)

Maintains french_words.csv master vocabulary alongside filtered words_to_learn.csv progress state.

Core Models & Entities
FlashCardRow

Authentication & Security Controls

Auth Model: Local Offline Desktop Application
  • Handles empty CSV or missing progress files cleanly without crashes.

Engineering Challenges & Technical Decisions

Key Challenges Solved

Challenge: Stale 3-second flip callbacks firing prematurely after clicking Next Card early.
Engineering Solution: Stored active flip_timer handle and invoked window.after_cancel() before generating each card.

Trade-Off Decisions

Decision: Pandas CSV Differential Save on Known Words
Architectural Rationale: Zero-setup local persistence requiring no external database server.

Testing & Verification Methodology

Frameworks & Approach: Fresh Start & Empty Deck Edge-Case Runs
  • Confirmed persistent deck resume across restarts.

Results & Engineering Takeaways

Learned event timer cancellation hygiene and lightweight Pandas persistence.