Need help/advice on backend choice and data model for an IOS app.

Basically for my app I need to implement UI with folder like structure and hence need to store hierarchal data in a database.

see example in attached image. However I dont need to store references to files but rather actual json objects/documents (or references to them?).

So I am looking for somebody to assist me with help/advice on how it could be implemented.

More Requirements below:

1. Folder names should be unique inside its parent folder.

2. Json Object names should be unique inside its parent folder.

3. I should be able to Add, Rename, Move, Copy, Delete folder with its subfolders/documents.

4. IMPORTANT: providing 1,2 are satisfied I should be able to query object data via their names path. For example i want to query/filter all the users whose age are >18, Name = John and [login to view URL] = Bob useing the below paths(if data exists there)

*USERUNIQUEID*/allData/Personal Data/Age

*USERUNIQUEID*/allData/Personal Data/Name


Some of my thoughts regarding db choices/designs:

1) Relational Databases (SQLite): there are some ways to model hierarchal data

[login to view URL]

However not sure if i would be able to easily query the way i want.

2) Firebase - json tree could store deep nested data however no native way of doing complex queries therefore i wold have to write some complex logic on client side (aka multiple requests for each filter condition). Also it downloads the whole json tree for a child...

3) Firestore - i am able to use complex queries providing put all user data as documents into one collection.

So every document would have ParentFolderId field. Problem here is that the path to a document would be made of Firestore generated unique ids (because document titles are only unique under its parentFolder so not possible to use as a document id)

[login to view URL]

4) Couch Db? not sure if this NoSql document store provides any advantage comparing to firestore solution.

[login to view URL]

Ideally if you have implemented something like this in the past and are based in the UK.

Important: I don't need you to develop anything - only advice/coaching on backend design, data model is required.

Skills: Backend Development, iPhone, Mobile App Development, Objective C

See more: mp3 files need help transcribing, need help adding google adsense site, freelance need help wsdl file, open source projects need help, need help text website, need help building resume, need help fixing cre loaded, coldfusion website need help, need web scraper takes search data excel, need brochure describing company structure business model culture, need help finishing work, need help design hair salon, need help mcafee secure vulnerabilities, need help cloning website, someone data entry need help, need help data entry, data entry ios app, okay google i need help preparing a powerpoint presentation or applicable media on the topic of my choice, scrape data from ios app

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #17688654

8 freelancers are bidding on average £215 for this job


How are you? I am an experienced full time(70+ hours per week) mobile developer. Please have a look at my profile: [login to view URL] I assure high quality of your a More

£150 GBP in 3 days
(229 Reviews)

Hello, I have read your project requirements very carefully and would like to share that I have 7+ years of experience in mobile app development. I have completed dozens of mobile apps for various clients. Quality w More

£150 GBP in 3 days
(37 Reviews)

Hi, I have used similar data structures before for complex apps. In my experience, storing data as direct JSON strings is much easier and better than maintaining relationships with database tables. I can definitely hel More

£122 GBP in 5 days
(50 Reviews)

Hi there, I would like to discuss your requirements in more details, would you please come on the chat to discuss? Thanks

£150 GBP in 3 days
(20 Reviews)

Hi I'm full stack professional developer. I have rich development experience and have developed many apps. I already read your proposal and understood your project clearly I will work for you honestly and w More

£500 GBP in 15 days
(3 Reviews)

Hi there, I read your requirements for suggestions regarding your IOS app and I can suggest you the best possible way to make it possible. Also if you would like, I can help you with the development process of it More

£222 GBP in 3 days
(0 Reviews)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I am a Fu More

£150 GBP in 3 days
(0 Reviews)

Hello, We've got the right expertise in application development by Android, iOS, ionic, React Native & We're happy to discuss all the requirements of your project. I’m sure that we can make a great deal together. Ho More

£277 GBP in 10 days
(0 Reviews)