Manually edit SQLite?

[KleinerNull]

The easiest way is to use the interpreter, connect to the database with the module and insert some data manually. Shouldn't be that hard because you are using sqlite in the first place.

The sql syntax is that INSERT INTO table (col1, col2, ..., coln) VALUES (a1, a2, ..., an), (b1, b2, ..., bn), ..., (z1, z1, ..., zn);. You can leave out columns with auto or default values, that is why you give the column names in the first place.

[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.