DEV Community: Whitley Legard Antoine

PostgreSQL

Whitley Legard Antoine — Thu, 10 Apr 2025 19:09:18 +0000

I did a presentation and blog on MySQL in the junior phase of a engineering program and came across another database called PostgreSQL. Now that I'm in the senior phase, I've had the opportunity to learn more about PostgreSQL and some the things it can offer. Lets take a look at some of the key points that I have learned from my research.

What is PostgreSQL?
PostgreSQL is an Open-source, relational database management system (RDBMS) that was first released in 1986. It is known for reliability, flexibility, and standards compliance. It was tarted at University of California at Berkeley by Michael Stonebraker. PostgreSQL comes from Post-Ingres was developed after the Ingres project. Ingres project was one of the first relational database management systems developed in the 1970s. PostgreSQL was first called Post-Ingres and was renamed to PostgreSQL(Post-GRE-SQL).It started as a project in 1986 with the goal of creating a database system with the minimal features needed to support multiple data types.

Why the Elephant?
PostgreSQL’s mascot is an elephant named Slonik which means little elephant in Russian. PostgreSQL is very good at keeping data safe and accurate. Like elephants never forget. It ensures your data stays reliable and intact. Elephants are known for being strong and stable, just like Postgres. Elephants are also intelligent and social which mirrors PostgreSQL’s smart design and vibrant open-source community.

Features

Free & Open-Source: No license fees and community-driven.
ACID Compliant: Ensures reliable and consistent transactions.
Extensible: You can add custom types, functions, and operators.
SQL Standard Support: follows standard SQL rules, making it compatible with other databases.
Security Features: user access control, encrypted connections (SSL), and fine-grained data access (Row-Level Security)
Performance Tools: boosts performance with faster searches, quicker queries, and the ability to handle multiple tasks at once.

Installation and Commands
Installing PostgreSQL
on unbuntu:

sudo apt update
sudo apt install postgresql postgresql-contrib

start the PostgreSQL shell with:

psql

Create a database:

CREATE DATABASE letsgeaux;

Create a table:

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  email TEXT UNIQUE NOT NULL
);

Insert data:

Insert data:INSERT INTO users (name, email)
VALUES ('Whitley', 'whitley@example.com');

Query data:

SELECT * FROM users;

Delete data:

DELETE FROM users WHERE id = 1;

Update data:

UPDATE users SET name = 'Whitley' WHERE id = 1;

Conclusion
PostgreSQL is a reliable, powerful, and flexible open-source database used by developers and companies worldwide. PostgreSQL keeps evolving and improving with its extensibility and strong community. Its advanced features, along with its ability to handle complex queries and large datasets, make it suitable for small or large projects.

Sources
https://www.bing.com/images/search?view=detailV2&ccid=ngvrPV8o&id=2393678AB1CECE331807E521A52AE33A9A1F29E7&thid=OIP.ngvrPV8oeZYqtVND9inJjwHaEK&mediaurl=https%3A%2F%2Fwebapp.io%2Fblog%2Fcontent%2Fimages%2F2019%2F11%2Fpostgres.png&cdnurl=https%3A%2F%2Fth.bing.com%2Fth%2Fid%2FR.9e0beb3d5f2879962ab55343f629c98f%3Frik%3D5ykfmjrjKqUh5Q%26pid%3DImgRaw%26r%3D0&exph=1080&expw=1920&q=postgresql+&simid=608021126569221321&FORM=IRPRST&ck=E2FF1DD7456D8F4FCA8BE51A8A3FB944&selectedIndex=2&itb=0&cw=1382&ch=626&ajaxhist=0&ajaxserp=0

https://en.wikipedia.org/wiki/PostgreSQL
https://www.postgresql.org/
https://sl.bing.net/dX9KCCXicBE
https://www.geeksforgeeks.org/difference-between-mysql-and-postgresql/
https://assets-global.website-files.com/6064b31ff49a2d31e0493af1/64550e9b8aa89a0c6cc96bb9_Postgres%20vs%20MySQL%20comparison%20table.jpg
https://www.postgresql.org/about/
https://en.wikipedia.org/wiki/PostgreSQL
https://www.w3schools.com/postgresql/index.php

