Mega Search
23.2 Million


Sign Up

Make a donation  
SQLite Encryption & in-memory Database  
News Group: embarcadero.public.delphi.database.firedac

I am just wondering if an in-memory database created using a connection that has encryption enabled, will the in-memory database be encrypted or does that only apply to on-file databases?

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 19-Jan-2015, at 1:09 PM EST
From: Chris Nillissen
 
Re: SQLite Encryption & in-memory Database  
News Group: embarcadero.public.delphi.database.firedac
> I am just wondering if an in-memory database created using a connection that has encryption enabled, will the in-memory database be encrypted or does that only apply to on-file databases?

In-memory database will be encrypted too. FireDAC SQLite driver
encryption works not on the file level, but on the pager level. This
means every page reading / writing leads to encryption calls.

-- 
With best regards,
Dmitry Arefiev / FireDAC Architect

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 19-Jan-2015, at 9:11 PM EST
From: Dmitry Arefiev