SingleStore for Laravel

A masterclass in using SingleStore to supercharge your Laravel applications

The standard package

$449 Buy now (instant access)
  • Stream and download all 20 lessons immediately
  • Membership to our private Discord community

The premium package

$949 Buy now (instant access)
  • Everything in standard package
  • $500 top-up of managed service credits (for new SingleStore customers or people wanting to trial SingleStore again)
  • Access to recordings of three private webinars with Jack Ellis (course creator) and Carl Sverre (former Senior Engineer @ SingleStore & database genius)
  • Access to codebase & migration files
For team pricing, click here.
Why am I here?

I got tired of MySQL headaches and needed something faster and more scalable. So we ditched MySQL, Redis and DynamoDB, moved everything to SingleStore, and are now able to achieve hyper-scale and performance we’d never imagined.

How fast are we talking?

Great question. Well let's take a look at a query.

SELECT SUM(pageviews) FROM pageviews

Let’s run it over a sample data set of 5 billion rows.

It takes just 1.49 seconds to complete.

Incredible, right?

You have my attention, tell me more!

I've built a course to show you how to use SingleStore with Laravel. As with my previous course, Serverless Laravel, I will save you time and help you skip past all of the gotchas. And whilst this course is specifically for using SingleStore in the Laravel ecosystem, everyone can benefit because we do focus on SingleStore itself.

Who is the course for?

This course is for people with growing databases who want to keep them fast, people who aren't getting the performance needed with their current solution, and those who are tired of the headaches MySQL brings.

For those using RDS at scale, you've likely run into IOPS headaches, connection limits, slow time to add indexes to tables, slow aggregations, slow migrations, slow filtering and performance degradation over time. Many people keep increasing their spending on RDS, but they're just not seeing a valuable performance jump.

This course is for you if you want a faster & more scalable database, and either of the following apply:

  • You are comfortable self-hosting SingleStore (free license)
  • You have the budget for an industry-leading managed service

SingleStore’s managed service, which we use, is unlike any managed database software you’ve ever used.

Keep in mind that you can drop Redis, DynamoDB and MySQL when moving to SingleStore.

Who is teaching this course?

That would be me, Jack Ellis. I’m the cofounder and CTO of Fathom Analytics and I brought awareness of SingleStore to the Laravel community by writing about my experiences scaling Laravel with SingleStore.

My courses have been downloaded by over 1,300 software engineers and have helped solve many challenges.

Lessons included in the course

SingleStore for Laravel

My story about how I ended up using SingleStore to power Fathom Analytics.

Who is this course for?

A dive into who this course is for and what OLTP and OLAP actually are.

Introducing: Acme Bank

Introducing the playground application we're creating.

Behind the scenes

How we built Acme Bank.

MySQL headaches

The headaches you will run into when you use MySQL and how SingleStore compares.

Local installation

Installing SingleStore on your local machine.

Installing in your Laravel application

Setting up the SingleStore driver in your application.

Refactoring for SingleStore

Running into the nuances of SingleStore with Laravel so that you don't have to.

What is a shard key?

How we split up our data and ensure long-term scalability.

Sharding our data

Reviewing our migration files and choosing shard keys.

Keyless sharding

An alternative way to shard your data.

Partitions, speed and scaling

How to really drive rapid performance with SingleStore.

Auto increments

An important note about auto increments with distributed databases.

Universal Storage vs Rowstore

The difference between the two types of database SingleStore offers.

Columnstore sort keys

Choosing a sort key is everything, and in this video we learn about how they work and dive into segment elimination.

Primary keys

Quick reminder on primary keys.

Hash Indexes

How to correctly use hash keys (don't make the same mistake I did).

Skiplist indexes

Using skiplist indexes (replacement for MySQL btree) on rowstore tables.

Full-text indexes

Full-text indexes are here, so you can drop that additional database for searching.

Goodbye Varchar

Goodbye my Varchar, goodbye my friend, you have been the one. You have been the one for me.

What will I learn from this course?

You will learn how SingleStore is different from MySQL, how to bring it into your application and how to scale your queries and data.

Can I pay with PayPal?

Absolutely. We use Gumroad for payment processing, so you can pay with your card or Paypal.

Can I get an invoice?

You most definitely can. Gumroad sends you an email when you make a purchase, and there's a link in the email for you to print an invoice.

Is SingleStore ready for production?

Yes, the software is 10+ years old and is used by companies such as Siemens, Akamai, Dell, Cisco, Disney, Goldman Sachs, Hulu, Kelloggs, Uber, Sony and, of course, my company Fathom Analytics.

What if I decide it's not for me?

No problem. I'll refund you in full if you email jack@jackellisweb.com within 7 days of purchase, no questions asked.

Is the price inclusive of VAT?

The price displayed here is exclusive of VAT. Depending on your location, Gumroad may add VAT to your purchase.

Do you have any free resources in the meantime?