Ember Essence

Whitley Legard Antoine — Sun, 30 Mar 2025 20:49:13 +0000

I came cross the name Ember.js and was curious to know more about what it actually is. I quickly discovered that is another framework used for web application, and also some of the companies I used often also use Ember.js. As I pursue a career as a software engineer, Ember.js is another framework that I can possibly add to my skillset. I would like to share what I've learned so far.

What is Ember.js?
Ember.js is a JavaScript framework for creating single-page web applications (SPAs) with dynamic and responsive user interfaces. It uses Model-View-Controller (MVC) pattern and includes helpful tools like a templating engine, a built-in router for navigation, and features to manage data and application state effectively.Ember.js was released in 2011 and was created by Yehuda Katz.

Key Concepts

Routes: The app's state is tied to URLs, with each URL having a "route object" that controls what the user sees.
Models: Each route has a model containing data for that part of the app, typically managed and loaded by Ember Data.
Templates: Define the app's HTML using HTMLBars, a version of Handlebars that directly creates DOM elements.
Components: Components are custom HTML tags that have their own behavior and look. They manage their own data and can interact with other components.
Services: Services are single-instance objects used to store long-term data, such as user sessions.

Key Features

Convention-over-Configuration: letting developers focus on features.
Ember CLI: command-line tool that helps manage projects.
Two-Way Data Binding: Changes in the model update the view, and changes in the view update the model.
Routing: handles navigation and state changes in single-page apps with nested routes and dynamic URLs.
Ember Data: Manages app data making it easy to fetch, create, update, and delete data from a server.
Templates and Handlebars: Uses the Handlebars templating engine to define dynamic HTML content.
Components: Reusable UI elements that combine logic and view.
Testing: focuses on testing by using built-in support for unit, integration, and acceptance tests to catch bugs early.

Getting Started with Ember.js

Make sure you install Node.js and npm on your system.
Install Ember CLI globally with the following command.

npm install -g ember-cli
npm install -g phantomjs

Create a New Ember Application.

ember new my-app

This will create a new Ember app with the default folder setup and settings.

Run Your Application: Go to your project folder and start the Ember server.

cd my-app
ember server

Your app will be available at http://localhost:4200.

Create Routes and Templates: You can add new routes and templates using Ember CLI:

ember generate route about

This command will create a new route for the "About" page and will have a template and JavaScript file.

Time to start building your application.

Conclusion
Ember.js is a JavaScript framework for building complex web applications.Ember.js allows you to concentrate on writing code instead of managing the framework. Ember offers tools and framework for effective development.

Sources

Python Bytes

Whitley Legard Antoine — Mon, 17 Mar 2025 03:47:50 +0000

What is Python🐍?
Python is a programming language known for its simplicity and readability. It was created by Guido van Rossum and first introduced in 1991. Python supports many programming styles, including procedural, object-oriented, and functional programming. Python is named after the British comedy television show "Monty Python’s Flying Circus", not the snake!

Key Features
Python code is executed line by line that simplifies debugging and testing. Python is beginner-friendly because of its English-like syntax and indentation-based structure. It aids in many programming styles like procedural, object-oriented, and functional programming.

Fields used in Python:

Web development
Software development
Data science and machine learning
Mathematics and scientific computing
System scripting
Artificial intelligence
Game development

Advantages

Easy to learn: simple syntax that's beginner-friendly
Versatile and open-source: used in many fields and freely available.
Enhances productivity: helps developers write faster and more efficiently.
Supports a wide range of libraries: large ecosystem of libraries for different uses
Extensive library ecosystem: large collection of already built modules and packages.
Strong community: community providing support and resources
Interpreted language: executes code line by line, simplifying debugging
Cross-platform compatibility: runs on Windows, macOS, and Linux
Scalable: scales from small scripts to large applications

Disadvantages

Design limitations: restricts some advanced use cases
Memory inefficiency: uses more memory than other languages
Weak mobile computing support: less suitable for mobile app development
Prone to runtime errors: dynamic typing may lead to runtime errors
Slower execution speed: slower than compiled languages like C or C++
Limited multi-threading: Global Interpreter Lock (GIL) limits true multi-threading for Central Processing Unit(CPU)-bound tasks

