In this post, we will install Django in a Python virtual environment using PostgreSQL. We will then install and configure Gunicorn to serve applications. Next, we will use Nginx as a reverse proxy to the Gunicorn application server.
Have you ever wanted to track your tweet activity on Twitter? Then this article is for you. I love how Django’s ORM makes it easy to model a database and modify it with views (i.e., the app’s functional back-end).
In this guide, we will use Postgres, Kafka, Kafka Connect, Debezium, and ZooKeeper to create a small API that keeps track of your stock & crypto purchases over time.
MySQL introduced Window functions in their release of MySQL version 8.0. to target groups of rows without collapsing them. In this article, we will explore example implementations of the most versatile window functions MySQL has to offer.
Once developers find themselves in the MySQL world, they will almost certainly hear some advice on how they should go about designing database schemas in MySQL. This blog post will provide insight into what you should consider when dealing with database schemas in MySQL.
As developers, we are aware of various best practices for SQL query optimization. While a few of these are specific to individual relational database management systems (RDBMSs), most can apply to virtually any database.
NewSQL was supposed to combine the best of SQL and NoSQL databases. 10 years after its inception, we are left wondering why it never saw broad adoption. What led to this failure? Lack of specialization and the cloud.
