Forem: Bento

How to Talk to AI (and Get Better Results)

Bento — Tue, 03 Jun 2025 22:59:15 +0000

Summary

Introduction
Context
First Example
Second Example
Third Example
Conclusion

Introduction

This short article aims to help beginner and curious users understand a simple approach to using AI effectively.

First of all, I'm not an AI expert, just someone who's curious about it and wants to help others make use of it. I'm doing this for fun, but I hope it ends up being helpful to someone out there!

Context

Most sources emphasize that you need to provide context when asking AI questions to get accurate answers. However, what many don’t mention is that you can actually ask the AI itself what context or background information you should include to improve the quality of its response. This way, even if you’re unsure what details are relevant, the AI can guide you on how to frame your request for the best possible results.

First Example

No context

Prompt:

Generate a image of a japanese city

Result:

No context, generic prompt, generic result.

Second Example

Asking to AI

First Prompt:

I want to generate an image of Japan. What should I say to you?

First Result:

To generate an image of Japan, you just need to describe what you want to see in the image. Here are a few examples of prompts you could give me:

General:

"Generate an image of Japan during cherry blossom season."
"Create a scenic image of Mount Fuji at sunrise."
"Show a street in Tokyo at night with neon signs and people walking."

More Specific Ideas:

"A traditional Japanese village with wooden houses and a Shinto shrine in autumn."
"A futuristic Tokyo skyline with flying cars and digital billboards."
"A peaceful Japanese Zen garden with raked gravel and bonsai trees."
"A snowy scene of a Japanese onsen (hot spring) in the mountains."

Optional Add-ons:

You can also mention:
Time of day (sunset, night, etc.)
Season (spring, winter, etc.)
Style (realistic, watercolor, anime, cyberpunk, etc.)

Just let me know what you have in mind—or I can suggest a few variations based on your interests!

Second Prompt:

A traditional Japanese city with wooden houses and a Shinto shrine during autumn, at sunset, in a realistic style.

Second Result:

Context, detailed prompt, detailed result.

Third Example

Asking to AI

First Prompt:

I want to cook something. How can you help me with that?

First Result:

Awesome! I can help you cook by:

Suggesting recipes based on what ingredients you have.
Guiding you step-by-step through a recipe.
Offering cooking tips or substitutions if you’re missing something.
Helping plan a menu or dietary preferences.
Providing quick recipes if you’re short on time.

What kind of cooking are you in the mood for? Do you have any ingredients on hand or any cuisine you’re craving?

Second Prompt:

I have a few eggs, some meat, and rice

Second Result:

Nice! With eggs, meat, and rice, you’ve got a solid base for several tasty dishes. Here are a few ideas:

Fried Rice with Meat and Eggs
Quick, flavorful, and you can toss in veggies if you have any.

Meat and Egg Stir-fry with Rice
Cook the meat and scramble the eggs, serve over steamed rice.

Meat and Egg Rice Bowl
Cook the meat with seasonings, fry or scramble the eggs, and serve on top of rice with some sauce.

Stuffed Meat and Egg Omelet with Rice on the side
Make an omelet with scrambled eggs and cooked meat inside, served with rice.

Would you like a detailed recipe for any of these, or maybe something else? Also, what type of meat do you have? That can help me tailor the recipe better!

Conclusion

If you want better results but aren’t sure how to clearly explain what you need, don’t worry! You can simply ask the AI itself for guidance on the best way to approach your request. The AI can help you figure out how to phrase your question or what information to provide, making it easier to get accurate and useful responses. This way, even if you’re unsure where to start, the AI can guide you step-by-step toward getting the results you want.

Generating Keyframes with ChatGPT 4o

Bento — Sun, 30 Mar 2025 11:31:21 +0000

Summary

The Problem
Generating Base Sprite
Generating 9 keyframes
Generating 18 keyframes
Generating 36 keyframes
Conclusion

First of all, I'm not a game developer or a designer. I'm just doing this for fun, but I hope it helps someone out there!

The Problem

Since the new version of ChatGPT seems better at maintaining consistency when creating images, I tried to apply that same consistency when generating keyframes to use in a GIF.

I spent several hours experimenting and refining the prompts to keep things consistent within a single image and across different generated images. The results of those hours of trial and error are shared in this article.

Generating Base Sprite

To generate the base sprite, I started with a random image and used the following prompt.

Create a detailed pixel art sprite for a game, use the guy in the photo as a base. 
I need a basic pose with full body to use in frames generation later.
The image should have a blank background.

With that prompt i generate these 3 base sprites

Druid

Wizard

Wizard 1

Generating 9 keyframes

Generating 9 keyframes isn't that difficult, I just uploaded the Druid and used the following prompt.

Keep the uploaded guy image as a base for the wizard
Create a detailed pixel art animation for a game, divided clearly into a 3x3 grid (each individual frame exactly 300px by 300px), forming a continuous 9-frame animation sequence.

Depict a wizard performing a spellcasting sequence, beginning with intricate hand motions, conjuring a vibrant fireball, and concluding with the dramatic release of the spell. Ensure each keyframe transitions smoothly and continuously into the next, clearly illustrating the wizard’s action.

Frame Sequence and Layout:  
Frames should be arranged from left-to-right, top-to-bottom:

Row 1: Frames 1 → 2 → 3  
Row 2: Frames 4 → 5 → 6  
Row 3: Frames 7 → 8 → 9

Detailed Frame-by-Frame Description:  

- Frame 1: Wizard standing idle, hands lowered naturally at sides.
- Frame 2: Wizard begins raising both hands upward, initiating the spell.
- Frame 3: Hands fully raised; a small glowing fireball starting to form between the palms.
- Frame 4: Fireball glow intensifies significantly, clearly visible between wizard’s hands.
- Frame 5: Fireball fully formed, bright and vibrant, floating prominently between wizard’s palms.
- Frame 6: Wizard starts pushing hands forward, actively casting the fireball outward.
- Frame 7: Fireball clearly leaving the wizard’s hands, trailing vibrant streams of energy.
- Frame 8: Fireball mid-air, glowing intensely, fully separated from wizard.
- Frame 9: Fireball reaches far-right edge of frame; wizard slightly leaned forward, clearly completing the spellcasting motion.

The result are these 9 keyframes:

Result image:

Result gif:

Sounds good, but I wanted more.

Generating 18 keyframes

Generating 18 keyframes is a bit more challenging, maintaining consistency across multiple images isn’t easy. I came up with these prompts, it’s not perfect, but it worked.

Prompt 1

Ensure character maintains exact same proportions, style, colors, and position as previous sprite.
Create a detailed pixel art animation for a game, divided clearly into a 3x3 grid (each individual frame exactly 300px by 300px), forming a continuous 9-frame animation sequence.

Frames 1–3: Druid stands still, trees gently swaying, arms beginning to rise.
Frames 4–6: Leaves swirl, mouth moves in slow chant, magical energy builds.
Frames 7–9: Vines shoot from the earth in spirals, reaching outward.

Ensure each keyframe transitions smoothly and continuously into the next, clearly illustrating the Druid action. 

Frame Sequence:   
Frames should be arranged from left-to-right, top-to-bottom:

Row 1: Frames 1 → 2 → 3  
Row 2: Frames 4 → 5 → 6  
Row 3: Frames 7 → 8 → 9

Prompt 2

Ensure character maintains exact same proportions, style, colors, and position as previous sprite.
Create a detailed pixel art animation for a game, divided clearly into a 3x3 grid (each individual frame exactly 300px by 300px), forming a continuous 9-frame animation sequence.

Frames 1–3: Flowers bloom quickly along the vines and around the druid.
Frames 4–6: A bright, green pulse of energy radiates from their chest.
Frames 7–9: Energy expands into a shimmering, protective dome over allies.

Ensure each keyframe transitions smoothly and continuously into the next, clearly illustrating the Druid action. 

Frame Sequence:   
Frames should be arranged from left-to-right, top-to-bottom:

Row 1: Frames 1 → 2 → 3  
Row 2: Frames 4 → 5 → 6  
Row 3: Frames 7 → 8 → 9

Prompt 1 result:

Prompt 2 result:

Prompt 1 gif:

Prompt 2 gif:

Final gif:

If you take a closer look at the result from prompt 2, you’ll notice the Druid’s face isn’t exactly the same as in prompt 1. I’m not sure why that happened, but the results are good enough for me, for now, but I wanted more.

Generating 36 keyframes

Now things are starting to get a bit strange. The facial consistency is good, but the character’s position isn’t quite right. Check out the prompt below, in this case, I used Wizard 1 as base.

Prompt 1

Ensure character maintains the exact same proportions, pixel art style (16-bit), color palette, lighting, outfit, facial features, and centered screen position as the uploaded frame.
Create a detailed pixel art animation for a game, divided clearly into a 3x3 grid (each individual frame exactly 300px by 300px), forming a continuous 9-frame animation sequence of a wizards's fire spell cast build-up.

Art Style:
Maintain 16-bit pixel art style throughout with consistent lighting (top-left light source), pixel-level shading, and no variation in robe or staff design.

Frame 1: Idle pose — staff down, neutral expression.
Frame 2: Slight lean back; robe begins shifting.
Frame 3: Left hand starts lifting the staff.
Frame 4: Staff halfway up, eyes focus forward.
Frame 5: Staff above chest height, orb glows faintly.
Frame 6: Staff almost fully raised; fire particles begin forming.
Frame 7: Glow intensifies; feet brace.
Frame 8: Wizard’s face turns stern; fire begins circling orb.
Frame 9: Final wind-up pose — staff high, glow pulsing, fire swirling.

Ensure each keyframe transitions smoothly and continuously into the next, clearly illustrating the Wizard action. 

Frame Sequence:   
Frames should be arranged from left-to-right, top-to-bottom:

Row 1: Frames 1 → 2 → 3  
Row 2: Frames 4 → 5 → 6  
Row 3: Frames 7 → 8 → 9

Prompt 2

Ensure character maintains the exact same proportions, pixel art style (16-bit), color palette, lighting, outfit, facial features, and centered screen position as the uploaded sprite. 
Create a detailed pixel art animation for a game, divided clearly into a 3x3 grid (each individual frame exactly 300px by 300px), forming a continuous 9-frame animation sequence of a wizards's fire spell cast build-up.
Art Style:
Maintain 16-bit pixel art style throughout with consistent lighting (top-left light source), pixel-level shading, and no variation in robe or staff design.

Frame 1: Energy crackles around the orb.
Frame 2: A fiery rune flashes faintly behind him.
Frame 3: The orb glows bright yellow-orange.
Frame 4: Body vibrates slightly (anticipating release).
Frame 5: Fire swirls intensify around staff.
Frame 6: Fire ring expands slightly outward.
Frame 7: Wizard begins motion to thrust the staff.
Frame 8: Fire concentrates into the orb.
Frame 9: Final charge frame — orb is blinding white/yellow.

Ensure each keyframe transitions smoothly and continuously into the next, clearly illustrating the Wizard action. 

Frame Sequence:   
Frames should be arranged from left-to-right, top-to-bottom:

Row 1: Frames 1 → 2 → 3  
Row 2: Frames 4 → 5 → 6  
Row 3: Frames 7 → 8 → 9

Prompt 3

Ensure character maintains the exact same proportions, pixel art style (16-bit), color palette, lighting, outfit, facial features, and centered screen position as the uploaded sprite. 
Create a detailed pixel art animation for a game, divided clearly into a 3x3 grid (each individual frame exactly 300px by 300px), forming a continuous 9-frame animation sequence of a wizards's fire spell cast build-up.
Art Style:
Maintain 16-bit pixel art style throughout with consistent lighting (top-left light source), pixel-level shading, and no variation in robe or staff design.

Frame 1: Staff thrusts forward sharply.
Frame 2: Cone of fire erupts from orb, bright center.
Frame 3: Fire blast expands outward (1st stage).
Frame 4: Pulse reaches max radius — bright flare.
Frame 5: Heat waves ripple across blast.
Frame 6: Flames flicker at edges; enemies are hit.
Frame 7: Blast starts shrinking, embers fly out.
Frame 8: Blast fades; staff begins to lower.
Frame 9: Staff halfway down; smoke trails remain.

