database server
A database that runs as its own long-lived program and serves many client programs over network connections.
In more detail
PostgreSQL, MySQL and SQL Server work this way. Clients open connections, send SQL and receive rows, while the server manages concurrency, background work and access control. That allows many applications and machines to share one database, at the cost of running and securing a separate service.
Related terms
- PostgreSQL — A widely used open source relational database server with strict typing, rich data types and extensions.
- embedded database — A database that runs as a library inside the application's own process instead of as a separate server.
- connection — An open session between a program and a database, through which it sends statements and receives results.
- connection pool — A set of already open database connections that a program reuses instead of opening a new one for each request.
Taught in
- Where PostgreSQL Differs From SQLite — PostgreSQL, Indexing & Relational Data Modeling