Naming Convention

Snake_case is a naming convention used in Python. All words are written in lowercase and spaces between words are replaced with underscores (_).

Python Syntax
Python uses indentation to define code blocks that makes it structured and easy to follow.

print("Hello, World!")  # Output: Hello, World!

Functions: Functions are defined using the def keyword, followed by the function name and parameters.

def greet(name):
    return f"Hello, {name}!"

print(greet("Jane"))  # Output: Hello, Jane!

Comments: Single-line comments begin with the # symbol, and multi-line comments are enclosed in triple quotes ''' or """.

# This is a single-line comment
'''
This is a
multi-line comment
'''

Variables: There is no need to declare variable types. Python automatically assigns types at runtime.

x = 15    
y = "Hello"

Conditionals and Loops: Python supports if, else, elif for conditionals, and for and while for loops.

for i in range(8):
    print(i)

Some companies that use Python include:

Dropbox
Instagram
Facebook
NASA
Pinterest
Spotify
YouTube
Uber
Airbnb

Conclusion
Python's simple and readable features make it a great choice for both beginner or experienced programmers. Its flexibility and large number of libraries make it easy to explore many areas of development.

Sources
https://en.wikipedia.org/wiki/Python_(programming_language)
https://www.python.org/
https://www.w3schools.com/python/python_intro.asp
https://www.nextacademy.com/blog/python-101-easy-to-learn-beginners/
https://sl.bing.net/jkn4sJQBmXk
https://sl.bing.net/kpfcnkn74DI
https://www.geeksforgeeks.org/python-features/
https://www.britannica.com/technology/Python-computer-language

Let's take a VUE

Whitley Legard Antoine — Mon, 03 Feb 2025 02:24:57 +0000

Vue is a open source JavaScript framework for building user interfaces and single page applications. Vue was created by Evan You in 2014 after working for google using AngularJS. It works with HML, CSS, and JavaScript, providing a component-based to build interfaces no matter the complexity.

import { createApp, ref } from 'vue'

createApp({
  setup() {
    return {
      count: ref(0)
    }
  }
}).mount('#app')
template
<div id="app">
  <button @click="count++">
    Count is: {{ count }}
  </button>
</div>

The result: count is 0;

Vue has a rich ecosystem that has many tools, libraries, and resources, making is easier and more efficient.

Vue has key features that include: reactivity, declarative rendering, components, single-file components, and flexibility.
Reactivity
Vue uses a data binding system that automatically updates the user interface when the data changes.

Declarative rendering
Vue uses an easy and very powerful templating system that lets you see how the user interface would look based on the current state of your data.

Single-file Components
Single-file Components are a special feature that allows you to define an entire component in one file. This file has the extension .vue and will have parts of a Vue component which are HTML, CSS, and JavaScript. They are separated into different sections within the same file to make it easy to control the components.
The structure will have a template, script, and style. Template contains the component's HTML. Script contains data, methods, and properties. Style contains scoped CSS for the component. All these features make it easy to manage and maintain complicated applications.

<script setup>
import { ref } from 'vue'
const count = ref(0)
</script>

<template>
  <button @click="count++">Count is: {{ count }}</button>
</template>

<style scoped>
button {
  font-weight: bold;
}
</style>

Flexibility
Vue is designed to be flexible to allow you to use many project whether its a small website or business application.
Component-Based architecture breaks down more difficult user interfaces into smaller, reusable pieces. Virtual DOM has efficient rendering that minimizes unnecessary DOM updates. Two-Way data binding will sync data between the model and user interface.

The options API and composition API are two different ways to write code in Vue.

Options API is the traditional way to write Vue component where it organizes and divide the components into options like data, methods, computed, watch, props. It gets harder to manage the options as the component grows.

export default {
  data() {
    return {
      message: 'Hello, Vue!'
    };
  },
  methods: {
    changeMessage() {
      this.message = 'Message changed!';
    }
  }
};

The Composition API that was introduced in Vue 3 gives you a more flexible way to organize logic. You can group similar code together instead of separating it into options like in the Options API.
You can reuse logic across components by creating reusable functions. It does require more more knowledge and may be challenging to understand for new users of Vue.

import { ref } from 'vue';

export default {
  setup() {
    const message = ref('Hello, Vue!');

    const changeMessage = () => {
      message.value = 'Message changed!';
    };

    return {
      message,
      changeMessage
    };
  }
};

Conclusion
Vue is a great choice for developers looking to build dynamic, interactive web applications. Its powerful features like reactivity and component-based architecture make it choice among other JavaScript frameworks. Vue can offer an efficient approach to building complex web apps to make it enjoyable.

Sources

Introduction to SQL

Whitley Legard Antoine — Sun, 26 Jan 2025 23:28:46 +0000

Introduction to SQL
SQL stands of Structured Query Language. It is programming language that is used to manage data in a relational data management system that was introduced in the 1970s. It was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce after learning about the relational model from Edgar F. Codd.
SQL was formerly knowns as SEQUEL, but later shortened SQL. SQL allows you access and manipulate databases. Oracle was the first vendor to offer a SQL management system.

SQL is used by software developers, data analysts, and data administers. These careers work with manipulating large amounts of data, and what why SQL is a great language to work with.

How does SQL work
SQL is a language used to communicate with databases. It’s used to create, modify, retrieve, and manipulate data in relational databases.
SQL can be used to create tables and interact with data in those tables.

SQL use a server to process requests for data and then it will send back results. A user will send a request with SQL query. The query is sent to the SQL server. The server searches the database. The results are returned.

SQL Query Received: A user sends a query and the SQL engine receives it from the application.
Query Parsing: The SQL engine's parser checks the syntax of the query to make sure that it’s valid. Once it's valid, the parser converts it into an internal representation called a parse tree.
Query Optimization: The optimizer checks out the query and decides the best way to execute it. The main goal it is minimize time and resources that's needed to run this query.
Query Execution: The query is executed and results are received according to the execution plan.
Data Retrieval and Storage Access: The storage engine interacts with the physical storage to get data and possibly update records.
Return Results: The SQL engine sends the results back to the user or application.

SQL Database Management Systems can be used with different Database Management Systems that offer their own way of using of SQL.

MySQL: An open-source relational database management system.
PostgreSQL: An advanced open-source database known for its ability to cover large databases.
SQL Server: A relational database developed by Microsoft.
Oracle: A widely used commercial relational database management system.

Datatypes
SQL Data Types
SQL databases support a variety of data types to define the type of data each column in a table can hold.

SQL Comments

/* This is a multi-line
comment in SQL. */

-- This is a single-line comment in SQL.

SQL Commands
SQL commands are case-insensitive and are written uppercase for clarity.
Statements end with a semicolon but it's not it is not needed.

There are four main key commands used in SQL.
SELECT is used to retrieve data.
DELETE is used to remove data.
INSERT is used to add new data.
UDPDATE is used to modify data.

-- Create Sales table

CREATE TABLE Sales (
    sale_id INT PRIMARY KEY,
    product_id INT,
    quantity_sold INT,
    sale_date DATE,
    total_price DECIMAL(10, 2)
);

-- Insert sample data into Sales table

INSERT INTO Sales (sale_id, product_id, quantity_sold, sale_date, total_price) VALUES
(1, 101, 5, '2024-01-01', 2500.00),
(2, 102, 3, '2024-01-02', 900.00),
(3, 103, 2, '2024-01-02', 60.00),
(4, 104, 4, '2024-01-03', 80.00),
(5, 105, 6, '2024-01-03', 90.00);

Output

Conclusion
Conclusion
SQL is a great programming tool for managing relational databases. You can create, manipulate, and retrieve data while keeping the data safe with great performance. SQL is the preferred language for relational database management if you are working with small or large databases.

Sources

What is Ruby?

Whitley Legard Antoine — Mon, 20 Jan 2025 01:27:36 +0000

Ruby is an object-oriented and general-purpose programming language created by Yukihiro Matsumoto (also known as Matz) in the 1990s in Japan. His main goal for creating Ruby is to make programming enjoyable. His focus was that systems design needs to emphasize human, rather than computer needs. Ruby's language was influenced by Perl, Smalltalk, and Eiffel. It is used by Github, Shopify, Twitter, Airbnb, Dribbble. Ruby's syntax is easy to learn and great for beginners.

Advantages
Ruby's is small, elegant and powerful with fewer number of lines of code.
Ruby allows simple and fast creation of Web application which means easier work.
Ruby is a dynamic programming language because of it features supports the dynamic behavior during runtime. Ruby is flexible and adaptable the way the programs are written and executed.

Anything that have a value is considered an object in Ruby and it supports powerful object-oriented concepts like inheritance, polymorphism, and encapsulation.

Ruby improves its memory through their built-in garbage collection that manages memory automatically by cleaning up unused objects.
Ruby follow the rules of duck typing where objects are identified by what they can do rather than what class they belong to.

Developers can use RubyGems to import add-ons, libraries and code packages that makes it faster to debug and authenticate.
Ruby uses a virtual machine that is part of an interpret to execute code.

Ruby is a highly flexible and powerful language because of metaprogramming which allows you to write code that can modify, define, or invoke methods, classes, and modules dynamically at runtime.

Disadvantages
Ruby is not the fastest language and runs slower than some other languages like C++ and Java, making less suitable for applications that require high performance.
Ruby takes up more memory than some other languages due to it being a dynamic, object-oriented program and garbage collection.

Ruby has scalability issues due to its design, runtime environment, performance and memory.

Syntax
Ruby's Syntax is slightly similar to Perl and Python.
Ruby has several built-in data types including strings, numbers, arrays, hashes, and Booleans. Its design is elegant, readable and easy to write.

Datatypes

# String
name = "Jane"

# Integer
age = 30



# Boolean
is_student = true

# Array
numbers = [3, 4, 5, 6]

Stings use single or double quotes.

greeting = "Hello"
name = "Jane"

Ruby use single-line and multi-line comments.

#This is a single line comment
=begin This is a double
 line comment 
=end

Hashes are (key-value pairs)

person = {
name: "Jane",
age: 30
}

Methods are defined with the def keyword and return values using the keyword return or implicitly.

def greet(name)
return "Hello" , #{name}!

put greet(Jane) #output: Hello, Jane!

Classes are written with the keyword class.
def defines the method and end close them.

class Human
def initialize (name, age)
@name = name
@age = age
end
human = new Human.new("Jane", 30)

Iterators are methods where you to loop through collections.
Here is an example of the each method.

[3, 4, 5].each do |num|
puts num
end
#output
#3
#4
#5

Loops are used to repeat a block of code multiple times until a particular condition is met or for a fixed number of iterations.

Here is an example of a for loop.

fruits = ["orange", "grapes", "apple"]
for fruit in fruits
  puts fruit
end
# Output:
# orange
# grapes
# apple

Conclusion
Ruby is an dynamic, object-oriented programming language known for it's simplicity and elegance. It's a language that can be used by beginners and experienced programmers. Ruby's focus is for the programmer to have fun and be happy.

Sources
https://en.wikipedia.org/wiki/Ruby_(programming_language)
https://www.geeksforgeeks.org/ruby-programming-language/
https://www.ruby-lang.org/en/about/

Array and Object Access

Whitley Legard Antoine — Fri, 15 Nov 2024 18:16:20 +0000

What are objects?
Objects are used to store keyed collections of various data and more complex entities. Objects are variables, but they can contain many values. An object can be created with brackets that can be empty or filled with key/value pairs. The key is a string, also called a property name, and value can be anything relating to the key. the key/value pairs are unordered. Objects can store other objects, functions, primitive data types, and arrays.

Object literal is an empty object.

var user = {};

var user = {
name: 'Carol',
age: 30,
occupation: 'Teacher'
};

Dot Notation and Bracket Notation
You can access the value property by its key. You can modify the value of the existing property of the key. You can add a new property to an object.

Dot Notation on objects
Dot Notation on objects will give you access to keys and methods of object. Dot notation is written with the object's name dot(.) the key/property.
object.key


var user = {
name: 'Carol',
age: 30,
occupation: 'Teacher'
};
console.log(user.name); //output "Carol"

To modify objects using object.key

