@Pete-S said in How to Rename a Column in SQLite Database:
There used to be a lot of databases like SQLite. Often called database engines. dBase was probably one of the first.
Later Microsoft Jet engine (aka Microsoft Access) became popular when Visual Basic ruled the world.
Basically it's a one user database. You can have more than one user but it's done by multiple users accessing the same database file.
Or by having an application on top that accessing the file and shares it out. That thing can be called a "database management system" or any application, really.
All databases use database engines. MySQL, for example, isn't a database. It's a database management system. It uses one or more database engines to talk to the files on disk. MyISAM and InnoDB are two database engine options for the MySQL platform.
At the end of the day, all databases work like SQlite. You can easily build your own database management system that uses SQlite as the engine and it could work just like MySQL or Oracle or SQL Server. Those are all single users to a file, under the hood. They just have the "multi-access" management built into an extra layer, instead of letting an application handle it.
But for most things, you only access a database from a single app anyway, so that extra layer is often unnecessary as it is redundant. Just adds overhead.