Ensure each keyframe transitions smoothly and continuously into the next, clearly illustrating the Wizard action. 

Frame Sequence:   
Frames should be arranged from left-to-right, top-to-bottom:

Row 1: Frames 1 → 2 → 3  
Row 2: Frames 4 → 5 → 6  
Row 3: Frames 7 → 8 → 9

Prompt 4

Ensure character maintains the exact same proportions, pixel art style (16-bit), color palette, lighting, outfit, facial features, and centered screen position as the uploaded sprite. 
Create a detailed pixel art animation for a game, divided clearly into a 3x3 grid (each individual frame exactly 300px by 300px), forming a continuous 9-frame animation sequence of a wizards's fire spell cast build-up.
Art Style:
Maintain 16-bit pixel art style throughout with consistent lighting (top-left light source), pixel-level shading, and no variation in robe or staff design.

Frame 1: Wizard exhales; aura fades.
Frame 2: Robe and hair sway back slightly.
Frame 3: Embers float gently around him.
Frame 4: Staff nearly back to idle position.
Frame 5: Legs realign to default stance.
Frame 6: Small afterglow around orb.
Frame 7: Expression softens, eyes widen.
Frame 8: Glow fades out completely.
Frame 9: Back to full idle pose — cycle complete.

Ensure each keyframe transitions smoothly and continuously into the next, clearly illustrating the Wizard action. 

Frame Sequence:   
Frames should be arranged from left-to-right, top-to-bottom:

Row 1: Frames 1 → 2 → 3  
Row 2: Frames 4 → 5 → 6  
Row 3: Frames 7 → 8 → 9

Prompt 1 result:

Prompt 2 result:

Prompt 3 result:

Prompt 4 result:

Prompt 1 gif:

Prompt 2 gif:

Prompt 3 gif:

Prompt 4 gif:

Final gif:

The first image turned out great. In the second one, the hat and face got a bit weird. The third image looked really good again, but by the last one, it’s like it completely lost its mind.

Conclusion

For now, it’s pretty easy to create simple poses. But when you need more frames, things can get a bit tricky, maybe there’s a better prompt for this type of generation.

If you’d like to see more of my tests, as well as the GIF generator I built, you can find them on my Github

Alfa Laval Petrópolis Architecture

Bento — Wed, 17 Jul 2024 16:53:55 +0000

Contextualization

Alfa Laval is a multinational corporation with operations in Petrópolis, where I am employed at a facility focused on industrial boilers.

Within our site, we have implemented a range of locally developed applications, each tailored to specific operational requirements. In this article, will be explained our infrastructure architecture and provide insights into the development and maintenance processes of our software solutions, all of that need to be in compliance with the global IT politics.

Infrastructure

In the infrastructure, we have one database server, two production servers and one test server, all of that is connected in our intranet, that are maintained and monitored by an external team of the global IT.

Intranet

All of the servers are running windows server and all users use windows, that make easier to develop in some point, because every part is using the same system and no external device could access the intranet even smarthphone, that make some tools to be really impossible to be developed in this case.

Database Server

Our database server is running SQL Server, we have just one instance running and all the systems use this instance with different databases.

Production Servers

One of the servers is responsible for desktop application, the other one is responsible for web applications.

Desktop Applications Server
This server hosts locally running applications, primarily basic tools that operate independently without the need to access other servers.

Web Applications Server
This server is dedicated to hosting web applications, many of which are microservices. Detailed development insights into these microservices will be covered in a separate article.

Technology Stack: The microservices are predominantly developed using .NET Core and Angular frameworks.
Server Management: They are managed using Internet Information Services (IIS) for Windows Server, with each service allocated its own application pool for optimal performance and resource management.
Deployment Process: New features that are approved by the users test are published and the old version is totally erased.

Test Server

Our test server serves as a versatile platform capable of running both desktop and web applications. It functions as the initial deployment environment for all new features before they are released.

Application Deployment: This server hosts a variety of applications, encompassing both desktop and web-based solutions.
Testing Environment: It connects to our primary database server for regular operations but typically utilizes a separate database instance for testing purposes.
Deployment Process: New features undergo testing and validation of the users, on this server before being rolled out to production environments.

Users

Users form the cornerstone of our IT architecture, influencing hardware requirements and software interactions. Our user base can be categorized into two groups based on their computing needs:

Laptop Users

Hardware Configuration: These users operate laptops equipped with either 13'' or 15'' screens.
Additional Display: Each laptop setup includes a supplementary 24'' monitor, enhancing visual workspace and productivity.
Usage Context: Laptop users typically benefit from mobility and flexibility, enabling them to work both in-office and remotely while maintaining a consistent computing experience.

Desktop Users

Hardware Configuration: Users utilizing desktops are equipped with one or two 24'' monitors.
Workstation Setup: The desktop environment provides a stable platform for tasks that benefit from larger displays and dedicated computing power.
Specialized Needs: These users may require more robust hardware configurations for tasks such as graphic design, data analysis, or software development.

Integration with IT Infrastructure

Network Connectivity: Both laptop and desktop users connect to our centralized IT infrastructure, ensuring seamless access to shared resources such as databases, applications, and network services.
Security and Access Control: User authentication and access control mechanisms are implemented to safeguard data integrity and protect sensitive information.
Support and Maintenance: IT support services are tailored to address the specific needs of each user group, ensuring smooth operation and timely resolution of technical issues.

Basic commands MongoDB

Bento — Wed, 06 Jul 2022 19:15:44 +0000

Summary

Select/create database
Insert/create collection/table with data
Show created databases
Show all collections in the database
Select data in the collection
Update data from one registry/document
Update all data from one registry/document
Delete data in the collection
Delete database

Select/create database

use firstDatabase;

Insert/create collection/table with data

Syntax

//INSERT one data in the collection
db.NameOfCollection.insertOne({"user": "admin", "password": "admin"});

//INSERT several data in the collection
db.NameOfCollection.insertMany([
  {"user": "admin", "password": "admin"},
  {"user": "admin", "password": "admin"},
  {"user": "admin", "password": "admin", "age": "10"}
]);

Example

//INSERT one data in the collection user
db.user.insertOne({"user": "admin", "password": "admin"});

//INSERT one data in the collection person
db.person.insertOne({"name": "Bill Gates", "age": "66 "});

//INSERT several data in the collection user
db.user.insertMany([
  {"user": "admin1", "password": "admin1"}, 
  {"user": "admin2", "password": "admin2"},
  {"user": "admin1", "password": "password"}
]);

/*INSERT several data in other collection
in this case collection person*/
db.person.insertMany([
  {"name": "Joao", "age": "10"}, 
  {"name": "Joao", "age": "20"},
  {"name": "Lucas", "age": "15"}
]);

Show created databases

Only show the database if something was inserted in some collection

Syntax

show dbs;

Example

//Result example:
admin    0.000GB
config   0.000GB
local    0.000GB
firstDatabase  0.000GB

Show all collections in the database

Syntax

show collections;

Example

//Result example:
person
user

Select data in the collection

Syntax

//Select all the register of one collection equal to SELECT all
db.NameOfCollection.find(); 

//SELECT the first register in the collection
db.NameOfCollection.findOne(); 

//SELECT all when the parameter is true
db.NameOfCollection.find({"WHERE"}); 

//SELECT all with the result similar to a Json (Bson)
db.NameOfCollection.find().pretty();

Example

//Data
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "admin1" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

//SELECT the first with user = admin1
db.user.findOne({"user": "admin1"}); 

//Result
{
        "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"),
        "user" : "admin1",
        "password" : "admin1"
}

//SELECT all with user = admin1
db.user.find({"user": "admin1"}); 

//Result
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "admin1" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

//SELECT all and return a Bson
db.usuario.find().pretty(); 

//Result
{
        "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"),
        "user" : "admin1",
        "password" : "admin1"
}
{
        "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"),
        "user" : "admin2",
        "password" : "admin2"
}
{
        "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"),
        "user" : "admin1",
        "password" : "password"
}

Update data from one registry/document

Syntax

/*Update the data when the first parameter is true to the second parameter 
don't change the struct*/

//Update one when the first parameter is true
db.NameOfCollection.updateOne({"WHERE"}, {$set:"SET"}); 

//Update all when the first parameter is true
db.NameOfCollection.updateMany({"WHERE"}, {$set:"SET"});

Example

//Data
db.user.insertMany([
  {"user": "admin1", "password": "admin1"}, 
  {"user": "admin2", "password": "admin2"},
  {"user": "admin1", "password": "password"}
]);

//UPDATE one when the first parameter is true
db.firstDatabase.updateOne({"user" : "admin1"}, {$set: {"password": "new-password"}}); 

//Result
db.user.insertMany([
  {"user": "admin1", "password": "new-password"}, 
  {"user": "admin2", "password": "admin2"},
  {"user": "admin1", "password": "password"}
]);

//UPDATE all when the first parameter is true
db.user.updateMany({"user" : "admin1"}, {$set: {"password": "new-password"}}); 

//Result
db.user.insertMany([
  {"user": "admin1", "password": "new-password"}, 
  {"user": "admin2", "password": "admin2"},
  {"user": "admin1", "password": "new-password"}
]);

Update all data from one registry/document

Syntax

/*Change ALL data when the first parameter is true to the second parameter 
change the struct, similar to ALTER TABLE*/

//Change just the first when the parameter is true
db.NameOfCollection.replaceOne({"WHERE"}, {"Nova estrutura"});

replaceMany

Don't exist

Example

//Data
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "admin1" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

/*Alter all data from the first when user = admin1
  to "password": "new-password"*/
db.user.replaceOne({"user" : "admin1"}, {"password": "new-password"}); 

//Result
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "password" : "new-password" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

Delete data in the collection

Syntax

//Delete just the first when the parameter is true
db.NameOfCollection.deleteOne({"WHERE"});

//Delete all data from the collection when the parameter is true
db.NameOfCollection.deleteMany({"WHERE"});

//Delete all data from the collection
db.NameOfCollection.deleteMany({});

Example

//Data
{ "_id" : ObjectId("62c4d3121a23db9b29b9fc9e"), "name" : "Joao", "age" : "10" }
{ "_id" : ObjectId("62c4d3121a23db9b29b9fc9f"), "name" : "Joao", "age" : "20" }
{ "_id" : ObjectId("62c4d3121a23db9b29b9fca0"), "name" : "Lucas", "age" : "15" }

//DELETE the first with name = Joao
db.user.deleteOne({"name" : "Joao"}); 

//Result
{ "_id" : ObjectId("62c4d3121a23db9b29b9fc9f"), "name" : "Joao", "age" : "20" }
{ "_id" : ObjectId("62c4d3121a23db9b29b9fca0"), "name" : "Lucas", "age" : "15" }

//DELETE all data with name = Joao
db.user.deleteMany({"name" : "Joao"}); 

//Result
{ "_id" : ObjectId("62c4d3121a23db9b29b9fca0"), "name" : "Lucas", "age" : "15" }

Delete database

Syntax

//Select the database
use database;
//Delete it
db.dropDatabase();

Comandos básicos MongoDB

Bento — Wed, 06 Jul 2022 18:21:51 +0000

Sumário

Selecionar/criar o banco
Inserir/criar collection/tabela de dados
Mostrar bancos criados
Mostrar todas as collections do banco
Selecionar dados na collection
Atualizar dados de um registro/documento
Atualizar todos os dados de um registro/documento
Excluir dados na collection
Excluir banco

Selecionar/criar o banco

use primeiroBanco;

Inserir/criar collection/tabela de dados

Sintaxe

//INSERT um dado na collection
db.NomeDaCollection.insertOne({"user": "admin", "password": "admin"});

//INSERT varios dados na collection
db.NomeDaCollection.insertMany([
  {"user": "admin", "password": "admin"},
  {"user": "admin", "password": "admin"},
  {"user": "admin", "password": "admin", "idade": "10"}
]);

Exemplo

//INSERT um dado na collection usuario
db.usuario.insertOne({"user": "admin", "password": "admin"});

//INSERT um dado na collection pessoa
db.usuario.insertOne({"nome": "Bill Gates", "idade": "66 "});