var user = {
name: 'Carol',
age: 30,
occupation: 'Teacher'
};

user.name = 'Bonnie'
console.log(user); //
//output 

name: '"Bonnie",
age: 30,
occupation: "Teacher"

To add to objects using object.key

var user = {
name: 'Carol',
age: 30,
occupation: 'Teacher'
};
user.favColor = 'Red'
console.log(user);
//output
age: 30,
  name: "Carol",
  occupation: "Teacher",
  favColor: "Red"

Bracket Notation on objects
This expression allows you to access the object properties using a string(wrapped in quotes) or variable that holds the property name. This is useful when dot notation can not be used. Bracket notation allows you to use variables as property names, unlike dot notation
object['expression'];

var user = {
name: 'Carol',
age: 30,
occupation: 'Teacher'
};

console.log(user['name']);//output "Carol"

To modify an object

var user = {
name: 'Carol',
age: 30,
occupation: 'Teacher'
};

user['name'] = 'Bonnie'
console.log(user);
//output
name: 'Bonnie',
age: 30,
occupation: 'Teacher'
};

To add to an object

var user = {
name: 'Carol',
age: 30,
occupation: 'Teacher'
};

user['favColor'] = 'Red'
console.log(user);
//output
name: 'Carol'
age: 30
occupation: 'Teacher'
user['favColor'] = 'Red'

};

What Are Arrays?
An array can hold different values including number, string, Boolean, and null. Each value in an array is called element, and each element is accessed by its index that starts at 0. Index will give the position of an element. The elements are enclosed within in square brackets([]) and separated by commas.

Empty array literal

var user =[]

index:      0     1      2
var user = [1, 'Carol', true, ];

1 is a number and is located at the zero index.
'Carol' is string and is located at the first index.
True is a Boolean value and it's located at the third index.

Array Methods are built in JavaScript methods where you add, remove, and modify elements.

.push() allows you to add an element to the end of an array.

var vegetables = ['spinach', 'broccoli', 'green beans', 'kale'];
vegetables.push('cauliflower')
console.log(vegetables)
//output
var vegetables = ['spinach', 'broccoli', 'green beans', 'kale', 'cauliflower'];

.pop() allows you remove a value to the end of an array.

var vegetables = ['spinach', 'broccoli', 'green beans', 'kale', 'cauliflower'];
vegetables.pop()
console.log(vegetables);
//output
var vegetables = ['spinach', 'broccoli', 'green beans', 'kale'];

.unshift() allows you add a value to the front of an array.

var vegetables = ['spinach', 'broccoli', 'green beans', 'kale'];
vegetables.unshift('Brussel sprouts');
console.log(vegetables);
//output
var vegetables = ['Brussel sprouts', 'spinach', 'broccoli', 'green beans', 'kale'];

.shift() allows you to remove a value to the front of an array.

var vegetables = ['Brussel sprouts', 'spinach', 'broccoli', 'green beans', 'kale'];
vegetables.shift();
console.log(vegetables);
//output
var vegetables = ['spinach', 'broccoli', 'green beans', 'kale'];

.length() property allows to get the number of items in an array.

var vegetables = ['spinach', 'broccoli', 'green beans', 'kale'];
console.log(vegetables.length); 
//output 4

Bracket Notation on arrays
You can use bracket notation and index to get the value of an element in an array.
The index starts at 0 which will give the first element and the index 1 will give you the second element, and then the next.

var vegetables = ['spinach', 'broccoli', 'green beans', 'kale'];
vegetables[0] = 'spinach';
vegetables[1] = 'broccoli';
vegetables[2] = 'green beans'
vegetables[3] = 'kale'
console.log(vegetables[0]);
//output 'spinach'

Conclusion
Arrays and objects are both collections in JavaScript where values can be manipulated. Arrays are ordered collections of primitive data types where you can access each element with a zero based index. Array methods are used to add, remove, or modify arrays with dot notation. Bracket notation along with the zero based index to access each element. Objects are a collection of unordered complex data types use keys to access values. Dot notation is used for simple keys and bracket notation is used for more complex keys.
References:
1.https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array
2.https://www.w3schools.com/js/js_arrays.asp
3.https://javascript.info/array