koa + mysql todo app
sample project to demonstrate the crud operations.
prerequirments
you need mysql installed and setup a appropriate user to run the demo.
mysql quick reference
installing:
$ brew install mysqlstart mysql service:
$ brew services start mysqllogin as root and add a user:
$ mysql -uroot
mysql> create user '<username>'@'localhost' identified with mysql_native_password by '<pswd>'then fill the <username> and pswd into config.js
login as the new created user and create corresponding database and tables.
mysql> quit
$ mysql -u <username> -p
Enter password: ***
mysql> create database todo
mysql> use todo;execute the following script to create the todo table:
CREATE TABLE `todo` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
`is_done` int(11) DEFAULT '0',
`date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ciinstalling
$ yarnrunning
$ yarn start
server started at http://localhost:3000then visit http://localhost:3000.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent