All posts tagged “data

comment 0

SQL Cheat Sheet

You can get the latest version of this SQL cheat sheet here: https://gist.github.com/janikvonrotz/6e27788f662fcdbba3fb

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.
Read More

comment 0

Build a Java 3-tier application from scratch – Part 3: Object-relational mapping

Welcome to third part of my 3-tier application tutorial. Within this and the next part we are going to develope simple webservice that communicates with the database and maps Java objects to data tables.
We will create a controller that communicates with our MySQL database using the EclipseLink ORM to abstract this process.

Here’s a picture of what we want to achieve. A simple webservice that’s serves depending on the url an array of json data.

Java 3-tier webservice
Read More

comment 0

Why you should use Piwik instead of Google Analytics

Piwik is growing fast, it’s getting smarter and more reliable every day. Right now it’s the time to think about this alternative web analytic solution.
As I’m using it for years I forgot the original cause that made me replace Google Analytics with Piwik.

So here are my most important perks for using Piwik instead of Google Analytics:
Read More