Skip to content

Instantly share code, notes, and snippets.

@timabell
Last active March 16, 2022 13:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timabell/6874ab9c58797bd3a1af82769b355a26 to your computer and use it in GitHub Desktop.
Save timabell/6874ab9c58797bd3a1af82769b355a26 to your computer and use it in GitHub Desktop.
An idea for a default peek configuration for http://schemaexplorer.io/
# http://schemaexplorer.io/
# This file configures which columns will be loaded from the other side of a foreign key.
# Place this file in folder `config` next the schema explorer executable and name it peek-config.txt, or use the `-peek-config-file` option to pass the path to it.
# Lines starting with # will be ignored along with blank lines.
# Names are lowercased before matching so make sure your all your regexes below are entirely lowercase otherwise they won't match.
# Each line is a golang regex https://golang.org/pkg/regexp/ that will be matched against schema.table.column, (table.column for sqlite)
# schema/table/column names are converted to lower-case before comparing with the below regexes
# Customise this file to suit your database (but make sure you keep your copy when upgrading schema explorer).
# Some sensible defaults to peek
name
\.title$
\.code$
\.email$
# Examples:
# ^finance\.invoices\.invoice_date$ - match exactly one column in one table
# ^public\..*\..*code.*$ - match any column with "code" in the name, but only in the "public" schema
# name - match any column with "name" in the name (but will match everything if you happen to have name in your schema or table)
# \.title$ - match any column called title
# \.code$ - match any column called code
# \.email$ - match any column called email
# Why not share yours to help others, you can fork this one from https://gist.github.com/timabell/6874ab9c58797bd3a1af82769b355a26
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment