✅ SQLite -> PostgreSQL (moving data) | Directus | Page 1

pseudo blaze May 31, 2023, 6:18 PM

#

Hi,

I can apply the snapshot created with the server cli from SQLite to a new PostgreSQL database but I find myself in the position of needing to also copy over all the data from SQLite.

I tried dumping all the tables from SQLite and using psql -f to populate the new pg db and also using pgloader, but the data type differences make it tricky.

Could anyone suggest a tool to take table dumps from SQLite and insert them into tables in Postgres created with directus’ snapshot apply? I have 3-4K rows.

Thanks for any help,
Gav

void pantherBOT May 31, 2023, 6:18 PM

#

Thanks for posting! This is a community powered server, so you may or may not get an answer based on available help and expertise. To increase your chances of somebody being able to help you, please help us help you making sure you:

Adding an explanation of exactly what you're trying to achieve.
Adding any and all related code or previous attempts.
Describing the exact issue or error you are facing.
Posting any screenshots if applicable.
Reading through https://stackoverflow.com/help/how-to-ask.

When you're done with this thread, please close it. Thanks! ✨

(If you have a support agreement and need help, please contact the core team via email.)

grizzled goblet May 31, 2023, 6:23 PM

#

Oof 🤦‍♂️ I went through this myself once. Tried several different tools I found on StackOverflow threads to try and get it done "easily".

#

Ended up writing a script that used the Directus API instead.

pseudo blaze May 31, 2023, 6:33 PM

#

I was hoping for a npx directus snapshot —with-data flag 😭. If you have anything left from that script, I’d love to take a look.

grizzled goblet May 31, 2023, 7:00 PM

#

you might have a look at this script that @sinful gate wrote
https://github.com/alexvdvalk/cms-schema-seeder.git

GitHub

GitHub - alexvdvalk/cms-schema-seeder

Contribute to alexvdvalk/cms-schema-seeder development by creating an account on GitHub.

#

not sure how it reacts with a large set of data but should put you on the right track

grizzled goblet May 31, 2023, 7:01 PM

#

pseudo blaze I was hoping for a `npx directus snapshot —with-data` flag 😭. If you have anyth...

one day 🤞

sinful gate May 31, 2023, 7:02 PM

#

How much data do you have

pseudo blaze May 31, 2023, 7:27 PM

#

The db is only 3mb and that includes all the directus data, it’s mainly contacts data, 3-4K rows I think.

void pantherBOT May 31, 2023, 7:45 PM

#

✅ SQLite -> PostgreSQL (moving data)

void pantherBOT May 31, 2023, 7:45 PM

#

void panther Thanks for posting! This is a community powered server, so you may or may not ge...

This post is now closed. If you want or need to continue this topic, just send another message and it will be unarchived.

pseudo blaze May 31, 2023, 7:45 PM

#

Closed by mistake

#

I will be taking a look @sinful gate

#✅ SQLite -> PostgreSQL (moving data)