Vertabelo Blog

Learn how to design and use database models
 
 
RSS
 
 
 
 
 
Vertabelo Academy It's time to speak the new lingua franca of the Web! Online Course ● Tons of Exercises ● Designed for Beginners DETAILS Check our other courses:
 
Emil Drkušić 26th Jun 2019

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.

 
Emil Drkušić 12th Jun 2019

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.

 
Emil Drkušić 22nd May 2019

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.

 
Patrycja Dybka 24th May 2016

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.

 
Patrycja Dybka 16th Feb 2016

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.

 
Patrycja Dybka 18th Aug 2015

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.

 
Rafał Strzaliński 16th Jun 2015

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.”

 
Patrycja Dybka 22nd May 2015

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.

 
Patrycja Dybka 22nd May 2015

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.

 
Patrycja Dybka 22nd May 2015

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.