你知道如何从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

... 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