Posts

PostgreSQL guide Connection Commands psql Definition: The PostgreSQL interactive terminal for connecting to a PostgreSQL database. Usage: 1 psql -h hostname -p port -U username -d database \connect (or \c) Definition: Connects to a new database and/or under a different user. Usage: 1 \\c database_name [username] \password Definition: Changes the password for the currently connected user. Usage: 1 \\password [username] \conninfo Definition: Displays information about the current database connection. ...

Angular basics What is angular and what workflows is it ideal at? Angular is a platform and framework for building single-page client applications using HTML and TypeScript. Developed and maintained by Google. t is designed to make the development and testing of such applications easier by providing a framework for client-side MVC (Model-View-Controller) architecture. Installing Angular from scratch involves setting up your development environment, which includes installing Node.js, the Angular CLI (Command Line Interface), and creating a new Angular project. Here’s a step-by-step guide to get you started: ...

C# Basics C# is a versatile programming language developed by Microsoft, widely used for building a variety of applications, from web to desktop and mobile. This post covers the basics of C#, including syntax, data types, and object-oriented programming concepts. Dotnet is a framework that supports C# and provides a rich set of libraries and tools for developers. Creating an application Dotnet provides a cli to create applicaitons. The entrypoint will always be Program.cs, here are the types of applications that the dotnet CLI helps to create ...

PHP What is php? PHP (Hypertext Preprocessor) is a widely-used open-source scripting language that is especially suited for web development and can be embedded into HTML. Here’s a breakdown: Server-Side Scripting: PHP code is executed on the server, and the results are sent to the user’s web browser as HTML. This contrasts with client-side scripting languages like JavaScript, which are executed in the browser. Dynamic Web Pages: PHP allows you to create dynamic web pages that can change content based on user input, database information, or other factors. Database Interaction: PHP can connect to various databases (like MySQL, PostgreSQL, and Oracle) to store and retrieve data. This is essential for building web applications that require data management. Open Source: PHP is open-source, meaning it’s free to use and distribute. This has contributed to its widespread adoption. Cross-Platform: PHP runs on various operating systems, including Windows, Linux, and macOS. Uses: Building websites and web applications Developing e-commerce platforms Creating content management systems (CMS) like WordPress, Drupal, and Joomla Handling form data Generating dynamic page content. Basics PHP Start and End Tags: These tags (<?php and ?>) are essential for embedding PHP code within HTML or other text-based files. The PHP interpreter only processes the code located between these tags. ...

Github actions What is github actions? Github actions is a tool baked inside github that facilitates ci/cd operations on github. It can provide all the operations including building and hosting webpages, providing important pust notifications when an important release is made and other updates. Getting started with the basics Github actions GitHub Actions lets you define workflows using YAML files, which are stored in your repository under the .github/workflows/ directory. A workflow consists of one or more jobs, and each job contains steps (commands or scripts) that run on a virtual machine (called a runner). ...