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

MySQL and Servlets

 
Micky Pat
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello World,

I am new to this website, even if I spent some time reading the posts... VERY interesting.
Straight to point: I would like to develop a website with some capabilities of storing and retrieving data from a database. Is MySQL a good/easy option? Can I expect significant worsening in performance if the database is too big or if I start too many users?

Any other idea? Sorry for the fuzzyness of the question, I am still browsing the Servlet/JSP world....
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64631
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MySQL is a popular choice for a web app DB, as is PostgreSQL. Naturally, there are issues around large databases and heavy bandwidth, but those are issues that DBs are built to deal with.
[ May 04, 2006: Message edited by: Bear Bibeault ]
 
Micky Pat
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Bear,

so I can start building my webapp without being afraid of future scalability....
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64631
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sure. Be sure to use best practices such as connection pooling, as well as architecting your web app using an n-tier model, segregating all DB access behind a model facade (in other words, NO db calls in the servelts and JSPs).
[ May 04, 2006: Message edited by: Bear Bibeault ]
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64631
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This article may be of interest with regards to web app structure.
 
Micky Pat
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok, I will investigate on that.
Thank you very much

Michele
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic