DB Migration *to* SQLite?

[cyphar]

I installed Nextcloud several years ago, but made the "mistake" of picking Postgres as a database (it has weird start-up times and I'm basically the only user of my instance so it's just overkill). I would much prefer to be able to use SQLite, but it looks like occ db:convert-type only supports converting from SQLite and doesn't support converting to it.

Is this something that you'd be interested in taking a patch for?

[nextcloud-bot]

GitMate.io thinks possibly related issues are #5155 (Migrations), #3536 (DB Migration from SQLite to PGSQL fails), #2494 (Sqlite support), #6773 (Migration overview issues), and #5099 (Failed to convert DB from sqlite to MariaDB).

[madmax2012]

Hey cyphar,
I had to do this in a different context some time back. Maybe just create a dump of your database, convert it by hand and import it as described over here?
https://manuelvanrijn.nl/blog/2012/01/18/convert-postgresql-to-sqlite/
Cheers, Max

[cyphar]

That does work as a hack, and is what I was considering doing, but given that Nextcloud actually has a db:change-type command (which converts between database types by doing the conversion themselves) it seems that this is a better place to fix it.

[szaimen]

As this sounds like a nice feature, the requests for this are quite low. Currently there are no plans to implement such a feature. Thus I will close this ticket for now. This does not mean we don't want this feature, but it is simply not on our roadmap for the near future. If somebody wants to implement this feature nevertheless we are happy to assist and help out.If you wish to have this feature implemented by the Nextcloud GmbH there is the option for consulting work on top of your Nextcloud Enterprise subscription to get your features implemented.

[kuflierl]

Hey cyphar, I had to do this in a different context some time back. Maybe just create a dump of your database, convert it by hand and import it as described over here? https://manuelvanrijn.nl/blog/2012/01/18/convert-postgresql-to-sqlite/ Cheers, Max

I also need to migrate over to sqlite due to severe memory constraints. While migrating i can't seem to find where i need to put the sqlite file. I know it's somewhere in the datadirectory folder due to https://docs.nextcloud.com/server/latest/admin_manual/configuration_server/config_sample_php_parameters.html#default-config-php-examples but could you point me to where exactly?

[mikrofyr]

I also want to move away from postgres. Too many problems and little value in my use case.

[reeno]

I used this script to convert from MySQL to SQLite: https://github.com/dumblob/mysql2sqlite
Worked perfectly