SPRING ENGINEERING

Misplaced Views and Choppy Scrolling with Dynamically Sized UICollectionViewCells. Here at Spring, we recently embraced Auto Layout in all of its glory to create dynamically sized cells for our collection views. (We then. Alan Wang. Dec 1, 2017. LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great SPEED UP WITH EAGER LOADING IN SQLALCHEMY Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected. Why? We hit the “N+1” problem that comes with lazy loading relationships in any Object Relational Model framework. Let’s say we query for N orders,

and

MISPLACED VIEWS AND CHOPPY SCROLLING WITH DYNAMICALLY Unfortunately, dynamically changing estimatedItemSize does not solve our problem, it only makes it less obvious. Every off-screen item is still using estimatedItemSize, and when that size has to be replaced by the actual size, the same choppy behavior will occur.. Misplaced Supplementary Views. We didn’t investigate this issue much ourselves, but according to this post from Stack Overflow: DYNAMIC CELL SIZING IN UICOLLECTIONVIEW ACCURATE PRODUCT COUNTS WITH ELASTICSEARCH At Spring, we use Elasticsearch to let users search and browse our 200,000+ products, with the ability to refine by category, size, color, and price. For each of these refinements, we display the number of products that match each possible option: For most of these refinements, getting product counts was straightforward, using

standard

CUSTOM COLLECTION VIEW LAYOUT A SIMPLE WAY TO OPTIMIZE EMAIL DOMAIN QUERY PERFORMANCE IN Postgres isn’t using the index at all; that Seq Scan indicates that it’s scanning every row in the table to check if each row matches the pattern. Surely we can do better! According to the PostgreSQL documentation:. The optimizer can also use a B-tree index for queries involving the pattern matching operators LIKE and ~ if the pattern is a constant and is anchored to the beginning of the AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

SPRING ENGINEERING

Misplaced Views and Choppy Scrolling with Dynamically Sized UICollectionViewCells. Here at Spring, we recently embraced Auto Layout in all of its glory to create dynamically sized cells for our collection views. (We then. Alan Wang. Dec 1, 2017. LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great SPEED UP WITH EAGER LOADING IN SQLALCHEMY Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected. Why? We hit the “N+1” problem that comes with lazy loading relationships in any Object Relational Model framework. Let’s say we query for N orders,

and

MISPLACED VIEWS AND CHOPPY SCROLLING WITH DYNAMICALLY Unfortunately, dynamically changing estimatedItemSize does not solve our problem, it only makes it less obvious. Every off-screen item is still using estimatedItemSize, and when that size has to be replaced by the actual size, the same choppy behavior will occur.. Misplaced Supplementary Views. We didn’t investigate this issue much ourselves, but according to this post from Stack Overflow: DYNAMIC CELL SIZING IN UICOLLECTIONVIEW ACCURATE PRODUCT COUNTS WITH ELASTICSEARCH At Spring, we use Elasticsearch to let users search and browse our 200,000+ products, with the ability to refine by category, size, color, and price. For each of these refinements, we display the number of products that match each possible option: For most of these refinements, getting product counts was straightforward, using

standard

CUSTOM COLLECTION VIEW LAYOUT A SIMPLE WAY TO OPTIMIZE EMAIL DOMAIN QUERY PERFORMANCE IN Postgres isn’t using the index at all; that Seq Scan indicates that it’s scanning every row in the table to check if each row matches the pattern. Surely we can do better! According to the PostgreSQL documentation:. The optimizer can also use a B-tree index for queries involving the pattern matching operators LIKE and ~ if the pattern is a constant and is anchored to the beginning of the AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great ABOUT SPRING ENGINEERING Read more about Spring Engineering. Tales from the team that builds

@Spring.

UICOLLECTIONVIEW

Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great

PROGRAMMING

A simple way to optimize email domain query performance in PostgreSQL. tl;dr: A prefixed pattern query will run faster than a suffixed one, because the former can take advantage of an index. In PostgreSQL, we can create a functional index using reverse() to make a suffixed

pattern

SQL – SPRING ENGINEERING A simple way to optimize email domain query performance in PostgreSQL. tl;dr: A prefixed pattern query will run faster than a suffixed one, because the former can take advantage of an index. In PostgreSQL, we can create a functional index using reverse() to make a suffixed

pattern

CUSTOM COLLECTION VIEW LAYOUT The Core Layout process, as illustrated by Apple prepare( ) (aka prepareLayout in Objective-C). This method is called at the beginning of the Core Layout Process and DATABASE – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any ORM – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any SQLALCHEMY – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any HOW SPRING PREPARES FOR THE BLACK FRIDAY FRENZY With the help of Uncubed and Amazon Web Services, we shot this video late last year to share a story about a scalability issue we had during Black Friday 2016 and the work we did to avoid that for Black Friday 2017 using AWS infrastructure.. It should come as no surprise that Black Friday is one of the busiest days of the year for a marketplace like Spring as retailers offer deep discounts and

SPRING ENGINEERING

Misplaced Views and Choppy Scrolling with Dynamically Sized UICollectionViewCells. Here at Spring, we recently embraced Auto Layout in all of its glory to create dynamically sized cells for our collection views. (We then. Alan Wang. Dec 1, 2017. LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great SPEED UP WITH EAGER LOADING IN SQLALCHEMY Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected. Why? We hit the “N+1” problem that comes with lazy loading relationships in any Object Relational Model framework. Let’s say we query for N orders,

and

DYNAMIC CELL SIZING IN UICOLLECTIONVIEW ACCURATE PRODUCT COUNTS WITH ELASTICSEARCH At Spring, we use Elasticsearch to let users search and browse our 200,000+ products, with the ability to refine by category, size, color, and price. For each of these refinements, we display the number of products that match each possible option: For most of these refinements, getting product counts was straightforward, using

standard

CUSTOM COLLECTION VIEW LAYOUT AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. 28 DAYS LATER: MY FIRST FOUR WEEKS AS A JUNIOR ENGINEER AT My name is Maia. I came out of school with a BA in music, tripped and fell, and landed in the tech world. After a whirlwind stint at the Recurse Center (Formerly “Hacker School”) and an internship with GNOME, the folks at Spring took a chance on me and offered me a job. I’ve been here now for a little more than two months, and I couldn’t be happier. A SIMPLE WAY TO OPTIMIZE EMAIL DOMAIN QUERY PERFORMANCE IN Postgres isn’t using the index at all; that Seq Scan indicates that it’s scanning every row in the table to check if each row matches the pattern. Surely we can do better! According to the PostgreSQL documentation:. The optimizer can also use a B-tree index for queries involving the pattern matching operators LIKE and ~ if the pattern is a constant and is anchored to the beginning of the MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

SPRING ENGINEERING

Misplaced Views and Choppy Scrolling with Dynamically Sized UICollectionViewCells. Here at Spring, we recently embraced Auto Layout in all of its glory to create dynamically sized cells for our collection views. (We then. Alan Wang. Dec 1, 2017. LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great SPEED UP WITH EAGER LOADING IN SQLALCHEMY Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected. Why? We hit the “N+1” problem that comes with lazy loading relationships in any Object Relational Model framework. Let’s say we query for N orders,

and

DYNAMIC CELL SIZING IN UICOLLECTIONVIEW ACCURATE PRODUCT COUNTS WITH ELASTICSEARCH At Spring, we use Elasticsearch to let users search and browse our 200,000+ products, with the ability to refine by category, size, color, and price. For each of these refinements, we display the number of products that match each possible option: For most of these refinements, getting product counts was straightforward, using

standard

CUSTOM COLLECTION VIEW LAYOUT AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. 28 DAYS LATER: MY FIRST FOUR WEEKS AS A JUNIOR ENGINEER AT My name is Maia. I came out of school with a BA in music, tripped and fell, and landed in the tech world. After a whirlwind stint at the Recurse Center (Formerly “Hacker School”) and an internship with GNOME, the folks at Spring took a chance on me and offered me a job. I’ve been here now for a little more than two months, and I couldn’t be happier. A SIMPLE WAY TO OPTIMIZE EMAIL DOMAIN QUERY PERFORMANCE IN Postgres isn’t using the index at all; that Seq Scan indicates that it’s scanning every row in the table to check if each row matches the pattern. Surely we can do better! According to the PostgreSQL documentation:. The optimizer can also use a B-tree index for queries involving the pattern matching operators LIKE and ~ if the pattern is a constant and is anchored to the beginning of the MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

ARCHIVE OF STORIES PUBLISHED BY SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great ABOUT SPRING ENGINEERING Read more about Spring Engineering. Tales from the team that builds

@Spring.

PROGRAMMING

A simple way to optimize email domain query performance in PostgreSQL. tl;dr: A prefixed pattern query will run faster than a suffixed one, because the former can take advantage of an index. In PostgreSQL, we can create a functional index using reverse() to make a suffixed

pattern

UICOLLECTIONVIEW

Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great ORM – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any DATABASE – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any DECIMAL: AN ARBITRARY-PRECISION FIXED-POINT DECIMAL When dealing with money, rounding errors are undesirable. Unfortunately, floating point numbers can’t represent fractional decimals (ex: 0.1) precisely, CUSTOM COLLECTION VIEW LAYOUT The Core Layout process, as illustrated by Apple prepare( ) (aka prepareLayout in Objective-C). This method is called at the beginning of the Core Layout Process and SQLALCHEMY – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any HOW SPRING PREPARES FOR THE BLACK FRIDAY FRENZY With the help of Uncubed and Amazon Web Services, we shot this video late last year to share a story about a scalability issue we had during Black Friday 2016 and the work we did to avoid that for Black Friday 2017 using AWS infrastructure.. It should come as no surprise that Black Friday is one of the busiest days of the year for a marketplace like Spring as retailers offer deep discounts and

SPRING ENGINEERING

Misplaced Views and Choppy Scrolling with Dynamically Sized UICollectionViewCells. Here at Spring, we recently embraced Auto Layout in all of its glory to create dynamically sized cells for our collection views. (We then. Alan Wang. Dec 1, 2017. LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great SPEED UP WITH EAGER LOADING IN SQLALCHEMY Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected. Why? We hit the “N+1” problem that comes with lazy loading relationships in any Object Relational Model framework. Let’s say we query for N orders,

and

DYNAMIC CELL SIZING IN UICOLLECTIONVIEW ACCURATE PRODUCT COUNTS WITH ELASTICSEARCH At Spring, we use Elasticsearch to let users search and browse our 200,000+ products, with the ability to refine by category, size, color, and price. For each of these refinements, we display the number of products that match each possible option: For most of these refinements, getting product counts was straightforward, using

standard

CUSTOM COLLECTION VIEW LAYOUT AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. 28 DAYS LATER: MY FIRST FOUR WEEKS AS A JUNIOR ENGINEER AT My name is Maia. I came out of school with a BA in music, tripped and fell, and landed in the tech world. After a whirlwind stint at the Recurse Center (Formerly “Hacker School”) and an internship with GNOME, the folks at Spring took a chance on me and offered me a job. I’ve been here now for a little more than two months, and I couldn’t be happier. A SIMPLE WAY TO OPTIMIZE EMAIL DOMAIN QUERY PERFORMANCE IN Postgres isn’t using the index at all; that Seq Scan indicates that it’s scanning every row in the table to check if each row matches the pattern. Surely we can do better! According to the PostgreSQL documentation:. The optimizer can also use a B-tree index for queries involving the pattern matching operators LIKE and ~ if the pattern is a constant and is anchored to the beginning of the MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

SPRING ENGINEERING

Misplaced Views and Choppy Scrolling with Dynamically Sized UICollectionViewCells. Here at Spring, we recently embraced Auto Layout in all of its glory to create dynamically sized cells for our collection views. (We then. Alan Wang. Dec 1, 2017. LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great SPEED UP WITH EAGER LOADING IN SQLALCHEMY Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected. Why? We hit the “N+1” problem that comes with lazy loading relationships in any Object Relational Model framework. Let’s say we query for N orders,

and

DYNAMIC CELL SIZING IN UICOLLECTIONVIEW ACCURATE PRODUCT COUNTS WITH ELASTICSEARCH At Spring, we use Elasticsearch to let users search and browse our 200,000+ products, with the ability to refine by category, size, color, and price. For each of these refinements, we display the number of products that match each possible option: For most of these refinements, getting product counts was straightforward, using

standard

CUSTOM COLLECTION VIEW LAYOUT AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. 28 DAYS LATER: MY FIRST FOUR WEEKS AS A JUNIOR ENGINEER AT My name is Maia. I came out of school with a BA in music, tripped and fell, and landed in the tech world. After a whirlwind stint at the Recurse Center (Formerly “Hacker School”) and an internship with GNOME, the folks at Spring took a chance on me and offered me a job. I’ve been here now for a little more than two months, and I couldn’t be happier. A SIMPLE WAY TO OPTIMIZE EMAIL DOMAIN QUERY PERFORMANCE IN Postgres isn’t using the index at all; that Seq Scan indicates that it’s scanning every row in the table to check if each row matches the pattern. Surely we can do better! According to the PostgreSQL documentation:. The optimizer can also use a B-tree index for queries involving the pattern matching operators LIKE and ~ if the pattern is a constant and is anchored to the beginning of the MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

ARCHIVE OF STORIES PUBLISHED BY SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great ABOUT SPRING ENGINEERING Read more about Spring Engineering. Tales from the team that builds

@Spring.

PROGRAMMING

A simple way to optimize email domain query performance in PostgreSQL. tl;dr: A prefixed pattern query will run faster than a suffixed one, because the former can take advantage of an index. In PostgreSQL, we can create a functional index using reverse() to make a suffixed

pattern

UICOLLECTIONVIEW

Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great ORM – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any DATABASE – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any DECIMAL: AN ARBITRARY-PRECISION FIXED-POINT DECIMAL When dealing with money, rounding errors are undesirable. Unfortunately, floating point numbers can’t represent fractional decimals (ex: 0.1) precisely, CUSTOM COLLECTION VIEW LAYOUT The Core Layout process, as illustrated by Apple prepare( ) (aka prepareLayout in Objective-C). This method is called at the beginning of the Core Layout Process and SQLALCHEMY – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any HOW SPRING PREPARES FOR THE BLACK FRIDAY FRENZY With the help of Uncubed and Amazon Web Services, we shot this video late last year to share a story about a scalability issue we had during Black Friday 2016 and the work we did to avoid that for Black Friday 2017 using AWS infrastructure.. It should come as no surprise that Black Friday is one of the busiest days of the year for a marketplace like Spring as retailers offer deep discounts and

SPRING ENGINEERING

Misplaced Views and Choppy Scrolling with Dynamically Sized UICollectionViewCells. Here at Spring, we recently embraced Auto Layout in all of its glory to create dynamically sized cells for our collection views. (We then. Alan Wang. Dec 1, 2017. LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great SPEED UP WITH EAGER LOADING IN SQLALCHEMY Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected. Why? We hit the “N+1” problem that comes with lazy loading relationships in any Object Relational Model framework. Let’s say we query for N orders,

and

DYNAMIC CELL SIZING IN UICOLLECTIONVIEW ACCURATE PRODUCT COUNTS WITH ELASTICSEARCH At Spring, we use Elasticsearch to let users search and browse our 200,000+ products, with the ability to refine by category, size, color, and price. For each of these refinements, we display the number of products that match each possible option: For most of these refinements, getting product counts was straightforward, using

standard

CUSTOM COLLECTION VIEW LAYOUT A SIMPLE WAY TO OPTIMIZE EMAIL DOMAIN QUERY PERFORMANCE IN Postgres isn’t using the index at all; that Seq Scan indicates that it’s scanning every row in the table to check if each row matches the pattern. Surely we can do better! According to the PostgreSQL documentation:. The optimizer can also use a B-tree index for queries involving the pattern matching operators LIKE and ~ if the pattern is a constant and is anchored to the beginning of the AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. HOW SPRING PREPARES FOR THE BLACK FRIDAY FRENZY With the help of Uncubed and Amazon Web Services, we shot this video late last year to share a story about a scalability issue we had during Black Friday 2016 and the work we did to avoid that for Black Friday 2017 using AWS infrastructure.. It should come as no surprise that Black Friday is one of the busiest days of the year for a marketplace like Spring as retailers offer deep discounts and MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

SPRING ENGINEERING

Misplaced Views and Choppy Scrolling with Dynamically Sized UICollectionViewCells. Here at Spring, we recently embraced Auto Layout in all of its glory to create dynamically sized cells for our collection views. (We then. Alan Wang. Dec 1, 2017. LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great SPEED UP WITH EAGER LOADING IN SQLALCHEMY Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected. Why? We hit the “N+1” problem that comes with lazy loading relationships in any Object Relational Model framework. Let’s say we query for N orders,

and

DYNAMIC CELL SIZING IN UICOLLECTIONVIEW ACCURATE PRODUCT COUNTS WITH ELASTICSEARCH At Spring, we use Elasticsearch to let users search and browse our 200,000+ products, with the ability to refine by category, size, color, and price. For each of these refinements, we display the number of products that match each possible option: For most of these refinements, getting product counts was straightforward, using

standard

CUSTOM COLLECTION VIEW LAYOUT A SIMPLE WAY TO OPTIMIZE EMAIL DOMAIN QUERY PERFORMANCE IN Postgres isn’t using the index at all; that Seq Scan indicates that it’s scanning every row in the table to check if each row matches the pattern. Surely we can do better! According to the PostgreSQL documentation:. The optimizer can also use a B-tree index for queries involving the pattern matching operators LIKE and ~ if the pattern is a constant and is anchored to the beginning of the AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. HOW SPRING PREPARES FOR THE BLACK FRIDAY FRENZY With the help of Uncubed and Amazon Web Services, we shot this video late last year to share a story about a scalability issue we had during Black Friday 2016 and the work we did to avoid that for Black Friday 2017 using AWS infrastructure.. It should come as no surprise that Black Friday is one of the busiest days of the year for a marketplace like Spring as retailers offer deep discounts and MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

LATEST STORIES PUBLISHED ON SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great ARCHIVE OF STORIES PUBLISHED BY SPRING ENGINEERING Custom Collection View Layout — A Simple Template Overview. UICollectionView is one of the most powerful tools in the iOS developer’s arsenal. With it, you can create complex UIs with built in support for scrolling, tap recognition, layout changes, and great ABOUT SPRING ENGINEERING Read more about Spring Engineering. Tales from the team that builds

@Spring.

PROGRAMMING

A simple way to optimize email domain query performance in PostgreSQL. tl;dr: A prefixed pattern query will run faster than a suffixed one, because the former can take advantage of an index. In PostgreSQL, we can create a functional index using reverse() to make a suffixed

pattern

DATABASE – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any SQL – SPRING ENGINEERING A simple way to optimize email domain query performance in PostgreSQL. tl;dr: A prefixed pattern query will run faster than a suffixed one, because the former can take advantage of an index. In PostgreSQL, we can create a functional index using reverse() to make a suffixed

pattern

AUTOMATED IOS INTEGRATION TESTING IN A REAL WORLD CONSUMER KIF works by using the iOS accessibility framework to run a set of gestures and expect a set of outcomes for each test. After giving your views accessibility labels, you use the KIF APIs to describe a set of gestures that the test should perform, and then an expected outcome. ORM – SPRING ENGINEERING Speed up with eager loading in SQLAlchemy. In our previous post about SQLAlchemy, we fixed our order search query to get the right rows, but the endpoint was still slower than we expected.Why? We hit the “N+1” problem that comes with lazy loading relationships in any MANIPULATING DATES AND TIME ZONES IN IOS DEVELOPMENT Figure 1: A Date object represents a point on a timeline. It is defined by its distance from an absolute reference point. Date is independent of calendar systems or time zones. In order to map a point in time to a particular “datetime” (a combination of a date and a time, i.e. January 28th, 2017, 2:45pm), we need to impose a calendar

system.

HOW SPRING PREPARES FOR THE BLACK FRIDAY FRENZY With the help of Uncubed and Amazon Web Services, we shot this video late last year to share a story about a scalability issue we had during Black Friday 2016 and the work we did to avoid that for Black Friday 2017 using AWS infrastructure.. It should come as no surprise that Black Friday is one of the busiest days of the year for a marketplace like Spring as retailers offer deep discounts and WE’RE MOVING ON TO OUR NEXT PHASE—COME WITH US! While shopspring.com is no longer active, we've taken lots of what you love and put it into two new shopping experiences: Powered by ShopRunner Discover the app shopping experience with everything you love about Spring...plus some serious perks: free 2-day shipping and free returns

on everything.

Download now

All Spring customers are now eligible for a free 1-year ShopRunner membership, which gets you free 2-day shipping, free returns, and exclusive perks at 140+ of your favorite retailers. Click here

to activate now!

Spring is accepting returns on qualifying orders through 6/18/2019. To process a return, contact concierge@shopspring.com For any questions on shopspring.com orders or SpringBack, visit https://concierge.shopspring.com or contact concierge@shopspring.com

*

*

*