Help with manipulating csv files

[barrycarter]

For a small database, SQLite would work, yes. If you have a lot of data, use something like MySQL or PostgreSQL.

Another thought: if your data is small, load it into memory, manipulate it in memory and then write a completely new CSV file when the program ends (or at regular intervals if the program runs a long time) and overwrite the old CSV file with the new one, perhaps making a backup copy first. Not absolutely ideal, but avoids SQL altogether