Two Laptop Bag*
The moose likes Servlets and the fly likes MySQL and Servlets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "MySQL and Servlets" Watch "MySQL and Servlets" New topic
Author

MySQL and Servlets

Micky Pat
Greenhorn

Joined: May 03, 2006
Posts: 18
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

Joined: Jan 10, 2002
Posts: 61103
    
  66

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 ]

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Micky Pat
Greenhorn

Joined: May 03, 2006
Posts: 18
Hi Bear,

so I can start building my webapp without being afraid of future scalability....
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61103
    
  66

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

Joined: Jan 10, 2002
Posts: 61103
    
  66

This article may be of interest with regards to web app structure.
Micky Pat
Greenhorn

Joined: May 03, 2006
Posts: 18
Ok, I will investigate on that.
Thank you very much

Michele
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL and Servlets