New #cln sql plugin is legit

lcli sql query="select count(*), sum(amount_received_msat) from invoices where description like '%damus donations%' and status = 'paid'"

{

"rows": [

[

2543,

185190500

]

]

}

Reply to this note

Please Login to reply.

Discussion

I have no idea what this is. But damn does it look cool and exciting.

throw everything in ChatGPT and then ask it to ELI5

“the query helps you find out how many "damus donations" invoices were paid and how much money was received in total for those invoices”

Damn. That’s a genius idea. I’ll add that to my notepad for the future.

Total sum of the "amount_received_msat" column for those rows: 185,190,500.

Sorry for the oftopic. I tagged you in a note. Not sure it works like that. Grab a look pls: https://iris.to/note197weahva8mhhf42tr4yr7mnl68gj7pgm8gjhfaj54dwmwyhzhlxqupdkag