//INSERT vários dados na collection usuario
db.usuario.insertMany([
  {"user": "admin1", "password": "admin1"}, 
  {"user": "admin2", "password": "admin2"},
  {"user": "admin1", "password": "password"}
]);

//INSERT vários dados em outra collection, no caso, collection pessoa
db.pessoa.insertMany([
  {"nome": "Joao", "idade": "10"},
  {"nome": "Joao", "idade": "20"},
  {"nome": "Lucas", "idade": "15"}
]);

Mostrar bancos criados

Só apresenta o banco se tiver algum dado em alguma collection

Sintaxe

show dbs;

Exemplo

//Exemplo resultado:
admin    0.000GB
config   0.000GB
local    0.000GB
primeiroBanco  0.000GB

Mostrar todas as collections do banco

Sintaxe

show collections;

Exemplo

//Exemplo de resultado:
pessoa
usuario

Selecionar dados na collection

Sintaxe

//Seleciona todos os registros de uma collection igual ao SELECT all
db.NomeDaCollection.find(); 

//SELECT primeiro item inserido na collection
db.NomeDaCollection.findOne(); 

//SELECT todos onde o parametro for verdadeiro
db.NomeDaCollection.find({"WHERE"}); 

//SELECT all com resultado semelhante a um Json (Bson)
db.NomeDaCollection.find().pretty();

Exemplo

//Dados
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "admin1" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

//SELECT o primeiro com o user = admin1
db.usuario.findOne({"user": "admin1"}); 

//Resultado
{
        "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"),
        "user" : "admin1",
        "password" : "admin1"
}

//SELECT todos com o user = admin1
db.usuario.find({"user": "admin1"}); 

//Resultado
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "admin1" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

//SELECT todos e retorna como Bson
db.usuario.find().pretty(); 

//Resultado
{
        "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"),
        "user" : "admin1",
        "password" : "admin1"
}
{
        "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"),
        "user" : "admin2",
        "password" : "admin2"
}
{
        "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"),
        "user" : "admin1",
        "password" : "password"
}

Atualizar dados de um registro/documento

Sintaxe

//Atualiza os dados para o(s) que foi(foram) passado(s) no segundo parâmetro e não modifica a estrutura

//Somente no primeiro correspondente ao primeiro parâmetro
db.NomeDaCollection.updateOne({"WHERE"}, {$set:"SET"}); 

//Em todos que correspondem ao primeiro parâmetro
db.NomeDaCollection.updateMany({"WHERE"}, {$set:"SET"});

Exemplo

//Dados
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "admin1" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

//UPDATE somente no primeiro que atendem ao "WHERE"
db.primeiroBanco.updateOne({"user" : "admin1"}, {$set: {"password": "nova-senha"}}); 

//Resultado
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "nova-senha" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

//UPDATE em todos que atendem ao "WHERE"
db.usuario.updateMany({"user" : "admin1"}, {$set: {"password": "nova-senha"}}); 

//Resultado
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "nova-senha" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "nova-senha" }

Atualizar todos os dados de um registro/documento

Sintaxe

/*Atualiza TODOS os dados para o(s) que foi(foram) passado(s) no segundo parâmetro e 
modifica a estrutura, semelhante ao ALTER TABLE*/

//Somente no primeiro correspondente ao primeiro parâmetro
db.NomeDaCollection.replaceOne({"WHERE"}, {"Nova estrutura"});

replaceMany

Não existe

Exemplo

//Dados
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "user" : "admin1", "password" : "admin1" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

/*Altera todos os dados do primeiro que corresponde a user = admin1
  para "password": "nova-senha"*/
db.usuario.replaceOne({"user" : "admin1"}, {"password": "nova-senha"}); 

//Resultado
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca1"), "password" : "nova-senha" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca2"), "user" : "admin2", "password" : "admin2" }
{ "_id" : ObjectId("62c4d5e11a23db9b29b9fca3"), "user" : "admin1", "password" : "password" }

Excluir dados na collection

Sintaxe

//Exclui somente o primeiro que corresponde a cláusula
db.NomeDaCollection.deleteOne({"WHERE"});

