HAF application development - progress report
hive-139531·@mahdiyari·
0.000 HBDHAF application development - progress report
Progress on HafSQL: I have been developing views for all the operations including the virtual operations. That is done now and the result is 93 views for all the operations. I did play with index creation for a while and after some testing on a fully synced haf node, ended up with 36 total indexes (partial indexes). It takes around 3.5 hours for indexes to be created on i9-13900 with 12 parallel workers. This test is with ZFS+LZ4 on raid 0 NVMe setup. Total storage usage is only by indexes and it is 185GB (non-compressed). 128GB of this space is used by indexes of `custom` and `custom_json` operations. This enables retrieving `custom_json` operations by `id` and by the username from `required_auths` or `required_posting_auths` parameters. I figured this can be a very useful feature for our apps when this gets implemented on the public RPC nodes. The rest of the development will probably be making the live sync part of the application to track things like delegations. The current code works as it is and is under the tag v0.0.1. Readme should be good enough to set everything up. I did try my best to cover all the operations with indexes. Feedback is very welcome. Code: https://gitlab.com/mahdiyari/hafsql Proposal: [DHF proposal - Hive related development](https://peakd.com/hive-139531/@mahdiyari/dhf-proposal-hive-related-development) <center></center>
👍 gaottantacinque, cloh76, macmaniac77, foodtaster, cribbio, gasaeightyfive, bigbos99, ausbit.dev, quochuy, smartvote, makrotheblack, gurujames, din0baba, tesaganewton, bilpcoinbpc, aquarius.academy, underground, azirgraff, vsemmetall, sward, riyuuhi, sirmiraculous, virgo27, kgcoin, vonzeppelin, achmadyani, martinstomisin, nnn1jls, tillmea, syahhiran, dreemsteem, sensiblecast, davidbright, biggerjoe, rezawijaya, rustam-02, kork75, onestop, lynliss, dappcast, repayme4568, joyceantonio, leduc1984, ekkah, joanpablo, sunnyjolly, hijosdelhombre, chike4545, steemwhalepower, zeero22, lothbrox, bahagia-arbi, walidchabir, jkp.nisha, tibra, gakimov, supperbotsps.com, gerber, mice-k, dcityrewards, ezzy, exyle, deathwing, houstonrockets, cambridgeport90, steem.leo, elcomentador, someguy123, carbodexkim, shitsignals, jeanlucsr, felander, blockbrothers, emrebeyler, unconditionalove, bestboom, themightyvolcano, meanbees, linco, sarix, dlike, bobby.madagascar, followjohngalt, determine, permaculturedude, haikusailor, kggymlife, tinyhousecryptos, steemindian, triplea.bot, beta500, leo.syndication, one.life, lividseagulls, luvlylady, artmusiclife, invest2learn, ribary, dpend.active, sketching, jelly13, hivechat, dcrops, hykss.leo, photo-hive-five, magnacarta, sannae.art, leodis, amjdancer, foxlatam, kaiggue, overunitydotcom, polashsen, hugo1954, bai123, kitsuki, ihsan19, joeyarnoldvn, khoon, not-a-gamer, merlin7, hungryharish, hungryanu, poliwalt10, dpoll.witness, emjoe, bilpcoin.pay, idea-make-rich, dumitriu, owasola, bpcvoter3, hive-117638, natha93, archangel21, dapu, kim24, tm2909, mahdiyari, maclevis, princefm, apostle-thomas, yogacoach, mrxplicit, garybilbao, bjornb, holoferncro, carmary, josewilchez, freebornsociety, fotonorway8, shebe, baroen96, djblendah, electronico, lordb, sorenkierkegard, raghib, irisworld, liable, edundayo, jsalvage, ghici, islandboi, cuthamza, abduljalill, glstech, valthy, mirnasahara, qaiserch0078, tonybad, eliasseth, apartphilosopher, mayib, jhiecortez, jff7777, ibook-ishare, disruptivas, marcocasario, ond, patagonian-nomad, g4fun, forecasteem, hive-defender, key-defender.shh, cryptoshotsdoom, otom, digital.mine, sbi7, xyz004, sbi-tokens, sneakyninja, mastergerund, thedailysneak, leone.bianco, borniet, cryptoknight12, unlockmaster, rituraz17, fulltimegeek, gooze, steinz, steveconnor, olgadmitriewna, bdlatif, youraverageguy, dickturpin, roleerob, beverages, lightflares, vicesrus, throwbackthurs, cryptological, fractalfrank, hornetsnest, shanibeer, dec.entralized, alandesign, greengalletti, laiyuehta, lloyddavis, itinerantph, sirjaxxy, horpey, the-table, justasperm, gmlrecordz, rudy-dj, mrhoofman, forykw, patronpass, gsbilbao, rdekeragoo, heyitshaas, enjar, zackarie, jaybird, ilovegames, dbfoodbank, steem-tube, weddinggift, chungsu1, lays, tasteofsuccess, offoodandart, nfaith, bucipuci, coquiunlimited, iamleicester, ycgg, gringo211985, solarwarrior, apineda, nazaleo, contentisking, akpos, radiv, teamashen, cconn, tomwafula, minerspost, darkpylon, plusvault, atma.love, steeminer4up, leomolina, creepycreature, netzisde, dipoabasch, hyborian-strain, sunisa, kont82, hhaskana, abduljalil.mbo, barslanhan, nipek, iccel35, barbyjr, blockchaincat, kriptoqraf, cloudhyip, willsaldeno, culturearise369, luciancovaci, prapanth, recan, santinhos, kharrazi, nthtv, vp-freelance, oomcie85, wakeupnd, gocular, yildiss, silberpapst, sankysanket18, privex, britcoins, kimchi-king, afrikablr, crescendoofpeace, estourefugiado, patlu, monstervoter, sitiaishah, ricko66, r4f4, abieikram, kshahrck, seikatsumkt, bryanj4, ian19, splash-of-angs63, lynbabe10, teachblogger, srl-zone, freshfund, leguidecrypto, herbncrypto, plebtv, gvincentjosephm, princeso, theleapingkoala, bolsfit, nasel, fuzzythumb, anutta, marcost4, dalz, piotrgrafik, trasto, steembet.asia, manniman, sudutpandang, fitnessgourmet, patlog, razorshark, marvinman, money.finance, mannimanccadm, deepresearch, techguard, danielsaori, speko, bluerobo, blue-witness, yialow, taskmaster4450, unyimeetuk, mightpossibly, rohansuares, rpren, fredhill, l337m45732, the.rocket.panda, summertooth, crypt0holics, uruiamme, blocktrades, tomiscurious, votehero, msp-makeaminnow, roelandp, rt395, petrolinivideo, tomatom, memepress, kgakakillerg, marblely, kgswallet, bilpcoinrecords, potpourry, creodas, krrizjos18, beauty197, xblocktrades, marblesz, gabrielatravels, kennyroy, auracraft, trostparadox, ykroys, humbe, mammasitta, macchiata, xyba, usainvote, hive-17777, appreciator, xappreciator, sunsea, dynamicrypto, braaiboy, myfreshes, emeka4, actioncats, discoveringarni, lucianav, cielitorojo, elgatoshawua, power-kappe, aprasad2325, quycmf8, micheal87, detlev, bluemist, lenasveganliving, bertrayo, gabilan55, noalys, hexagono6, fotomaglys, tanzil2024, wendy0520, annabeth, baasdebeer, afternoondrinks, noelyss, wynella, inciter, coolsurfer, kattycrochet, thereikiforest, thevil, resonator, ura-soul, informationwar, leprechaun, ausbitbank, tftproject, truthforce, dmwh, montycashmusic, riskneutral, inigo-montoya-jr, shanhenry, delver, investinfreedom, risemultiversity, empress-eremmy, haccolong, deepdives, kennyskitchen, dbroze, stevescoins, hoaithu, anhvu, kind.network, thecontesttrain, ganjafarmer, beerlover, martial.media, retard-gamer-de, wend1go, insanityisfree, newsnownorthwest, roadstories, kirito-freud, honeymoon-1611, jvphotography, damian-z, roadstories.trib, commonlaw, clownworld, zaibkang, jimbobbill, pocketrocket, maxsieg, sophieandhenrik, trafalgar, raindrop, traf, julesquirin, artefactoestudio, xtrafalgar, andyjaypowell, abelfotografia, el-dee-are-es, rammargarita, ahmedsy, arabisouri, bonzopoe, mengao, deeanndmathews, hope.venezuela, stoodkev, hoffmeister84, smooth, freddio.sport, xsmooth, olaunlimited, santigs, softworld, photographercr, louis88, louis.pay, louis.random, maureenedwards, botefarm, professur, waliphoto, oaldamster, v4vapid, primeradue, nadhora, aera8, kramgelo, vanessageorge, ferguis-ve, melcaya, ssebasv, diehardknocks, isabelpena, phortun, onlavu, velinov86, drag33, devosdevosi, mickiewicz, duke77, russia-btc, criptomaster, ayudando, chaodietas, cyber-tech, give-cat-food, fatimajunio, crisgojar, odsam2, fatherfaith, angelowkhelow, norat23, adesojisouljay, opeyemioguns, eldaniel0131, anytime-soon, gleam-of-light, hiro-hive, sucal, argeh, sparker005, joven777, drbenzz, princess001, tildy, zenai, emmy3, servant7, opopa, charlotte01, shalom0809, blackdovy, emmanuel222, simplymeekarts, pana1, joseystarr, lsoto713, elizahfhaye, lordneroo, franzpaulie, smonkstop1, kstop1, queercoin, henrietta27, hive-122727, fw206, soulsdetour, brianoflondon, zwhammer, hivehydra, podping, cryptoccshow, iproto, tokenomic, jphamer1, sharkthelion, some-asshole, nonameslefttouse, bittujos, parissousa, a-quarius, pibara, elikast, itsabandoned, ksmith7, msadegh, themonetaryfew, borran, thrasher666, thelastofcat, lisfabian, breelikeatree, francescomai, brutus22, chinito, worldtraveller32, burnleoburn, purrix, karmaa13, awuahbenjamin, cowboyzlegend27, palasatenea, demon19, gubbatv, angelagui, lordshah, sisterhood2, wiseagent, trangbaby, babeltrips, dodovietnam, phuongthao98, thaolaven, lynnnguyen, kimloan, winnietran, dora381, whynotcamp, crazy-bee, hyhy93, lamphuong, ivypham, danghao, youdontknowme, thu172, sunnyvo, innfauno12, lifesadvice, newsflash, ksjegw, rajhbd84, drakos, esecholito, rauti, lauti, my451r, ratnaayub, shinoxl, watchlist, workaholic666, amoreyl, sanach, rey01v, taradraz1, torem-di-torem, aswita, saltycat, travoved, captainbob, phdreamers, rosalestrust, foodchunk, whyshy, sunitahive, gledys19, zdigital222, bbphotography, oluwadebby, cryptokungfu, essejparr, tgarcialvarez, joyce152218, tatiana21, profwhitetower,