password protect or encrypt sqlite db file in python

Question

I am generating a sqlitedb file with below code

import sqlite3
conn = sqlite3.connect('../sqlitedb/sample_db.db')

Is there any way I can password protect this file or some kind of security in python or generally in windows so nobody can access it.

Use SQLCipher to perform encryption and decryption with a password from your python code. — Armaggheddon
– Armaggheddon, Commented Aug 26, 2021 at 11:08
Is it answer for your question? stackoverflow.com/questions/50381616/… — mascai
– mascai, Commented Aug 26, 2021 at 11:08
Pointless. Your computer if you are admin (if its a corporate environment you are not), then you can set the permissions which is simple, but then you hardly need to protect. If its on someone else's computer they can just read the python password from your file. — jwal
– jwal, Commented Aug 26, 2021 at 11:09
@Armaggheddon could you exactly show me as its new for me to use this. — shee
– shee, Commented Aug 26, 2021 at 11:10
@jwal I should use it in someone else's system so I am protecting the python file as well so the code cannot be read or accessed — shee
– shee, Commented Aug 26, 2021 at 11:11

Sabil · Accepted Answer · 2021-08-26 11:31:20Z

2

This Solution Will Work on Linux OS Only

Install sqlcipher:

sudo apt-get install sqlcipher

Install sqlcipher package:

pip install pysqlcipher3

Sample Code:

from pysqlcipher3 import dbapi2 as sqlite
conn = sqlite.connect('test.db')
c = conn.cursor()
c.execute("PRAGMA key='password'")
c.execute("PRAGMA cipher_compatibility = 3")
c.execute('''create table stocks (date text, trans text, symbol text, qty real, price real)''')
c.execute("""insert into stocks values ('2006-01-05','BUY','RHAT',100,35.14)""")
conn.commit()
c.close()

For Windows You Can Follow Below Links:

edited Aug 26, 2021 at 11:31

answered Aug 26, 2021 at 11:16

Sabil

4,5391 gold badge9 silver badges21 bronze badges

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

3 Comments

shee Over a year ago

not able to use the sudo command on windows

Armaggheddon Over a year ago

See at the end of this page. Windows binaries are not provided so you have to compile your own or buy a prebuilt one. Is just easier to use a linux based system.

Sabil Over a year ago

@shee You follow attached links

Collectives™ on Stack Overflow

password protect or encrypt sqlite db file in python

1 Answer 1

This Solution Will Work on Linux OS Only

For Windows You Can Follow Below Links:

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

This Solution Will Work on Linux OS Only

For Windows You Can Follow Below Links:

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related