I have data in sqlite, mongodb and json formats, I want to upload them to my appwrite server and use them. What should I do?
it's a dictionary and i want to use it in my project
Using any of these types will suffice.
JSON format should be great π You can use createDocument
endpoint. Document is like row in SQL world. Make sure to create a database and collection (like a table) first.
I also highly recommend setting up attributes (like columns) for every key you have in the JSON. doing that will let you query your data really quick and easy in future.
First you setup a NodeJS server with API key (https://appwrite.io/docs/getting-started-for-server)
Or python, java, or any other server language you like Then you use create document method: https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesCreateDocument You do that for each item in your JSON export
very thanks
Recommended threads
- Edit ID of an existing collection
Hi there. Is it possible to edit an ID of an existing collection? Right now it looks impossible from AppWrite cloud at least.
- Seed db
hello there... is this correct way to seed appwrite
- Query Appwrite
Hello, I have a question regarding Queries in Appwrite. If I have a string "YYYY-MM", how can I query the $createdAt column to match this filter?