sql Tag Posts Index

每天进步一点点：如何在LINQPad中使用HafSQL

你知道如何从HIVE链上获取数据嘛？直接访问各个DAPP（比如hive.blog, peakd.com等）无疑是个办法，或者访问区块链浏览器获取一些更底层的数据，又或者我们可以通过API直接从hived节点获取数据。 (图源 ：pixabay)

#SQL is weird.

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

Have you ever had the need for a JOIN on expression other than = ? #sql ...

... #postgresql

Announcing pg_snowflake, a #sql #postgresql extension for creating customisable ...

... snowflake ID types.

每天进步一点点：SQL的注释

最近O哥奋发图强每天都在努力学习，比如说写点Python程序，又比如说写点PHP代码，有时候也用SQL来做一些数据分析，等等等等。 (图源 ：pixabay) 虽然忙忙碌碌把自己搞得晕头转向也没啥成果产生，但还是乐此不疲。不由得曾经一个前上司说的一句话：生命在于折腾。

SQL Query to Get Column Name & Value Pairs | Understanding Database Structure

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

Updates on my Hive Post Payout Dashboard (using HafSQL) / New Endpoint for mahdiyari.info

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

Hive Devs Journal "HiveSQL" | Diario del desarrollador Hive

Saludos Hivers, siempre es un placer saludarles y compartir lo que voy llevando a cabo. Quiera Dios que mis artículos sirvan para compartir el conocimiento y ahorrarles

TypeOrm View Entities Explained

A View Entity in TypeOrm is like a virtual table that pulls data from your database view. Creating one is simple! Just define a new class and mark it with @ViewEntity().

Writing query creating #sql function that is run inside plpython function created ...

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

#sql is nice, high level language they said. Focus on the meaning of the query ...

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

Release of HiveSQL Discord Bot with AI Capabilities

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

Querying HiveSQL with AI: Goodbye Complex SQLs!

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?

兜兜转转，如果绕过限制访问HiveSQL

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

Me writing #sql

I just spent a few hours trying to fix failing tests after a change. Turned out ...

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

I Just Learned How to Sort Following List by Reputation With HiveSQL—Feels Silly but Exciting!

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

(EN-TR) SQL CODES -- I SHARE WHAT I'VE LEARNED///SQL KODLARI -- ÖĞRENDİKLERİMİ PAYLAŞIYORUM

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

SQL TUTORIALS [001]

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