Hacker News new | ask | show | jobs
by keithnz 2 days ago
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)