pg_extractor | PG Extractor - Advanced PostgreSQL Dump Filter

by omniti-labs Python Version: v2.3.8 License: No License

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | pg_extractor Summary

pg_extractor is a Python library. pg_extractor has no bugs, it has no vulnerabilities and it has low support. However pg_extractor build file is not available. You can download it from GitHub.

pgextractor is both a command line script and python class that can be used to provide more finely detailed filtering options for postgresql's pg_dump program. each database object is extracted into its own file organized into folders by type. this makes having the database schema as a reference easier and allows for better checking into version control. by default data is not dumped, but is easily done with a single option and can be done as plaintext or pg_dump's custom format. object filtering can be done directly via command line options or fed in with external text files. regex pattern matching is also possible. see --help & --examples for a full list of available options and how to use the script. the script only uses pg_dump/all to touch the database. pg_restore

Support

Quality

Security

License

Reuse

Support

pg_extractor has a low active ecosystem.

It has 151 star(s) with 31 fork(s). There are 36 watchers for this library.

It had no major release in the last 6 months.

There are 1 open issues and 27 have been closed. On average issues are closed in 238 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of pg_extractor is v2.3.8

Quality

pg_extractor has 0 bugs and 0 code smells.

Security

pg_extractor has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

pg_extractor code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

pg_extractor does not have a standard license declared.

Check the repository for any license declaration and review the terms closely.

Without a license, all rights are reserved, and you cannot use the library in your applications.

Reuse

pg_extractor releases are not available. You will need to build from source code and install.

pg_extractor has no build file. You will be need to create the build yourself to build the component from source.

Installation instructions are not available. Examples and code snippets are available.

pg_extractor saves you 507 person hours of effort in developing the same functionality from scratch.

It has 1191 lines of code, 25 functions and 2 files.

It has high code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed pg_extractor and discovered the below as its top functions. This is intended to give you an instant insight into pg_extractor implemented functionality, and help decide if they suit your requirements.

Create extract files from a list of objects
Print a list of values
Recursively replace all functions and views
Run pg_dump command
Runs a pg_restore command
Filter the main object list
Build a filter list
Create argument parser
Set configuration
Create a temporary dump file
Prints values to stdout
Print the minimum usage
Recursively replace a list of functions
Checks the version of the bin
Delete all files in the specified directory
Extract roles from database
Check the version of the bin file
Removes passwords from a role file
Cleans up temp files

Get all kandi verified functions for this library.

pg_extractor Key Features

No Key Features are available at this moment for pg_extractor.

pg_extractor Examples and Code Snippets

No Code Snippets are available at this moment for pg_extractor.

Community Discussions

Trending Discussions on pg_extractor

Speeding up a ton of short-lived `psql` sessions on Windows

QUESTION

Speeding up a ton of short-lived `psql` sessions on Windows

Asked 2019-Jul-25 at 05:57

I have inherited an application which is written in dozens (maybe hundreds, I haven't counted exactly) of PostgreSQL functions. In order to check the application code into git and be able to easily work on specific functions, I used pg_extractor to export the database into a separate file for each function.

In order to easily apply updates from git (both on developer machines and in production), I wrote a bash script that uses the psql command line client to run all of the function files, which causes the database server to be updated to match the files from git.

The gist of it looks like this (with some initialization code replaced by comments for brevity):

...

ANSWER

Answered 2019-Jul-25 at 04:32

Running the connection through PgBouncer instead of directly to Postgres makes a huge difference.

Using it, my script run on Windows is reduced to around 30 seconds.

It's still not quite as fast as on Linux, but I can live with "only" a 6x improvement.

Source https://stackoverflow.com/questions/57193662

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install pg_extractor

You can download it from GitHub.
You can use pg_extractor like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: