The SQLite-Encryption is a Java based utility which allows you to convert an SQLite Database into an encrypted .sqlite file. Three different encryption algorithms are supported:
shift cipher
substitution cipher
transposition cipher
These encryption algorithms are less secure compared to AES, but are more efficient in terms of storage and complexity. The AES based encryption has performance issues during bulk DML-based operation. It also increases the size of the database by 70%. On the contrary, these basic ciphers provides efficiency at the cost of reduced security.
It is already included the POM.xml of the project. Run Maven build to download it.
-
[Download snapshot of this repository][SQLite-Encryption], unzip and open it. use IntelliJ IDEA to open the project
-
Configuration
You can configure the following parameter in the App.java file
String DATABASE_NAME = "test.db" //path to the sqlite db
String CONFIG_FILE_NAME = "table_col_map.json" //path to the json file which has table column mapping
The table_col_map.json contains the tables, their primary key and the columns to be encrypted. You need to update it as per your db schema.
[{
"tableName": "Customer",
"primaryKey": "CustomerId",
"toEncrypt": [
"FirstName",
"LastName",
"Company"
]},
...
]run using IntelliJ IDEA
OR
- Run in terminal
javac src/co.techelix/*.java -d classes
java -cp classes App.java
You can report the bugs at the issue tracker
OR
You can message me if you can't get it to work. In fact, you should message me anyway.
This program was developed to secure an SQLite database with multi-lingual data. These basic ciphers were selected to provide weak encryption without impacting performance. There could be other ciphers that could provide stronger encryption without degrading performance. If you know one, don't be shy to make a Pull request :)
For making contribution:
- Fork it
- Clone it
git clone https://github.com/wahabjawed/SQLite-Encryption.git
cd SQLiteEncrypt
use IntelliJ IDEA to open the project
Copyright 2020 Abdul Wahab
Licensed under the MIT License, (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
https://opensource.org/licenses/MIT
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.