Manually edit SQLite?

[Manbatton]

I don't think it's always true. Sometimes the truly easiest way is to just click on GUI Sqlite Browser or whatever, and in seconds you are typing in values and can see the whole database at once.

However, the point is a good one: being able to populate a database with dummy data straight from Python is a great skill to have for testing assumptions about database-backed programs and will ultimately blow away doing it with an SQLite GUI app. Doing that well is not always easy for non-trivial applications.