I am thinking about using BoltDB as a backend main DB and have few question with my Go code; also need your opinion of using BoltDB as a main backend DB.
Q1. Most important question, is BoltDB capable for production with 1000 concurrent connection? Q2. If there were concurrent writing queries, will BoltDB automatically process one by one?
Thank you so much. I am new to Go and BoltDB and I am wondering if I am using right DB with right way.
A1. Yes, we use it with way more than 1000 concurrent connections.
A2. Yes, bolt is thread safe, when you call db.Update, it will lock the database, so you know you data will always be consistent.
Also a hint, never do any heavy lifting inside the update func.