Tag Archives: PostgreSQL

Refactor time convertion from postgresql to php. – Be taught from Tutorial

Refactor time convertion from postgresql to php. In my software I had the next question: choose appointment.doctor_id, appointment.date, date_part(‘epoch’,appointment.date::DATE + schedule.time_zero – INTERVAL ‘2 hours’)::INT AS date_that_should_have_booked_in_unix_time from appointment be part of schedule on appointment.schedule_id = schedule.id order by date asc Enter fullscreen mode Exit fullscreen mode With the question above I retrieve the overbooked…

Read More

What’s New in PostgreSQL 14? – Learn from Tutorial

What’s New in PostgreSQL 14? PostgreSQL 14, released on September 30, 2021, introduces many new features and improvements. Two I find particularly interesting are JSON syntax conveniences and the multirange data type. But there are also several noticeable performance improvements that many applications will benefit from without any code changes. JSON Conveniences PostgreSQL can store…

Read More

💆‍♀️ 💆‍♂️ PostgreSQL query optimization for Gophers: It’s much easier than it sounds! – Learn from Tutorial

💆‍♀️ 💆‍♂️ PostgreSQL query optimization for Gophers: It’s much easier than it sounds! Introduction Hello, amazing DEV people! 😉 Today I will show you a wonderful query optimization technique for Postgres that I often use myself. This approach to optimization can save you from a long and tedious transfer of your project to another technology…

Read More

Build and Deploy your Django & React App: Authentication, Docker, AWS Lightsail, GitHub Actions & PostgreSQL – React Dev Feed

Build and Deploy your Django & React App: Authentication, Docker, AWS Lightsail, GitHub Actions & PostgreSQL I’ve recently published some articles on Django and React. If you are looking to learn how to use Django Rest to build an API that you can consume using React from development to deployment, this post will list the…

Read More

Deploy a Django App on AWS Lightsail: Docker, Docker Compose, PostgreSQL, Nginx & Github Actions – Python Dev Feed

Deploy a Django App on AWS Lightsail: Docker, Docker Compose, PostgreSQL, Nginx & Github Actions So you have written your Django Application and you are ready to deploy it? Although there are already existing solutions like Heroku, to help you deploy your application easily and quickly, it’s always good for a developer to know how…

Read More