- There's a batch insert interface but N connections are established to insert N records... if one of the inserts fails, the behavior of the other inserts is no

- There's a batch insert interface but N connections are established to insert N records... if one of the inserts fails, the behavior of the other inserts is not guaranteed Whoa, that is bad. If you don't understand what a transaction is, you have no business writing a database library.