Dan The Engineer
  • Home
  • About Dan
Subscribe
Tagged

CockroachDB tutorial

A collection of 3 posts

CockroachDB and the Symfony Framework
symfony framework

CockroachDB and the Symfony Framework

CockroachDB is a distributed SQL database that is designed to be scalable, resilient, and highly available. It is compatible with PostgreSQL, which means that applications built to use PostgreSQL can use CockroachDB as a drop-in replacement with minimal modifications. Symfony, on the other hand, is a popular PHP web application

  • Paul Lovett
Paul Lovett Mar 9, 2023 • 2 min read
Utilise the included demo feature of CockroachDB to discover how to geographically position your data
data locality

Utilise the included demo feature of CockroachDB to discover how to geographically position your data

Example setup, configuration and test 1. Stand up a demo multi-region cluster locally using CockroachDB Demo $ cockroach demo --no-example-database --nodes 9 --global 2. Create a Database CREATE DATABASE db PRIMARY REGION "us-east1" REGIONS "us-west1", "europe-west1"; USE db; 3. Create a table with Region by Row functionality CREATE TABLE public.users

  • Paul Lovett
Paul Lovett Feb 16, 2023 • 4 min read
Getting to know the CockroachDB 'demo' feature
Cockroach Demo

Getting to know the CockroachDB 'demo' feature

Getting started with CockroachDB demo Prerequisite Download the CockroachDB binary from this location  (MacOS, Linux or Windows available) What is the CockroachDB demo? The cockroach demo command starts a temporary, in-memory CockroachDB cluster of one or more nodes, with or without a preloaded dataset, and opens an interactive SQL shell

  • Paul Lovett
Paul Lovett Feb 15, 2023 • 4 min read
Dan The Engineer © 2023
Powered by Ghost