How to Install PostgreSQL on Ubuntu 24.04
PostgreSQL is an open-source advanced Relational Database Management System (RDBMS) designed to hand
PostgreSQLDatabase SecurityUbuntu
SQL
June 12, 2024
By Bagaskara Guruh T
Articles in category: Database
How to Implement Case Statement Using Vultr Managed Database for PostgreSQL
PostgreSQL is a high performance database server that allows you to store common data types and use
PostgreSQLCASE StatementVultr Managed Database
SQL
December 5, 2023
By Francis Ndungu
AI Powered Search with Python and Milvus Vector Database
Vector databases are commonly used to store vector embeddings for tasks such as similarity search to
Milvus Vector DatabaseAI SearchPython
NoSQL
November 12, 2023
By Mirdul Swarup
How to Implement Apache Cassandra Driver for Python
Apache Cassandra is a fault-tolerant high-availability NoSQL database. The database server uses a di
Apache CassandraDatabase ConnectionPython
NoSQL
August 10, 2023
By Francis Ndungu
How to Install and Secure the Apache Cassandra Database Server On Ubuntu 22.04
Apache Cassandra is a free open-source NoSQL database server commonly used with distributed systems.
Apache CassandraDatabase ServerUbuntu
NoSQL
August 10, 2023
By Francis Ndungu
How to Use Triggers in PostgreSQL
Triggers in PostgreSQL allow developers to define rules and actions which can be executed without th
PostgreSQLDatabase ManagementTriggers
SQL
July 22, 2023
By Ashish Kumar Panda
How to Implement PostgreSQL Stored Procedures
In PostgreSQL, a stored procedure is a user-defined function that runs multiple queries to automate
PostgreSQLStored ProceduresDatabase Management
SQL
July 12, 2023
By Francis Ndungu
How to Encrypt Data Columns in PostgreSQL
Databases that contain sensitive information often need multiple layers of security to protect that
PostgreSQLData Encryptionpgcrypto
SQL
February 1, 2023
By Arun Nanda