Why is connecting directly to databases not recommended?

Should I use API or direct database access?

Originally Answered: Which one is better for internal use - an API or direct database access? An API is almost always better. You'll get significant benefits in terms of reusability of the data and portability of your code, as well as avoiding coupling between your app and the database.

What is direct connection to database?

Connecting directly from a client application to a geodatabase means communication between the database and client takes place by way of a direct-connect driver, not through an ArcSDE service.

When should you not use a database?

When Not to Use a DBMSHigh initial investment in hardware, software, and training.The generality that a DBMS provides for defining and processing data.Overhead for providing security, concurrency control, recovery, and integrity functions.Simple, well-defined database applications that are not expected to change at all.

What is the need for connecting to database?

A database connection is a facility in computer science that allows client software to talk to database server software, whether on the same machine or not. A connection is required to send commands and receive answers, usually in the form of a result set. Connections are a key concept in data-centric programming.