Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What db start with?

 
Ruslan Salimovich
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?
 
Campbell Ritchie
Sheriff
Posts: 51439
87
  • 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.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • 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.
 
K. Holgate
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.
 
Tim Holloway
Saloon Keeper
Posts: 18367
56
Android Eclipse IDE 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic