wclimb / Koa2 Blog
node+koa2+mysql
Stars: ✭ 856
Programming Languages
javascript
184084 projects - #8 most used programming language
es6
455 projects
Projects that are alternatives of or similar to Koa2 Blog
Vue Qq
🎨 Vue family bucket with socket.io and express/koa2 , create a web version of mobile QQ, supporting real-time group chat, real-time private chat, special care, shielding chat, smart IP geographic location, real-time display temperature and other QQ core functions
Stars: ✭ 861 (+0.58%)
Mutual labels: mysql, koa2
React Blog
react hooks + koa2 + sequelize + mysql 构建的个人博客。具备评论、通知、上传文章等等功能
Stars: ✭ 530 (-38.08%)
Mutual labels: mysql, koa2
Don Blog Backmanage
Don's blog的后台管理系统,基于Vue.js + Node.js + Koa.js + MySQL + Redis + WebSocket。
Stars: ✭ 112 (-86.92%)
Mutual labels: mysql, koa2
React Ssr
React 服务端渲染(SSR),react + redux + koa2 + sequelize + mysql全栈项目(Full Stack)
Stars: ✭ 205 (-76.05%)
Mutual labels: mysql, koa2
Web Performance Monitoring System
A complete performance monitoring system.
Stars: ✭ 436 (-49.07%)
Mutual labels: mysql, koa2
Typescript Node
📋 TypeScript and NodeJS project template.
Stars: ✭ 282 (-67.06%)
Mutual labels: mysql, koa2
Ghchat
📱A chat application for GitHub. React + PWA + Node(koa2) + Typescripts + Mysql + Socket.io
Stars: ✭ 791 (-7.59%)
Mutual labels: mysql, koa2
Cool Admin Midway
cool-admin(midway版)一个很酷的后台权限管理框架,模块化、插件化、CRUD极速开发,永久开源免费,基于midway.js 2.0、typeorm、mysql、jwt、element-ui等构建
Stars: ✭ 204 (-76.17%)
Mutual labels: mysql, koa2
Vue Koa Demo
🔰A simple full stack demo(CSR & SSR & Docker Support) written by Vue2 & Koa2(Koa1 verson also completed)
Stars: ✭ 730 (-14.72%)
Mutual labels: mysql, koa2
Mysqlconnector
Async MySQL Connector for .NET and .NET Core
Stars: ✭ 942 (+10.05%)
Mutual labels: mysql
Koa Generator
Koa' application generator for 1.x and 2.x( Express-style and support all middlewares include async/await )
Stars: ✭ 929 (+8.53%)
Mutual labels: koa2
Unilinks
Plataforma para encontrar os links das aulas virtuais gravadas.
Stars: ✭ 25 (-97.08%)
Mutual labels: mysql
Springbootunity
rabbitmq、redis、scheduled、socket、mongodb、Swagger2、spring data jpa、Thymeleaf、freemarker etc. (muti module spring boot project) (with spring boot framework,different bussiness scence with different technology。)
Stars: ✭ 845 (-1.29%)
Mutual labels: mysql
Koa2-blog(有问题可以加qq群:725165362)
node+koa2+mysql (欢迎star)
现在最新的代码有变动,请参照最新的代码,新增了上传头像、分页、markdown语法等
创建数据库
登录数据库
$ mysql -u root -p
创建数据库
$ create database nodesql;
使用创建的数据库
$ use nodesql;
database: nodesql tables: users posts comment (已经在lib/mysql建表)
users | posts | comment |
---|---|---|
id | id | id |
name | name | name |
pass | title | content |
avator | content | moment |
moment | md | postid |
- | uid | avator |
- | moment | - |
- | comments | - |
- | pv | - |
- | avator | - |
- id主键递增
- name: 用户名
- pass:密码
- avator:头像
- title:文章标题
- content:文章内容和评论
- md:markdown语法
- uid:发表文章的用户id
- moment:创建时间
- comments:文章评论数
- pv:文章浏览数
- postid:文章id
$ git clone https://github.com/wclimb/Koa2-blog.git
$ cd Koa2-blog
$ cnpm i supervisor -g
$ cnpm i
$ npm run dev(运行项目)
$ npm test(测试项目)
演示
注册
登陆
发表文章
文章详情
文章列表
个人文章页以及正常编辑删除文章和评论
个人小程序
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].