Skip to content
  • Home
  • Search
  • Tools
  • About
  • Terms of Service Agreement
  • Log In
  • Guest

Category: database

NODE.JS: SEQUELIZE: MVC Project – 4TH STEP

Posted on June 18, 2022October 15, 2022 By Andre Dias
data persistence, database, javascript, web design

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” »

MariaDB: Reset Root Password

Posted on December 15, 2020December 20, 2020 By Andre Dias
database

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” »

WILDFLY/JBOSS: POSTGRESQL AND MYSQL DATASOURCE CONFIGURATION

Posted on April 30, 2020August 30, 2020 By Andre Dias
database, server

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” »

POSTGRESQL: RESTORING DATABASES WITH DIFFERENT USER FROM THE CURRENT WINDOWS USER

Posted on April 29, 2020August 30, 2020 By Andre Dias
database

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” »

NODE.JS: SEQUELIZE: EVOLVING PERSISTENCE AND CREATING BUSINESS LAYER – 3RD STEP

Posted on March 26, 2020June 24, 2022 By Andre Dias
data persistence, database, javascript, node.js, web design

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” »

NODE.JS: SEQUELIZE TUTORIAL SERIES

Posted on March 24, 2020June 21, 2022 By Andre Dias
database, javascript

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” »

NODE.JS: VIEW USING EXPRESS AND SEQUELIZE – 2ND STEP

Posted on March 9, 2020June 24, 2022 By Andre Dias
database, javascript

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” »

NODE.JS: USING SEQUELIZE – EXPRESS PROJECT 1: SUPER SIMPLE PROJECT FOR BEGINNERS – 1ST STEP

Posted on March 7, 2020June 23, 2022 By Andre Dias
database, javascript

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: NOTES

Posted on November 26, 2018March 19, 2020 By Andre Dias
database, devops, sql

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” »

CEP: BASE DE DADOS DE CEP EM MYSQL, POSTGRESQL E DICAS ADICIONAIS

Posted on February 12, 2018March 19, 2020 By Andre Dias
database

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” »

Posts pagination

1 2 Next

Search

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Filter by Categories
angular
bootstrap
browser
computer science
container
data persistence
database
devops
editors
hardware
health
hosting
info
internet
it
java
javascript
network
node.js
play
protocol
security
self-help
selfhelp
server
services
soft
software engeneering
sql
support
Systems
techs
Uncategorized
versioning
web
web design
windows
wordpress

Recent Posts

  • Angular From Scratch Tutorial – Step 9: Modal
  • Angular From Scratch Tutorial – Step 8: Miscellany
  • Angular From Scratch Tutorial – Index
  • angular: Reading JSON files
  • NODE.JS: SEQUELIZE: MVC Project – 4TH STEP

Categories

  • angular (19)
  • bootstrap (6)
  • browser (4)
  • computer science (4)
  • container (1)
  • data persistence (2)
  • database (11)
  • devops (1)
  • editors (1)
  • hardware (4)
  • health (2)
  • hosting (1)
  • info (1)
  • internet (2)
  • it (1)
  • java (13)
  • javascript (32)
  • network (6)
  • node.js (1)
  • play (1)
  • protocol (1)
  • security (4)
  • self-help (1)
  • selfhelp (1)
  • server (2)
  • services (1)
  • soft (1)
  • software engeneering (1)
  • sql (1)
  • support (2)
  • Systems (1)
  • techs (3)
  • Uncategorized (2)
  • versioning (6)
  • web (1)
  • web design (5)
  • windows (3)
  • wordpress (4)

Copyright © 2025 .

Theme: Oceanly by ScriptsTown

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
Cookie SettingsAccept All
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis 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-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis 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-others11 monthsThis 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-performance11 monthsThis 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_policy11 monthsThe 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.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT