Upvoted, resteemed and witness voted.
I am a heavy user of steemsql.
Thanks for the good work.
A health check would be nice, to see, how far the db is behind or if maintenance is ongoing :)
Upvoted, resteemed and witness voted.
I am a heavy user of steemsql.
Thanks for the good work.
A health check would be nice, to see, how far the db is behind or if maintenance is ongoing :)
Thank you for your witness vote and helping the SteemSQL project.
Very good idea. I will implement it as soon as I find some time for it ;)
Christmas is coming.. I have a long list:)
Maybe a Web api, so one can browse through data.
I have a health check of sorts on steemsearch which uses the following query
select top(1) datediff(minute, created, getutcdate()) as diff from comments nolock where depth=0 order by created desc
Thanks!
I try to put it to good use!
:)
As far as just using SteemSQL to browsed posts (and not to browse the various other types of data found there), check out steemsearch.com. This is what Mark developed the health check shared here for - it is already a pretty amazingly full featured way to browse for new posts / posters. And it shows the current SteemSQL database lag when you visit it, so it is a quick and easy way to check :)