This week's book giveaway is in the Web Services forum.
We're giving away four copies of Microservices in Action and have Morgan Bruce & Paulo A. Pereira on-line!
See this thread for details.
Win a copy of Microservices in Action this week in the Web Services forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Ganesh Patekar
  • Frits Walraven
  • Tim Moores
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Stephan van Hulst
  • salvin francis
  • Tim Holloway

What type of database to use?  RSS feed

 
Ranch Hand
Posts: 55
Chrome Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,
I would like to know what type of database is best for a small scale(+-500 users ) cross platform application (Windows , Linux , android ect)?

Thanks in advanced for all the help and advice!
 
Ranch Hand
Posts: 76
C++ Linux Python
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Determining the best database is really subjective.  Here are a couple of good database systems.  If you have a database server being used by remote clients I would consider MySQL/MariaDB.  If the database is local I would consider sqlite.  My only reasoning is that they are well suited for general DB tasks, simple enough to implement, and they are popular enough to get good free help.

I am assuming you are not looking to store binary values.  If you are there are better databases for that, but I don't have experience with any of them.
 
Ray mann
Ranch Hand
Posts: 55
Chrome Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks ! well no binary values at this point of the plan , yeah I was thinking it would be both I would have a database on a server and locally for offline use then when user connects it can commit and "sync"(still gota figure that idea out). This project is still conceptual in the planing phase !
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!