Public HafSQL database on HAF
hive-139531·@mahdiyari·
0.000 HBDPublic HafSQL database on HAF
### Edited Jan 2025 The endpoint listed in this post is deprecated and will be dropped soon. See https://mahdiyari.gitlab.io/hafsql/#connection-settings The above includes the new public database as well as documentations related to that database. *** #### What is HafSQL It is built to run on HAF and provide gateway to certain data. For example with hafsql, you can query all the operations and virtual operations by their parameters. This includes getting `custom_json` operations based on their `id` with incredible speed. Or searching transfers based on their `memo`. Or having list of incoming delegations. It is just the matter of what data do you want or need. Then we can add certain indexes to provide that data easily. On top of that, `hafsql-api` is built to provide JSON-RPC 2.0 API access. This again makes it possible to add/manage custom APIs that translate to SQL queries. #### Why this post Although it is fairly "easy" to set up a development environment in 20 minutes and play with HAF and HafSQL, it is not as accessible for everyone. Thus I am providing a public database that is open to anyone. Just remember, this public database is not meant to be used in a production environment in your application. Play with it and see what data is available and what is not and see how it can help your project. It is possible to add a custom API designed for your needs to `hafsql-api` that we can potentially run on all the public RPC nodes. Including `rpc.mahdiyari.info`. Check my previous related posts and gitlab for example API calls. Here are the details for the public HafSQL database. ``` host: [Deprecated - read first paragraph] hafsql.mahdiyari.info port: 5432 database: haf_block_log user: hafsql_public password: hafsql_public ``` This server has been running for couple of months now. There is also a backup server running just in case. There is a 45s timeout on queries. If you hit the timeout it usually means the query is not using an index. You can change your query around, or open an issue, or MR, or reach out to me to potentially add a new index to fit your query if needed. *** https://gitlab.com/mahdiyari/hafsql https://gitlab.com/mahdiyari/hafsql-api I would also recommend [DBeaver](https://dbeaver.io/) as a free database manager.
👍 gurujames, baroen96, emjoe, elricmoonslayer, lothbrox, gaottantacinque, hyun-soo, cribbio, riyuuhi, onestop, repayme4568, smartvote, gasaeightyfive, owasola, luvlylady, sorenkierkegard, leyla5, hijosdelhombre, joeyarnoldvn, bubtforhad, cryptoshots.nft, glimpsytips.dex, macmaniac77, mrxplicit, marcocasario, keys-defender, chimp.ceo, crypto-shots, karina.gpt, sunnyjolly, jhiecortez, rezawijaya, joanpablo, edundayo, supperbotsps.com, dutchchemist, dappcast, carbodexkim, hive-defender, key-defender.shh, cryptoshots.play, cryptoshotsdoom, khoon, steemian258, maclevis, tibra, not-a-gamer, ausbit.dev, islandboi, idea-make-rich, psygambler, natha93, ibook-ishare, abduljalill, din0baba, cloh76, irisworld, disruptivas, cambridgeport90, chike4545, lynliss, mdaminulislam, apostle-thomas, walidchabir, rustam-02, vonzeppelin, tesaganewton, jsalvage, djblendah, naviii, bjornb, freebornsociety, life.bank, achmadyani, imammudarifqi, ekkah, kim24, jff7777, crypt0gnome, sirmiraculous, glstech, jkp.nisha, archangel21, steemwhalepower, ond, trentonlundy1, mirnasahara, antisocialist, fotonorway8, sensiblecast, sumotori, yayogerardo, polashsen, virgo27, adysscheryl, dragokazo, sward, bustillo, overunitydotcom, voaputra, artmusiclife, tikki00taffi, vsemmetall, bahagia-arbi, foodtaster, bigbos99, bai123, dreemsteem, brotherhood, raghib, mamalikh13, azirgraff, vahidrazavi, g4fun, gamercreed, merit.ahama, davidbright, biggerjoe, bhdc, robat71, marco77290, kevinwong, gakimov, xyz004, makrotheblack, amico.sports, mrwang, leduc1984, techken, nurhayati, mayib, waraira777, underground, zeero22, ihsan19, tonybad, eliasseth, tillmea, ghici, cuthamza, dumitriu, apartphilosopher, kgcoin, shanibeer, sandyprasasty, gejzep, kaiggue, rocketpower, lordb, firinmahlazer, roleerob, digital.mine, dec.entralized, houstonrockets, sbi3, liable, sbi-tokens, gerber, ezzy, exyle, deathwing, sneakyninja, mastergerund, thedailysneak, steem.leo, the-table, mice-k, dcityrewards, someguy123, daan, cryptoknight12, shitsignals, felander, emrebeyler, unconditionalove, bestboom, dlike, samsemilia7, determine, haikusailor, therealyme, invest2learn, ribary, sketching, jelly13, hivechat, dcrops, hykss.leo, leodis, jeanlucsr, permaculturedude, triplea.bot, gmlrecordz, dpend.active, nyxlabs, merlin7, dpoll.witness, unlockmaster, forecasteem, rituraz17, leone.bianco, coquiunlimited, mrhoofman, lloyddavis, nfaith, enjar, borniet, fourfourfun, yogacoach, laiyuehta, heyitshaas, simsahas, youraverageguy, jaybird, horpey, steem-tube, saifulanwar, solarwarrior, zackarie, iamleicester, apineda, samueluche07, beverages, rudy-dj, dreamon, offoodandart, lightflares, vicesrus, throwbackthurs, cryptological, fractalfrank, hornetsnest, itinerantph, bucipuci, ashokcan143, steveconnor, gooze, tasteofsuccess, bdlatif, dickturpin, steinz, lays, olgadmitriewna, sirjaxxy, chungsu1, goodcontentbot, ilovegames, gringo211985, gmlgang, socialmediaseo, ycgg, mahuampionlinemg, radiv, hairyfairy, steeminer4up, akpos, leomolina, contentisking, teamashen, laabuelita, creepycreature, kharrazi, kont82, barslanhan, nipek, hhaskana, dipoabasch, iccel35, swearingradio, blockchaincat, kriptoqraf, recan, cloudhyip, oomcie85, willsaldeno, hyborian-strain, luciancovaci, culturearise369, danielsaori, santinhos, prapanth, abduljalil.mbo, britcoins, kimchi-king, manniman, i-test-stuff, fitnessgourmet, patlog, razorshark, marvinman, money.finance, mannimanccadm, gocular, yildiss, chamudiliyanage, estourefugiado, monstervoter, sitiaishah, sankysanket18, afrikablr, patlu, wakeupnd, silberpapst, crescendoofpeace, abieikram, elluismma, anutta, kshahrck, freshfund, seikatsumkt, herbncrypto, plebtv, gvincentjosephm, ian19, theleapingkoala, nasel, xanderslee, leguidecrypto, princeso, srl-zone, fuzzythumb, lynbabe10, marcost4, teachblogger, bryanj4, bolsfit, resonator, ura-soul, informationwar, leprechaun, jagged71, ausbitbank, tftproject, firstamendment, risemultiversity, dmwh, empress-eremmy, aagabriel, haccolong, deepdives, riskneutral, unknownonline, oratione, inigo-montoya-jr, eldritchspig, okluvmee, shanhenry, delver, jagjnr, brain71, stevescoins, hoaithu, anhvu, reteem, thecontesttrain, bilpcoinbpc, illuminaticongo, abundance.tribe, retard-gamer-de, investinfreedom, dbroze, tribesteemup, kennyskitchen, dannyshine, gabrieljr, elamental, makinstuff, sagescrub, moxieme, hempress, nataboo, eugenekul, homestead-guru, steemer-x, indigoocean, nmcdougal94, actordontee, catherinebleish, whatamidoing, rt395, zyx066, libertyepodcast, annemariemay, jessicaossom, treaphort, solarsupermama, smarmy, phillyc, profgabs05, reversehitler88, steembet.asia, haileyscomet, sanderjansenart, taskmaster4450, mightpossibly, rohansuares, trucklife-family, fredhill, insanityisfree, atma.love, paradise-paradox, l337m45732, the.rocket.panda, crypt0holics, newsnownorthwest, commonlaw, aconsciousness, clownworld, belleamie, churdtzu, eaglespirit, thomaskatan, bia.birch, vegan.niinja, kieranpearson, brightstar, jimbobbill, heart-to-heart, doze, mannacurrency, colinhoward, canadianrenegade, celestialcow, gregorypatrick, meesterbrain, uruiamme, maxsieg, holisticmom, v4vapid, kgakakillerg, primeradue, kgswallet, blog-beginner, deeanndmathews, skiptvads, mein-senf-dazu, hive-coding, hivegadgets, nthtv, andyjaypowell, bartheek, trostparadox, xyba, riseofthepixels, pixels.vault, asgarth, bilpcoin.pay, hive-108278, peakd, kingkinslow, mozzie5, acantoni, bihutnetwork, borislavzlatanov, michelmake, mahdiyari, oflyhigh, wherein, celeste413, cnstm, likuang007, lianjingmedia, zerofive, starrouge, fw206, gadrian, imbartley, hdmed, morwhale, morwhaleplus, feedme, hdmed.dev, kamalamezwar, steemorocco, morwhalebonus, teammorocco, sarmitirajaa, cura, najat, sweeverdev, thedd, deepresearch, techguard, spiritabsolute, newsflash, petrolinivideo, tierra-errante, ronibarua, adcreatordesign, profwhitetower, arieswilly, lolz.byte,