Mirror of forum.nim-lang.org

3660 :: db_mysql & threads

• lightness1024 (orginal) [2018-03-17T07:59:48+01:00] view original

  Is it possible to have a thread that update contents on the table A, and another thread that queries table A on the same connexion, or I need 2 DbConn objects ? I guess it doesn't make much sense to share anyway since nim supposedly separates all memory, though I could copy the conn object on a channel ? can of worms ?

---

• sky_khan (orginal) [2018-03-17T09:19:51+01:00] view original

  can of worms ?

  Yes, according to this : MySql Reference "Multiple threads cannot send a query to the MySQL server at the same time on the same connection"

  So you'll have to serialize your queries anyway, what's the point then?

---

• Araq (orginal) [2018-03-17T16:32:21+01:00] view original

  Doesn't this mean that you have to use multiple connections? Which seems easy enough to do.

---