Hacker News Reader

I wrote a tui sql client to replace DataGrip (which is really slow). https://github.com/keithn/sql It's quite customized to what I wanted, I haven't really checked it works with other things.... only thing is, I don't really use it much anymore, I just get claude to do all my querying.

Most of the tools I write now are bridges to various SaaS products that have APIs but no CLIs.

View on HN

how is autocomplete implemented ?

autocomplete isn't "exact", so it does have in its suggestions things that don't exactly always make sense, but it does list things by what is contextually relevant. It has a basic understanding of sql syntax such it will suggest potential keywords next, it introspects things like tablenames so they are available in spots where a tablename would be relevant, and if it has tables it will introspect them to get fieldname, and any named things like x as y will also become suggestions within the context of the query you are working on. This results in mostly correct suggestions. However it generally always has the suggestion you want, it works really well with field names / table names, which mainly what I wanted, and very basic with sql syntax (which I normally don't need any help with other than relevant keyword completion)

Reply on news.ycombinator.com