Table: github_gitignore - Query GitHub Gitignore using SQL

GitHub Gitignore is a feature that specifies intentionally untracked files to ignore when using Git. These are typically files that are generated during the build process or at runtime, and are not part of the source code repository. GitHub provides a list of templates for different programming languages and environments, which can be used to generate a .gitignore file for a new project.

Table Usage Guide

The github_gitignore table provides insights into Gitignore templates available on GitHub. As a developer or a DevOps engineer, explore template-specific details through this table, including the name of the template and its source. Utilize it to discover available templates, understand their structure, and decide which one to use for your project.

Examples

List basic gitignore info

Explore the various types of gitignore files in your GitHub repositories, in an organized manner. This will help you understand the different ignore rules applied across your projects, promoting better code management.

select
  *
from
  github_gitignore
order by
  name;

select
  *
from
  github_gitignore
order by
  name;

View the source of the Go template

Uncover the details of the original Go template from GitHub. This query can help developers understand the foundation of Go programming language templates, providing a starting point for potential customization or improvement.

select
  source
from
  github_gitignore
where
  name = 'Go';

select
  source
from
  github_gitignore
where
  name = 'Go';

Schema for github_gitignore

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
login_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the user login.
name	text	=	Name of the gitignore template.
source	text		Source code of the gitignore template.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- github

You can pass the configuration to the command with the --config argument:

steampipe_export_github --config '<your_config>' github_gitignore