//Exclui todos os que correspondem a cláusula
db.NomeDaCollection.deleteMany({"WHERE"});

//Exclui todos os dados da collection
db.NomeDaCollection.deleteMany({});

Exemplo

//Dados
{ "_id" : ObjectId("62c4d3121a23db9b29b9fc9e"), "nome" : "Joao", "idade" : "10" }
{ "_id" : ObjectId("62c4d3121a23db9b29b9fc9f"), "nome" : "Joao", "idade" : "20" }
{ "_id" : ObjectId("62c4d3121a23db9b29b9fca0"), "nome" : "Lucas", "idade" : "15" }

//DELETE o dado primeiro com o nome = Joao
db.usuario.deleteOne({"nome" : "Joao"}); 

//Resultado
{ "_id" : ObjectId("62c4d3121a23db9b29b9fc9f"), "nome" : "Joao", "idade" : "20" }
{ "_id" : ObjectId("62c4d3121a23db9b29b9fca0"), "nome" : "Lucas", "idade" : "15" }

//DELETE todos os dados com o nome = Joao
db.usuario.deleteMany({"nome" : "Joao"}); 

//Resultado
{ "_id" : ObjectId("62c4d3121a23db9b29b9fca0"), "nome" : "Lucas", "idade" : "15" }

Excluir banco

Sintaxe

//Selecione o banco
use bancoDados;
//Exclua
db.dropDatabase();

Github tip #2 (EN)

Bento — Tue, 21 Jun 2022 23:27:42 +0000

Do you know is possible use github as a host FOR FREE for you website?

Don't know it? Just follow this thread

Github has Github pages tool from any repository is possible host your website.

The link for the web will be something like this one: http://senhorbento.github.io

To active it is pretty simple, just go on your repository click on settings -> pages

In source just chose a branch and the source folder, where the index.html is, (for default is selected the root folder) and click in save.

If everything is alright, in you repository will show an icon next to the description from your last commit, indicating everything is correct and in the right bottom corner will appear a indicator from the github pages like is this repository

The link for the page will be available on the pages section in the settings from your repository, like in the example below:

Github tip #1 (EN)

Bento — Tue, 21 Jun 2022 23:14:33 +0000

Do you know that is possible add SQL as a language on your repository?

Just add " *.sql linguist-detectable=true " in your .gitattributes, if you repository don't have it, just create it and add this line.

Example repository here

Github tip #2

Bento — Sun, 19 Jun 2022 12:58:37 +0000

Você sabia que é possível hospedar seus sites pelo github de forma gratuita?

Não sabia? Então segue o fio

O GitHub possui a ferramenta GitHub pages a partir de qualquer repositório é possível hospedar sua página.

O link da página ficará algo como: http://senhorbento.github.io

Para ativá-lo é bem simples, basta ir no repositório que deseja hospedar, clicar em settings -> pages

Em source basta escolher a branch e a pasta do source, (por padrão é selecionado a pasta root) e clicar em save.

Se estiver tudo certo, no seu repositório deverá aparecer um ícone, próximo a descrição do seu último commit, indicando que está tudo certo e no canto inferior direito vai aparecer um indicador do github pages, como nesse repositório

O link de acesso fica disponibilizado na aba pages das configurações do seu repositório, como no exemplo da figura.

Github tip #1

Bento — Sun, 19 Jun 2022 12:54:44 +0000

Você sabia que é possível adicionar SQL como uma linguagem em seu repositório?

Basta adicionar " *.sql linguist-detectable=true " no seu .gitattributes, caso não tenha, basta criá-lo.

Repositório de exemplo aqui

Markdown tip #1

Bento — Sun, 19 Jun 2022 12:41:11 +0000

Dica simples sobre markdown, pode ser que você não saiba ainda. Acha chato ficar reorganizando os números toda vez que vai alterar uma lista numerada?

Basta colocar todos os itens como "00."

Se o primeiro item for colocando como "00." a lista iniciará com 0, exemplo no print da parte de projetos.

Se quiser começar com outro número basta usá-lo na primeira posição, por exemplo temos o módulo básico que começa com 01.

Link do repositório de exemplo aqui

Espero que chegue em alguém que ainda não saiba 😊