Write SQL queries effortlessly with Falcon by Plotly
This post guides you through downloading and setting up Falcon - a free, open-source SQL editor which enables you to write your SQL queries without the hassle and moreover gives you an option to visualize the results.
Introduction
Falcon is a free, open-source SQL editor with inline data visualization. It lets you write SQL queries without hassle, as well as allows you to visualize the result with simple clicks.
It currently supports connecting to RedShift, MySQL, PostgreSQL, IBM DB2, Impala, MS SQL, Oracle, SQLite, and more.
Note: Falcon is open source and works without an internet connection or a Plotly Chart Studio account. Click on the button below to download Falcon.
Further, follow these steps to set up Falcon on your computer:
Step 1: Select the preferred Database Type (We have selected SQLite).
Step 2: Select the data file and click on 'SAVE CHANGES'(our file is android_apps.db)
Step 3: Go to the Query Section to run your queries.
Step 4: After running the query, you can visualize it in the 'CHART' section.
You have successfully set up Falcon on your computer (Yay!).
Heads up! Falcon is open source and works without an internet connection or a Plotly Chart Studio account. The software works well and we hope you find it useful. FYI, as a company we are spending most of our development effort on Dash Open Source & Dash Enterprise. Truth be told, we found that most companies we worked with preferred to own the analytical backend. With Dash, we provide the visualization and application primitives so that you can build your own tailor-made dashboards, analytical apps, or yes, even, SQL editors.
Conclusion
Now, that you are all set with Falcon - SQL editor, let's begin writing some queries. Check out our post that answers some business questions using real-life Play Store Dataset using SQL queries on Falcon
Happy Learning!
