Captain's log-

Database migration fixes and reconsidering UI layout

What I worked on today

  • Migrated from SQLite (file-based) to MySQL/MariaDB, requiring changes to foreign keys between models, improving database scalability for pricing intelligence tools.
  • Updated almost every database migration to resolve structural conflicts, ensuring better support for competitor price tracking.
  • Did some code cleanup to streamline the new database structure, which should help with future price monitoring software features.
  • Posted something on Reddit, but it didn’t gain much traction.
  • Noticed that Google Search Console graphs are still disappointing, and there’s still no waiting list subscriber.

Lessons learned

  • Moving from SQLite to MySQL/MariaDB isn’t always straightforward, especially with foreign key constraints, but it’s essential for handling larger datasets in pricing intelligence.
  • A cleaner database migration setup helps long-term scalability, particularly when supporting e-commerce competitive analysis.
  • UI space allocation can significantly affect the overall product feel—right now, the container-width layout might be too restrictive for displaying competitive pricing insights effectively.
  • Posting content without an engaged audience doesn’t immediately drive traffic, reinforcing the need for an SEO-driven marketing strategy.

Challenges faced

  • Foreign key constraints between models caused delays.
  • The decision to redesign the UI could slow down overall progress.
  • Marketing efforts feel stagnant with no waiting list sign-ups yet.

What’s next

  • Get into my Tailwind CSS workflow and experiment with a full-screen layout to better present price change alerts and competitor pricing insights.
  • Evaluate whether the UI revamp is worth the time investment or if it’s just a form of procrastination, especially when there are still pricing intelligence updates to focus on.
  • Refocus on marketing strategies that could improve reach and attract potential sign-ups for businesses looking for real-time price tracking solutions.
Photo of captain Davy de Vries

Davy de Vries

Captain 🏴‍☠️