big data nested api call | Django | Page 1

glad plank Jul 12, 2023, 10:15 AM

#

Hi how are you guys i have nested big data database
And i need to build an api for this data and their nested data and view them on one page using Vue js i wanna know about the best way to do this
#1031641814186328064

undone basin Jul 12, 2023, 10:17 AM

#

You'll need to explain what your use case is in more detail and what you need from us.

glad plank Jul 12, 2023, 11:47 AM

#

What i need is
I have about 4 models
And they are all connected with foreign key
So model 1
We have grandfather
Model 2 father
Model 3 son
Model 4 grandson
I want i way to expose all of them on one vue js page
Is it better to have them nested in one big api call
Or separate

undone basin Jul 12, 2023, 12:15 PM

#

It depends on your ux needs and the size of the data.

glad plank Jul 12, 2023, 12:16 PM

#

Data is too big

#

First model has less than than second model and so on
Cascade

#

What is your advice

undone basin Jul 12, 2023, 12:23 PM

#

I don't have enough details to help. My generic advice is to get something up and working first, then iterate.

#

If the total number of objects is less than 1000, then you could probably do it in one API request. If it's more than 1000, you should break it up. Anywhere in the 100-1000 range, it's hard to say.

glad plank Jul 12, 2023, 12:35 PM

#

No it will exceed 30000

#

And even more

#

So breaking it is the way to go

#

But pardon me
Why 1000 exactly

undone basin Jul 12, 2023, 1:33 PM

#

Experience? I have no justification. It could be 500, it could be 3000.

#

It's all going to depend on various aspects of your environment, users, and application.

glad plank Jul 12, 2023, 2:52 PM

#

Any recommendation of the best way to view this to clients
I mean from design perspective
of things to click then another things came up and so on

undone basin Jul 12, 2023, 3:03 PM

#

You need to include more details.

glad plank Jul 12, 2023, 3:38 PM

#

How i could visualize a nested data

undone basin Jul 12, 2023, 4:05 PM

#

Try searching for UI examples. Tailwind has some components that may inspire you https://tailwindcomponents.com/components/dashboard
Bootstrap has example pages as well: https://getbootstrap.com/docs/5.2/examples/

Tailwind CSS Dashboard - Free and Premium Components Collection.

Visit our Dashboard collection that you can add to your Tailwind UI project to analyze your data.

Examples

Quickly get a project started with any of our examples ranging from using parts of the framework to custom components and layouts.

glad plank Jul 13, 2023, 2:57 PM

#

Thank you very much
But i have an update
I have my data in hireachy and the bad news is
This is my hireachy in normal
1 -> 2 -> 3 -> 4
But also it could be like this
1 -> 2 -> 4
That means i need to make one big endpoint

#

Or you have another idea

undone basin Jul 13, 2023, 3:27 PM

#

You can make anything work. That's the nice thing about software.

#

I don't have a suggestion though.

glad plank Jul 13, 2023, 3:44 PM

#

Yeah it will work on say in that
But efficiency?

#big data nested api call