What is the quickest way to import thounsand records to a table?

Thanks you so much. But will the SQLite Restful API lock for multiple connection at the same time ? (For SELECT only)