Posts by
Redgate Data Modeler
An online discussion forum is a site where people can hold conversations in the form of posted messages. Discussion forums allow conversations to take place when people are not on-line, and messages may be temporarily archived. Also, depending on the forum set-up, a message might need to be approved by a moderator before it... Read more
I recently realized that our database modeling library could use a few more advanced titles. So I headed over to Amazon to see what they had on offer. There are plenty of introductory books for beginners that tell you how to normalize data, and introduce you to indexes, but what about something for the... Read more
So many organizations face the common problem of storing employee schedules. No matter what institution: a company, a university or simply an individual, many entities need an application to view schedules. Therefore, I will try to come up with a database model and then, in a future article, we’ll talk about a simple application... Read more
One of the exciting moments in a programmer’s life is to leave legacy code behind and have fun with some new, fresh and cool tools. Today I have just such an opportunity – I’m creating the structure of a new project in Java. Read more
Most relational databases allow you to define comments for their tables, columns, views, and so on. These additional pieces of information are called database meta data or data dictionary. Meta data may be useful for developers or other database users. Meta data allow the development team to understand what various tables or columns are... Read more
In this article I’m going to show you how to design SQLAlchemy models using Vertabelo, an online tool for visual database design, and our code generator. Read more
In this article, I will try to compare two database modelers: Vertabelo in version 1.21.0 and Navicat Data Modeler in version 1.0.12. Read more
You are the owner of an online store, located in Poland. The majority of your customers are from Poland and they speak Polish. But you want to sell your products abroad too and your international customers mainly speak English. So you want your online store to be available in both Polish and English. You... Read more
We hadn’t planned on adding a feature to print diagrams. Our original idea was that Vertabelo would supersede paper diagrams. Nevertheless, some of our users pointed out that they rely heavily on printouts (Export to PDF topic). So, I'd like to announce a new feature called "Export to PDF" also known as "Printing."
Read more
Sooner or later there comes a moment when database performance is no longer satisfactory. One of the very first things you should turn to when that happens is database indexing. This article will give you a general overview on what indexes are without digging into too much detail. Read more