Migrating from SQLite to PostgreSQL

[qstorey]

Hi,

I have been running firefly-iii for a year now and I am super happy with it. I started out with a simple setup and opted for SQLite but now I'm looking to move to PostgreSQL for better performance.

I tried looking through the docs and existing discussions but couldn't find any hits. Are there any guides or tools for migrating firefly-iii from SQLite to PostgreSQL?

[JC5]

There are no instructions for Firefly III specifically, but there may be generic guides out there?

[qstorey]

I can have a look at generic migration tools for SQLite to PostgreSQL but I wanted to make sure first that the ORM or database layer in firefly-iii would cope with me migrating and changing database technology.

I don't want to lose any data or go into an unsupported mode of operating firefly-iii.

[JC5]

Ah yes. Both are supported, so a migration should not give you any trouble.