In the previous two articles of this series, we discussed how to use Python and SQLAlchemy to perform the ETL process. Today we’ll do the same, but this time using Python and SQL Alchemy without SQL commands in textual format. This will enable us to use SQLAlchemy regardless of the database engine we’re connected to. So, let’s start.
SQLAlchemy helps you work with databases in Python. In this post, we tell you everything you need to know to get started with this module.
Python is very popular these days. Since Python is a general-purpose programming language, it can also be used to perform the Extract, Transform, Load (ETL) process. Different ETL modules are available, but today we’ll stick with the combination of Python and MySQL. We’ll use Python to invoke stored procedures and prepare and execute SQL statements.
Social media surrounds us, so it’s not unusual for applications to require some kind of social media integration. The most common is signing in with Facebook, Twitter, or another service. Users expect to be able to log in with different social accounts. So, applications meet these expectations by offering external login options. Let’s take a look at this functionality and investigate how to merge users’ accounts – specifically, we’ll consider the situation when people use several methods to log in.
Handling user registration and authentication isn’t an easy task. Both users and developers understand this. Users have to select and remember another username and password. A developer’s responsibility is to make this process secure and to properly protect the user’s data. So it’s no surprise that logging in with one account – Facebook or Google, for example – is extremely popular.
It often happens that if something is loved, it is also hated with the same power. The idea of object relational mapping fits into this concept perfectly. You will definitely come across many opposite points and fierce discussions as well as unwavering advocates and haters. So if you have ever asked whether to use ORM or not, the answer “it depends” will not be enough.
I’m a kind of guy who likes to make jokes or take some ideas ad absurdum. In this article I examine how you can use Python to implement the crazy idea of “PostgreSQL as an Application Server.”
Hosting applications in the Cloud has become the most popular method of application since it offers great flexibility and is relatively simple to set up. This model earned a formal name known as Platform as a Service (PaaS). In a PaaS model the service provider offers a fully managed platform in which a web application is uploaded and deployed. Most PaaS providers offer to scale an application by adding or removing servers.
In the part II of TODO app development I'm going to show database model, create the initial database, prepare Flask-SQLAlchemy models, define view functions, templates and finally beautify webapp with Bootstrap.
Part I of TODO app web development presents initial steps to set up a local development environment. It includes creating a virtual environment for all required dependencies and organizing the structure of an application.