- After exploring the wordpress modernization I was given another task to work on updating another old website using wordpress
- See results below:
OLD:

NEW:


By Abdurrahmaan
By Abdurrahmaan
Docker is a platform that is used to package applications into images
The reason for this are to help avoid version conflicts and ensure functionality of those using the image
Examples:


credit: https://www.docker.com/
Woodpecker is a CI/CD tool (continuous integration / continuous delivery) that is made to automatically update sites as changes are made

credit: https://woodpecker-ci.org/docs/usage/intro


credit: https://roots.io/bedrock/


credit: https://documentation.suse.com/cloudnative/rancher-manager/v2.15/en/about-rancher/overview.html







credit: https://rancherdesktop.io/



By Abdurrahmaan
I first started to take a look at the STA knowledge base around the time I was being hired, I was interested in improving the details and joined a project to help redesign our old STA KB internal site









By Abdurrahmaan
Below are some of the integrations that the my local LLm could support:










By Abdurrahmaan

NEW:

By Abdurrahmaan
Day one as an STA at LAITS, I was introduced to a software known as Airtables: In Airtables, we are able to see all the sites hosted by LAITS, their associated frameworks, versions developers and the links to them (Note: for the purposes of the post I have recreated demo data following the format)




Below is an example of the Readme for the self hosted Sites on how to interact with users (opened in the VScode IDE):

Here is an example of how that is seen in a database:

There a couple of important items to take a look at in regards to databases, we see here foreign keys, indexes, and triggers
In my example I did not implement any of these, but the idea is that there is a set of tables in a database that interconnect in a schema known as an Entity Relationship Diagram (ERD)
Example below:

Credit: https://www.red-gate.com/blog/schema-diagram/
There are 3 different relationships/ways a database can interconnect based on each datapoint:
Foreign keys are columns in a database that reference the head of another table indicating a connection between the two tables within the database
Indexes are a selection of values in a database that are stored in a smaller list for quick access, this can be done with specific data structures to increase the speed and efficiency of referencing common elements in a database
Any interaction that causes changes in long term data causes a process to run in the database the core of these operations is referenced as CRUD
The significant purpose is to set protocols that occur in reaction to these operations in order to maintain a database
Ex.
Data Definition Language (DDL) triggers run when commands like CREATE, ALTER or DROP are used. They help track or stop changes to the database structure, such as creating, modifying or deleting tables.
Example: Prevent Table Deletions
CREATE TRIGGER prevent_table_creation
ON DATABASE
FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE
AS
BEGIN
PRINT 'you can not create, drop and alter table in this database';
ROLLBACK;
END;
Triggers can automatically perform tasks when data changes in a table. For example, in a student database, when a student’s grades are updated, the total score should also be updated automatically.
CREATE TRIGGER update_student_score
AFTER UPDATE ON student_grades
FOR EACH ROW
BEGIN
UPDATE total_scores
SET score = score + :new.grade
WHERE student_id = :new.student_id;
END;
credit: https://www.geeksforgeeks.org/sql/sql-trigger-student-database/

Templates that can be edited to interact with the way a site looks. The way it is displayed and its default visual behavior.
Add-ons to WordPress sites that can add to or change WordPress functionality