O'Reilly logo

MySQL™ and JSP™ Web Applications: Data-Driven Programming Using Tomcat and MySQL by James Turner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building a Database Schema

Now that you're ready to build your schema and populate it with data, it's worth talking about how to manage your database.

In the BFG example, MySQL is the database that was chosen. Accordingly, a database instance, called BFG, was created to use with it. Although you can do schema and database maintenance on the fly during development, it's important to capture all that information into scripts that can be run repeatedly, each time re-creating a perfect beginning state for your database.

WHY USE MYSQL?

When choosing a database for a JSP project, a number of considerations come into play. MySQL certainly has one overwhelming characteristic that places it at the head of the class: It's free.

If price were the only ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required