create account

HafSQL update 2.0.0-rc1 - Breaking changes by mahdiyari

View this thread on: hive.blog |  peakd.com |  ecency.com
hive-139531 · @mahdiyari ·
$163.54
HafSQL update 2.0.0-rc1 - Breaking changes
<center>![image.png](https://files.peakd.com/file/peakd-hive/mahdiyari/23uQJFstu9WELzuWhgKxFERDXiae9zBtBJJx6zGGZazUEzG3e3cpWPNaU1WQeMUWzE3x3.png)</center>
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.
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 703 others
properties (23)
authormahdiyari
permlinkhafsql-update-200-rc1-breaking-changes
categoryhive-139531
json_metadata{"app":"peakd/2024.11.3","format":"markdown","tags":["hivedev","hive","dev","haf","hafsql"],"users":[],"image":["https://files.peakd.com/file/peakd-hive/mahdiyari/23uQJFstu9WELzuWhgKxFERDXiae9zBtBJJx6zGGZazUEzG3e3cpWPNaU1WQeMUWzE3x3.png"]}
created2024-12-14 16:24:00
last_update2024-12-14 16:24:00
depth0
children11
last_payout2024-12-21 16:24:00
cashout_time1969-12-31 23:59:59
total_payout_value81.816 HBD
curator_payout_value81.726 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,339
author_reputation199,864,818,197,856
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,206,976
net_rshares504,547,689,368,926
author_curate_reward""
vote details (767)
@bbhbot · 
<center><p>@mahdiyari! <b>@day1001 likes your content!</b> so I just sent 1 <b>BBH</b> to your account on behalf of @day1001. <sub>(13/20)</sub></p>
<p><!--<img src="https://i.imgur.com/QwsegY0.png">--></p></center>
properties (22)
authorbbhbot
permlinkre-mahdiyari-20241216t081158
categoryhive-139531
json_metadata""
created2024-12-16 08:11:57
last_update2024-12-16 08:11:57
depth1
children0
last_payout2024-12-23 08:11:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length215
author_reputation2,740,199,634,396
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,247,594
net_rshares0
@danzocal · 
!PIZZA
properties (22)
authordanzocal
permlinkre-mahdiyari-soj7dq
categoryhive-139531
json_metadata{"tags":["hive-139531"],"app":"peakd/2024.11.3","image":[],"users":[]}
created2024-12-15 10:49:03
last_update2024-12-15 10:49:03
depth1
children0
last_payout2024-12-22 10:49:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length6
author_reputation12,432,803,008,396
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,222,934
net_rshares0
@day1001 ·
$0.08
Keep up the great job bro !BBH
👍  ,
properties (23)
authorday1001
permlinkre-mahdiyari-20241216t16112873z
categoryhive-139531
json_metadata{"type":"comment","tags":["hivedev","hive","dev","haf","hafsql"],"app":"ecency/3.0.46-mobile","format":"markdown+html"}
created2024-12-16 08:11:30
last_update2024-12-16 08:11:30
depth1
children0
last_payout2024-12-23 08:11:30
cashout_time1969-12-31 23:59:59
total_payout_value0.038 HBD
curator_payout_value0.039 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length30
author_reputation9,704,511,542,293
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,247,585
net_rshares245,515,562,100
author_curate_reward""
vote details (2)
@dungvip123a ·
$0.07
when you talk about docker it is difficult for non tech people
👍  ,
properties (23)
authordungvip123a
permlinksoifl0
categoryhive-139531
json_metadata{"app":"hiveblog/0.1"}
created2024-12-15 00:48:36
last_update2024-12-15 00:48:36
depth1
children0
last_payout2024-12-22 00:48:36
cashout_time1969-12-31 23:59:59
total_payout_value0.036 HBD
curator_payout_value0.037 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length62
author_reputation-6,267,521,520
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,216,673
net_rshares230,756,185,490
author_curate_reward""
vote details (2)
@hive-lu · 
#### 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](/lucoin/@hive-lu/daily-report-day-513). Additionally, you can also receive a unique **LUSILVER** token for taking 2nd place. All you need to do is reblog [this](/lucoin/@hive-lu/daily-report-day-513) report of the day with your winnings.
 
<center>[![2.png](https://files.peakd.com/file/peakd-hive/now.calendars/23uEwt7Djmb4N3dE96ecCUemJez6vLU3fmoTrdjEJn1ws4d8iPw2QrrsB22nyhbb178sx.png)](/@hive-lu)</center>
 
---
<center><sub>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](https://hive-engine.com/trade/LU) exchange | World of Lu created by @szejq </sub></center>
<center><sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP` _or to resume write a word_ `START`</sub> </center>
properties (22)
authorhive-lu
permlinklucoin-prize-249s5s
categoryhive-139531
json_metadata""
created2024-12-22 03:36:00
last_update2024-12-22 03:36:00
depth1
children0
last_payout2024-12-29 03:36:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,190
author_reputation32,196,513,073,198
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,393,748
net_rshares0
@hivebuzz · 
Congratulations @mahdiyari! Your post has been a top performer on the Hive blockchain and you have been rewarded with this rare badge

<table><tr><td><img src="https://images.hive.blog/60x60/https://hivebuzz.me/badges/toppayoutday.png"></td><td>Post with the highest payout of the day.</td></tr>
</table>

<sub>_You can view your badges on [your board](https://hivebuzz.me/@mahdiyari) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>



**Check out our last posts:**
<table><tr><td><a href="/hive-122221/@hivebuzz/lpud-202412"><img src="https://images.hive.blog/64x128/https://i.imgur.com/pVZi2Md.png"></a></td><td><a href="/hive-122221/@hivebuzz/lpud-202412">LEO Power Up Day - December 15, 2024</a></td></tr></table>
👎  
properties (23)
authorhivebuzz
permlinknotify-1734224418
categoryhive-139531
json_metadata{"image":["https://hivebuzz.me/notify.t6.png"]}
created2024-12-15 01:00:18
last_update2024-12-15 01:00:18
depth1
children0
last_payout2024-12-22 01:00:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length857
author_reputation369,404,011,994,576
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,216,841
net_rshares-65,871,303,012
author_curate_reward""
vote details (1)
@josim100 ·
$0.13
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!
👍  ,
properties (23)
authorjosim100
permlinksohwm6
categoryhive-139531
json_metadata{"app":"hiveblog/0.1"}
created2024-12-14 17:58:54
last_update2024-12-14 17:58:54
depth1
children1
last_payout2024-12-21 17:58:54
cashout_time1969-12-31 23:59:59
total_payout_value0.066 HBD
curator_payout_value0.067 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length252
author_reputation1,375,509,897
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,208,959
net_rshares415,107,072,777
author_curate_reward""
vote details (2)
@josim100 · 
Thank you so much
properties (22)
authorjosim100
permlinksojtiv
categoryhive-139531
json_metadata{"app":"hiveblog/0.1"}
created2024-12-15 18:47:21
last_update2024-12-15 18:47:21
depth2
children0
last_payout2024-12-22 18:47:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length17
author_reputation1,375,509,897
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,233,304
net_rshares0
@latinowinner ·
$0.13
keep up the good work
👍  ,
properties (23)
authorlatinowinner
permlinkre-mahdiyari-20241215t595878z
categoryhive-139531
json_metadata{"tags":["hivedev","hive","dev","haf","hafsql"],"app":"ecency/4.0.2-vision","format":"markdown+html"}
created2024-12-14 19:10:00
last_update2024-12-14 19:10:00
depth1
children0
last_payout2024-12-21 19:10:00
cashout_time1969-12-31 23:59:59
total_payout_value0.066 HBD
curator_payout_value0.066 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length21
author_reputation2,954,178,241,880
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,210,731
net_rshares412,213,774,356
author_curate_reward""
vote details (2)
@pizzabot · 
<center>PIZZA!
 Hive.Pizza upvoted this post.

$PIZZA slices delivered:
@danzocal<sub>(8/10)</sub> tipped @mahdiyari 


<sub>Learn more at https://hive.pizza.</sub></center>
properties (22)
authorpizzabot
permlinkre-hafsql-update-200-rc1-breaking-changes-20241215t105057z
categoryhive-139531
json_metadata"{"app": "pizzabot"}"
created2024-12-15 10:50:57
last_update2024-12-15 10:50:57
depth1
children0
last_payout2024-12-22 10:50:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length173
author_reputation7,591,131,951,197
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,222,968
net_rshares0
@ricardogoto ·
$0.07
successful my friend, great job you have done. best regards!
👍  ,
properties (23)
authorricardogoto
permlinksoi5ix
categoryhive-139531
json_metadata{"app":"hiveblog/0.1"}
created2024-12-14 21:11:21
last_update2024-12-14 21:11:21
depth1
children0
last_payout2024-12-21 21:11:21
cashout_time1969-12-31 23:59:59
total_payout_value0.035 HBD
curator_payout_value0.037 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length60
author_reputation12,684,450,909,344
root_title"HafSQL update 2.0.0-rc1 - Breaking changes"
beneficiaries
0.
accounthiveonboard
weight100
1.
accountmanuelramos
weight300
2.
accountroomservice
weight100
max_accepted_payout1,000,000.000 HBD
percent_hbd0
post_id139,213,194
net_rshares231,679,440,959
author_curate_reward""
vote details (2)
Help/Feedback