Using Magic with PostgreSQL
In this tutorial we will cover the following parts of Magic and Hyperlambda.
- How to use Magic with PostgreSQL
The default “docker-compose.yml” file for Magic will create a MySQL Docker container. If you instead want to use Postgres, you’ll need a slightly modified “docker-compose.yml” file. Below is a complete docker-compose file, except it creates a PostgreSQL database image and not a MySQL image.
version: "3.3" services: db: image: postgres:9.3 restart: always environment: - POSTGRES_PASSWORD=ThisIsNotAGoodPassword backend: image: aistamagic/magic-backend:latest depends_on: - db restart: always ports: - "4444:4444" volumes: - etc_magic_folder_pg:/magic/files/etc - modules_magic_folder_pg:/magic/files/modules - config_magic_folder_pg:/magic/config frontend: image: aistamagic/magic-frontend:latest depends_on: - backend restart: always ports: - "5555:80" volumes: etc_magic_folder_pg: modules_magic_folder_pg: config_magic_folder_pg:
If you create a file named “docker-compose.yml” and save it to any directory on your machine with the above content, for then to run the following command in that same directory, this will start a Postgres instance on your machine.
When you configure Magic, you’ll need to choose the “pgsql” database type. Afterwards you’ll need to paste the following into its connection string settings and choose a root password.
The rest of the process is similar to the MySQL equivalent, and implies crudifying your backend, creating a key pair, and running the assumptions. You also need to have Docker installed on your development machine.
- Continue with Using Magic with MySQL