search

jfo8000 / ScratchJr-Desktop

Open source community port of ScratchJr for Desktop (Mac/Win)
https://jfo8000.github.io/ScratchJr-Desktop/
BSD 3-Clause "New" or "Revised" License
137 stars 80 forks source link

Question: .sjr -> .sqllite ? #48

Open merrickw opened 4 years ago

merrickw commented 4 years ago

Is there any relationship between .sjr files (from android or iphone) and .sqllite files? Is there a way to convert or build the .sqllite file?

Avantimus commented 3 years ago

Same question ...

jfo8000 commented 3 years ago

It has been a really long time since I looked at it. The sqllite file - as it is - would possibly open up in a SQL lite editor. As I recall it was a bit of a relational database mess - bits of the project were everywhere. The SJR file - I would maybe try and rename it to a zip and see if the file contents are all in there. You could potentially work out where to put the assets in the database and then load from there.

Because of the spirit of the MIT license I could only take the source code as was and port to a new platform - I just rewrote (if I recall correctly) the database layer to port to SQL.js instead which is an enscripten version of sql lite.

Hope this helps! JFo

iamthefaker commented 2 years ago

An "import from .sjr file" menu item on the file menu would be a huge help, if anyone has time to do this? (Sorry I don't right now, but I might set this as project for a very bright student at some point if no one does it before then.)