• Post Reply Bookmark Topic Watch Topic
  • New Topic

Alternative to Database  RSS feed

 
Naresh Bafna
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I have no database installed in my system as office. I am undergoing some J2EE training which needs me to read and write from a database.

Is it possible to use a text file or an excel sheet as a replacement for the regular database?

Will I be able to do everything that can be done using a normal Database?

Thanks
 
Maneesh Godbole
Bartender
Posts: 11445
18
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In theory, yes, but you will have to write all the logic yourself. Why re-invent the wheel?

Search for Derby. It is an open source java DB. I think you get it with the 1.6 JDK installer (might be in 1.5 too, am not sure)
 
Rob Spoor
Sheriff
Posts: 21133
87
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HSQLDB or SQLite may be a better solution, as both can use a single file to store the database. SQLite's Java driver is enough to use it; the SQLite executable is not needed.
 
Naresh Bafna
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I work on my clients network and do not have permission to install anything without approval. Hence , I was looking for an alternative
 
Campbell Ritchie
Marshal
Posts: 56529
172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can download several open-source full-powered databases, eg MySQL, PostgreSQL. You need a trip to the Java Tutorials where you get a nice simple introduction to databases.
 
Joe Ess
Bartender
Posts: 9439
12
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maneesh Godbole wrote:
Search for Derby. It is an open source java DB. I think you get it with the 1.6 JDK installer (might be in 1.5 too, am not sure)


I second Apache Derby AKA JavaDB. It's is a good choice for your purposes because it can be run in-process with a Java application and does not require a separate install.
 
Naresh Bafna
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you everyone for the suggestions.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!