Stack Overflow
Stack Overflow

Questions tagged [pysqlcipher]

pysqlcipher is an interface to the SQLite 3.x embedded relational database engine. It is almost fully compliant with the Python database API version 2.0. At the same time, it also exposes the unique features of SQLCipher.

21 questions
18
votes
7 answers

"ModuleNotFoundError: No module named 'pysqlcipher3'" error while using Python 3.7 on windows 10

I am trying to decrypt one database file using Python 3.7. To decrypt it, I have to use pysqlcipher3 version for python 3.7. To install it, I have tried by using both commands: pip3 install pysqlcipher3 and pip install pysqlcipher3 and both the…
sak
  • 1,230
  • 18
  • 37
8
votes
3 answers

Issue in installing pysqlcipher3

So even though pip install pysqlcipher3 worked returned Successfully installed pysqlcipher3, it did not. From my research, it seems that its a common issue for Windows user trying to install Sqlcipher. Attempt #1 First, I try to download the…
Programer Beginner
  • 1,377
  • 6
  • 21
  • 47
4
votes
1 answer

Install pysqlcipher3 windows

I need to install pysqlcipher on my windows computer but when I do: pip install pysqlcipher I have: Collecting pysqlcipher3 Using cached…
Elouan Jeannot
  • 61
  • 1
  • 8
4
votes
0 answers

Accessing an encrypted SQLite3 database in Python (I have the Key)

I apologize if its redundant but I couldn't seem to find answer anywhere. I set up a password(encryption key) for my database using DB browser for SQLite3. It uses sqlcipher. Now I cannot access it. I'm not able to provide password\key. Here's my…
Matee Ullah Malik
  • 41
  • 3
3
votes
1 answer

Problem Creating One File exe with pyinstaller and pysqlcipher

I'm trying to create a one file .exe to run on any windows machine but I've hit a problem with pysqlcipher. I've gone back to some basic code that just creates a simple database with a key, on my dev machine all works fine whether I use the python…
Andrew Smith
  • 117
  • 9
3
votes
0 answers

Encrypt sqlite table of a Python Tkinter App - pysqlcipher? How is it secure?

I have made a tkinter desktop application and I have a table named auth with a single row which contains sensitive API credentials. My thought is to encrypt this table using pysqlcipher (link) or equivalent. According to the documentation, you have…
Jarad
  • 17,409
  • 19
  • 95
  • 154
3
votes
1 answer

Unable to open pysqlcipher-encrypted dictionary in command-line sqlcipher tool

I am able to create an encrypted database using pysqlcipher, and open it with pysqlcipher, but somehow I cannot open the same database using the sqlcipher command0line tool installed on Mac OS X when installing sqlcipher from source. For…
Herman Schaaf
  • 46,821
  • 21
  • 100
  • 139
2
votes
0 answers

How to encrypt a database using Python and sqlite?

I've got a web app which using Flask, python3, sqlite and sqlalchemy but before I deploy I want to encrypt the contents of the database. I've googled and read on here that pysqlcipher is the route to go (happy to choose another option if this is…
Johnny John Boy
  • 3,009
  • 5
  • 26
  • 50
2
votes
1 answer

'sqlite3.h': No such file or directory

I am attempting to install the pysqlite module for Python 2.7 on my Windows 10 computer. I issued the following command: pip install pysqlite The installation ran as usual until it hit an…
xaresys
  • 31
  • 1
  • 3
  • 7
2
votes
1 answer

How to build SQL Cipher Python Binding for Windows

I'm having trouble building a python binding for SQL cipher on my Windows machine. I have already sucessfully built the python binding for Macintosh. I would like to use my python script on both Mac and PC. I’m new to python and don’t fully…
user5544191
  • 51
  • 1
  • 6
1
vote
0 answers

Error while connecting to sqlite. Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied

I am trying to make a connection to my (pysqlcipher) encrypted sqlite database but I am failing because PRAGMA key input is incorrect. I have my correct password 'test' in a separate .env file. Even though everything should be correct I get the…
JeffA
  • 11
  • 1
1
vote
0 answers

I get an Import Error: partially initialised module with SQLCipher

I get the following error, when I try to use SQLCipher. I'm following a tutorial, which can be found here: https://charlesleifer.com/blog/encrypted-sqlite-databases-with-python-and-sqlcipher/ I copied the first 2 lines which are: >>> from…
user12426459
1
vote
1 answer

Python aiosqlite override Connection with pysqlcipher3

I saw an example of peewee where pysqlcipher was used as the connector for managing a database file rather than the sqlite module. That's great and there's even an async version of peewee but I don't need (Or want) to use peewee's object model. In…
Paragon512
  • 143
  • 8
1
vote
0 answers

How to compile sqlcipher for windows 10 64/32 bit

I have installed VS 2017 and I am trying to build the sqlcipher command (as in Ubuntu 18) for my Windows 10 x64. but I get the below error: ..\Makefile.msc(2547) : fatal error U1052: file '..\sqlite\ext\lsm1\Makefile.msc' not found I tried to do so…
Mike IT Expert
  • 329
  • 1
  • 3
  • 13
1
vote
1 answer

How to get Pysqlcipher to detect openssl during installation

I am trying to Install pysqlcipher to enable me use sqlcipher function in python. While installing pysqlcipher I got an error saying Fatal error: OpenSSL could not be detected! I then tried to install openssl C:\Python27\Scripts>pip install…
e.kenny67
  • 11
  • 5
1
2