Revision 2022. TARGET This tutorial is the 4th step of the series and its code evolves from the 3rd step. The target is to apply Object-Oriented and MVC architecture concepts for a Todo site using relationship, where: Todo 1 ——– + TodoItem One Todo may have one or more TodoItem instances. The concepts seen … Read More “NODE.JS: SEQUELIZE: MVC Project – 4TH STEP” »
PROBLEM This procedure resets the MariaDB root password when it is not possible to access the database returning: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES) ENV debian 10/9 10.x , 10.3.27-MariaDB SOLUTION – Stop database: sudo systemctl stop mariadb – Test: sudo systemctl status mariadb You shall get; Status: “MariaDB … Read More “MariaDB: Reset Root Password” »
ENVIRONMENT Java 13 Wildfly 18 Windows 10 / *Nix (also applicable adapting the commands) DRIVER CONFIGURATION The trick is to match the requirements of the participants. They are: – the application server’s (the way it requires the configuration) – the target database version (type of database and version) – the driver compatible with the target … Read More “WILDFLY/JBOSS: POSTGRESQL AND MYSQL DATASOURCE CONFIGURATION” »
Your current user on Windows doesn’t let you perform a PostgreSQL’s command? Some PostgreSQL commands like createdb, pg_restore, etc. works assuming the current user logged on the console (or system). This approach makes simple things; Unfortunately, many times, the current user doesn’t exist on the database, mainly when restoring legacy databases. On *Nix environment, it … Read More “POSTGRESQL: RESTORING DATABASES WITH DIFFERENT USER FROM THE CURRENT WINDOWS USER” »
Revision 2022. TARGET This tutorial is the 3rd step of the series and its code evolves from the 2nd step. The target is to apply Object-Oriented and MVC architecture concepts. The controller (the router) delivers to a business layer that accesses the persistence. FAST START FOR THE IMPATIENT – Help for linux (debian/ubuntu) install: … Read More “NODE.JS: SEQUELIZE: EVOLVING PERSISTENCE AND CREATING BUSINESS LAYER – 3RD STEP” »
Revision 2022 A SEQUELIZE TUTORIAL SPLIT INTO STEPS USING Node.js 16 AND Express This series presents a sequential tutorial evolving from the simplest approach starting from scratch that evolves to an advanced application using Node.js , Sequelize, PostgreSQL and applying advanced software engineer concepts for software development through Object-Oriented(OO) approach using MVC architecture and … Read More “NODE.JS: SEQUELIZE TUTORIAL SERIES” »
Revision 2022 TARGET Post revised at 2022. CREATING THE VIEW LAYER USING STUBS This step of the project will create a Todo list as shown in the picture above, using Bootstrap. This project evolves from the 1st step. Now, let’s follow to the 2nd step. Projects need speed, so it goes faster using multiple development … Read More “NODE.JS: VIEW USING EXPRESS AND SEQUELIZE – 2ND STEP” »
Revision 2022 TARGET Learn Sequelize constructing a project using Node.js, Express, Sequelize for persistence using PostgreSQL, MariaDB (MySQL) or another database. Source code to download using Node.js v.16: GitHub, node_sequelize_ultering_ml40643_1st_step Project developed using Node.js version 16. Node: 16.13.1 Package Manager: npm 8.5.4 OS: win32 x64 (Windows 10) SUPER FAST START USING THE CODE FROM … Read More “NODE.JS: USING SEQUELIZE – EXPRESS PROJECT 1: SUPER SIMPLE PROJECT FOR BEGINNERS – 1ST STEP” »
DEPLOY REQUIREMENTS AND ISSUES Be sure of something: if you have different environments, the same code that runs successfully were was born in, may fail on a new environment due many causes, like version differences and other system’s idiosyncrasies . So, rule of thumb: always assume that a deploy on a new environment requires full … Read More “DEPLOY: NOTES” »
NOTE: English is the usual language here on the purpose to increase sharing possibilities once it is an international language, however the information here is just about some specific brazilean stuff – the CEP, our USPC, so it was written in the native language. Certa vez andei precisando criar massa de dados em vários bancos … Read More “CEP: BASE DE DADOS DE CEP EM MYSQL, POSTGRESQL E DICAS ADICIONAIS” »
| Cookie | Duration | Description |
|---|---|---|
| cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
| cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
| cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
| cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
| cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
| viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |