ACAlex Cosmasinalexcosmas.com·Oct 6, 2023 · 4 min readPostgreSQL Command ReferenceThis is a compilation of frequently used commands for administering PostgreSQL databases. The placeholders enclosed in angle brackets ("<" and ">") should be substituted with your chosen names or values. PostgreSQL provides various shortcut functions...00
ACAlex Cosmasinalexcosmas.com·Oct 6, 2023 · 1 min readHow to Move Directories in Linux"How to Move Directories in Linux Moving directories is a routine task in Linux, essential for reorganizing files, changing a directory's location, or maintaining a clean file system structure. In this guide, we will explore various efficient methods...00
ACAlex Cosmasinalexcosmas.com·Oct 6, 2023 · 2 min readPostgres commands cheat sheetConnecting to PostgreSQL: Connect to a database: psql -U username -d dbname Connect to a database with host and port: psql -U username -d dbname -h hostname -p port Database Operations: Create a new database: CREATE DATABASE dbname; Delete a da...00
ACAlex Cosmasinalexcosmas.com·Oct 5, 2023 · 2 min readHow to Create a Simple Static Website Using Phoenix Framework 1.6$ mix phx.new sample_app --no ecto $ cd sample_app/ We will first create a controller to handle static pages name Static Page Controller. This will be designated by the name StaticPage.We will create actoins for Home page, a Help page, and an Abou...00
ACAlex Cosmasinalexcosmas.com·Oct 5, 2023 · 11 min readMake sense of PhoenixPhoenix is a modern web development framework built with the Elixir programming language. Elixir is a functional programming language that runs on the Erlang Virtual Machine (BEAM), which is known for its scalability and fault tolerance.Phoenix is a ...00