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

How to be an awesome Android Marketplace Data Analyst for Beginners - Part 1
This post will guide you through writing SQL queries using a real-life dataset of Android apps to answer some analytics-oriented questions.

Happy Learning!