Setup PostgreSQL DB In The Dev Environment - Feat. Helm And Crossplane (You Choose!, Ch. 1, Ep. 5)

[@maudrid]

I understood that in the next video you will be looking at how to maintain the schema within the database? I have been using Sqitch for several years. It's a simple and flexible, Git-like versioning system for databases. Maybe worth a look.

[@DevOpsToolkit]

I'll take a look at it. Thanks for the suggestion.

[@KnThSelf2ThSelfBTrue]

This is excellent. One thing I've never seen covered is how you might host OLAP databases or a data warehouse in a prod cluster or in a development environment.

[@DevOpsToolkit]

If it's in Cloud with, let's say, Azure, you can do it with Crossplane. If it's self-hosted, I am not sure since I never tried to self-host it in Kubernetes.

[@KnThSelf2ThSelfBTrue]

@@DevOpsToolkit I'm struggling to find "Self Hosted, Free and Open Source, Cloud Native Data Warehouse" anywhere. Seems like an unmet niche! Then again, people are still scared to host even production OLTPs in-cluster, so I guess I shouldn't be surprised that self-hosting data warehouses would be absolutely terrifying.

[@DevOpsToolkit]

@@KnThSelf2ThSelfBTrue That's not my area of expertize (self-hosted warehouse) so I can't give a recommendation. I just assume that there are quite a few solutions and maybe different phrases should be searched or, maybe, it's not a thing to run in Kubernetes (these days Cloud-native often means Hyperscaler or Kubernetes).

[@KnThSelf2ThSelfBTrue]

That said, maybe you can just throw a good FOSS column store database at the problem, get the performance you want from that. Then you must forget about all the Enterprisey features of AWS Redshift or whathaveyou, and make up for that with all the orchestration capabilities of the Kubernetes ecosystem.

[@andrewmadsen1973]

@Issac Lee Not sure what your use case is but happy to discuss. Check out the Trino project, might be of interest.

[@ivar786]

How to provision postgresql database using crossplane.

[@DevOpsToolkit]

You might want to check Crossplane Tutorial kzbin.info/aero/PLyicRj904Z99i8U5JaNW5X3AyBvfQz-16. It's a set of crossplane tutorial videos that, among other things, show how to use it to manage posgresql database servers and databases.

[@ivar786]

@@DevOpsToolkit Thank you, if you could help me out to which particular video or document I should check for postgresql database, it'll be helpful. I'm able to create aws services but postgresql I'm not able to provision. So please if you could provide me with postgresql database related documents it'll be helpful. I need to complete this task by tomorrow.

[@DevOpsToolkit]

@ivar786 try github.com/vfarcic/crossplane-sql/blob/main/examples/aws.md

[@SV-tc8cu]

I think it would be. more productive to have less banter and more time for presenters

[@ash3rr]

your guest gave me a headache. can I expense my panadol to you?

[@DevOpsToolkit]

Which one of the guests did that to you?

[@ash3rr]

@@DevOpsToolkit the nervous laugher.