ffay / proxygateway Goto Github PK

Proxy Gateway基于openresty（nginx lua module）开发，可以作为接口网关（api gateway）使用，整合业务模块接口，微服务治理聚合，通过web配置界面，能够轻松进行代理配置管理，支持负载均衡，服务器状态检测等

License: MIT License

HTML 7.10% CSS 37.93% JavaScript 46.98% Lua 7.98%

apigateway nginx openresty pgw pgw-proxy-gateway proxy

proxygateway's People

Contributors

Stargazers

Watchers

Forkers

zjpjohn ycaihua yonglehou powellmao fxk2006 eysdo edagarli publicgeneseeq zyhxq changliu0403 ifa6 26844 cjhoffice bradbann gspandy liufulin90 manyixu skyformat99 apple-cloud gdbobu rox2k jaychang9 lzw2015 theusa1776 xlogin liukun-lk zofuthan royyoung525 xingchuang tinygg fushanlang szlch01 dossec wenzhenxing 3zamn zhangjingpu afghanistanyn chenjy16 chenld noshenxian heartshare arishu jamesmarc2016 littleyang qinxingnet 52nlp kevin021788 waffcloud csy512889371 qimingnan xydsoft dukexia sunmsn muxiyun danmi1258 fskpang werthergit happyguy1986 hanbinggary clistery 123waily kenser adangadang duyouhua strivestruggleyou gitplt gfadel88 heaunter duanwucui lambertwe miskeylee comk88 gqfjob yangminglis cedarx kaowul jaronzheng azkoss zhangxuewen123 edgeowner waitingfy kjfcpua jsyzjhj xiangya123 wuwx zc806zc massinger sumsung007 jiaojie1989 duanshuaimin sugear w796933 enjoyec xiaobudianyuner torns gongzhen1 iahehe whantt jinguangyang superfrankjiang

proxygateway's Issues

能增加对postgresql数据库的支持吗？

我现在所有的服务器都用postgresql，对postgresql比较熟悉，我试着增加对postgresql的支持，装了pgmoon模块，也可以连上数据库，但是后面报错，因为对lua也不是很熟悉，不知道作者能否增加对postgresql数据库的支持。希望您能增加对postgresql的支持,我做测试，如果您愿意增加，请联系我的
qq 171958445,我帮您测试。

安装pgmoon包.

下面的postgresql 为建表的SQL语句。

CREATE TABLE agw_api (
id serial PRIMARY KEY,
service_id int DEFAULT NULL,
request_uri varchar(64) DEFAULT NULL,
original_uri varchar(64) DEFAULT NULL,
uri_limit_seconds int NOT NULL DEFAULT '0',
uri_limit_times int NOT NULL DEFAULT '0',
ip_uri_limit_seconds int NOT NULL DEFAULT '0',
ip_uri_limit_times int NOT NULL DEFAULT '0',
description varchar(128) DEFAULT NULL
);
INSERT INTO agw_api (service_id, request_uri, original_uri, description) VALUES
( 1, '/', '/', 'all request map');
CREATE TABLE agw_domain (
id serial PRIMARY KEY,
name varchar(255) NOT NULL
);
INSERT INTO agw_domain (name) VALUES
('localhost');
CREATE TABLE agw_server (
id serial PRIMARY KEY,
service_id int DEFAULT NULL,
ip varchar(64) DEFAULT NULL,
port int DEFAULT NULL,
protocol varchar(32) NOT NULL DEFAULT 'http://',
weight int DEFAULT NULL,
status int DEFAULT 1,
description varchar(255) DEFAULT ''
);
INSERT INTO agw_server (service_id, ip, port, protocol, weight, status, description) VALUES
( 1, '127.0.0.1', 8081, 'http://', 1, 1, 'proxygateway management');
CREATE TABLE agw_service (
id serial PRIMARY KEY,
domain_id int NOT NULL,
name varchar(64) DEFAULT NULL,
host varchar(255) NOT NULL DEFAULT '',
description varchar(64) DEFAULT NULL
);
INSERT INTO agw_service (domain_id, name, host, description) VALUES
( 1, 'default', 'localhost', 'default proxy configuration');