Configure a Database in Vapor

Database is configured in configure.swift file.


  let psqlConfig = PostgreSQLDatabaseConfig(hostname: "localhost", port: 5432, username: "vapor", password: "password")
  var dbConfig = DatabaseConfig()
  
  let database = PostgreSQLDatabase(config: psqlConfig)
  dbConfig.add(database: database, as: .psql)
  services.register(dbConfig)

Use the same username and password as in Add PostgreSQL into Vapor App.


Vapor docs state that migrations are a way of making organised, testable, and reliable changes to your database's structure-- even while it's in production!

Migrations are often used for preparing a database schema for your models. However, they can also be used to make normal queries to your database.


Configure migrations (also in configure.swift file) :


  var migrations = MigrationConfig()
  migrations.add(model: Tip.self, database: .psql)
  services.register(migrations)

Here we just declared that our prosgreSQL database has just one table Tip for out Tip model.



Prev: Add PostgreSQL into Vapor App

Next: Database Relationships


Vapor 3 Tutorial Start


#pub #postgresql #db #vapor #swift