marimo
Log in

Get help from the marimo community

Updated 3 weeks ago

DB Connection SQL Cell not connected to other SQL Cells not linked in dataflow

Bug
llucharo
·
As you can see in the picture attached from my notebook data flow the cell where I create my DB connection is not linked to the SQL cell below it. This is to be expected because these two cells don't share variables but at the same is wrong because these cells depend on each other for execution. I don't know what a good solution for this is at the moment.

I think I suggested in another post to have a DB connection tab on the left side menu, this wouldn't solve this particular issue but might be beneficial. @Myles Scolnick
M
l
13 comments
MMyles Scolnick
this does seem like a bug
does the full ATTACH looks something like ATTACH 'dbname...' as db?
llucharo
It does yes, I actually saw in a different notebook that the db objects gets returned under the hood, I’ll dig some more later
llucharo
What are your thoughts on having a db connection section in the data sources menu?
MMyles Scolnick
Yea happy to add something. What are you thinking exactly? Viewing active connection? Or a gui for creating connections?
llucharo
What do you mean by “Viewing activity connects”?
MMyles Scolnick
Sorry on the phone, “viewing active connections”
llucharo
I’m thinking of more of a GUI I guess, in functionality it would replace the ATTACH cell and also show status, and yeah show active connections
llucharo
And also I would tidy up all the tables that are shown when attaching a db, currently you get lots of:
  • db.schema1.a
  • db.schema1.b
  • db.schema2.a
Etc, I’d make those collapsible
llucharo
I actually think this could be a nice first issue for me to look at if you’re open to it, perhaps two issues: nicer presentation of remote data sources and db connection mini gui
llucharo
I might need more help on the 2nd but we’ll see
MMyles Scolnick
Yea we would really appreciate the contribution!

And we can pair on it to if needed.

First one sounds good to me. For the second one, the tricky part is making sure the notebook still contains the connection information, so when shared, they can connect to the db as well.

Maybe the GUI at first just creates the cell for you (similar to how the snippets panel creates cells for you). And then can be improved?
llucharo
That sounds good to me! I'll let you know if I encounter issues, how do you usually go on about pairing?
MMyles Scolnick
We could pair live if you wanted or just pass PRs back and forth or just push to the same branch
Add a reply
Sign up and join the conversation on Discord