When comparing Falcon vs SQL Power Architect, the Slant community recommends Falcon for most people. In the question“What are the best cross-platform GUI tools for DBMS?” Falcon is ranked 10th while SQL Power Architect is ranked 11th. The most important reason people chose Falcon is:
Falcon is designed entirely around building REST APIs. It achieves this helps a lot with it being lightweight and simple. It also helps developers take some design choices which would otherwise not be possible with a more general-purpose framework,
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Built to build REST APIs
Falcon is designed entirely around building REST APIs. It achieves this helps a lot with it being lightweight and simple. It also helps developers take some design choices which would otherwise not be possible with a more general-purpose framework,
Pro Lightweight with minimal dependencies
Falcon is a very lightweight framework. This can be noticed simply by looking at the dependency list: other than the python standard library, six and mimeparse are the only dependencies.
Pro Performance is really awesome
Pro Convert
Can convert databases and copy the data from tables.
Pro OLAP schema modeling
Cubes, Measures, Dimensions, Hierarchies & Levels.
Pro Reverse engineering
Pro Drag and Drop
Cons
Con Limited in scope
Being designed around building REST APIs and the fact that it's minimalistic with very few dependencies makes Falcon opinionated (you should build a REST API) and limited in scope (you shouldn't be using Falcon to build a news site, blog or ecommerce platform).
Con The manual is not free
The SQL Power Architect User Guide costs $ 99.
