Setting up and managing an Odoo installation will require a basic understanding of the components that make up Odoo. Every business system has a set of technologies and underlying software platforms that are required for the system to function. Fortunately, unless you plan to customize Odoo, you only need to understand the very basics of the Odoo architecture to complete a successful installation.
Getting to know the Odoo architecture
Introducing the PostgreSQL database
Like most ERP systems, Odoo has specific database requirements: in this case, PostgreSQL. PostgreSQL is an open source, cross-platform Object Relational Database Management System (ORDMS). While not popular on the scale of Microsoft SQL Server or MySQL, PostgreSQL is an enterprise-class database server with many advanced features. In fact, PostgreSQL stacks up very well against far more expensive databases such as Microsoft SQL Server and Oracle Database.
PostgreSQL runs on every major OS. For most Odoo installations, Ubuntu is the OS of choice. However, PostgreSQL will also run quite well under other versions of Linux, Microsoft Windows, and even macOS X.
You can learn more about PostgreSQL at http://www.postgresql.org/.
Writing code with Python
The primary programming language of Odoo is Python. Like the other technologies underlying Odoo, the Python language is open source and runs on all of the major contemporary OS. It is an extremely popular programming language, which makes it very easy to find resources to help you to get started.
Starting in Odoo 11, Odoo began using Python 3.5 instead of Python 2.7.
You can learn more about the Python programming language at http://python.org/.
Following the Model-View-Controller design
Odoo is built upon a Model-View-Controller (MVC) architecture. One of the primary goals of this architecture is to separate the visual display of the information from the business rules and management of the underlying data. For example, if you need to change the way data is organized in the model, it is desirable not to have to make dramatic changes to how you view the data. This is true for maintaining flexibility in viewing data. Today, it is common to have many different client applications sharing the same underlying data.
Designing models
The model is essentially the data that makes up your Odoo installation, which is stored in the PostgreSQL database. Odoo is unique in that database structures are typically defined by the Odoo modules at the time they are installed. The Odoo framework takes the model definitions and automatically creates the necessary table structures inside of the PostgreSQL database. Furthermore, a web interface in Odoo allows administrators to easily extend the Odoo data model in a variety of ways without having to modify the Odoo source code.
Rendering views
Each view in Odoo is defined in XML documents. The Odoo framework is responsible for rendering these view files in a web browser. Alternative views can be built to render Odoo functionality upon other platforms such as mobile devices.
Authoring controllers
The controller component of the architecture is where the business logic and workflow rules of the Odoo application are applied. The controller components in Odoo are written in Python code and stored as objects in Odoo modules.