This week's book giveaway is in the JavaScript forum.
We're giving away four copies of Svelte and Sapper in Action and have Mark Volkmann on-line!
See this thread for details.
Win a copy of Svelte and Sapper in Action this week in the JavaScript 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
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

What db start with?

 
Greenhorn
Posts: 25
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm studying Java and also planning to start studying a data base. Since there is a variety of databases, which one do you recommend to start with?
 
Marshal
Posts: 70292
282
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I shall move you to our databases forum.

Try going through the Java™ Tutorials and in the first instance use the same database that they use.
 
author & internet detective
Posts: 40200
816
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ruslan,
While the built in database (Derby) is fine for the basics, I recommend you move to mySql or postgres after that. That way you have the experience and understanding of installing a database.
 
Greenhorn
Posts: 3
Oracle Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Depends on your project... SQLite works great for getting a database up and running quickly without a hassle of an install. If you're planning on getting into enterprise-level stuff, Oracle has a free version of their database you can run on your PC as well as Microsoft SQL Server.
 
Saloon Keeper
Posts: 22498
151
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here are some of the DBMS's that can be installed on a desktop computer at no cost:

1. Apache Derby
2. Oracle MySQL/MariaDB (the open-source fork of MySQL)
3. PostgreSQL
4. Oracle Community Edition
5. IBM DB2 Community Edition
6. Microsoft SQL Server (free edition)
7. SQLite (used internally in Linux and Android OS)

Those are the most popular, but there are others as well. MariaDB and PostgreSQL are provided in standard package form in almost all Linux OS distros in addition to being available directly from their respective development websites for other platforms.

Apache Derby is now included as part of the Java JDK, which is a well-kept secret, since I myself only found out about this recently. I've been using a downloaded independent copy of it for years.

SQLite is the SQL DBMS built into Android, but it's also popular as a default or internal database on a lot of Linux apps. My Gourmet Recipe Manager app uses SQLite. So don't be surprised to find it was pre-installed on your Linux computer when it was first set up.

The Community Edition versions of the commercial DBMS's these days are fairly complete implementations of their commercial counterparts. The main difference is the number of CPU cores and/or amount of RAM that they'll be permitted to use and of course, you get less in the way of direct vendor support. Then again, direct vendor support these days is usually pretty feeble regardless of product. Used to be IBM would keep an engineer on-site in many cases. Then came the telephone waits. Finally things deteriorated to message boards staffed by junior personnel reading scripts and possessing questionable English skills. I'm picking on IBM since Service was their primary selling point up until about 1990, but their competitors are no better. Often the open-source products have better message boards these days with the added bonus that if you get frustrated enough, you can always dig through the source code (and I have, alas, more than once).
 
Ruslan Salimovich
Greenhorn
Posts: 25
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks!
 
Ruslan Salimovich
Greenhorn
Posts: 25
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it ok if I install MySQL and start studying SQL? Or having installed MySQL I need to study some other lunguage for database?
 
Live ordinary life in an extraordinary way. Details embedded in this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic