Vertabelo Blog

Learn how to design and use database models
 
 
RSS
 
 
 
 
 
New SQL Course! The only interactive course for SQL window functions on the Internet. View course Discover our other courses:
 
Patrycja Dybka 30th Aug 2016

Everyone likes to play games, especially the simple ones. Tic tac toe is about as simple as you can get, and despite its age it is still widely played. In the past, the only way to play tic tac toe was on paper; now there are plenty of computerized options. In this article (inspired by our recent post, A Database Model for Simple Board Games), we’ll present a tutorial on building a tic tac toe web application with Spring Boot and AngularJS.

 
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.

 
Pawel Poskrobko 4th Mar 2016

The most common way to implement database functionalities in iOS applications is definitely Apple’s Core Data. However, its architecture is really Apple-like: it doesn’t let you see anything happening inside and the structure is hidden from you. That’s why some people dislike Core Data and prefer to stick with an SQLite database – even though SQLite is not supported natively.

 
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 22nd Oct 2015

I’ve been testing a ton of frameworks lately – good and otherwise. One of them, the Java micro framework Spark, really amazed me with its simplicity and rapid development capabilities. In this article, we’ll examine an example of Spark’s usefulness by creating a REST API. So, without further ado, let’s see how to store, retrieve, update and delete some information in a PostgreSQL database using jOOQ ORM over a RESTful API in a simple To-do app.

 
Patrycja Dybka 11th Sep 2015

jOOQ is a Java Object-Relational Mapper that lets you build type safe SQL queries through its fluent API. Using built-in Vertabelo support we can generate sufficient code from the previously designed model. Generated Java classes correspond to database tables, records, etc. This time, we automate this process by using Gradle build system.

 
Patrycja Dybka 2nd Sep 2015

jOOQ provides an easy way to automate the process of generating the java classes that represent database tables, records, etc. via the jooq-codegen-maven plugin. This time we let Maven worry about downloading the required JAR files and generating Java code that lets you build typesafe SQL queries through jOOQ’s fluent API.

 
Patrycja Dybka 14th Aug 2015

jOOQ and Vertabelo perfectly complement each other in the application development. With Vertabelo you can easily design a database structure what saves you from writing DDL code manually, while jOOQ handles generation of Java classes corresponding to database tables, and allows to construct SQL queries through its fluent API.

 
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.