MySQL

mysql2 gem prepared statements

Interact with Mysql Server using mysql2 gem [Part 3] – Prepared Statements

This is the third part of the series where we create a service to interact with MySQL server in rails using mysql2 gem. You can read other parts by following the links below: Interact with MySQL server using mysql2 gem – select operations Interact with MySQL Server using mysql2 gem [Part 2] – Insert and …

Interact with Mysql Server using mysql2 gem [Part 3] – Prepared Statements Read More »

insert using mysql2 gem

Interact with Mysql Server using mysql2 gem [Part 2] – Insert and Update Operations

This is the second part of the series where we create a service to interact with MySQL server in Rails using mysql2 gem. You can read the first part here. Requirements [x] Service to connect with external MySQL server [ ] Perform basic query: select, insert and update [ ] Prepared statement [ ] Perform …

Interact with Mysql Server using mysql2 gem [Part 2] – Insert and Update Operations Read More »

mysql2 gem

Interact with Mysql Server using mysql2 gem [Part 1] – Select operations

Rails has made our lives easier. If we are talking in terms of querying the database, the active record has got us covered. But what if we had to communicate with an external database? Recently in one of the project that I worked on, I had to perform insert, update, select, and other different queries …

Interact with Mysql Server using mysql2 gem [Part 1] – Select operations Read More »