All Projects → aaparmeggiani → Pg_tail

aaparmeggiani / Pg_tail

Licence: mit
' tail -f ' your PostgreSQL tables.

Programming Languages

c
50402 projects - #5 most used programming language

Projects that are alternatives of or similar to Pg tail

Stern
⎈ Multi pod and container log tailing for Kubernetes -- Friendly fork of https://github.com/wercker/stern
Stars: ✭ 268 (+152.83%)
Mutual labels:  logging, tail
Remote Tail
RemoteTail用于同步监控多台服务器日志文件变更,一句话说就是多主机的远程tail。
Stars: ✭ 166 (+56.6%)
Mutual labels:  logging, tail
Tail
[Revamped] Go package for reading from continuously updated files (tail -f)
Stars: ✭ 81 (-23.58%)
Mutual labels:  logging, tail
Utern
Multi group and stream log tailing for AWS CloudWatch Logs.
Stars: ✭ 241 (+127.36%)
Mutual labels:  logging, tail
Stern
⎈ Multi pod and container log tailing for Kubernetes
Stars: ✭ 5,614 (+5196.23%)
Mutual labels:  logging, tail
Aspnetcorenlog
ASP.NET Core NLog MS SQL Server PostgreSQL MySQL Elasticsearch
Stars: ✭ 54 (-49.06%)
Mutual labels:  postgresql, logging
Kail
kubernetes log viewer
Stars: ✭ 1,259 (+1087.74%)
Mutual labels:  logging, tail
Activerecord Clean Db Structure
Automatic cleanup for the Rails db/structure.sql file (ActiveRecord/PostgreSQL)
Stars: ✭ 101 (-4.72%)
Mutual labels:  postgresql
Pg flame
A flamegraph generator for Postgres EXPLAIN ANALYZE output.
Stars: ✭ 1,391 (+1212.26%)
Mutual labels:  postgresql
Maha
A framework for rapid reporting API development; with out of the box support for high cardinality dimension lookups with druid.
Stars: ✭ 101 (-4.72%)
Mutual labels:  postgresql
Periods
PERIODs and SYSTEM VERSIONING for PostgreSQL
Stars: ✭ 101 (-4.72%)
Mutual labels:  postgresql
Openseedbox
OpenSeedbox - Open Source Multi-User Bittorrent Web UI
Stars: ✭ 101 (-4.72%)
Mutual labels:  postgresql
Spring Boot 2.x Examples
Spring Boot 2.x code examples
Stars: ✭ 104 (-1.89%)
Mutual labels:  postgresql
Terraform Provider Postgresql
As part of our introduction to self-service publishing in the Terraform Registry, this copy of the provider has been archived, and ownership has been transferred to active maintainers in the community. Please see the new location on the Terraform Registry: https://registry.terraform.io/providers/cyrilgdn/postgresql
Stars: ✭ 101 (-4.72%)
Mutual labels:  postgresql
Serverless Postgraphql
Serverless GraphQL endpoint for PostgresSQL using AWS, serverless and PostGraphQL
Stars: ✭ 105 (-0.94%)
Mutual labels:  postgresql
Apex Unified Logging
Platform-Event-based Apex logger for unified logging over transaction boundaries
Stars: ✭ 101 (-4.72%)
Mutual labels:  logging
Illuminati
This is a Platform that collects all the data accuring in your Application and shows the data in real time by using Kibana or other tools.
Stars: ✭ 106 (+0%)
Mutual labels:  logging
P6spy
P6Spy is a framework that enables database data to be seamlessly intercepted and logged with no code changes to the application.
Stars: ✭ 1,567 (+1378.3%)
Mutual labels:  logging
Rsyslog
a Rocket-fast SYStem for LOG processing
Stars: ✭ 1,385 (+1206.6%)
Mutual labels:  logging
Kotlin Logging
Lightweight logging framework for Kotlin. A convenient and performant logging library wrapping slf4j with Kotlin extensions
Stars: ✭ 1,378 (+1200%)
Mutual labels:  logging

pg_tail

Watches last lines of a PostgreSQL table like in a "tail -f".
( inspired by mysqltail )

Install

macOS

brew install aaparmeggiani/tap/pg_tail

generic Unix

PostgreSQL is needed and make sure yours have pg_config and libpq.

git clone https://github.com/aaparmeggiani/pg_tail.git
cd pg_tail
make
make install

Usage

% pg_tail [OPTIONS] -t TABLE -c uKEY[,COL1,..,COLn]

Options:
    -d, --dbname=DBNAME         database to connect to
    -h, --host=HOSTNAME         database server host or socket directory
    -p, --port=PORT             database server port number
    -U, --username=NAME         connect as specified database user
    -W, --password              prompts for the user password


    -t, --table=TABLE           table to watch
    -c, --columns=COL1..COLn    columns to watch, the first one must be an ordered primary key (sequence)
    -i, --interval=SECONDS      database polling interval in seconds (default: 10)
    -s, --separator=CHAR        sets a column delimiter (an no column alignment)
    -n  NUM                     number of lines in the first polling (default: 5)
    -v, --version               version info

Example

% pg_tail -d database -t users -c id,login,email
id | login  | email              |
1  | system | [email protected] |
2  | global | [email protected] |
3  | teller | [email protected] |

Dockerized

Docker Build Status Image Info

docker run -it --init --rm aaparmeggiani/pg_tail -h host -d database -U user -t table -c key

(don't forget --init or you'll find yourself trapped without ctrl-c =)

License

MIT

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].