Summary

In this chapter, you learned how to set up a database and replaced the temporary storage in myJournal applications with more permanent database storage. You learned how to install three SQL databases on your system: SQLite, PostgreSQL, and MySQL. Then, you integrated the PostgreSQL software driver into your Vapor project and came up with a new data model that conforms to the Fluent Model. With Vapor Fluent, you implemented the CRUD operations for PostgreSQL. Next, you integrated database drivers into your Kitura application. Swift-Kuery-ORM is a Fluent-like abstraction for database management and manipulation in Kitura. You took advantage of Swift-Kuery-ORM to implement the CRUD operations for PostgreSQL in the myJournal for Kitura application. In the next chapter, you will add authentication and Admin account management to the codebase you worked on here.

...