[MDBF-81] %connect to local DB, non-local DB, Cloud database Created: 2020-05-25  Updated: 2022-02-01  Due: 2020-06-10

Status: Closed
Project: MariaDB Foundation Development
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Kaj Arnö Assignee: Robert Bindar
Resolution: Unresolved Votes: 0
Labels: jupyter
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
PartOf
is part of MDBF-55 Development of Jupyter maria kernel, ... Closed

 Description   

%connect to local DB, non-local DB, Cloud database

  • with helpful UI guidance
  • two options for role models, MongoDB and Teradata.
  • MongoDB uses YAML file with connection parameters; friendly to millennial developers
  • Teradata uses %magic commands - which one should we pick?


 Comments   
Comment by Vicențiu Ciorbaru [ 2020-06-01 ]

I believe multiple variants would be good. One that would be good to have is the canonical jdbc canonical url, like:

jdbc:mysql://localhost:3306/sonoo

Comment by Kaj Arnö [ 2020-06-03 ]

Right! Can Robert specify the exact proposed syntax in this MDBF, as a next step?

Comment by Robert Bindar [ 2020-06-25 ]

I would go only with a json/yaml file for specifying the connection info along with other options for this release.
The argument is that if you add `%connect`, it's nice if you go all the way through and do what Teradata did (and what mysql-test does), i.e. ability to create new connections, switch between them, add cell magic that executes the code for a particular cell using the specified connection in the cell magic, and so on. But even if we add only `%connect`, there are still further questions that need to be answered, what happens if the user doesn't specify a `%connect` statement, what happens if the user runs some code in some cells then, in the 3rd cell for instance, there is a `%connect` magic. So I'd say better leave it as a feature for after we release the mvk, what do cvicentiu and kaj think?

Comment by Robert Bindar [ 2021-02-08 ]

Moved to GitHub issues: https://github.com/MariaDB/mariadb_kernel/issues/10

Generated at Thu Feb 08 03:35:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.