ihp icon indicating copy to clipboard operation
ihp copied to clipboard

Make It Easier To Query Database Inside ghci

Open s0kil opened this issue 4 years ago • 3 comments

Currently, we have two options, run make psql and manually write SQL queries. Or print database results inside a controller action. We should have model context ready when running make ghci so it could be as simple as query @User |> fetch

s0kil avatar Feb 22 '21 18:02 s0kil

One can write any SQL in the tables view in the IDE. I use this a lot for minor update and delete statements. We should extend this to be a more general SQL query window within the IDE.

fegu avatar Feb 22 '21 18:02 fegu

^ I use this a lot too. It would be great to store the history as well, I find myself retyping the same query a lot when testing. Maybe this could be a window in the future "REPL" tab!

zacwood9 avatar Feb 22 '21 19:02 zacwood9

Instead of investing a lot of time into making it easier to write SQL queries, we should focus on improving the QueryBuilder and developer experience around it.

s0kil avatar Feb 22 '21 19:02 s0kil