How do I get connection pool in form / golang to an instance without database?

Question

I have 10 databases in one instance. I want to take a single connection pool to the instance. From that connection I will trigger "use database" query before trigger any other query or I can build query with database name. Ex select * from database.table.

How do I get connection pool to instance without database in xorm or golang?

Jonathan Hall · Accepted Answer · 2017-03-19 08:34:29Z

2

Just use the DSN without selecting a database:

dsn := "root:@/"
db, err := sql.Open("mysql", dsn)

and then use one of your suggestions. You can also create a 10-keys map between the databases' names and their corresponded Db object.

edited Mar 19, 2017 at 8:34

Jonathan Hall

80.5k19 gold badges162 silver badges206 bronze badges

answered Mar 19, 2017 at 7:50

Shmulik Klein

3,92224 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kumar Siva Over a year ago

Is this possible in xorm?

Collectives™ on Stack Overflow

How do I get connection pool in form / golang to an instance without database?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related