Importing SQLite database?

Glitch Help
1

I want to import an existing SQLite database. However, when I try to drag it into Glitch, it just gets uploaded to the assets. And when I try to use the template from my GitHub repo, suddenly the tables no longer exist, despite it being fine when I download the file locally. Any way to import an existing SQLite file?

2

Hey there,
I tried to reproduce this issue, however, I was not able to.
You can perhaps upload the file from assets folder into a different folder and access it from there:

  1. Go to the assets folder in your project and select the image you want to upload locally to your Glitch project. Click on the ‘Copy URL’ button. This will copy an image URL like https://cdn.glitch.com/f6254aa9-8051-48db-bbc1-5e7766f748c5%2Fw6.jpg?1531238960521 to your clipboard. How to access ‘Assets’ drawer
  2. Go to the ‘Console’ in Glitch, and if you don’t already have an assets folder, type mkdir assets and hit enter. (How to access Console on Glitch editor
  3. type cd assets and hit enter to move into the assets folder.
  4. type wget and then paste the image URL, you copied previously into the console, so you see something like wget https://cdn.glitch.com/f6254aa9-8051-48db-bbc1-5e7766f748c5%2Fw6.jpg?1531238960521 and hit enter. That’ll import that image to your assets folder. Note that it’ll be imported with the name f6254aa9-8051-48db-bbc1-5e7766f748c5%2Fw6.jpg?1531238960521 . To make it easier to deal with you’ll want to rename it. To do so, type mv /app/assets/f6254aa9-8051-48db-bbc1-5e7766f748c5%2Fw6.jpg?1531238960521 /app/assets/w6.jpg and hit enter. You can confirm the asset renamed correctly by typing ls -al and you’ll see a list of files, one of which should be called w6.jpg .
  5. Repeat steps 1 and 4 for each image you want to upload. Be sure to change the name of the file to the relevant one in step 4.

The path you’ll then use is: __dirname + '/assets/w6.jpg'

3

The assets folder is not a folder it is apart of the CDN.

4

This is still happening exactly as you describe. How do you import an existing SQLite database into Glitch?

5

You wget it into your container using your project’s terminal (button at the bottom in the editor) from somewhere that you’ve already (temporarily) made web-accessible. And then you make sure to keep it small enough so your project doesn’t get suspended for taking up too much space =D

6

Thank you.
Can this be scripted?

7

Probably, but that’s up to you: you’re responsible for making sure whatever code you host behaves itself.