I did not have any previous experience with the Hive Application Framework (HAF) and I can say that I just started researching it. And to share my first impressions.
I think that working with data in PostgreSQL database will be much more efficient and faster for me than working on data in blockchain. And I think HAF based application will be faster. I have sufficient knowledge of MySql, Oracle, MSSql. I have no experience in PostgreSQL, but I know that I will not have any difficulties. I see that there are useful add-ons in HAF and I think they will be very useful for me. Especially in the case of a blockchain fork, the rollback action caught my attention. It is the most important issue for a programmer and database administrator. It happened to me, sometimes it can take days to fix the mistakes.
I'm currently reviewing the code for HAF on https://gitlab.syncad.com/hive/balance_tracker/-/tree/develop it will improve my coding experience on the blockchain. I haven't set up a HAF server yet, but I'm planning to setup a HAF server soon. In this way, I think that I will have the opportunity to examine the sample codes in more detail and that I can write sample codes myself. This will increase the experience.
I have developed many applications but no experience in blockchain. I'm reviewing sample codes and articles to develop my own application on the Hive blockchain. Hopefully when I feel ready I will start writing code to develop my own app.
I also believe that HAF will both make it easier for me to write code and reduce the amount of code. I don't know much about HAF at the moment, but I hope to share more experiences in the future.
Posted Using LeoFinance Beta
I don't think PostgreSQL is all too different for normal queries so you should be fine moving over the queries. I do think writing function blocks might be different though and it might be annoying if you need other people's packages.
Posted Using LeoFinance Beta
PostgresSQL is probably one of closest SQL clones to Oracle (closer than Microsoft SQL, for example). It is also very fast. And the docs for it are very good.