Page 1 of 1

How to create Relational Database?

Posted: Tue Oct 29, 2013 5:14 am
by Troy Sorensen

How to create database of orders (user, date, total, payment, etc) with one-to-many relationship with database of OrderDetails (products, prices, quantities). Would this be two collections within same database?


How to create Relational Database?

Posted: Tue Oct 29, 2013 7:16 am
by Serhii Kulibaba

Hi Troy,

Appery.io uses MongoDB that is not a relational database.
In your case it's better to create 2 collections in the same database, as you asked


How to create Relational Database?

Posted: Wed Oct 22, 2014 8:59 pm
by greg7178824

I see that you guys have released RESTExpress. Is this able to link multiple tables with primary and foreign keys?


How to create Relational Database?

Posted: Wed Oct 22, 2014 10:37 pm
by Illya Stepanov

Hi Troy,

This should be possible with RESTxpress with multiple tables.
But not I'm not sure what do you mean by: "primary and foreign keys"?

By the way here is our video about connecting RESTxpress in Appery.io.


How to create Relational Database?

Posted: Thu Oct 23, 2014 7:26 pm
by greg7178824

Its Greg, but no problem

Thanks for the link however it did not address my concern

The basics of relational databases are to create a relationship between 2 tables with the one having a primary key and the corresponding table a foreign key. So like if I have a Customer table (customerId(PK), Name, age, orderID (FK)) and Orders table (OrderId(PK), item, number). Can I link the 2 tables so that when adding/editing/deleting records?

Thanks


How to create Relational Database?

Posted: Tue Oct 28, 2014 12:35 pm
by Maryna Brodina

Hello!

Please use links from one collection to another http://devcenter.appery.io/documentat...


How to create Relational Database?

Posted: Tue Oct 28, 2014 7:39 pm
by greg7178824

Thank you...

Pretty confusing though. Is there a video which explains it more clearly possibly?


How to create Relational Database?

Posted: Wed Oct 29, 2014 9:40 pm
by Evgene Karachevtsev

Hello Greg,

Unfortunately we don't have such video. Please read the whole doc http://devcenter.appery.io/documentat...
there are different examples of working with Pointers.