0

I am completely new to SQL and I am trying to connect to a database with sqlite3. This database has a Browser-based access, but I would like to connect directly with a Python script. I can see that there is a wealth of material on SQL and SQL with Python, but I am struggling to understand what to do. I have the url of the database Browser-based access.

Which keywords shall I specify in the connect command in sqlite3?

Also, I was told that there are different flavours of SQL and one should use the version that is used on the target database, is this the case?

EDIT:

I have found out that SQLite cannot do this and one need to install MySQL for python.

Improve this question
2
  • 1
    Python's sqlite docs are here. You should be able to connect with conn = sqlite3.connect(url) I think - see the docs for the connect function. Commented Nov 26, 2020 at 10:54
  • stackoverflow.com/questions/22837920/… might help Commented Nov 26, 2020 at 10:58
Related questions
9
Connect to a remote sqlite3 database
0
Python Django sqlite connection
0
Using Python with sqlite3
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.