Leveraging the Options of Your Database With Postgres and Python – The Actual Python Podcast

Are you getting essentially the most out of your Postgres database? What options may you leverage to enhance your Python venture? This week on the present, Craig Kerstiens from Crunchy Information is right here to debate getting essentially the most out of Postgres.

Craig shares his years of PostgreSQL experience with recommendation on getting extra from the platform. We speak about wealthy knowledge varieties for describing ranges, geospatial knowledge, and JSON.

Craig shares instruments for accessing efficiency statistics from the command line and techniques for optimizing your terminal settings for SQL searches. He discusses Postgres extensions for customizing the database to your wants. Craig additionally gives a number of sources for studying extra and a web-based device for working towards inside a playground surroundings.

Matters:

• 00:00:00 – Introduction
• 00:02:36 – What are causes for contemplating Postgres?
• 00:07:41 – Timeline of current options
• 00:11:06 – Distinctive knowledge varieties
• 00:16:34 – Storing JSON info
• 00:20:19 – Video Course Highlight
• 00:21:50 – Storing geographic info
• 00:25:16 – What’s the method for including extensions?
• 00:31:33 – Recommendation for Python builders utilizing Postgres
• 00:33:31 – Recommendation on writing SQL
• 00:38:06 – Command-line instruments and customizations
• 00:48:18 – Django as an entry to Python
• 00:51:13 – Assets for studying and working towards with Postgres
• 00:53:45 – What are you enthusiastic about on this planet of Python?
• 00:55:55 – What do you need to be taught subsequent?
• 00:58:34 – How can individuals comply with your work on-line?
• 00:59:20 – Thanks and goodbye

Present Hyperlinks:

Tweet
Share
Share
Electronic mail
class=”h4″>