Quote from luishp on August 8, 2021, 8:35 am

@andy-marshman as far as I know SQLite databases can't be password protected, but you can restrict access to the data by using different user profiles. neoPhp includes user management with unlimited user levels. The database video tutorial includes a basic user autentication sample.

Quote from Andy Marshman on August 8, 2021, 8:59 am

Hi @luishp,

An SQLite database can be password protected as per https://www.sqlite.org/see/doc/trunk/www/readme.wiki

It all depends on the version of SQLite being used and if SEE was added.

So my question really should have neen if an SEE enabled version of SQLite is used can neophp accept the password in the config file to open it?

Regards

Andy

 

 

 

 

Quote from luishp on August 8, 2021, 9:11 am

@andy-marshman that's not exactly "password protected" but "content encrypted". Currently there is not an encryption/ decryption facility in neoPhp but it's probaly possible to add it by editing neofunctions.php. It would be necessary to encrypt the content before writing it to the database and decrypt it before sending it to VisualNEO Web app.

Anyway, why do you need this? As SQLite databases are usually hosted in a server, you just need to protect the database file from being downloaded.

Regards.

Quote from Andy Marshman on August 8, 2021, 4:32 pm

@luishp as this will be used on a shared host you can never be sure how secure the hosting is. The are always admins that reside over the entire hosting platform. You would have no way of knowing if they took a copy of your SQLite DB.

 

Regards

Andy

 

Quote from luishp on August 9, 2021, 5:32 pm

@andy-marshman as you must host the logic to unencrypt your database in your hosting service, even an encrypted database can be easily read by an admin.

Regards.

Quote from Andy Marshman on August 9, 2021, 5:35 pm

@luishp you are correct I was not thinking straight.

I think I will encrypt the contents before sending it.

Regards

Andy