Falcon is a free, open-source SQL editor with inline data visualization (github.com)

Article summary

Falcon is a free, open-source SQL editor with inline data visualization that supports connecting to various databases. It works without an internet connection or a Plotly Chart Studio account. The software is built with Electron, React, Redux, and Sequelize. Falcon is available for download on Mac OS, Windows, and Linux.

Main themes

• SQL editors
• Data visualization
• Non-technical users
• Database management
• Alternative tools
• BigQuery support
• Naming conflicts
• SQL writing vs drag-and-drop tools

What commenters say

• Giving non-technical users a powerful SQL editor can lead to data integrity issues if not managed properly.
• Some users have successfully empowered non-technical colleagues to use SQL editors, resulting in reduced requests and improved productivity.
• Oracle's requirement for a specific client install to use their database is seen as an oddity compared to other databases with open client library implementations.
• Graphical SQL tools can be helpful for new users, but may not cover complex queries and are often less efficient than writing SQL directly.
• Several alternative SQL editors and data visualization tools are available, including Metabase, Redash, and Cluvio.
• BigQuery support is a key consideration for some users, with some tools offering better support than others.
• The name 'Falcon' is overloaded, leading to confusion with other projects and products.
• Some users prefer to write SQL rather than use drag-and-drop tools, which may not handle complex queries well.