你知道如何从HIVE链上获取数据嘛？直接访问各个DAPP（比如hive.blog, peakd.com等）无疑是个办法，或者访问区块链浏览器获取一些更底层的数据，又或者我们可以通过API直接从hived节点获取数据。 (图源 ：pixabay) 但当我们想获取一些更为复杂的数据时，以上方法都显得无能为力，比如说统计中文区失联（长时间没有发帖）用户的情况，或者查询HP代理（代理进来），等等等。

#SQL is weird.

The need for workarounds like this is the reason I don't like #SQL

... #postgresql

... snowflake ID types.

最近O哥奋发图强每天都在努力学习，比如说写点Python程序，又比如说写点PHP代码，有时候也用SQL来做一些数据分析，等等等等。 (图源 ：pixabay) 虽然忙忙碌碌把自己搞得晕头转向也没啥成果产生，但还是乐此不疲。不由得曾经一个前上司说的一句话：生命在于折腾。 确实如此呀，模仿那句经典的我思故我在，咱也整上一句我折腾故我在，哪天真的彻底不折腾了，那一定是嘎了。话说，这句会被载入史册不？

SELECT * FROM SAMPLE_TABLE FOR JSON PATH The line of SQL code above is what I have been looking for in the last couple of weeks. I always get excited when I discover solutions for problems. Seeing problems

I have just updated the small help tool “Hive Post Payout Dashboard (using HafSQL)” to a new host endpoint, as the dear @mahdiyari will soon deactivate the old version at hafsql.mahdiyari.info and the

HiveSQL create account, tests, azure data studio, nodejs with HiveSQL

Oh yeah, let’s nail them down

... in sql file is next level sql skill. #postgresql

... and let the optimiser choose the right plan they said. And then you extract part of the big query as a VIEW and suddenly the performance it 4x worse.

GM HiveDevs! In my last post, I introduced the HiveSQL AI Bot, a tool that combines Discord, HiveSQL database querying, and AI capabilities to help users interact with the database through natural language.

Hey there, HiveDevs! Yesterday I needed to query HiveSQL to get some statistics from PixBee, and I had an idea: why not use AI to create these SQL queries automatically? The idea came and soon it will

HiveSQL是包含Hive区块链所有数据的一个MS SQL Server 数据库，是我认为HIVE上最有价值的项目之一。 (图片由ChatGPT协助生成） 通过HiveSQL可以查询很多有价值的数据，比如说都谁没有设置我成为他的见证人代理也没投我见证人票，都谁没有给我的帖子投票，然后画个圈圈哦，不对，是拿个小本本记下来。

Me writing #sql

... it mas missing LEFT in a JOIN. ._. #sql

There's this awesome tools by @arcange called HiveSQL and if you haven't supported the proposal check out the proposal to keep HIVESQL price "Free" to use ( although you still have to pay 1 HBD)

EN Hello Today I started my SQL lessons, today I understood better how queries are made via SQL. I will try to share what I learned in these lessons. Let's start writing our arms by opening a new Query

This is a new tutorial series on Structured Query Language(SQL), I will start from the basics to advanced concepts like SQL programability. ▶️ 3Speak