CLI Postgres Tool Written in Python
This CLI PostgreSQL tool is a command-line application developed in Python using Psycopg2, designed to streamline interactions with PostgreSQL databases. It offers a range of functionalities for managing and querying database tables, making it a valuable asset for developers and database administrators who prefer a terminal-based interface.
Database Interaction:
Tables: Fetch a list of all tables within the connected PostgreSQL database.
Fetch Records: Retrieve records and metadata from a specified table, with an optional limit on the number of records.
Backup: Perform backups of individual tables to safeguard your data.
Ease of Use:
Simple command-line interface with clear, straightforward commands for efficient database management.
Programming Language:
Python: Utilized for its ease of development and powerful libraries for database interaction.
Libraries:
Psycopg2: Provides a robust interface for connecting and executing queries on PostgreSQL databases.
Dotenv: Manages environment variables for secure configuration.
Tabulate: Formats the output for better readability in the terminal.
Like this project
0
Posted Aug 4, 2024
A PostgreSQL tool that functions as a command-line application made using Python and Psycopg2. https://github.com/basperheim/cli-psycopg2
Likes
0
Views
0
Isometric 2.5D Game Engine Prototype Written in Python
Learn Programming Personal Portfolio Website
Published an NPM Package That Converts Markdown to HTML
Example 2D Game Engine Web App Made With React/Vite