• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

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

 
Ranch Hand
Posts: 172
Netbeans IDE MySQL Database Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!!
 
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 22862
132
Eclipse IDE Spring TypeScript Quarkus Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 L Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 4568
9
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 .
 
Bartender
Posts: 2407
36
Scala Python Oracle Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic