# Guides

> The concepts of API Maker explained one by one - schema and data, your code and its tools, security and access, settings, performance and operations with Index Maker, the connection strings of every database and the deprecated UI Maker.

Source: https://docs.apimaker.dev/v1/docs/guides/index.html

The [APIs](https://docs.apimaker.dev/v1/docs/apis-all/overview.html) tab tells what each API does. These guides tell how the pieces around them work, in the order you meet them.

- [Schema and data](https://docs.apimaker.dev/v1/docs/schema/schema.html) : The schema of a table, auto increments, optimistic concurrency control, multi-tenant databases and migration scripts.
- [Your code](https://docs.apimaker.dev/v1/docs/pre-defined-terms/global-object-g.html) : The global object g, process initializers, test cases, developer tools, Git, developer accounts, code search and browsers with Playwright or Puppeteer.
- [Security and access](https://docs.apimaker.dev/v1/docs/secrets/secrets.html) : Secrets, groups, API users, role based permissions, the security report, single sign-on and every auth provider.
- [Settings](https://docs.apimaker.dev/v1/docs/settings/databaseSettings.html) : Caching, access type and auth providers per database, table and API ; sandbox settings ; the configuration of API Maker.
- [Performance and operations](https://docs.apimaker.dev/v1/docs/features/automatic-caching.html) : Caching, Index Maker and automatic indexes, logs, dashboards, internationalization, deploying a new version of API Maker.
- [Connection strings](https://docs.apimaker.dev/v1/docs/Database-connection-string/mongodb-connection-strings.html) : The connection string of MongoDB, MySQL, MariaDB, PostgreSQL, Oracle and SQL Server, with SSL and cloud examples.
- [UI Maker](https://docs.apimaker.dev/v1/extensions/ui_maker/introduction.html) : Grids and forms generated from your tables, configured in JSON. Kept for the projects which use it. (deprecated)

## Read in this order

1. [Table schema](https://docs.apimaker.dev/v1/docs/schema/schema.html) : how a table is described and what the schema APIs do with it.
2. [Global object g](https://docs.apimaker.dev/v1/docs/pre-defined-terms/global-object-g.html) : the one object your code gets.
3. [Secrets](https://docs.apimaker.dev/v1/docs/secrets/secrets.html), then [API group permission](https://docs.apimaker.dev/v1/docs/apis-security/api-group-permission.html) and [Handle role based permissions](https://docs.apimaker.dev/v1/docs/authorization/handle-role-based-permissions.html) : who may do what.
4. [Settings](https://docs.apimaker.dev/v1/docs/settings/databaseSettings.html) : caching, access type and auth providers at every level.
5. [Automatic caching](https://docs.apimaker.dev/v1/docs/features/automatic-caching.html), [Index Maker](https://docs.apimaker.dev/v1/extensions/index_maker/introduction.html), [Log profile](https://docs.apimaker.dev/v1/docs/logs/log-profile.html) and the dashboards : running it.
6. [Git integration](https://docs.apimaker.dev/v1/docs/Git/git.html) and [Deploy API Maker](https://docs.apimaker.dev/v1/docs/features/deploy-api-maker.html) : shipping it.