• 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
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Devaka Cooray
Saloon Keepers:
  • Ganesh Patekar
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • salvin francis
Bartenders:
  • Ron McLeod
  • Frits Walraven
  • Pete Letkeman

Which databases should I choose  RSS feed

 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am a student who recently got an offer from a company and I am required to choose 2 databases from

MySQL
SQLite
mongoDB
Oracle
PostgreSQL

I don't know much about databases and my selection was based on java programming language.So I know Java 8 but I am not able to pick 2 databases from them

From my side I did some research and got MySQL and postgreSQL as the 1st and 3rd mostly used databases according to stack overflow survey
Should I go with these 2 databases ?
 
Sheriff
Posts: 12477
206
Android Debian Eclipse IDE IntelliJ IDE Java Linux Mac Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Andy Hunt's Rule #1: Always consider context.

The choice of database depends largely on the context in which you're going to use it. There are many different things that make up the context for use. How many users do you expect will be accessing the data? What kind of data are you dealing? How is the data structured? What kind of operations are you going to perform on the data? What kind of admin capabilities do you have? What are the performance parameters? What skills does the development team that will be programming to this database have? Do they have more experience with any particular database(s)?  And many more...

So, you can't expect to get a good answer to an open-ended question like that if you don't provide more context.
 
Saloon Keeper
Posts: 4859
117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I am required to choose 2 databases


Choose for what purpose? Assuming that you'll be a developer -and not a DBA- some of those are very similar (MySQL, Postgres and SQLServer). If you used one as a developer, you'll be able to use the other ones.

mongoDB is not a SQL DB, so that's a very different beast from a developer perspective.

SQLite is a SQL DB, but frequently used as an embedded DB (for example, on Android) - so the use cases for it are a bit different.
 
Marshal
Posts: 60776
189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved discussion to our databases forum.

Please explain why your new employer wants you to choose two databases programs.
 
Setu Dengre
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
They are taking me as a full stack developer. I know Java programming but they also want me to know some databases,that I will learn from scratch,and I don't know for which context they want me to know and may be depending upon the choice of the databases they will put me in particular team, I am a student and I don't know the working of IT sector, so all I can ask now is which databases is having good scope in future.
 
Tim Moores
Saloon Keeper
Posts: 4859
117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, who knows what the future will hold? Software development is constantly evolving, so you'll need to keep learning whatever you do.

I suggest a general purpose open source SQL DB (either MySQL or Postgres) and a document DB like MongoDB.
 
Campbell Ritchie
Marshal
Posts: 60776
189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If they want you to know databases, I suggest you start by asking them to train you. Consider asking what they would recommend.
Although they are an old‑fashioned paradigm, try a common‑or‑garden SQL relational database. More people use the conventional type of database than the newer‑fangled things. In which case maybe try Oracle or Postgres or MySQL.
 
Bartender
Posts: 1856
81
Android Chrome IntelliJ IDE Java MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As stated the first steps would be deciding if you need a relational database management system system (RDBMS) like MySQL, MS SQL Server or Postgre or if you would need a NoSQL system like MongoDB.
RDBMS have been around for decades and usually does a very good job with structured data.
Often times you will end up using some SQL (Structured Query Language) command for manipulating the data.
NoSQL systems, which actually means Not Only Structured Query Languages, are usually used for unstructured data.
Most NoSQL systems have their own proprietary commands for  manipulating the data which could vary a fair amount between systems.

In today's world we have a lot of both structured and unstructured data, both of which are increasing daily.
A system/site like a WordPress site would probably have a lot more structured data then unstructured data and therefor would probably use a RDBMS.
Project management solutions like Trello would probably use NoSQL to store the much of their data which is probably unstructured.
 
Setu Dengre
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry for late reply and thanks for providing your thoughts. I selected MySQL and MongoDB.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!