I am new to LiveCode and mobile development in general... This may be common or it may not be possible or suggested in LiveCode. If LiveCode is not a good choice for my current project based on this need then hopefully someone can let me know so I don't spend a lot of time spinning my wheels.
Anyway I have a table consisting of 3 fields and 5 million records. 1 need to encrypt 1 of the fields for every record. Here is an example record:
SERIES_ID|CODE|CUTS
---------------------------
1|S123A|1342443513 (<-- this 3rd column needs to be encrypted)
The way my app needs to work is like this:
1. User selects a category from a picklist or ALL (this will be used to filter the query)
2. User enters a code to search for. Example S123A.
3. Application searches 5 million record table and returns all the SERIES_ID values containing that code and the corresponding decrypted cut value.
Is this possible using LiveCode and the 3rd party tools available? If so, which database and tool is recommended?
Thanks in advance for the input. And if I'm in the wrong forum I apologize. Please direct me to the correct one.
Ted
Mobile database encryption
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Mobile database encryption
i think you have 2 needs here :
-1 to encrypt permanently the third column of your database
-2 to create an app that will access the database, and perform other operations
For 1 :
Using a livecode stack, with proper script , you can of course perform an ecryption job on the third column, and then update the DB
It depends of your needs, but MySQL could do the job for the DB.
For 2 :
Here, it's a simple app to perform a SQL query, and then to decrypt the third column of each lines retrieved.
But you have to decide :
-wich DB system you'll use : do you have a server ? Is it mono or multi user ? If no server and only 1 user (you) then SQLlite would be enough.
-which encryption scheme you'll use (simple or private/public key ?)
-1 to encrypt permanently the third column of your database
-2 to create an app that will access the database, and perform other operations
For 1 :
Using a livecode stack, with proper script , you can of course perform an ecryption job on the third column, and then update the DB
It depends of your needs, but MySQL could do the job for the DB.
For 2 :
Here, it's a simple app to perform a SQL query, and then to decrypt the third column of each lines retrieved.
But you have to decide :
-wich DB system you'll use : do you have a server ? Is it mono or multi user ? If no server and only 1 user (you) then SQLlite would be enough.
-which encryption scheme you'll use (simple or private/public key ?)