I am trying to import my data from a MySQL database on Amazon into appery.io. The problem I am having is that when I import each table via csv format, appery is using it's own primary key instead of the one I have in my mysql database.
I have over 100 tables and 500k records. How will relationships be maintained?????
Hello,
Could you show us one of your DB table structure and some data fields.
Sure, how?
Do you want a sql dump? Would that help? CSV export of some of the tables? I'd rather not attach here.
You can send CSV file example to a href="mailto:support@appery.io" rel="nofollow"support@appery.io/a.
I just sent you an email. Thanks!
Got it. We'll check it, but it can take some time.
Hi Jose,
[quote:]How will relationships be maintained2[/quote]There is no way, we use noSQL database.
[quote:]appery is using it's own primary key[/quote]Do you mean "_id"? Yes, this is how Appery.io works.
I'd recommend you not to import MySQL database to our noSQL backend. Working with it will be pretty difficult. You'd better use MySQL database on a third-party service.
Katya,
When you say third party service, do you mean I should continue using Amazon RDS and somehow connect my appery.io app to it?
How so?
Thanks,
Jose
Jose,
Amazon or any other. This service must support REST API.
Thanks Katya,
I noticed the tools for creating and managing databases are rather crude. You can basically create collections and corresponding documents and that's it.
Does appery.io have or plan to have some kind of model designer?
Take a look at Wakanda's model designer and you will get an idea of what I'm talking about.
