Some database questions?

Question

MySQL

Hello, the questions are rather general, not related to a specific database.
In general, I use Python and postgres
1) I have a text field that my script will search for very often
. So, when creating a field, do I need to do something with it to optimize the process? or just create the field as char? I just read about indexes, do I need to make it an index?
2) I will often add new rows to the database, what is the right way to do it, do insert one row at a time or in batches?

Answer 1

1. The index is unambiguous, which index depends on the condition by which you will do the search.
2. batch paste, much faster.