Integrate Cool Applications with

Integrate Cool Applications with

The API gives developers access to posts and comments, as well as the ability to Follow, Like, or Reblog content for users. Other features from, like the daily handpicked content on Freshly Pressed, are also available through the API.

An excellent example of an application that uses the new API is the Windows 8 app, available now.

Our goal with the new API is to simplify the experience of using and adding to the data available on To do this, we now use the OAuth2 protocol to authenticate requests for data. To retrieve public data, you can make unauthenticated requests. To perform actions, such as making new posts or comments, you would need to make authenticated requests. When the API returns data, we now return a standardized JSON object for ease-of-use.

The REST API also self-documents itself; as we add new endpoints, the documentation on our Developer Resources blog will auto-update to provide you with the latest information. In addition, you’ll also have access to a Developer Console, which will allow you to run real REST API queries and see real JSON data directly in your web browser. You can read more about the Console here.

Ready to build an app and integrate it with Great! You can now sign up for and manage your OAuth2 tokens without waiting through an approval cycle. If you have any questions or feedback on the API, please get in touch with us. Make sure to follow the Developer Resources blog for news, updates, and documentation about the REST API and other awesome services we are making available to developers seeking to integrate with

Memories of Amsterdam.

Entering Amsterdam through the beautiful Centraal Station…devouring every dessert my stomach can hold at Unlimited Delicious in the Jordaan…shopping (window shopping, really) at Amsterdam’s largest department store – De Bijenkorf…observing the stylish women of Amsterdam on bike after bike after bike… (they’re so well put together!)


via Memories of Amsterdam..

Introduction to SQL

SQL Tutorial

SQL (Structured Query Language) is used to modify and access data or information from a storage area called database. This beginner sql tutorial website teaches you the basics of SQL and how to write SQL queries. I will be sharing my knowledge on SQL and help you learn SQL better. The sql concepts discussed in this tutorial can be applied to most of database systems. The syntax used to explain the concepts is similar to the one used in Oracle database.

SQL Introduction

SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”. It is a query language used for accessing and modifying information in the database. IBM first developed SQL in 1970s. Also it is an ANSI/ISO standard. It has become a Standard Universal Language used by most of the relational database management systems (RDBMS). Some of the RDBMS systems are: Oracle, Microsoft SQL server, Sybase etc. Most of these have provided their own implementation thus enhancing it’s feature and making it a powerful tool. Few of the sql commands used in sql programming are SELECT Statement, UPDATE Statement, INSERT INTO Statement, DELETE Statement, WHERE Clause, ORDER BY Clause, GROUP BY Clause, ORDER Clause, Joins, Views, GROUP Functions, Indexes etc.

In a simple manner, SQL is a non-procedural, English-like language that processes data in groups of records rather than one record at a time. Few functions of SQL are:

  • store data
  • modify data
  • retrieve data
  • modify data
  • delete data
  • create tables and other database objects
  • delete data

SQL SELECT Statement

The most commonly used SQL command is SELECT statement. The SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must specify the column(s) name and the table name. The whole query is called SQL SELECT Statement.

Syntax of SQL SELECT Statement:

SELECT column_list FROM table-name
[WHERE Clause]
[GROUP BY clause]
[HAVING clause]
[ORDER BY clause];

  • table-name is the name of the table from which the information is retrieved.
  • column_list includes one or more columns from which data is retrieved.
  • The code within the brackets is optional.

database table student_details;

id first_name last_name age subject games
100 Rahul Sharma 10 Science Cricket
101 Anjali Bhagwat 12 Maths Football
102 Stephen Fleming 09 Science Cricket
103 Shekar Gowda 18 Maths Badminton
104 Priya Chandra 15 Economics Chess

NOTE: These database tables are used here for better explanation of SQL commands. In reality, the tables can have different columns and different data.

For example, consider the table student_details. To select the first name of all the students the query would be like:

SELECT first_name FROM student_details;

NOTE: The commands are not case sensitive. The above SELECT statement can also be written as “select first_name from students_details;”

You can also retrieve data from more than one column. For example, to select first name and last name of all the students.

SELECT first_name, last_name FROM student_details;

You can also use clauses like WHERE, GROUP BY, HAVING, ORDER BY with SELECT statement. We will discuss these commands in coming chapters.

NOTE: In a SQL SELECT statement only SELECT and FROM statements are mandatory. Other clauses like WHERE, ORDER BY, GROUP BY, HAVING are optional.

How to use expressions in SQL SELECT Statement?

Expressions combine many arithmetic operators, they can be used in SELECT, WHERE and ORDER BY Clauses of the SQL SELECT Statement.

Here we will explain how to use expressions in the SQL SELECT Statement. About using expressions in WHERE and ORDER BY clause, they will be explained in their respective sections.

The operators are evaluated in a specific order of precedence, when more than one arithmetic operator is used in an expression. The order of evaluation is: parentheses, division, multiplication, addition, and subtraction. The evaluation is performed from the left to the right of the expression.

For example: If we want to display the first and last name of an employee combined together, the SQL Select Statement would be like

SELECT first_name || ' ' || last_name FROM employee;


first_name || ‘ ‘ || last_name
Rahul Sharma
Anjali Bhagwat
Stephen Fleming
Shekar Gowda
Priya Chandra

You can also provide aliases as below.

SELECT first_name || ' ' || last_name AS emp_name FROM employee;


Rahul Sharma
Anjali Bhagwat
Stephen Fleming
Shekar Gowda
Priya Chandra