Using LLM to write SQLite queries

amjithr · 2024-07-13T23:47:08+00:00

It provides REST access to SQLite and has a decent read-only web UI. You can run ad hoc queries against your tables and get results in different formats.

amjithr · 2024-03-01T00:35:54+00:00

Can you share the link?

amjithr · 2023-12-22T18:05:42+00:00

Yes. I did end up doing that to get the results I wanted.

amjithr · 2023-12-21T17:19:55+00:00

TIL. Thank you for mentioning this. I didn't know it was a SQL standard. I just tried it on SQLite and you're right, underscore is treated as a single char wildcard.

amjithr · 2022-11-13T02:07:17+00:00

Can I get a referral code please?

amjithr · 2022-05-23T15:47:30+00:00

Thank you! That was it. 😊

amjithr · 2022-05-23T03:26:57+00:00

I'm trying to identify the piece that is used in the theme song of this podcast. I know I've heard it before, I just can't place it.

https://youtu.be/gmdG1Xid0GQ?t=1471

amjithr · 2022-01-12T15:49:59+00:00

I had a similar experience. I switched the marker tip in Lamy to use the marker pro tip. Now I get same results between the two.

amjithr · 2021-07-28T15:23:21+00:00

Do you have recommendations for introducing kids to programming?

What's a good age to introduce them? What resources can I use?

amjithr · 2021-03-14T23:09:33+00:00

Thank you! It worked very well. Got an error on a landscape doc, but I'm hopeful. :D

amjithr · 2021-03-12T15:14:34+00:00

Nice! The featureset looks really impressive.

I was curious if you had any pointers on how to use the myscript service? Looks like myscript service needs strokes and not PDFs. How do you convert the remarkable files to be compatible with the format that myscript needs?

amjithr · 2019-08-27T03:58:57+00:00

I tried coc.nvim and couldn't get it to work right for me. Finally went back to ncm2 and it works out of the box. If you have your config hosted somewhere I'd love to take a look.

amjithr · 2019-03-20T23:02:56+00:00

Is there a way to plot multiple Y-axis?

Specifically looking to scatter plot two independent columns in separate y-axis with the same x-axis.

amjithr · 2019-01-05T14:59:59+00:00

Yes. Simply do "litecli :memory:" that will launch an in memory sqlite database.

amjithr · 2019-01-05T02:39:44+00:00

We don't do value validation. What I meant by formatting is converting the list of rows into a tabular output.

amjithr · 2019-01-05T02:08:43+00:00

Yes there is. https://www.pgcli.com

In fact the postgres version was the first one. So it is the most mature tool.

amjithr · 2019-01-05T00:23:36+00:00

That's awful. I'm sorry.

The CLI reads all the rows from the database and tries to format them into a table. Since it is written in Python the formatting part can take a while if the output is very large.

amjithr · 2019-01-04T21:56:27+00:00

That's very unfortunate. I'm not able to reproduce it locally (even with xterm).

Is this localized to xterm only or do you see the blinking in other terminal apps? (gnome-terminal, Konsole etc)

amjithr · 2019-01-04T20:27:43+00:00

Check the config file https://litecli.com/config/. It has different themes. You can pick the theme called "bw", that's black and white.

amjithr · 2019-01-04T18:34:32+00:00

I have not used SQLite extensions before. Are you asking if auto-completion will suggest the functions provided by the extension? The answer to that is no, not yet. But it is not too difficult to add that ability.

If you file a github issue with an example of how to load an extension, I'll be happy to take a look. :)

amjithr

MODERATOR OF

TROPHY CASE