Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

A general question but still need a suggestion on JDBC. Important to know for me!!!

 
Pranit Sonawane
Ranch Hand
Posts: 172
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi am using windows 7 64 bit OS. I wanted to know to store a database, should i use MS-Access. Is it secured? Does that crash? or please help me with the database management system..!! Many Thanks!!
 
Wendy Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would never use access, but that was because 10 years ago, it was rubbish, it may have improved.
I would use mySQL, some people on here would recommend postgreSQL.
 
Rob Spoor
Sheriff
Pie
Posts: 20495
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It depends. Access is OK if it's not shared by multiple people and you already have a license for it. If you don't I wouldn't bother buying it, it's too expensive. Access is also notorious for its poor support for concurrent access.
If you need concurrent access or don't have a license, there are still many choices. If money is an issue (like when you need it at home) then go for one of the free choices; MySQL and PostgreSQL are recommended most often. If it's for a company and you have budget for it you can still go for one of the free choices, but you can also choose Oracle or MS SQL Server.
 
Wendy Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rob Spoor wrote:It depends. Access is OK if it's not shared by multiple people and you already have a license for it. If you don't I wouldn't bother buying it, it's too expensive. Access is also notorious for its poor support for concurrent access.
If you need concurrent access or don't have a license, there are still many choices. If money is an issue (like when you need it at home) then go for one of the free choices; MySQL and PostgreSQL are recommended most often. If it's for a company and you have budget for it you can still go for one of the free choices, but you can also choose Oracle or MS SQL Server.


so my main complaint still hasn't improved, couldn't handle 10 people at once
 
Matthew Brown
Bartender
Posts: 4565
8
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wendy Gibbons wrote:so my main complaint still hasn't improved, couldn't handle 10 people at once

To be fair, it's never been designed for that. And if you want a proper database, Microsoft will be more than happy to sell one to you .
 
chris webster
Bartender
Posts: 2407
32
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you're looking at a scalable open source choice, I would go for PostgreSQL, which IMHO is a more robust alternative than MySQL. Plus I like elephants.

If you want to try a commercial vendor, you can start with the free Oracle Express Edition (Oracle XE), which has a restricted licence but can be used commercially as well as for personal use:

Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.


Oracle XE is fully compatible with enterprise Oracle, so you can migrate your applications easily to scale up in future. Oracle XE includes most of the core RDBMS tools you will find on any Oracle edition, including PL/SQL and a load of other stuff. I often use Oracle XE to prototype applications that will eventually be implemented on an enterprise Oracle platform, for example.

Combine Oracle XE with the free SQLDeveloper tool, which includes data modelling options and can also be integrated with version control tools like Subversion, and you have a pretty good basis for database application development even before you start building your Java stack. Oracle XE also includes the free Oracle Application Express (APEX) tool for building data-driven web applications really easily without Java, but I'm guessing nobody around here would talk to you if you used that!

There is also a free edition of Microsoft's SQL Server, which is probably easy to integrate with Visual Studio and .NET etc, but I don't know anything about it. Maybe I'll try it out...

All of the above options are serious relational databases that will give you access to many of the core features available on any enterprise RDBMS, so any work you do on these will teach you useful skills for working with any database.

I wouldn't use Microsoft Access.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic