Next: Using Postgres Indexes to Speed Up a Fuzzy Search

The registration and login feature is now secure and pleasant to use. By using the best of both Postgres and Bootstrap, you’ve gotten a good taste of using the full application stack to deliver a great feature. The power of these tools allowed us to tackle an important part of any application—authentication—easily and quickly, without sacrificing security or user experience.

In the next chapter, you’ll start on a new feature: customer search. Search is a great way to learn about all aspects of full-stack development. It’s got everything: user input, complex output, and complex database queries. You’ll start this feature by implementing a naive fuzzy search that you can then examine and optimize using special indexes Postgres provides.

Footnotes

[28]

http://www.postgresql.org/docs/9.5/static/ddl-constraints.html

[29]

http://api.rubyonrails.org/classes/ActiveRecord/Migration/CommandRecorder.html