# data migrations

Data migration is the process of selecting, preparing, extracting, transforming, and permanently transferring data between computer storage systems or other computing environments.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## SQL Tips for Application DBAs

DevFeed: [SQL Tips for Application DBAs](<https://devfeed.tech/articles/some-sql-tricks-of-an-application-dba-33940.md>)

Original publisher: [Read original article](<https://hakibenita.com/sql-tricks-application-dba>)

Author: Haki Benita

Published: 2020-07-26T21:00:00Z

Content type: tutorial

Language: en

Sources: [Haki Benita](<https://devfeed.tech/sources/haki-benita.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Development](<https://devfeed.tech/topics/development.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [schema design](<https://devfeed.tech/topics/schema-design.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>), [etl](<https://devfeed.tech/topics/etl.md>)

Tags: [articles](<https://devfeed.tech/tags/articles.md>), [data-migrations](<https://devfeed.tech/tags/data-migrations.md>), [databases](<https://devfeed.tech/tags/databases.md>), [development](<https://devfeed.tech/tags/development.md>), [etl](<https://devfeed.tech/tags/etl.md>), [performance](<https://devfeed.tech/tags/performance.md>), [schema-design](<https://devfeed.tech/tags/schema-design.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

An application DBA shares practical SQL and database-development advice, including limiting updates to rows that need changes and considering constraint costs when loading or updating many rows.

### Source excerpt

Some tips and misconceptions about database development I gathered along the way.

## New release: pgloader 3.2

DevFeed: [New release: pgloader 3.2](<https://devfeed.tech/articles/new-release-pgloader-3-2-34548.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2015/01/new-release-pgloader-3.2/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2015-01-16T08:35:00Z

Content type: release

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>), [Database](<https://devfeed.tech/topics/database.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>)

Tags: [command-line](<https://devfeed.tech/tags/command-line.md>), [csv](<https://devfeed.tech/tags/csv.md>), [data-migrations](<https://devfeed.tech/tags/data-migrations.md>), [error-handling](<https://devfeed.tech/tags/error-handling.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [rollback](<https://devfeed.tech/tags/rollback.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>)

### AI overview

This release announces pgloader 3.2, which simplifies common data-loading jobs from the command line. It supports migrations such as MySQL to PostgreSQL with schema discovery, type casting, cleanup, and support for indexes, keys, and comments.

### Source excerpt

PostgreSQL comes with an awesome bulk copy protocol and tooling best known as the COPY and \copy commands. Being a transactional system, PostgreSQL COPY implementation will ROLLBACK any work done if a single error is found in the data set you're importing. That's the reason why pgloader got started: it provides with error handling for the COPY protocol.