Author: Leandro Toniut

Independent Database Developer

Logging in With External Services

Inputting a username and password is one way of accessing an account, but it’s not the only one. In this article, we’ll see how to enable external services (like Google or Facebook) when logging in to a database.What Are External Service Logins?Giving a user the option to access their system accounts through external services is a growing trend among web designers. This option can provide several benefits, such as giving users one less name-and-password combination to remember. It can also help administrators personalize user experiences.

Upcoming Database Conferences: Winter 2015-2016

Once again, it’s time for a roundup of upcoming database events. Today, however, we’ll be covering events for the winter season (December 2015 to the end of February 2016) instead of our usual monthly schedule. Why are we changing it up? The holidays, for a start. Plus, organizers tend to schedule events during better traveling weather.Weather and seasonal festivities aside, the conferences are looking interesting. Berlin and Texas will go in-depth on the topic of machine learning and data science, so those interested in smart data should take note. Los Angeles and Sydney will also be hosting their own tech-centric conventions. For a more comprehensive list of software-related events, check out

Upcoming database conferences – November 2015

As per every month, here’s the database modeling, design and administration events for November. This upcoming month will feature four big database conferences. Interestingly enough, three of them, in Germany, Brazil and San Francisco, will be focusing on PostgreSQL, so this is a good month of events for Postgres developers. The fourth one,All Your Basein London, will be a fairly encompassing one, focusing not only on the software challenges and solutions but also the human elements when it comes to working with databases.

Upcoming database conferences – October 2015

For almost any software developer, database designer, or otherwise, events and conventions signify a variety of opportunities. Whether it’s keeping up with the latest patches and functions of a programming language or seeing how other developers handle the sort of problems you deal with, or maybe making business contacts or just meeting like-minded people, there’s a lot to gain from attending the right events.In this article we’re going to mention some of the most important worldwide events taking place in the upcoming month which focus specifically on database modelling, design and administration.

Upcoming database conferences – September 2015

For almost any software developer, database designers or otherwise, events and conventions signify a variety of opportunities. Whether it’s keeping up with the latest patches and functions of a language or seeing how others handle the sort of problems they deal with, or maybe making business connections or just meeting like-minded people, there’s a lot to gain from assisting the right events.In this article we’re going to mention some of the most important, worldwide events of the upcoming month which focus specifically on database modelling, design and administration.

Analysing the SQL Server Numeric Data Types

A common challenge for database modellers is deciding which data type is the best fit for a particular column. It is a problem which involves consideration of both the properties and the scale of the data that will be stored, and in no case is this more evident than when handling numeric values because of the large variety of alternatives that most relational databases provide for their storage.In this article we’ll explore the numeric data types available in SQL Server and analyse their advantages, disadvantages and general usage.

Upcoming database conferences – August 2015

For almost any software developer, database designers or otherwise, events and conventions signify a variety of opportunities. Whether it’s keeping up with the latest patches and functions of a language or seeing how others handle the sort of problems they deal with, or maybe making business connections or just meeting like-minded people, there’s a lot to gain from assisting the right events.In this article we’re going to mention some of the most important, worldwide events of the upcoming month which focus specifically on database modelling, design and administration.

Email Confirmation and Recovering Passwords

Modern applications have plenty of authentication features beside registration and login. In this article we will take a look at how to design the database for two such features: email confirmation and password recovery.Email ConfirmationWhat Is It?Most people familiar with the Internet know what an activation email is. An activation email is sent to the user after he or she registers for an account on a website or web application and contains a link that will allow the user into the system. The email is primarily used to ensure that the email address provided by the user during registration is