I am working on a app that will need to access and edit some kind of database.
My first thought is core data and SQLite but I am concerned about the limits of SQLite. From there I only know SQL, are there other good options? FileMaker? How is SQL accessed by an IOS app, web services? Security concerns?
Database hosting? I can run SQL and SQLite on my servers but due to crappy internet I would need to host the live database elsewhere.
General user info:
1 to 5000+ users
All users could be accessing the same data at the same time (some edit, others just view).
Users are not all from the same company. So some of the tables will be common to all users and other tables will be accessible by one group of users only (users within each company).
Simplified version - Table #1 is a global contacts table, table #2 is a list of clients, table #3 is a list of computer assists within each company.
So, table #1 is a global access table accessible by everyone with the app and table #2 is global access but with a filter on who can access what and table #3 is unique for each company and only accessibly by that company.
I want to be sure to build the app for growth, and I can see this app being used by a lot of users. So I want to be sure I select the correct database up front. I will also need to convert the app to be used on smart devices other than IOS and have a PC and a MAC interface.
Kind of a open ended question, but I need to start somewhere :)