Loading data into PostgreSQL
pgloader is a data loading tool for PostgreSQL, using the COPY command.
Its main avantage over just using COPY or \copy and over using a Foreign Data Wrapper is the transaction behaviour, where pgloader will keep a separate file of rejected data and continue trying
... [More] to copy good data in your database.
The default PostgreSQL behaviour is transactional, which means that any erroneous line in the input data (file or remote database) will stop the bulk load for the whole table.
pgloader also implements data reformating, the main example of that being a transformation from MySQL dates 0000-00-00 and 0000-00-00 00:00:00 to PostgreSQL NULL value (because our calendar never had a year zero). [Less]
Stamina is an Akka serialization toolkit written specifically for use with Akka Persistence. It has a strong focus on long-term viability of your persisted data so it provides support for versioning that data, auto-migrating that data at read time to be compatible with your current event and domain
... [More] classes, and a testkit to make sure all older versions of your persisted data are still readable. [Less]
mschematool is a simple tool for managing database migrations. Migrations are native SQL/CQL scripts or Python modules. Configuration is a Python module.
Supports PostgreSQL, SQLite3 and Apache Cassandra.
This site uses cookies to give you the best possible experience.
By using the site, you consent to our use of cookies.
For more information, please see our
Privacy Policy