Page History

...

When developing database applications in a team development environment, considerations must be made on the development database environment. Servoy Developer allows a developer to connect to the database they are developing against. This database can be a local database to the development machine, or it could be a shared database on a the database server.

Reasons

...

to Use

...

a Local Database

• Distributed developers - Developers may be in various locations and a shared database may not be conducive to security, maintenance, etc.
• Offline development - Developer may not have consistent connections to the database server.
• Platform preferences - Developers may have different database platforms or may purposely need to use a different platform for various reasons.
• Development isolation - If a single developer is working on a new features that may change the database in a way that will affect other developers adversely.

Reasons

...

to Use

...

a Shared Database

• Test data - It is easier to provide test data for all developers and to use the same test data if the database is shared. Also, if test data is updated regularly from a production server, it would be easier to provide changes to development with a shared database.
• Outside database administration - if a non Servoy developer is responsible for the database structure during development, they do not even need to use Servoy to create the database structure when sharing the database. Changes will be picked up when Servoy Developer starts.
• Maintenance - easier to maintain, tune, and optimize a single database server than many.
• Security Policies - may require data not leave the office via laptops, etc.

...