Search Results

Hello. Recently there has been an increase in hacking, data theft, etc. Using databases, we are exposed to unauthorized downloading of data from databases, theft of entire databases, etc. containing sensitive personal data. A simple select will show encrypted data, as well as downloading database f
link: ", Array As String(DBM.EncryptHash("secret@email.com"))) Log(li3)
link: Wonderful stuff. Just to be clear, you can call this once on an existing table you have? Then after that you need to use To add any new data to the

Hi, I've almost finished an app for Android that I would now like to convert to IOS, with B4A I used the SQLCipher library to encrypt the database, there is something similar with B4I to encrypt the database on the IOS version. Does Isql allow you to encrypt a database?
link: https://www.b4x.-library-for-b4i.47453/
link: Mcqueccu OK thank you

Released: 09/07/2019: 1.00 SS_AESEncryption Author: Peter Simpson Version: 1 AESEncryption Fields: InitializationVector As String SecretKey As String Functions: AESDecrypt (DecryptData As String) As String Decrypt AES encoded data to plain string AESEncrypt (EncryptData As String) As String E
link: Actually no Manfred, it stands for SuperStud https://en.wiktionary.org/wiki/superstud :cool:
link: SS = ?? SuperSimpson? SimpsonSpecial? Sorry, could´nt resist ;-)

invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:629) at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:234) at anywheresoftware.b4a.shell.Shell.raiseEvent(S
link: Maybe the Database is not properly encrypted. Some software's do not do it well. I will advice you test it with the DB Brower and do new encryption. T
link: This jdbc driver doesn't support encrypted databases.
link: How can I connect to an encrypted database? Does B4J only connect to a non-encrypted database?

Encrypting a SQL database has its price. One of them is a larger memory footprint. On the one hand, because in addition to the encryption routines, these must also be linked and included in your program. You can determine how much that is by looking at the size of a test project. First with an empt
link: If the size of the APK is a problem, I wonder if you realize that encrypting a database also results in a much larger database length. Another issue i
link: Thanks for your reply. I do understand that encrypting a sqlite has a higher overhead. But our app is only used by our customers, so we know that the

Good idea, but the practice is unmanageable. Encrypting a database is also not without problems. After a lot of searching I found out that if you do that, you come into conflict with, for example, the unencrypted search of a B4X table search field.
link: Well I think.. this point with assets can be a wish to Erel future updates for encrypting like zip with password... good point... For now.. I think
link: Not encrypting... dB... only specific strings that will have the order of parts of blobs

Embedded In memory database DBtemp.Initialize2("org.h2.Driver","jdbc:h2:mem:mydatabase","sa","sa") 3. Connect to remote server (in Potsgres Mode) Dim driver As String = "org.h2.Driver" Dim url As String = "jdbc:h2:tcp://db_host/~/mydatabase;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE" DBdest.Initializ
link: I didn't know this program. He downloaded the H2 driver, but I don't know how to set the ODBC connection to the encrypted database. Ok it worked. You

My thoughts on this: If there is no more air in the database, you can't squeeze any air out... Maybe you can have a look at the encrypted database with a viewer, you have the key (a challenge with this amount of data though). To be honest, I've never looked at a database encrypted with SQLCipher wit
link: Well, everything has it's limitations. When modifiying such large databases (encrypted or not) with a single command (the command to vacuum it), could
link: Strange indeed. Will investigate further. I would be very interested if anybody has managed to vacuum an encrypted file of say 5Gb in a B4A app, usin
link: I tried this on on a much smaller and also unencrypted DB and the vacuum worked fine (file size reduced some 10%). Still connecting with SQLCipher. So

DB Browser for SQLCipher.exe You can create the database with this program and open it from B4J. I also encrypted a database using .NET and can open it using this code. There is a paid program called Navicat that also allows you to open these encrypted databases; it's just a matter of using the cor
link: Hi @mcqueccu. Did you have any luck with the SQLCipher for B4J? I tried your project and it responds that the file is not a sqlite database. Edit - W
link: Download the JDBC from this GitHub, and place it in your Additional folder In your Main Module, use #AdditionalJar to add your jdbc. Add JSQL librar
link: Hi @mcqueccu I used your example for testing And I have to say that there are errors with individual JDBC: java.io.FileNotFoundException: Version fi

Hi, I was able to open your encrypted access database @IndieDev It was from a sample I saw sometime in the forum. Am still searching for the link to send to you. But this is how i did it Add this additional jars #AdditionalJar: commons-lang3-3.0 #AdditionalJar: jackcess-encrypt-2.1.4 #
link: Trying to open a MSACCESS database which is protected with a password. Have added "#AdditionalJar: jackcess-encrypt-3.0.0". Throws errors and cannot
link: Function to Initialize the DB: Sub Database_Init As Boolean Dim Result As Boolean = False DBFile = File.DirData("PKDBServer") & "\" & "us
link: 1. Download UCanAccess: https://www.b4x.com/b4j/files/ucanaccess.zip (Sources: https://jackcessencrypt.sourceforge.io/ and http://ucanaccess.sourcefor

Powered by ColBERT