studio Export/Copy as JSON feature

Hi! Should there be an issue to track "copy as json" implementation?

I miss this, but I know there are bunch of things coming first. Thanks!

Nov 29 '19 20:11 outerlook

Isn't this already doing what you were looking for?

Nov 29 '19 21:11 schickling

Yes it is here, but I receive this on browser console:

My prisma2 version is [email protected]... sorry if I'm missing something

Nov 29 '19 22:11 outerlook

Ouh. I see.

Nov 30 '19 02:11 schickling

Hello! I was looking into this right now. Implementing is trivial, but there's one question that needs answering: How much do we want to copy? For a small dataset with a bunch of relations (I had 5 records with ~15K relations in total), the payload ended up being 11Mb in size. While theoretically there isn't a limit, Firefox & Chrome wouldn't let me copy something that huge to the clipboard. Obviously, even if you have 5000 records with a couple of relations each, this quickly gets out of control.

Maybe we want a strategy to strip parts of records that are less useful. @outerlook What parts do you generally see yourself using?

Dec 02 '19 10:12 sdnts

I don't know if it is a good workflow, but I'm thinking of using for this:

In my schema there is a "Place", that can have many "Amenity"`s, that are divided in "CategoryOfAmenity". So, place is a thing that will be truly dynamic, I definitely won't need to store this amount of data in JSON. But amenities will be kind of static, as the costumer will just pick from this list what amenities his place may have.

But since I'm in phase of developing this new application, there are many times I need to start a fresh database, and then I need to seed my data. So, the easiest way is store a JSON of the last data (as it really won't change often), I may tweak things directly in studio if needed, then I can easily update my seed files with "Copy as Json".

I would need at least one depth more in a relation, so I can get which category each amenity belongs to. There isn't much data

There are other things I will be seeding like my country's cities and states. Which is Brazil, with around 5500 cities. So, could there be a "Download as Json" for this bigger results, if results pass a size, for example?

Does this clarify already?

Dec 02 '19 12:12 outerlook

@madebysid I'd suggest showing some kind of confirmation modal in case you're copying more than x amount of data.

Dec 02 '19 12:12 schickling

Moving this to Post-Beta. Absolutely great to have, but not essential for MVP.

Mar 02 '20 10:03 matthewmueller

Hi, any progress on this issue?

Jun 19 '22 23:06 Mozartted

An export feature is on the roadmap. It's one of the next bigger features to come, but we don't have a timeline currently for when it'll be available.