<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/sources/cockroachdb/best-of/2022" -->

---
title: Best CockroachDB posts of 2022 | daily.dev
description: The most upvoted CockroachDB posts of 2022, curated by the daily.dev community.
canonical: https://daily.dev/sources/cockroachdb/best-of/2022
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:url: https://daily.dev/sources/cockroachdb/best-of/2022
og:type: website
og:site_name: daily.dev
og:title: Best CockroachDB posts of 2022 | daily.dev
og:description: The most upvoted CockroachDB posts of 2022, curated by the daily.dev community.
og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph
---

# Best of CockroachDB — 2022

1. 1  
[](/posts/sql-performance-best-practices-1pu22cul6 "SQL Performance Best Practices")  
[![Cockroach Labs's profile](https://media.daily.dev/image/upload/s--7jIxBrvX--/f_auto/v1789479232/avatars/avatar_Csil5c2qFlskxGyz9CDs6?_a=BAMAMicg0)](https://daily.dev/cockroachdb302)  
[![cockroachdb's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/d44d24541246413da70b09f5e81d845e)](/sources/[source]/best-of/[year])  
10m read time • Sep 08, 2022  
### SQL Performance Best Practices  
A distributed database can distribute the query and most of the work of the sort operation, but can’t reduce the workload without using an index. This index is ordered by email, enabling the server to isolate only the user’s messages, and ignore the other 999,000 in the table. It still has 3 stages, but when you take a closer look, the scan stage only touches 1,000 rows.

+2  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/09e7cc40d86177e66382fd27785784c9)  
119  
4
2. 2  
[](/posts/sql-cheat-sheet-quick-and-easy-sql-command-reference-examples-vwkxcyjzu "SQL Cheat Sheet – Quick and Easy SQL Command Reference Examples")  
[![Cockroach Labs's profile](https://media.daily.dev/image/upload/s--7jIxBrvX--/f_auto/v1789479232/avatars/avatar_Csil5c2qFlskxGyz9CDs6?_a=BAMAMicg0)](https://daily.dev/cockroachdb302)  
[![cockroachdb's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/d44d24541246413da70b09f5e81d845e)](/sources/[source]/best-of/[year])  
7m read time • Apr 26, 2022  
### SQL Cheat Sheet – Quick and Easy SQL Command Reference Examples  
This cheat sheet is designed to make it quick and easy to find that SQL command that’s right on the tip of your tongue. It’ll also be available in a printer-friendly, downloadable PDF form so that you can print it out and reference it easily from your desk.

+2  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/3bb7772fff86cd365a1f13d20193069e)  
61  
5
3. 3  
[](/posts/building-a-payments-system-that-scales-to-infinity-with-examples--qjcplpp06 "Building a Payments System That Scales to Infinity (With Examples)")  
[![Cockroach Labs's profile](https://media.daily.dev/image/upload/s--7jIxBrvX--/f_auto/v1789479232/avatars/avatar_Csil5c2qFlskxGyz9CDs6?_a=BAMAMicg0)](https://daily.dev/cockroachdb302)  
[![cockroachdb's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/d44d24541246413da70b09f5e81d845e)](/sources/[source]/best-of/[year])  
6m read time • Aug 02, 2022  
### Building a Payments System That Scales to Infinity (With Examples)  
Payments often don’t matter much beyond the 60-90 seconds during which a payment transaction takes place. Storing all of this data and keeping it available without bogging down your application can be. CockroachDB allows table- and row-level data homing, making it easy to assign rows to specific geographic regions.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/e0cb6cad47b3df146d10da09418cd3b4)  
40
4. 4  
[](/posts/cockroachdb-serverless-free-forever-seriously--2hggtud8 "CockroachDB Serverless: Free Forever. Seriously.")  
[![Cockroach Labs's profile](https://media.daily.dev/image/upload/s--7jIxBrvX--/f_auto/v1789479232/avatars/avatar_Csil5c2qFlskxGyz9CDs6?_a=BAMAMicg0)](https://daily.dev/cockroachdb302)  
[![cockroachdb's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/d44d24541246413da70b09f5e81d845e)](/sources/[source]/best-of/[year])  
6m read time • Oct 06, 2022  
### CockroachDB Serverless: Free Forever. Seriously.  
CockroachDB serverless charges you only for the actual data storage and activity of your cluster. You are guaranteed to never exceed your set spend limit, so there will never be an end-of-the-month charge that comes as a shocking surprise.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/e836b45f498ab54a480c2c9adcab2daa)  
18  
1

[See all CockroachDB archives](/sources/cockroachdb/best-of)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/cockroachdb/best-of/2022#page","url":"https://daily.dev/sources/cockroachdb/best-of/2022","name":"Best CockroachDB Posts of 2022","description":"The most upvoted CockroachDB posts of 2022, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/cockroachdb/best-of/2022#items","numberOfItems":4,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/sql-performance-best-practices-1pu22cul6","name":"SQL Performance Best Practices"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/sql-cheat-sheet-quick-and-easy-sql-command-reference-examples-vwkxcyjzu","name":"SQL Cheat Sheet – Quick and Easy SQL Command Reference Examples"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/building-a-payments-system-that-scales-to-infinity-with-examples--qjcplpp06","name":"Building a Payments System That Scales to Infinity (With Examples)"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/cockroachdb-serverless-free-forever-seriously--2hggtud8","name":"CockroachDB Serverless: Free Forever. Seriously."}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"CockroachDB","item":"https://daily.dev/sources/cockroachdb"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/cockroachdb/best-of"},{"@type":"ListItem","position":5,"name":"2022"}]}]}
```

