alchemydumps | SQLAlchemy backup/dump tool for Flask | Continuous Backup library

by cuducos Python Version: Current License: MIT

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

kandi X-RAY | alchemydumps Summary

alchemydumps is a Python library typically used in Backup Recovery, Continuous Backup applications. alchemydumps has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. However alchemydumps build file is not available. You can install using 'pip install alchemydumps' or download it from GitHub, PyPI.

Do you use Flask with SQLAlchemy? Wow, what a coincidence!. This package lets you backup and restore all your data using SQLAlchemy dumps() method. It is an easy way (one single command, I mean it) to save all the data stored in your database. You can save it locally or in a remote server via FTP. WARNING @baumatron've found an important bug: at this time this package won't backup non-standard mappings, such as many-to-many association tables. This is still an open issue and I have no expectation to fix is in the following weeks — pull requests are more tham welcomed.

Support

Quality

Security

License

Reuse

Support

alchemydumps has a low active ecosystem.

It has 88 star(s) with 24 fork(s). There are 8 watchers for this library.

It had no major release in the last 6 months.

There are 6 open issues and 14 have been closed. On average issues are closed in 76 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of alchemydumps is current.

Quality

alchemydumps has 0 bugs and 0 code smells.

Security

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

alchemydumps code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

alchemydumps is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

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

Deployable package is available in PyPI.

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

Installation instructions, examples and code snippets are available.

alchemydumps saves you 383 person hours of effort in developing the same functionality from scratch.

It has 911 lines of code, 90 functions and 18 files.

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

Top functions reviewed by kandi - BETA

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

Manage backups
Yield all files that match the given timestamp
Extract timestamp from a file name
Get timestamps
Restore the data from the database
Get all mapped models
Add subclasses of a model
Return the name of the file
Run the filter
Returns the length of the last month
Returns the length of the last year
Filter dates according to the given period
Connect to FTP server
Change ftp
Delete files
Check if a file is valid
Create backup files
Returns a dictionary of mapped mappings
Show list of backups

Get all kandi verified functions for this library.

alchemydumps Key Features

No Key Features are available at this moment for alchemydumps.

alchemydumps Examples and Code Snippets

No Code Snippets are available at this moment for alchemydumps.

Community Discussions

Trending Discussions on alchemydumps

How to backup up a Sqlalchmey database?

QUESTION

How to backup up a Sqlalchmey database?

Asked 2019-Jul-11 at 15:10

I am trying to backup a database through sqlachemy and save it as a file. I tried using the extension, Flask-AlchemyDumps, but it appears to no longer be supported.

I musted be missing something obvious as this is surly an action a lot of developers want to do. Does anyone know how I should be backing up the database?

Thanks in advance

J Kirkman

...

ANSWER

Answered 2019-Jul-11 at 15:10

SQLAlchemy is an ORM which sits between your code and the database. It's useful if you want to interact with specific rows and relationships without having to keep track of lots of ids and joins.

What you're looking for is a way to dump the entire contents of your DB to disk, presumably so you can restore it later/elsewhere. This is a bulk action, which is your first clue that an ORM may not be a suitable tool. (ORMs tend to be fast enough for small to medium operations, but slow and not ideal for actions which affect 10s of 1000s of rows at once.) And indeed, this isn't usually something you'd use an ORM for, it's a feature of your DB, presumably Postgres or MySQL. If you happen to be using Heroku, you can use their command line tool to do this.

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

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

Vulnerabilities

No vulnerabilities reported

Install alchemydumps

First install the package: pip install Flask-AlchemyDumps. Then pass your Flask application and SQLALchemy database to it.
The second line imports the object from the package.
The last line instantiates AlchemyDumps for your app and database.

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: