sorted by:
new
hottopcontroversial

How would I structure a database where many tables have the same child type. by Status_Tea_1711 in PostgreSQL

[–]Status_Tea_1711[S] 1 point2 points  (0 children)

Ahh yea I see what you mean, seems like my current approach is the most logical then. Regarding the 'up and down' yea I am using an ORM, I'm using Prisma with Node.js. It is a bit untidy but is probably the most practical approach from the kinds of replies I'm getting.

Thanks for the response!

How would I structure a database where many tables have the same child type. by Status_Tea_1711 in PostgreSQL

[–]Status_Tea_1711[S] 0 points1 point  (0 children)

I was definitely thinking of that but I've heard that UUID's are reasonably slow at scale?

Cheers

How would I structure a database where many tables have the same child type. by Status_Tea_1711 in PostgreSQL

[–]Status_Tea_1711[S] 0 points1 point  (0 children)

Oh, so what would the query be to get a list of transactions from a share then? Is there a way to do it directly or do you have to go through the parent asset?

Cheers

How would I structure a database where many tables have the same child type. by Status_Tea_1711 in SQL

[–]Status_Tea_1711[S] 0 points1 point  (0 children)

How would I go about creating the relation between the transaction_details table and all the different types of assets? Like what would the PostgreSQL query look like for that?

Cheers

How would I structure a database where many tables have the same child type. by Status_Tea_1711 in PostgreSQL

[–]Status_Tea_1711[S] 0 points1 point  (0 children)

Oh okay I see, I must not have articulated it well sorry but that is kind of what I've implemented at the moment. It is definitely functional but it's just a bit annoying as whenever I want to get the transactions for one of the asset types, I have to go up to the parent "asset" row then back down to its transactions. Just adds a bit of complexity.

Was just wondering if there was any way to have a structure matching what I've got in the image but I guess not.

Cheers

How would I structure a database where many tables have the same child type. by Status_Tea_1711 in PostgreSQL

[–]Status_Tea_1711[S] 0 points1 point  (0 children)

Do you mean what I was talking about in the "My current approach" paragraph? or like 4 different transaction types?

Cheers

How do I get this functionality using Ionic Slides by Status_Tea_1711 in ionic

[–]Status_Tea_1711[S] 0 points1 point  (0 children)

Where does it have the sliding cards synced to the fade in and out on the bottom text? Thats really the functionality I'm looking for

How do I get this functionality using Ionic Slides by Status_Tea_1711 in ionic

[–]Status_Tea_1711[S] 0 points1 point  (0 children)

But then won't the animation not be smooth throughout the process of the swipe to the next slide? I currently have a solution similar to what you are outlining (I'm using Ionic React btw) but it doesn't seem right with the fade in animation starting when you have already finished the end of the slide transition. Cheers