Program HN: Automate export SQL query results to CSV, excel and JSON formats

sql2json is a tool( python package) to automate export sql inquiry to csv o excel.

I published sql2json previously here, now it come with csv and excel assistance.

sql2json is Github: https://github.com/fsistemas/sql2json
sql2json in pypi: https://pypi.org/project/sql2json/

My usage cases:
Run cron jobs to extract sales information and post to a geckoboard dataset( json format).
Run cron tasks to draw out details in a csv then submit it to Google BigQuery.
Run cron jobs to draw out information in a csv or excel format.

Remarks are welcome.

Find Out More

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *

scroll to top