Customers List (MySQL - Connection One-by-One using Promises)
This section implement a MySQL Database connected with node.js mysql driver creating and managing connections one-by-one using Promises. Dynamic web pages without connection pooling open connections to database services as required and close them when the page is done servicing a particular request. Opening and maintaining a database connection for each user is costly and wastes resources. In this section every database calls are closed after completing. In addition the calls are write with asynchronous code using Promises.
| # | Id | Name | Active | Action Menu | |
|---|---|---|---|---|---|
| 1 | 11 | Marlowe Worts | mworts0@blog.com | Active | Edit |
| 2 | 12 | Aurthur Matitiaho | amatitiaho1@msn.com | Active | Edit |
| 3 | 13 | Cristine Tomik | ctomik2@java.com | Active | Edit |
| 4 | 15 | Leigh Korba | lkorba3@infoseek.co.jp | Suspended | Edit |
| 5 | 21 | Gonzales Crathern | gcrathern4@admin.ch | Active | Edit |
| 6 | 22 | Albert Ranger | aranger5@who.int | Active | Edit |
| 7 | 23 | Merline Skillern | mskillern6@360.cn | Suspended | Edit |
| 8 | 24 | Norine Eadmeads | neadmeads7@csmonitor.com | Active | Edit |
| 9 | 28 | Clarette Wilber | cwilber8@slideshare.net | Active | Edit |