Anuncios Libros Cursos Categorías

Bucardo: the replication system for PostgreSQL

22-05-2023 - Andrés Cruz

Bucardo: the replication system for PostgreSQL

Base de Datos As the title for this post specifies, Bucardo is a replication system that in other words allows you to "clone" or "duplicate" records from a Database to other Databases (source-target).

Continuar leyendo


Synchronizing the sequences with Bucardo

21-05-2023 - Andrés Cruz

Synchronizing the sequences with Bucardo

Base de Datos In this entry I will show you how to synchronize the sequences of a Postgresql Database using Bucardo.

Continuar leyendo


Defining enum columns in migrations for CodeIgniter 4

27-04-2023 - Andrés Cruz

Defining enum columns in migrations for CodeIgniter 4

Base de Datos We will explain how to use the enums types for our columns in the definition of migrations in CodeIgniter 4.

Continuar leyendo


Database join queries in CodeIgniter 4

25-04-2023 - Andrés Cruz

Database join queries in CodeIgniter 4

Base de Datos We will see how we can use joins to join tables in CodeIgniter 4

Continuar leyendo


Foreign relations in CodeIgniter 4

24-04-2023 - Andrés Cruz

Foreign relations in CodeIgniter 4

Base de Datos We will learn how to work with foreign type relationships in CodeIgniter 4; from the definition of the migrations, to its use from the models.

Continuar leyendo


Backup of the database in CodeIgniter (includes CSV)

19-04-2023 - Andrés Cruz

Backup of the database in CodeIgniter (includes CSV)

Base de Datos Learn how to fully or partially export your database through a query in CodeIgniter

Continuar leyendo


Migrations in CodeIgniter 4

18-04-2023 - Andrés Cruz

Migrations in CodeIgniter 4

Base de Datos We are going to know and work with the migrations to generate our tables in the database using CodeIgniter 4.

Continuar leyendo


Delete records in CodeIgniter 4

16-04-2023 - Andrés Cruz

Delete records in CodeIgniter 4

Base de Datos We are going to see how we can delete records from the database using CodeIgniter 4.

Continuar leyendo


Create a list or table view in CodeIgniter 4 styled in Bootstrap 4 or 5

15-04-2023 - Andrés Cruz

Create a list or table view in CodeIgniter 4 styled in Bootstrap 4 or 5

Base de Datos We are going to know how we can create the list of records in a table using CodeIgniter 4, this list will be paginated and it is a fundamental element for our CRUD.

Continuar leyendo


FOREIGN_KEY_CHECKS for rollback of foreign key type migrations in Laravel

04-04-2023 - Andrés Cruz

FOREIGN_KEY_CHECKS for rollback of foreign key type migrations in Laravel

Base de Datos We will see how to deal with a common error when working with migrations in Laravel, which happens when we rollback them.

Continuar leyendo