You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is there perhaps a good way to migrate from sqlite to postgres? I used sqlite for a bit and it works well, though now I'm wondering if I should migrate. Thanks.
The text was updated successfully, but these errors were encountered:
It might be as simple as sqlite3 /path/to/database.db .dump | psql databasename, since it doesn't look like any fancy datatypes are used. Though if sqlite3 is working fine, you don't really need to migrate since there isn't much data or any psql-specific features (unless you want all data in one place, ie. for backups.)
It looks like it's so that the same sql schema can be used with both postgres and sqlite while making use of each one's featureset. The data itself should be portable, you should https://tryitands.ee/
Is there perhaps a good way to migrate from sqlite to postgres? I used sqlite for a bit and it works well, though now I'm wondering if I should migrate. Thanks.
The text was updated successfully, but these errors were encountered: