undefined | Better HN

0 pointsjasonpbecker2y ago0 comments

A vote here for a SQL cell. I want folks to use Livebook and Explorer more, but a very easy win for data folks who are not familiar with Ecto and are mostly writing complex select statements would be a sql code block that can easily reference a connection.

That would let people who are getting into Elixir for data work run a query, get an Explorer.DataFrame, and interact further that way.

0 comments

hugobarauna2y ago

Good feedback, thanks.

Livebook already has a SQL Smart cell (https://livebook.dev/integrations/sql). It doesn't integrate with Explorer yet, but it's already possible to reference a database connection, run a SQL query, and visualize the results in a table.

Here's a video showing how to do that https://www.youtube.com/watch?v=F98OWdigCjY

j / k navigate · click thread line to collapse

0 pointsjasonpbecker2y ago0 comments

That would let people who are getting into Elixir for data work run a query, get an Explorer.DataFrame, and interact further that way.

0 comments

hugobarauna2y ago

Good feedback, thanks.

Here's a video showing how to do that https://www.youtube.com/watch?v=F98OWdigCjY

j / k navigate · click thread line to collapse