7. Getting Started with the Database | Clojure Web Development Essentials

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Clojure Web Development Essentials

By : Baldwin

4.5 (6)

Clojure Web Development Essentials

4.5 (6)

By: Baldwin

Overview of this book

This book is for anyone who's worked with Clojure and wants to use it to start developing applications for the Web. Experience or familiarity with basic Clojure syntax is a must, and exposure to Leiningen (or other similar build tools such as Maven) would be helpful.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with Luminus

1. Getting Started with Luminus

Leiningen

Dependencies of the app

Luminus file structure

Summary

2. Ring and the Ring Server

2. Ring and the Ring Server

Understanding Ring in Clojure

What is the Ring Server?

Configuring and running the Ring Server

Summary

3. Logging

3. Logging

What is Timbre?

Configuring a Timbre appender

Logging with Timbre

Adding an appender

Summary

4. URL Routing and Template Rendering

4. URL Routing and Template Rendering

What is Compojure?

Creating a Compojure route

What is Selmer?

Creating your first page

Editing the home page

Serving the signup form

Creating the signup page

Summary

5. Handling Form Input

5. Handling Form Input

Handling the form POST

Validating the form POST

Summary

6. Testing in Clojure

6. Testing in Clojure

The necessity of testing

Anatomy of a test

Writing and running our first test

Writing a high-level integration test

Summary

7. Getting Started with the Database

7. Getting Started with the Database

Creating the database schema

Maintaining the database schema

Adding data to the database

Summary

8. Reading Data from the Database

8. Reading Data from the Database

Creating the catalog

Fetching albums from the database

Creating the recently added route

Rendering the results

An exercise!

Summary

9. Database Transactions

9. Database Transactions

Introduction to Database Transactions

The ACID properties

Importance of database transactions

Implementing a transaction

Extending the application requirements in brief

Summary

10. Sessions and Cookies

10. Sessions and Cookies

Sessions

Setting up sessions

Interacting with the session

Restricted routes

Cookies

Extending the application: brief requirements

Summary

11. Environment Configuration and Deployment

11. Environment Configuration and Deployment

Environ

Setting and resolving environment configurations

Adjusting the database connection

Deploying the hipstr application

Summary

A. Using Korma – a Clojure DSL for SQL

A. Using Korma – a Clojure DSL for SQL

Getting Korma

The Quick Korma Crash Course

Port the models from YeSQL to Korma

Index

Index

Customer Reviews

4.5 (6)

5 star

66.7%

4 star

16.7%

3 star

16.7%

2 star

0%

1 star

0%

Creating the database schema

Before we interact with a database, we'll need to actually create a database schema, go figure, as you can't harvest eggs without the chicken. In this section, we're going set up the database schema for our hipstr application, using PostgreSQL.

Note

This section assumes you already have the PostgreSQL database server installed on your machine, and thus, will not guide you through that process. You can download PostgreSQL at http://www.postgresql.org/download/. This book was written using PostgreSQL 9.3.5 OS X application on Mac OS X Yosemite.

You may be asking, "Why a database schema instead of a new database?" You can do either, really. The advantage of creating a new database schema over a database, however, comes in the form of role and user management, which for the most part, we won't get into except to create the user for the hipstr application. Let's do this now.

Perform the following steps as either a super user (if you already have a PostgreSQL super user...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Clojure Web Development Essentials

Search

Your notes and bookmarks