{
"info": {
"author": "lqkweb",
"author_email": "798244092@qq.com",
"bugtrack_url": null,
"classifiers": [
"Development Status :: 4 - Beta",
"Intended Audience :: Developers",
"License :: OSI Approved :: BSD License",
"Operating System :: OS Independent",
"Programming Language :: Python",
"Programming Language :: Python :: 3",
"Programming Language :: Python :: Implementation",
"Topic :: Software Development :: Libraries"
],
"description": "#### \u9879\u76eegit\uff1ahttps://github.com/lqkweb/sqlflow\n#### Blog\uff1ahttp://www.leiqiankun.com\n#### \u7b80\u4e66\u535a\u5ba2: https://www.jianshu.com/u/3fe4aab60ac4\n\n\u5f00\u53d1\u4ea4\u6d41QQ\u7fa4: 941879291\n\n# SQLflow (python3.6)\nSQLflow based on python development, support to Spark, as the underlying distributed computing engine, through a set of unified configuration file to complete the batch, flow calculation, the Rest service development.\n##### 2019-03-26 \u66f4\u65b0\u540e\u53f0\u8def\u7531,\u524d\u7aef\u62bd\u53d6base\u6a21\u677f\u5e76\u66f4\u65b0\u4f7f\u7528ajax\u65b9\u5f0f\u6267\u884csql\u8bed\u53e5\n\u4e3b\u9875\uff1a\n\n\u7ed3\u679c\u9875\uff1a\n\n\n# \u76ee\u6807\nSQLflow \u57fa\u4e8epython\u5f00\u53d1, \u652f\u6301\u901a\u8fc7\u5199sql\u7684\u65b9\u5f0f\u64cd\u4f5c\u5206\u5e03\u5f0f\u96c6\u7fa4, \u8fd0\u884cspark, \u673a\u5668\u5b66\u4e60, \u6df1\u5ea6\u5b66\u4e60, \u5206\u5e03\u5f0f\u722c\u866b, \u6570\u636e\u53ef\u89c6\u5316\u3002\n\n# Build\n\npython3.6\n\ngit clone https://github.com/lqkweb/sqlflow.git\n\npip install -r requirements.txt\n\npython manage.py\n\n\u4e3b\u9875\uff1ahttp://127.0.0.1:5000\n\u811a\u672c\u9875\u9762\uff1ahttp://127.0.0.1:5000/script\n\u5355sql\u9875\u9762\uff1ahttp://127.0.0.1:5000/sql \n\n\u3010\u6ce8\u610f\uff1a1\u3001\u4e0b\u8f7dapache spark\u6587\u4ef6\u914d\u7f6emanage.py\u4e2d\u7684SPARK_HOME\u8def\u5f84\u30022\u3001data.csv\u662f\u653e\u5230sqlflow/data\u76ee\u5f55\u4e2d\u3011\n\n# Usage [sparksql doc:https://spark.apache.org/docs/latest/api/sql/index.html]\n\n\u5728\u811a\u672c\u6267\u884c\u9875\u9762\uff1ahttp://127.0.0.1:5000/script \u8f93\u5165 select * from A limit 3; \u6216\u8005 select * from A limit 3 as B; \u751f\u6210\u4e34\u65f6\u8868A\u6216\u8005B\n\n\u751f\u6210\u4e34\u65f6\u8868A\u6570\u636e:\n\nselect * from A limit 3;\n\n\u751f\u6210\u4e34\u65f6\u8868B\u6570\u636e:\n\nselect * from A limit 3 as B;\n\n\u6253\u5f00\u5355sql\u6267\u884c\u9875\u9762\uff1ahttp://127.0.0.1:5000/sql, \u76f4\u63a5\u5c31\u53ef\u4ee5\u7528spark sql\u8bed\u6cd5\u64cd\u4f5c\u6570\u636e\u8868A\u548c\u6570\u636e\u8868B\u4e86:\n\ndesc A\n\nselect * from A limit 2\n\nselect * from B limit 2\n\nas B \u76f8\u5f53\u4e8e\u521b\u5efa\u4e86\u4e00\u4e2a B \u4e34\u65f6\u8868\u3002\n\n\u4e00\u4e2a\u7b80\u5355\u7684sql\u64cd\u4f5cspark\u96c6\u7fa4\u7684demo,\u662f\u4e0d\u662f\u5f88\u7b80\u5355\u3002\n\n### [\u8fd8\u6709\u66f4\u591asql\u7248\u9ed1\u79d1\u6280\uff0csql\u7248scikitlearn, sqlspider, sqlcharts, sqlkeras\u6df1\u5ea6\u5b66\u4e60\u5e73\u53f0\u6b63\u5728\u5185\u6d4b\u4e2d\uff01]\n\n### * \u6b63\u5728\u65b0\u589esql\u7248\u673a\u5668\u5b66\u4e60\u7b97\u6cd5\u529f\u80fd, \u8c22\u8c22\u652f\u6301\u3002 *\n### * \u6b63\u5728\u65b0\u589esql\u7248\u722c\u866b\u529f\u80fd, \u8c22\u8c22\u652f\u6301\u3002 *\n### * \u6b63\u5728\u65b0\u589esql\u7248\u6570\u636e\u53ef\u89c6\u5316\u529f\u80fd, \u8c22\u8c22\u652f\u6301\u3002 *\n### * \u6b63\u5728\u65b0\u589esql\u7248keras\u6df1\u5ea6\u5b66\u4e60\u529f\u80fd, \u8c22\u8c22\u652f\u6301\u3002 *\n\n\n# \u8bb0\u5f97\u7ed9\u4e2astar\u9f13\u52b1\u4e00\u4e0b\uff01Thanks\u266a(\uff65\u03c9\uff65)\uff89\n\n----------\n[](http://hits.dwyl.io/lqkweb/sqlflow)",
"description_content_type": "",
"docs_url": null,
"download_url": "",
"downloads": {
"last_day": -1,
"last_month": -1,
"last_week": -1
},
"home_page": "https://github.com/lqkweb/sqlflow/tree/master",
"keywords": "",
"license": "LICENSE.txt",
"maintainer": "",
"maintainer_email": "",
"name": "pysqlflow",
"package_url": "https://pypi.org/project/pysqlflow/",
"platform": "",
"project_url": "https://pypi.org/project/pysqlflow/",
"project_urls": {
"Homepage": "https://github.com/lqkweb/sqlflow/tree/master"
},
"release_url": "https://pypi.org/project/pysqlflow/0.0.1/",
"requires_dist": null,
"requires_python": "",
"summary": "SQL Machine learning platform",
"version": "0.0.1"
},
"last_serial": 5002436,
"releases": {
"0.0.1": [
{
"comment_text": "",
"digests": {
"md5": "333d70480b68a149805515de8e5b5d62",
"sha256": "87b0315be77e9fff2aa82f81b38742d1234f1de9e696749a7a87c48f8620eedc"
},
"downloads": -1,
"filename": "pysqlflow-0.0.1.tar.gz",
"has_sig": false,
"md5_digest": "333d70480b68a149805515de8e5b5d62",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 3631,
"upload_time": "2019-03-29T10:01:34",
"url": "https://files.pythonhosted.org/packages/33/19/abe5f9bcd32b608706d7702f0fd111dbc242433b1b7ca1fb96a9a02297ee/pysqlflow-0.0.1.tar.gz"
}
]
},
"urls": [
{
"comment_text": "",
"digests": {
"md5": "333d70480b68a149805515de8e5b5d62",
"sha256": "87b0315be77e9fff2aa82f81b38742d1234f1de9e696749a7a87c48f8620eedc"
},
"downloads": -1,
"filename": "pysqlflow-0.0.1.tar.gz",
"has_sig": false,
"md5_digest": "333d70480b68a149805515de8e5b5d62",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 3631,
"upload_time": "2019-03-29T10:01:34",
"url": "https://files.pythonhosted.org/packages/33/19/abe5f9bcd32b608706d7702f0fd111dbc242433b1b7ca1fb96a9a02297ee/pysqlflow-0.0.1.tar.gz"
}
]
}![\"SQLflow](\"https://upload-images.jianshu.io/upload_images/11023671-f9f8887c69961f55.png\")
\n\n![\"SQLflow](\"https://upload-images.jianshu.io/upload_images/11023671-b4d8905fda2ebe67.png\")
\n\n