Coding with Missak
Coding with Missak
  • 44
  • 71 650
PostgreSQL - Array Lengths
In this video, I explain how to get the length of an Array Column in PostgreSQL.
--------------------------------------------------------------------------------------------------------------
📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*.
Use Coupon Code **TH-cam** or click the links below!
🎓 Mastering PostgreSQL: Learning By Real Examples
www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam
🎓 PostgreSQL: The Ultimate Exam
www.udemy.com/course/postgresql-the-ultimate-exam/?couponCode=TH-cam
🎓 Algorithm and Data Structures: The Ultimate Exam
www.udemy.com/course/postgresql-the-ultimate-exam/?couponCode=TH-cam
#database #postgres #postgresql #sql
มุมมอง: 50

วีดีโอ

PostgreSQL - Selecting JSON Props
มุมมอง 45ปีที่แล้ว
In this video, I explain how you can select properties from a JSON column in PostgreSQL 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam 🎓 PostgreSQL: The Ultimate Exam...
PostgreSQL - Unnesting an Array
มุมมอง 189ปีที่แล้ว
If you want to MASTER PostgreSQL, check out my courses on Udemy! 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam 🎓 PostgreSQL: The Ultimate Exam www.udemy.com/course/p...
PostgreSQL - Sub Querying
มุมมอง 19ปีที่แล้ว
In this video, I explain how to write subqueries in PostgreSQL. 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam 🎓 PostgreSQL: The Ultimate Exam www.udemy.com/course/po...
PostgreSQL - Handle Row Conflicts
มุมมอง 24ปีที่แล้ว
In this video, I explain how to handle row conflicts when inserting a record into PostgreSQL table. 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam 🎓 PostgreSQL: The U...
PostgreSQL - Working with Timezones
มุมมอง 1.3Kปีที่แล้ว
In this video, I explain how timezones work in PostgreSQL querying. 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam 🎓 PostgreSQL: The Ultimate Exam www.udemy.com/cours...
Puppeteer - An Introduction
มุมมอง 5132 ปีที่แล้ว
In this video, we explain what is Puppeteer and what can we do with it. 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam 🎓 PostgreSQL: The Ultimate Exam www.udemy.com/c...
Visual Studio Code. 13 Features You Should Know
มุมมอง 1.6K2 ปีที่แล้ว
In this video, I will cover some tips and tricks in visual studio code that will make you code faster. 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam 🎓 PostgreSQL: Th...
Testing React with Jest - Learn By Examples
มุมมอง 4802 ปีที่แล้ว
In this video, we cover the basics of testing a React component with Jest. The code is provided in the following link. github.com/missak-boyajian/utube-testing-react 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresq...
Writing Cron Jobs with Node Js
มุมมอง 5622 ปีที่แล้ว
In this video, we show how can you create a Cron job with Node Js. We will be using a tool called "Node Cron". For documentation, follow this link www.npmjs.com/package/node-cron 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/master...
Setting Up Git Hooks with Husky
มุมมอง 1.5K2 ปีที่แล้ว
In this video, we show how to set up Husky Git Hooks. Husky is a great tool to improve your commits! For more reference: github.com/typicode/husky 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-...
Dockerize node application using docker compose.
มุมมอง 4.5K2 ปีที่แล้ว
In this video, we dockerize a simple node.js application using docker compose. 📚 If you want to get better in tech, check out my courses on Udemy with *35% Discount*. Use Coupon Code "*TH-cam*" or click the links below! 🎓 Mastering PostgreSQL: Learning By Real Examples www.udemy.com/course/mastering-postgresql-learning-by-real-examples/?couponCode=TH-cam 🎓 PostgreSQL: The Ultimate Exam www.udem...
React - Debugging using Chrome
มุมมอง 1332 ปีที่แล้ว
This video shows how to debug a React application using Chrome's developer tools. 📚 If you want to learn more PostgreSQL, check out my courses on Udemy with *35% Discount* 🎓 Mastering PostgreSQL: Learning By Real Examples tinyurl.com/2t72aabk 🎓 PostgreSQL: The Ultimate Exam tinyurl.com/242pxsk4
Node.js and Firestore(Part 4) - Sorting and Paginating Collections
มุมมอง 1.3K2 ปีที่แล้ว
This video shows how to sort and paginate a simple Firestore collection. To learn more about setting up, reading, and writing Firestore please check out my previous videos. Connecting to Firestore th-cam.com/video/7ryA594RAmw/w-d-xo.html Reading from Firestore th-cam.com/video/PbvdMa1jFMA/w-d-xo.html Writing to Firestore th-cam.com/video/o-yqOAXxNXQ/w-d-xo.html 📚 If you want to get better in te...
Node.js and Firestore(Part 3) - Reading from Firestore
มุมมอง 1.6K3 ปีที่แล้ว
Node.js and Firestore(Part 3) - Reading from Firestore
Node.js and Firestore(Part 2) - Writing to Firestore
มุมมอง 2.9K3 ปีที่แล้ว
Node.js and Firestore(Part 2) - Writing to Firestore
Node.js and Firestore(Part 1) - Connecting to Firestore
มุมมอง 11K3 ปีที่แล้ว
Node.js and Firestore(Part 1) - Connecting to Firestore
VS Code - HTML Tricks and Shortcuts(Emmet)
มุมมอง 4403 ปีที่แล้ว
VS Code - HTML Tricks and Shortcuts(Emmet)
Node.js - Building APIs with Express
มุมมอง 6363 ปีที่แล้ว
Node.js - Building APIs with Express
Programmers - Before and After Finishing a Task
มุมมอง 1563 ปีที่แล้ว
Programmers - Before and After Finishing a Task
CSS - Rotate elements with animation
มุมมอง 5243 ปีที่แล้ว
CSS - Rotate elements with animation
CSS - Vertically Centering an Element(Mystery Solved)
มุมมอง 6513 ปีที่แล้ว
CSS - Vertically Centering an Element(Mystery Solved)
JavaScript - The Weird Parts
มุมมอง 6423 ปีที่แล้ว
JavaScript - The Weird Parts
Deno - Getting Started
มุมมอง 1073 ปีที่แล้ว
Deno - Getting Started
React - 4 Ways to Style Your Components
มุมมอง 1103 ปีที่แล้ว
React - 4 Ways to Style Your Components
Googling - Junior VS Senior Software Engineer
มุมมอง 743 ปีที่แล้ว
Googling - Junior VS Senior Software Engineer
Node.js - Read Excel File Cells
มุมมอง 3.9K3 ปีที่แล้ว
Node.js - Read Excel File Cells
Writing Regex. Junior vs Senior Software Engineer
มุมมอง 2143 ปีที่แล้ว
Writing Regex. Junior vs Senior Software Engineer
JavaScript Developers After Learning Java
มุมมอง 1173 ปีที่แล้ว
JavaScript Developers After Learning Java
Node.js: Read from Excel File
มุมมอง 32K3 ปีที่แล้ว
Node.js: Read from Excel File

ความคิดเห็น

  • @necronomicon-xmortis9362
    @necronomicon-xmortis9362 5 หลายเดือนก่อน

    that is a cool function i didnt know we can animate without canvas and javascript i love it❤❤😊

  • @felipevasconcelos869
    @felipevasconcelos869 6 หลายเดือนก่อน

    my code erro C:\Users\Conferente\Documents\curso> node ./index.js { id: 200, name: 'felipe' } C:\Users\Conferente\Documents\curso\index.js:7 const id = worksheet[`A${i}`].v; ^ TypeError: Cannot read properties of undefined (reading 'v') at Object.<anonymous> (C:\Users\Conferente\Documents\curso\index.js:7:31) at Module._compile (node:internal/modules/cjs/loader:1376:14) at Module._extensions..js (node:internal/modules/cjs/loader:1435:10) at Module.load (node:internal/modules/cjs/loader:1207:32) at Module._load (node:internal/modules/cjs/loader:1023:12) at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:135:12) at node:internal/main/run_main_module:28:49

  • @felipevasconcelos869
    @felipevasconcelos869 6 หลายเดือนก่อน

    my code erro C:\Users\Conferente\Documents\curso> node ./index.js { id: 200, name: 'felipe' } C:\Users\Conferente\Documents\curso\index.js:7 const id = worksheet[`A${i}`].v; ^ TypeError: Cannot read properties of undefined (reading 'v') at Object.<anonymous> (C:\Users\Conferente\Documents\curso\index.js:7:31) at Module._compile (node:internal/modules/cjs/loader:1376:14) at Module._extensions..js (node:internal/modules/cjs/loader:1435:10) at Module.load (node:internal/modules/cjs/loader:1207:32) at Module._load (node:internal/modules/cjs/loader:1023:12) at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:135:12) at node:internal/main/run_main_module:28:49

  • @singiri697
    @singiri697 7 หลายเดือนก่อน

    Can you give this code?

    • @felipevasconcelos869
      @felipevasconcelos869 6 หลายเดือนก่อน

      var XLSX = require("xlsx"); var workbook = XLSX.readFile('C:/Users/Conferente/Documents/excel/arquivo.xlsx'); let worksheet = workbook.Sheets[workbook.SheetNames[0]]; for(let i = 2; i < 7; i++){ const id = worksheet[`A${i}`].v; const name = worksheet[`B${i}`].v; console.log({ id:id, name:name}) }

  • @phoxworx
    @phoxworx 8 หลายเดือนก่อน

    All of the Google documentation was absolutely USELESS let alone inaccurate and this is the actual only way I could get this to work, thank you!

  • @MultiCarsman
    @MultiCarsman ปีที่แล้ว

    THATS WHY HES THE GOAT

  • @kylechen7107
    @kylechen7107 ปีที่แล้ว

    Exceedingly helpful. Thank you

  • @mahadihasan7300
    @mahadihasan7300 ปีที่แล้ว

    Thanks bro for save my lifer. God bless you 💌

  • @rithick8809
    @rithick8809 ปีที่แล้ว

    Thank you so much mahn

  • @jashanpreetsingh5592
    @jashanpreetsingh5592 ปีที่แล้ว

    Thanks bro 🎉it was very helpful

  • @handlebest
    @handlebest ปีที่แล้ว

    pal, do u know how to read ole object like images, .docx files, .pdf files that attached inside an xlsx file?

  • @sagyblecher9258
    @sagyblecher9258 ปีที่แล้ว

    Brother, thank you so much!

  • @edisonmondal2798
    @edisonmondal2798 ปีที่แล้ว

    Sir! Billions of thanks will be less for your massive help. You have saved my life 🖤🖤❤❤🖤🖤

  • @sagyblecher9258
    @sagyblecher9258 ปีที่แล้ว

    Amazing video!!! Thank you so much <3

  • @souravsinha5330
    @souravsinha5330 ปีที่แล้ว

    Thanks a lot !!!

  • @crimeducentury
    @crimeducentury ปีที่แล้ว

    For those of you who struggle a little here are a few thoughts from my brother who has a fair amount of knowledge in this type of stuff. Keep in mind that the ` is not a single quote but rather a "back tick". On a mac its the key beside the #1. The ".v" my brother believes is for the name in the JSON file. You can get a glimpse of the JSON file that is created from your excel by temporarily changing your code so that you have on line 9 console.log (worksheet). ++ Appears to be something regarding doing a job on one line and moving to the next. And for super noobz like myself don't forget to save before running in terminal.

  • @hasithasawbhagya708
    @hasithasawbhagya708 ปีที่แล้ว

    Great! Will you publish some video about upload and retrieve image to Firebase

  • @helderam
    @helderam ปีที่แล้ว

    Thanks. How can I control if I launch a program thats run every hour, but I wanna check to lounch only if the last launch was finished ?

  • @dasarisahith3540
    @dasarisahith3540 ปีที่แล้ว

    for me it is getting error as .v is undefined

  • @bIgceksy
    @bIgceksy ปีที่แล้ว

    thank you so much, this was exactly what i needed to get this started

  • @lincolnpires
    @lincolnpires ปีที่แล้ว

    direct to the point! Thank you very much.

  • @surjeetsingh5821
    @surjeetsingh5821 ปีที่แล้ว

    buddy your second query of pagination is printing the same documents same of that first query

  • @poojaj8081
    @poojaj8081 2 ปีที่แล้ว

    how to get only value of json array

  • @Abhi-ow6xe
    @Abhi-ow6xe 2 ปีที่แล้ว

    Thanks very useful

  • @ugochukwu.chigozie9698
    @ugochukwu.chigozie9698 2 ปีที่แล้ว

    amazing video God bless you

  • @datboi765
    @datboi765 2 ปีที่แล้ว

    That's what I wanted. Searched for this for hours for such a simple thing. Thanks

  • @toufikurrahmantoufik5368
    @toufikurrahmantoufik5368 2 ปีที่แล้ว

    Thank You so much.

  • @bijeyta1028
    @bijeyta1028 2 ปีที่แล้ว

    Can we do reverse of this i.e fetching terminal data to Msexcel

  • @sprintwithcarlos
    @sprintwithcarlos 2 ปีที่แล้ว

    You're getting errors at 2:07 and completely omit comment them. I guess something related to act?

  • @celine.3749
    @celine.3749 2 ปีที่แล้ว

    Thank you for making this video, it really helps me

  • @CAF-EHE
    @CAF-EHE 2 ปีที่แล้ว

    How To Insert Data, I Don't Want To Use Function "set()" because it only works for replace, what I want is just insert data one by one in Same document

  • @julioalmeida4645
    @julioalmeida4645 2 ปีที่แล้ว

    Amazing. Well done

  • @minngoc6417
    @minngoc6417 2 ปีที่แล้ว

    Thank you for your help.

  • @ianfeldman7101
    @ianfeldman7101 2 ปีที่แล้ว

    Greate video, very simple and clear, just perfect!!

  • @lopezrunco
    @lopezrunco 2 ปีที่แล้ว

    Very useful!

  • @pedrocazala1403
    @pedrocazala1403 2 ปีที่แล้ว

    Hace días que no encontraba la forma de conectar firebase. I love you!!!

  • @christianborrello1922
    @christianborrello1922 2 ปีที่แล้ว

    Great! Will you publish some video about upload image to firebase?

  • @christianborrello1922
    @christianborrello1922 2 ปีที่แล้ว

    you are my savior, I tried a lot of example found on web, this is the only that works good. Thank you very much!

  • @programmercupu7547
    @programmercupu7547 2 ปีที่แล้ว

    Hi, Missak, on 1:02 can I set doc.data() into array and retrieve those with res.send? How I can do that?

  • @MrMemb
    @MrMemb 2 ปีที่แล้ว

    Excelent video thankyou!

  • @AllroundZone
    @AllroundZone 2 ปีที่แล้ว

    great video

  • @abdullahwaseem9901
    @abdullahwaseem9901 2 ปีที่แล้ว

    helped alot thank you!

  • @learnwithme5209
    @learnwithme5209 2 ปีที่แล้ว

    Thanks for the help:)

  • @kaigoat5265
    @kaigoat5265 2 ปีที่แล้ว

    Thank u so much, i like short and clear videos, so helpfull

  • @NIRAJKUMAR-ri9jb
    @NIRAJKUMAR-ri9jb 2 ปีที่แล้ว

    Why you have used .v in the for loop ?

  • @BABARBEATS
    @BABARBEATS 2 ปีที่แล้ว

    good stuff

  • @ohwow2074
    @ohwow2074 2 ปีที่แล้ว

    Sublime has easier shortcuts. Does anyone know how I can use it VSCode?

  • @EliasMakes
    @EliasMakes 2 ปีที่แล้ว

    Great one Missak

  • @ashishranjan7586
    @ashishranjan7586 2 ปีที่แล้ว

    hey man loved your video...how can i get currentuser id from firebase..auth

  • @shalihuddinfams1227
    @shalihuddinfams1227 2 ปีที่แล้ว

    May I suggest to breakdown for every function, and be less rushed in explanation. Your content is very informative

    • @codingwithmissak
      @codingwithmissak 2 ปีที่แล้ว

      Thanks, will take into consideration!