HafSQL update 2.0.0-rc1 - Breaking changes

avatar

image.png

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_* and vo_* have been removed and replaced with operation_*_table and operation_*_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.

hivedev hive dev haf hafsql
0
0
0.000
11 comments
avatar

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!

0
0
0.000
Reply
avatar

successful my friend, great job you have done. best regards!

0
0
0.000
Reply
avatar

when you talk about docker it is difficult for non tech people

0
0
0.000
Reply
avatar

Congratulations @mahdiyari! Your post has been a top performer on the Hive blockchain and you have been rewarded with this rare badge

Post with the highest payout of the day.

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 STOP

Check out our last posts:

LEO Power Up Day - December 15, 2024
0
0
0.000
Reply
avatar

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.

2.png

Invest in the Lu token (Lucoin) and get paid. With 50 Lu in your wallet, you also become the curator of the @hive-lu which follows your upvote.
Buy Lu on the Hive-Engine exchange | World of Lu created by @szejq

If you no longer want to receive notifications, reply to this comment with the word STOP or to resume write a word START

0
0
0.000
Reply