Login Register

All gists

linkjobai / System Design Interview: Designing a Ticket Booking System (Ticketmaster-style)

Last active 18 hours ago interview

Interview prep notes

0 0 1

System Design Interview: Designing a Ticket Booking System (Ticketmaster-style)

The hard part isn't browsing events; it's selling a limited number of seats to a crowd that all clicks "buy" in the same second.

Requirements

  • Browse events and see a seat map with availability.
  • Hold seats for a few minutes during checkout; never sell the same seat twice.
  • Survive "on-sale" spikes: 1M users arriving for 50k seats.
MrGeneration

MrGeneration / Dark Zammad Knowledge Base Stylesheet

Last active 1 month ago zammad knowledge base custom css stylesheed

Sample dark mode variant for your public Zammad Knowledge Base. As shown in the Zammad 7.2 release video: https://www.youtube.com/watch?v=2X5dMVEfgHo

0 0 1
1 /*
2 * Dark theme for the Zammad public Knowledge Base.
3 *
4 * Install per https://next.zammad.org/en/tutorials/custom-kb-css.html:
5 * 1. Copy this file into app/assets/stylesheets/custom_knowledge_base_public/
6 * 2. rake assets:precompile
7 * 3. Restart Zammad
8 * 4. View the *published* KB (not the admin editor) to see the result.
9 *
10 * Built against the markup/CSS served at /help/ (Zammad's default
MrGeneration

MrGeneration / Migrating Elasticsearch from 7 to 9

Last active 3 weeks ago elasticsearch zammad upgrade helper scripts

This gist holds all required commands to upgrade Elasticsearch from 7 to 9 without data loss. It also holds helper scripts for this process. The order is crucial and not reflected independently in this gist. As shown on https://www.youtube.com/watch?v=sb3VBkaHGz4

0 0 6
1 # What we ultimatively add to the Elasticsearch configuration during the upgrades
2 # xpack
3 xpack.security.enabled: true
4 xpack.security.transport.ssl.enabled: true
5 xpack.security.transport.ssl.verification_mode: certificate
6 xpack.security.transport.ssl.keystore.path: certs/elastic-certificates.p12
7 xpack.security.transport.ssl.truststore.path: certs/elastic-certificates.p12
8 xpack.security.http.ssl.enabled: true
9 xpack.security.http.ssl.keystore.path: certs/http.p12
MrGeneration

MrGeneration / Zammad CSV-Import for Users and Organizations

Last active 3 months ago csv import users organizations

Sample CSV files to highlight the CSV import function - as shown in the youtube video https://www.youtube.com/watch?v=OeelYx106WU

0 0 2
1 login,firstname,lastname,email,web,phone,fax,mobile,department,street,zip,city,country,address,vip,verified,active,note,last_login,out_of_office,out_of_office_start_at,out_of_office_end_at,roles,two_factor_preferences,out_of_office_replacement,organizations,chat_agent_created_by,chat_agent_updated_by,overview_sortings,organization
2 mherrguth@example.com,Marcel,Herrguth,mherrguth@example.com,"","","","",,"","","","",,false,false,true,"",,false,,,Customer,"",,"",,,"",
3 some-employee@example.com,Marcel,Herrguth,some-employee@example.com,"",+492214710231,"","","","","","","","",false,false,true,"",2024-11-26T17:01:15Z,false,,,Admin~~~Agent~~~Customer,"",,"",,,"",Zammad GmbH
4 nicole.braun@zammad.org,Nicole,Braun,nicole.braun@zammad.org,"","","","","","","","","","",false,false,true,"",,false,,,Customer,"",,"",,,"",Zammad Foundation
MrGeneration

MrGeneration / Zammad-Repository Upgrades for Packager

Last active 5 months ago zammad repository change apt debian
0 0 1
1 # This quickly changes from the old packager.io to the new packager.io repository
2 # Commands require sudo / root permissions
3
4 # Drop existing GPG-Key and Repository-File
5 rm -f /etc/apt/trusted.gpg.d/pkgr-zammad.gpg /etc/apt/sources.list.d/zammad.list
6
7 # Download the new Keyring
8 curl -fsSL "https://go.packager.io/srv/deb/zammad/zammad/gpg-key.gpg" \
9 -o /usr/share/keyrings/zammad.gpg
MrGeneration

MrGeneration / KB Catalan redirect

Last active 6 months ago zammad knowledge base catalan es-ca

Redirects outdated locale slug for knowledge bases from 'es-ca' to 'ca' for improved usability and very easy switching. As shown in the Zammad 7.0 Release video: https://www.youtube.com/watch?v=unwYUx5--7M

0 0 2
1 # Default /help URL (replace help with your custom alias if needed; NOT for custom domains)
2 rewrite ^/help/es-ca/(.*)$ /help/ca/$1 permanent;
3
4 # for custom URLs
5 rewrite ^/es-ca/(.*)$ /ca/$1 permanent;
MrGeneration

MrGeneration / Backup Paperless NGX with restic

Last active 6 months ago restic backup restore paperless

As shown on https://youtu.be/P-Pr7Dy6mP8

0 0 4
1 #!/usr/bin/env bash
2 #
3 # 2025-09-25 Marcel Herrguth
4 # As shown on https://youtu.be/P-Pr7Dy6mP8
5 # Attribution back to this GIST is required!
6 #
7 # Parts of this script are oriented from https://github.com/zammad/zammad/tree/develop/contrib/backup
8 # This script supports PostGreSQL (docker) stacks only and expects your media to be in a mounted folder.
9 #
10 # Restoration only works on a pre-installed Paperless NGX installation of the same version (or higher).
MrGeneration

MrGeneration / Backup Zammad with restic

Last active 6 months ago restic backup restore zammad

As shown on https://youtu.be/P-Pr7Dy6mP8

0 0 2
1 #!/usr/bin/env bash
2 #
3 # 2025-09-06 Marcel Herrguth
4 # As shown on https://youtu.be/P-Pr7Dy6mP8
5 # Attribution back to this GIST is required!
6 #
7 # Parts of this script are oriented from https://github.com/zammad/zammad/tree/develop/contrib/backup
8 # Only PostGreSQL is supported; No symlinks are supported
9 #
10 # Restoration only works on a pre-installed Zammad installation of the same version (or higher).
MrGeneration

MrGeneration / Search and Replace Gitlab / Github URLs in Tickets

Last active 6 months ago

These snippets allow you to search and replace either just your Gitlab / Github URL or whole group / project URLs if needed. Proceed with care, you cannot undo this operation.

0 0 2
1 # URLs below can contain project / group URLs, but have to fit as this script
2 # does a very simple search and replace.
3 # Backup first
4 old_gitlab_url = 'https://git.my-old.domain/'
5 new_gitlab_url = 'https://git.my-new.domain/'
6
7 Ticket.where("preferences LIKE '%gitlab%'").find_in_batches.each do |b|
8 b.each do |t|
9 next if t.preferences[:gitlab][:issue_links].count.zero?