Comments (5)
I want to learn whether this project is compatible with the official SEE?
Unfortunately, the answer is no. Official SEE is a commercial product, to which I don't have access. And even if I had access to SEE, its license would prohibit to use it in an open-source project.
Algorithm: AES-128-CCM dbKey: Known
However, the encryption algorithm AES-128-CCM is publicly available and is patent-free. If you could provide a small sample database encrypted with AES-128-CCM
, I could give it a try.
from wxsqlite3.
Thanks for your reply! There is a simple example.
File Here
Algorithm: AES-128-CCM
dbKey: "Egroj38D9fUNkkgB" (16-bits ByteArray -> 128 bits)
Content: Some simple UTF-8 text files
from wxsqlite3.
Thanks for your reply! There is a simple example. File Here Algorithm: AES-128-CCM dbKey: "Egroj38D9fUNkkgB" (16-bits ByteArray -> 128 bits) Content: Some simple UTF-8 text files
By the way, seemly there is also a strange way to get access to its content without offcial SEE source. "sqlite3-see-aes128-ccm.c" is integrated in the old-fashioned "Flash", the "flash.data.SQLConnection" API.
But as a result of my poor experience on ActionScript, I can only connect to the database according to some official examples and perform simple reads. without being able to decrypt it to raw database.
flash.data.SQLConnection.openAsync(dbFile, air.SQLMode.CREATE, null, false, 1024, encryptionKey);
https://help.adobe.com/en_US/air/html/dev/WS8AFC5E35-DC79-4082-9AD4-DE1A2B41DAAF.html
from wxsqlite3.
Thanks for your reply! There is a simple example. File Here Algorithm: AES-128-CCM dbKey: "Egroj38D9fUNkkgB" (16-bits ByteArray -> 128 bits) Content: Some simple UTF-8 text files
Thanks for the sample file. I'll take a look at it. However, I can't promise anything. In fact, it not only depends on the - known - encryption algorithm, but also on several other - unknown - factors (key derivation, initialization, ...).
By the way, seemly there is also a strange way to get access to its content without offcial SEE source. "sqlite3-see-aes128-ccm.c" is integrated in the old-fashioned "Flash", the "flash.data.SQLConnection" API.
Obviously the API binaries are linked with SEE, and therefore you can access encrypted databases via the API (as long as you know the encryption key).
But as a result of my poor experience on ActionScript, I can only connect to the database according to some official examples and perform simple reads. without being able to decrypt it to raw database.
If you can execute arbitrary SQL statements via the API (as seems to be the case), it is of course possible to find out the structure of the database schema, and to retrieve all database content based on that knowledge.
If extracting the content from such an encrypted database file is all you actually need, I would recommend to follow the outlined procedure (determine database schema, retrieve data based on the schema).
from wxsqlite3.
I'm going to convert the issue into a discussion, because wxSQLite3 currently doesn't support accessing SEE encrypted databases - and, actually, it is highly unlikely that it ever will.
The "flash.data.SQLConnection" API will allow you to access encrypted databases for which you are authorized. If that API doesn't suit your needs, you still have the option to purchase SEE.
from wxsqlite3.
Related Issues (20)
- Crash on just _some_ client PCs related to sqlite HOT 2
- -ldl in AM_LDFLAGS breaks building for systems that don't know/use that library HOT 4
- Visual Studio 2022 says wxprec.h is missing HOT 4
- Please consider updating autotool scripts HOT 6
- compile error on gcc 5.4 HOT 4
- wxSQLite3Database::SetJournalMode always returns DELETE HOT 1
- Build on MacOS and Linux? HOT 2
- cipherName is corrupted in wxSQLite3Cipher::SetCipher() HOT 2
- "file is not a database" issue HOT 6
- Linker error when building wxSqlite3-4.9.6 with MinGW-64 or TDM-64 under Windows 64-bit HOT 1
- wxSQLite3CipherSQLCipher : InitializeFromGlobalDefault crash HOT 3
- There is question that cost much time when I drop a table with larger data; HOT 2
- x64 MinGW build cannot find setup.h (4.5.1) HOT 3
- wxSQLite3Transaction HOT 2
- Rekey issue HOT 2
- wx/setup.h: No such file or directory HOT 11
- Memory leak in wxSQLite3Database::GetTable() HOT 2
- How to access wxsqlite3 encrypted database in Android。there is already a key HOT 2
- Android is strongly requested HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from wxsqlite3.