Au

Automate export SQL query to CSV, excel, JSON - python package sql2json

Hacker News

Automate export SQL query to CSV, excel, JSON - python package sql2json

sql2json is a tool(python package) to automate export sql query to csv o excel. I posted sql2json previously here, now it come with csv and excel support. sql2json is Github: https://github.com/fsistemas/sql2json sql2json in pypi: https://pypi.org/project/sql2json/ My use cases: Run cron jobs to extract sales information and post to a geckoboard dataset(json format). Run cron jobs to extract information in a csv then upload it to Google BigQuery. Run cron jobs to extract information in a csv or excel format. Comments are welcome.

Share card

Actual performance

1points
Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →
Hacker NewsStrong engagement from HN community · Strong signals: io · Missing: https docs, excited, just released
56%56% predicted probability of success on Hacker News, based on ML models trained on real launch data.
nativeThis product was originally launched on this platform.
Indie HackersIH features products with proven revenue · Missing: supports, reddit linkedin, podcasting
43%43% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.
TrustMRRLess likely to generate early MRR · Strong signals: google · Missing: mobile apps, ios, personal
41%41% predicted probability of success on TrustMRR, based on ML models trained on real launch data.
AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive
23%23% predicted probability of success on AppSumo, based on ML models trained on real launch data.
Product HuntUnlikely to reach the leaderboard · Strong signals: google · Missing: mac, agents, macos
18%18% predicted probability of success on Product Hunt, based on ML models trained on real launch data.
Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue
15%15% predicted probability of success on Acquire.com, based on ML models trained on real launch data.
BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto
8%8% predicted probability of success on BetaList, based on ML models trained on real launch data.

Incorrect prediction on native model

Similar products

Sq
Sql2json – Python package to run SQL query and get JSON result57%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Sql2json – Python package to run SQL query and get JSON result

Hacker News9
Si
Simplql - Query csv, xls and json files with SQL58%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Simplql - Query csv, xls and json files with SQL

Hacker News11
Go
Goqu – Idiomatic SQL and query package for golang42%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Goqu – Idiomatic SQL and query package for golang

Hacker News7
Ru
Run SQL Queries Against JSON, CSV, Excel, Parquet, and More72%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Run SQL Queries Against JSON, CSV, Excel, Parquet, and More

Hacker News7
Mu
Musoq – Query Anything with SQL Syntax (Git, C#, CSV, Can DBC)42%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Musoq – Query Anything with SQL Syntax (Git, C#, CSV, Can DBC)

Hacker News56
Co
Convert sql result tuples to json consumable dicts [Python]59%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Convert sql result tuples to json consumable dicts [Python]

Hacker News4
CS
CSVFiddle – Query CSV files with SQL in your browser58%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

CSVFiddle – Query CSV files with SQL in your browser

Hacker News2
Qu
Query CSV files in the browser with SQL69%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Query CSV files in the browser with SQL

Hacker News3
A
A Usable CSV and JSON to SQL Converter in Elm and Phoenix62%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

A Usable CSV and JSON to SQL Converter in Elm and Phoenix

Hacker News8
Cs
Csvqsh – SQL-like query language for CSV in Awk55%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Csvqsh – SQL-like query language for CSV in Awk

Hacker News3