Others

Six Things You Need to Know About Securing Your Database

by Marian Dziubiak
2 May 2017 Whether you store secret government information or standard user data, you don’t want some unknown person to access to your database. Especially if they’re an evil hacker. So what can you do to protect your sensitive information? Lack of Security Is a Huge Problem Generally, people want to do the minimum. When they set up the database environment, they often forget about securing it. Or they rely on someone else to do it for them, as many MongoDB users did.
Read more
Others

How to Set Up a Composite Primary Key in jOOQ and Hibernate

by Patrycja Dybka
1 Sep 2016 In today’s article, we will take a look at composite primary key support in two top Java ORMs: jOOQ and Hibernate. We’ll look at a couple examples, learn how column configuration looks in Hibernate, and how support is organized in jOOQ. The composite primary key is a key that consists of more than one column, and its column combination guarantees its uniqueness. To handle the connection to the database, the application uses libraries known as object-relational mappers, or ORMs.
Read more
Others

How to Develop a Simple Tic Tac Toe Game with Spring Boot and AngularJS

by Patrycja Dybka
30 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.
Read more
Others

What a Concept! Is Logical Data Modeling Obsolete?

by Andrew Wolfe
19 Jul 2016 When databases were sized in megabytes rather than petabytes, their design was a well-defined discipline of data analysis and implementation. A progression of modeling steps – from conceptual and logical through relational and/or physical – promised successful deployment. But as we passed more orders of magnitude in data volume, we seemed to stop seeking modeling approaches to manage that volume. So the question arises: Is logical data modeling obsolete?
Read more
Others

CHAR and VARCHAR Data Types in Different Database Engines

by Patrycja Dybka
31 May 2016 Storage engines can surprise you. For example, take the CHAR data type. It expects an exact number of characters and by definition stores a fixed amount of information. However, you don’t have to fill all the available CHAR space – a shorter value will work. This is so similar to VARCHAR that I decided to explore the differences between these two types. Before diving into the details, let’s start with some basic information.
Read more
Others

Database Design

by Michael Blaha
13 Apr 2016 I’ve been practicing agile database techniques for about twenty years now. My use of these techniques didn’t start as a set plan; rather, it evolved over time as I consulted on various projects. It made sense to look for ways of working faster and with greater customer interaction. I can think of at least three kinds of agile database techniques: Data modeling Data warehouse development Database reverse engineering Agile Data Modeling Many think of data modeling as a laborious task.
Read more
Others

How to Embed Your Database Model Into a Website

by Adrian Więch
6 Apr 2016 Did you know that you can embed your database model in your website? If you haven’t tried this yet, now’s your chance – we’ve recently improved the process. It’s an excellent way to share ideas with readers or make projects available to co-workers. You might have already seen some interactive models embedded in our blog. They look like this: if (typeof VertabeloEmbededObject === 'undefined') {var VertabeloEmbededObject = "loading";var s=document.createElement("script");s.setAttribute("type","text/javascript");s.setAttribute("src", "
Read more
Others

SQLite Tools for Objective-C

by Pawel Poskrobko
4 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. Fortunately, you are not forced to use core SQLite API in pure C.
Read more
Others

A Comparison of Android ORMs

by Pawel Poskrobko
1 Mar 2016 Although mobile apps do not rely on databases as much as, say, web applications, mobile app developers should still be interested in databases. There are better database solutions for Android apps than a native SQLite library; we’ll nominate ORMs (Object Relational Mapping) as one of them. ORMs make developers’ lives easier. They let us avoid struggling with building queries by concatenating strings or manually handling the connection with database. Typos are less of threat to your queries.
Read more
Others

Business Logic in the Database. Yes or No? It Depends!

by Lukas Eder
19 Jan 2016 We’ve had tremendously positive feedback on my recent article that talked about “Why SQL is neither legacy, nor low-level, nor difficult, nor the wrong place for (business) data logic, but simply awesome” both within the blog’s comment section as well as on reddit. However, one of the sections triggered very controversial feedback. Clearly, not everyone agreed to: Fallacy #5: The database is the wrong place for business logic
Read more