HafSQL went through a big update. This is a release candidate and not a final release as HAF 1.27.6 is not released yet. This version of HafSQL is compatible with HAF 1.27.6-rc9.
There are a lot of breaking changes. In terms of API usage, the REST APIs are replacing the JSON RPC methods.
Database tables and views have been also changed.
Notable features/changes:
op_*andvo_*have been removed and replaced withoperation_*_tableandoperation_*_view- See documentations - Each replacing table might have a slightly different structure/data types- Useful HAF tables are now accessible under
haf_* - Addition of HBD/HIVE savings balances
- Addition of account information - In par with hivemind if not more
- REST API integration into the main APP - the API repository has been dropped
- Streamlined docker integration - Maintaining a docker compose repository
- The code base is now Typescript with Deno
- Database documentations: https://mahdiyari.gitlab.io/hafsql/
- API documentations: https://hafsql-api.mahdiyari.info
The API documentation link is also the endpoint for the REST APIs. Every node running HafSQL will also serve that documentation. The APIs are not done yet and more will be added.
The database documentation provides an easy way of searching the columns and the tables. It also includes the new endpoint of the public HafSQL node (hafsql-sql.mahdiyari.info).
The switch to the breaking code will be after the official HAF 1.27.6 release. Until then the old node will work (hopefully). Test your codes and be ready for the official release as this is just a release candidate.
The main repository and the documentations should have all you need for using HafSQL either locally or by the provided public node. I have tried to write only useful information there.
Main repository: https://gitlab.com/mahdiyari/hafsql
Docker hub: https://hub.docker.com/r/mahdiyari/hafsql
Future work
I will try to complete the API list as far as I can for the data already present in the database and have public API nodes run and provide HafSQL APIs.
I will probably write another post after the above is done and discuss what comes next.
Your work is impressive! The effort and thought you're putting into improving HafSQL is truly commendable. Once the API list and public nodes are up and running, it will benefit many more people. Looking forward to your next post on what's coming next!
Thank you so much
keep up the good work
Keep up the great job bro !BBH
successful my friend, great job you have done. best regards!
when you talk about docker it is difficult for non tech people
!PIZZA
Hive.Pizza upvoted this post.
$PIZZA slices delivered:
@danzocal(8/10) tipped @mahdiyari
Learn more at https://hive.pizza.
@mahdiyari! @day1001 likes your content! so I just sent 1 BBH to your account on behalf of @day1001. (13/20)
(html comment removed:
)
Hello mahdiyari!
It's nice to let you know that your article won 🥈 place.
Your post is among the best articles voted 7 days ago by the @hive-lu | King Lucoin Curator by deepresearch
You and your curator receive 0.0345 Lu (Lucoin) investment token and a 6.60% share of the reward from Daily Report 513. Additionally, you can also receive a unique LUSILVER token for taking 2nd place. All you need to do is reblog this report of the day with your winnings.
Buy Lu on the Hive-Engine exchange | World of Lu created by @szejq
STOPor to resume write a wordSTARTCongratulations @mahdiyari! Your post has been a top performer on the Hive blockchain and you have been rewarded with this rare badge
You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPCheck out our last posts: