What database to use for an App

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 :)
BojikAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Walter RitzelSenior Software EngineerCommented:
Take a look on these documents from official SQLite website:
http://www.sqlite.org/about.html
http://www.sqlite.org/limits.htm

I think this should help you to understand if SQLite is a good option for your application.

Anyway, if you are intending to use a central database hosted on the cloud, you'll need to build an API, which renders the decision on which database to use almost pointless: it should be better use whatever is the database provided by your cloud host, as your application will only know the API interface.
BojikAuthor Commented:
So based on this http://www.sqlite.org/whentouse.html
I will need to use a client\Server database.
Is SQL my only option?  Or my best option?
Walter RitzelSenior Software EngineerCommented:
No, it is not your only option: you could use MySQLas well, or PostgreSQL. That will depend on what will be available on your host. I think that MS SQL Server is better than the others that I have cited. The one I consider the best database is Oracle, but is very difficult to have it available in a host for apps.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

BojikAuthor Commented:
Host has SQL and SQLite only.
I have no experience with Oracle, is it worth taking a look at?  I would not be against moving this site and database to a host with Oracle if it was better suited for what I am doing than SQL.
Walter RitzelSenior Software EngineerCommented:
Oracle is the best relational database, but MS SQL Server is also really great. Both would serve for your purposes. SQLite would also be a good choice, but it is usually used when the database will stay on the device (smartphone, arduino, etc...).

So, your app will be a WEB app, hosted on cloud or it will be a mobile app for smartphones?
You have planned already how to deal with the architecture? Are you going to use MVC, will create a WEB API, etc...?

Bottom line: if you are between SQL Server and SQLite, go with SQL Server.
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm a SQL Server specialist but there are a lot of good solutions using MySQL. The main reason is because is free, I guess.
SQL Server Express is a free edition of MSSQL but have a lot of limitations (1CPU, 10GB database size, few available features, ...) so my suggestion is you to check MySQL if price is an issue.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BojikAuthor Commented:
Ok, SQL server it is, thx
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.