Tag : Database πŸ—ƒοΈ

A database is an organized collection of data, generally stored and accessed electronically from a computer system. The database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. Relational databases model data as rows and columns in a series of tables, and the vast majority use SQL for writing and querying data.

“Database” Wikipedia


Upgrading PostgreSQL from version 10 to 11 on Ubuntu 19.04 (Disco Dingo)

Howto guide for upgrading PostgreSQL from version 10 to 11 on Ubuntu, after its upgrade from version 18.10 to 19.04.

Logos of Ubuntu and PostgreSQL

 2019-05-28   3 min read      Howto   #Database πŸ—ƒοΈ #Debian πŸ₯ #PostgreSQL 🐘 #Ubuntu πŸ‘₯


Continue reading

Updating a Django queryset with annotation and subquery

How-To guide to update a Django queryset with annotation and subquery

Photo of Cerrano beach in Abruzzo, Italy

 2018-10-01   2 min read      Article   #Database πŸ—ƒοΈ #Django πŸ¦„ #Python 🐍 #SQL πŸ†”


Continue reading

Upgrading PostgreSQL from 9.6 to 10.0 on Ubuntu 18.04

How-To guide to upgrade PostgreSQL from 9.6 to 10.0 on Ubuntu after upgrade it to 18.04 version.

Logos of Ubuntu and PostgreSQL

 2018-05-19   3 min read      Howto   #Database πŸ—ƒοΈ #Debian πŸ₯ #PostgreSQL 🐘 #Ubuntu πŸ‘₯


Continue reading

Full-Text Search in Django with PostgreSQL

Article based on my talk about Full-Text Search in Django with PostgreSQL.

Logos of Django and PostgreSQL

 2017-12-22   11 min read      Article   #Conference πŸ—£οΈ #Database πŸ—ƒοΈ #Django πŸ¦„ #Full-text search πŸ” #PostgreSQL 🐘 #Python 🐍 #SQL πŸ†” #Talk πŸ’¬


Continue reading

Upgrading PostgreSQL from 9.5 to 9.6 on Ubuntu 17.04

How-To guide to upgrade PostgreSQL from 9.5 to 9.6 on Ubuntu after upgrade it to 17.04 version.

Logos of Ubuntu and PostgreSQL

 2017-04-14   2 min read      Howto   #Database πŸ—ƒοΈ #Debian πŸ₯ #PostgreSQL 🐘 #Ubuntu πŸ‘₯


Continue reading