In Part 2 of this 2 part PostgreSQL 🐘 Table Partitioning series, we’ll focus on how we modified the Primary Key online for a large partitioned table. This is a disruptive operation, so we had to use some tricks to pull this off.

Read on to learn more.

At Fountain, we’re fans of PostgreSQL, 🐘 especially the capabilities that help us meet the demands of high volume hiring.

Recently we faced a challenge working with a large table where query performance had worsened. This is a high growth database table that tracks applicants as they move through their hiring process.

Read on to find out how we solved it.

Fountain’s high-volume hiring platform helps organizations find and hire the right people, faster. One early feature in Fountain was a calendar view that listed a manager’s upcoming interviews, let applicants schedule interviews in available slots, and provided a summary of upcoming interviewees.

We’ve learned a key fact since our beginnings - managers don’t need a second calendar. What they need is one integrated view.

Background

Validating identification data is always tricky. The sheer amount of different national (and international) identification numbers could be overwhelming for developers to come up with a right solution. In this article, I’m going to share some...

The highest volumes of traffic to Fountain’s high-volume hiring platform are driven by workers applying for jobs. Our efforts to provide an accessible, seamless hiring experience recently led to an ambitious redesign of the applicant-facing side of our software...

In Part 1 of this series, Fountain Engineering team members shared their RailsConf 2022 experiences.

Now that all recorded presentations have been posted publicly, in Part 2 of this 2 post series, team members share links to some of their favorite presentations and describe what they liked about the presentations.

Read on to learn more!

This year Fountain was a sponsor of the RailsConf 2022 Conference conducted in Portland, OR. 🎟️

Some goals for Fountain were to increase the presence and awareness of engineering team opportunities in the Rails community, and increase brand recognition for Fountain the company.

The overall objectives were met! The majority of the conference attendees were unfamiliar with Fountain before and through many conversations, we had the opportunity to tell them about the company, products, and engineering team opportunities.

Read on to learn more!

Members of the Fountain Engineering recently attended RailsConf 2022 in Portland, OR! 🎉

In this post, the first part of a 2-part series, team members reflect on their conference experiences including selecting sessions, Fountain’s booth presence and conference sponsorship, meeting up in person, and more. In a future post, attendees will describe their favorite sessions and link to the public recordings.

For many attendees, due to the COVID-19 pandemic, this was their first in-person conference in years. There were feelings of both excitement and concern. The conference organizers did a great job with health and safety protocols..

Some folks had attended RailsConf before and for some, it was their first RailsConf experience. Read more to learn about their first hand experiences.

The Fountain engineering team recently upgraded all production traffic to a new major version of Elasticsearch without having to plan and coordinate downtime with customers. 🎉

The approach was a “zero downtime” strategy, gradually cutting over specific aspects as steps, and making each step reversible. Avoiding downtime meant that the upgrade would not block customer usage of Fountain. Although each step required coordination and planning, this approach reduced risk because each step was granular and reversible.

During the course of testing and fixing upgrade related issues, the team also took the opportunity to modernize and simplify Elasticsearch-related application code.

This post will recap some of the key points in achieving both goals of a zero downtime upgrade and an application code modernization.

We’re excited to announce we’ve recently integrated with Indeed via their Sponsored Jobs Integration. This allows our users to advertise their jobs on Indeed directly from Fountain, using our platform to allocate money to promote these jobs, receive applicants, review the performance of their job campaigns, and pay for the campaigns.

Welcome! 👋

I’m Matt Tucker, Fountain’s CTO. I recently joined the company via the acquisition of my latest startup Koan (koan.co), and I’m thrilled to be here for (1) our mission around creating compelling technology for the benefit of hourly workers; (2) the opportunity we have in building a great company and engineering culture as we continue to very rapidly grow.