4 ms·
Show HN: Sql2json – Python package to run SQL query and get JSON result
- fsistemas 7y agoI created a python package to run sql query and get json result. I have created multiples python scripts to to run specific query return json, again and again. But since now i only need to create my sql query and run it using sql2json. I think that this tool can be useful for automations. Right now i'm using it in personal project to run queries with dynamic date parameters and post result to a rest API with a linux cron job. Also i'm testing it to send data to geckoboard using curl with sql2json response and geckoboard dataset api. I want to receive some feedback from this community, how can improve it, is it useful for you. Thanks
- g82918 7y agoSo are you using this mostly with something like Django on the backend? Aside from creating a REST API endpoint with python, I can't see many reasons to need this.
- fsistemas 7y agoNo. It's focused to use as a command line and for automation not inside a webapp. You can see usage examples in github