Learning PostgreSQL | an Introduction | DevOps

Subscribe to show your support! goo.gl/1Ty1Q2 .
Patreon 👉🏽 / marceldempers
Checkout the source code below 👇🏽 and follow along 🤓
Also if you want to support the channel further, become a member 😎
marceldempers.dev/join
Checkout "That DevOps Community" too
marceldempers.dev/community
Source Code 🧐
--------------------------------------------------------------
github.com/marcel-dempers/doc...
If you are new to Kubernetes, check out my getting started playlist on Kubernetes below :)
Kubernetes Guide for Beginners:
---------------------------------------------------
• Kubernetes development...
Kubernetes Monitoring Guide:
-----------------------------------------------
• Kubernetes Monitoring ...
Kubernetes Secret Management Guide:
--------------------------------------------------------------
• Kubernetes Secret Mana...
Like and Subscribe for more :)
Follow me on socials!
marceldempers.dev
Twitter | / marceldempers
GitHub | github.com/marcel-dempers
Facebook | thatdevopsguy
LinkedIn | / marceldempers
Instagram | / thatdevopsguy
Music:
Track: jimmysquare - My Band | is licensed under a Creative Commons Attribution licence (creativecommons.org/licenses/...)
Listen: / my-band
Track: J3bii - Existance | is licensed under a Creative Commons Attribution licence (creativecommons.org/licenses/...)
Listen: / existance-prod-j3bi
Track: Reckoner - lofi hip hop chill beats for study~game~sleep | is licensed under a Creative Commons Attribution licence (creativecommons.org/licenses/...)
Listen: / reckoner-lofi-hip-hop-...
Track: souKo - souKo - Parallel | is licensed under a Creative Commons Attribution licence (creativecommons.org/licenses/...)
Listen: / parallel
Timestamps
00:00 intro
01:10 source code
02:02 docker
04:01 docker compose
05:55 docker volumes
11:21 test persistence
12:39 docker networking
13:47 environment variables
16:01 outtro

[@haddocks]

I'am not a native English speaker, but you speak slowly and clearly so i understand everything! Thanks for these contents!

[@clippy3656]

Thanks for this video! I‘m excited for the rest of this series, there are not many YT channels as good as this one

[@majorpain9106]

Thanks very much man. The way you explain things and teach concepts is super captivating, currently learning a lot from you! Huge appreciation.

[@faadi4536]

what an amazing intro. keep up the good work brother. looking forward to future series.

[@bnssoftware3292]

This channel is pure gold!

[@anshkumargarhewal8582]

Eagerly waiting for upcoming parts 🎉

[@manuelgp343]

Awesome intro to the series, looking forward to the next one. For a bonus chapter you could try a Postgres operator in K8S, there is CrunchyData's PGO, EnterpriseDB's CloudnativePG, Zalando's and many more.

[@felipeozoski]

Gotta love this channel ❤

[@anthonyrussano]

this was the exact video i needed

[@TheForge47]

Great Video 💪

[@harishdevarapalli1537]

Thanks for you Time on sharing your knowledge. Its a small request, plz implement end to end devops i.e ci/cd because the way you explain topics are beautiful and understandable.

[@unekuejiga9817]

this is wonderful

[@veteran35th]

Excellent vid. I would (DBA who knows next to nothing about Docker but does know a bit about databases) suggest creating a database first and then creating the tables in that database. The postgres database should not really be touched.

[@amreissa4636]

Thanks!

[@jdubeau007]

I joined the patreon. I'm waiting for discord invite. That was one of the best lessons.

[@MarcelDempers]

Thanks for the support! Check the link in description to the community page and remember to link your discord account to your patreon too :)

[@IonutBoghean-sb6wx]

For some reason, I can get data persistance when I stop the container, but not when I remove it ?! I am attempting to use named volumes.

[@sreeharshagarimella1593]

Wonderful

[@awdwadawda352]

Hey Marcel, are there any upsides to using VOLUME within your dockerfile instead of using the -v flag when running the container? And are there any alternative methods?

[@MarcelDempers]

adding VOLUME inside your dockerfile only tells the reader that a folder path should be mounted in. You still either have to create a volume doing the docker volume create command or you -v on your docker run command

[@anthonyrussano]

yesssssssssssss thank you

[@exit-zero]

That Database guy!

[@Rienck]

Awesome intro! I'm using pgadmin instead of adminer. I like it more because it's more user friendly and extensive. Looking forward to the next video!

[@MarcelDempers]

nice! thanks for the tip. 💪🏽 I'm still a noob with Postgres, will check it out

[@Rienck]

@@MarcelDempers me too, I just bummed into it during my new project with the purpose of challenging myself to become a bit full stack. It's a combination of Svelte, Golang , Postgres, Keycloak and pgadmin all started and stopped with podman-compose. One thing I really like is to create a Makefile with 'phony' shortcuts for starting and stopping. It's better than aliases because I can make one per project.

[@TheForge47]

I use dbvisualizer, which is not opensourrce but it supports lots of other databases.

[@sasidharjanaki5852]

Nice