Alpha Anywhere vs. PostgreSQL

The speed of development from concept, through development and delivery of the end product is so impressive [with Alpha Anywhere]. There is an impressive array of genies and helper functions meaning that you can focus on what matters, the end user experience. It is not a "No code" solution but it is a very impressive "low code" solution which allows detailed access under the hood to tweak the applications to your own needs and the needs of your clients.

PostgreSQL is best used for structured data, and best when following relational database design principles. I would not use PostgreSQL for large unstructured data such as video, images, sound files, xml documents, web-pages, especially if these files have their own highly variable, internal structure.

Incentivized

• Our company had been creating small business applications since the 1980's, when we used DBase IV (don't laugh... that's what was available). Then, we got more "sophisticated" with Microsoft Access. Clearly, we would always be limited with what we can do with those two programs. By accident, during an Internet search, we saw and ad for Alpha Anywhere (back then, it was called Alpha V). After working with the 30 free trial for just two weeks, we retired Access, for good. The best part was Alpha's flexibility in its use of "back end" data tables. That allowed us to use existing Access tables as we redesigned the front-end program (Alpha ships with its own DBF system, but we prefer SQL-Based tables). You can choose, SQL Server, MySQL, Oracle, Access, Paradox (actually, too many to name) for your tables. You can even create links to Excel spreadsheets or QuickBooks Tables. It's outstanding!
• Alpha allows developers to create very large and very complex programs. However, it's also a great choice for RAD (Rapid Application Development) for those who need to be up and running quickly or for less experienced programmers. Actually, the interface truly allows for "codeless" development of your application (more on that later). That means you can design a fully functional application, without typing a single line of code. They have some examples on their website.
• My favorite part of Alpha is that it is constantly adding features and functions that allow us to do more with our applications. In fact, one of my biggest problems is that I need more time to learn and practice the added features as fast as they are introduced
• Prior to Alpha Anywhere, we never considered creating/developing "mobile" applications (for tablets, smartphones, etc.). Alpha created a unique "panel" system that makes those application work great... and allows for the design of very sophisticated Apps.

Incentivized

• It works well with external data sources and runs on platforms with stable performance.
• Clients can rest assured that their personal information will be safe and secure.
• Many forums discuss setup and usage, and most are free.
• Adding tooling applications to a computer is unlimited.
• PostgreSQL runs on many OS platforms and supports ANSI SQL, stored procedures, and triggers.

• I really enjoyed product when the database was a part of it, less maintenance
• Converting to the cloud has been challenging
• Security setup should be simpler, like Softr or Stacker

• Clearer indications on what is the query plan, to optimize the query
• More out of the box, Postgres specific, SQL functions
• It would be nice to have a more visual aid of the relationship between all tables, but possibly this depend more on the UI used

Incentivized

As a needed software for day to day development activities

Incentivized

Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.

Incentivized

PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.

Incentivized

The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.

Incentivized

There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.

But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.

Incentivized

The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.

Incentivized

The online documentation of the PostgreSQL product is elaborate and takes users step by step.

Incentivized

Alpha Anywhere is a full-stack IDE. It’s no code and low code, but you can also custom code if you need to. About 10% of our application is no code. 80% is low code and 10% is custom code.

Although the competition between the different databases is increasingly aggressive in the sense that they provide many improvements, new functionalities, compatibility with complementary components or environments, in some cases it requires that it be followed within the same family of applications that performs the company that develops it and that is not all bad, but being able to adapt or configure different programs, applications or other environments developed by third parties apart is what gives PostgreSQL a certain advantage and this diversification in the components that can be joined with it, is the reason why it is a great option to choose.

Incentivized

The DB is reliable, scalable, easy to use and resolves most DB needs

Incentivized

• Allows for a great return on investment since you can quickly become very productive and complete more projects and applications in a shorter period of time with hand coding and the normal programming headaches of PHP, C#, Angular, etc.
• You can afford to take on more and smaller projects since they will require far less time to complete than more traditional development environments.
• Alpha Anywhere is continuously updated coming out with new features and capabilities on essentially a daily basis. Continuous improvement and frequent updates allows you to always stay ahead of the curve and competitors.
• Alpha Anywhere allows you to offer lower cost solutions that will be completed in less time and that will be much easier to support and maintain.

Incentivized

• Easy to administer so our DevOps team has only ever used minimal time to setup, tune, and maintain.
• Easy to interface with so our Engineering team has only ever used minimal time to query or modify the database. Getting the data is straightforward, what we do with it is the bigger concern.
• It's free. You can't beat that.

Incentivized