Can't open Sqlite db create in Python with sqlite command bash

Question

So if I create a db in Python using the sqlite3 package:

import sqlite3
con = sqlite3.connect('test.db')

I can't open the db using the sqlite command line in bash:

sqlite test.db
Unable to open database "test": file is encrypted or is not a database

I can however connect to a db created with the sqlite command line using sqlite3 in Python.

How can I open the Python created dbs in the sqlite command line?

Have you read these posts: about version mismatch stackoverflow.com/questions/1513849/… or about password problem stackoverflow.com/questions/16030601/…? — goose
– goose, Commented May 5, 2014 at 11:39

furas · Accepted Answer · 2020-06-06 16:09:19Z

21

Install sqlite3 and use sqlite3 test.db in bash.

answered May 5, 2014 at 11:51

furas

149k12 gold badges121 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1