Jump to content

The location of sqllite database ?

Recommended Posts

good morning every one ^^ how is every one doing ))
1- i have fmx android app that s create sqllite db on create ,what's  the location of db on the phone and is it const location ? (does not change for every other phones)
2- what's the proper way to copy it from that location to sd card (backup) ?
thanks and take care ☺️

Share this post

Link to post

For iOS: StartUp\Documents\

For Android: .\assets\internal

Use those folders if you deploy an existing DB. This is the Project Options section.


At runtime you can use something like this

  FDConnection.Params.Values['ColumnMetadataSupported'] := 'False' ;
  FDConnection.Params.Values['Database'] := TPath.Combine(TPath.GetDocumentsPath, 'mydb.sqlite') ;

Then do whatever you need to create/open/update, etc...


  • Like 1

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now