OneWebSQL Is Going Mobile

Yes. We are implementing support for iOS and Android platforms. As always, we eat our own dog food first, and then finalize the product. Our customers can be assured that they are buying a battle proven product. …

Read the whole article

Comments

SQL Course - Part 6. Selecting Columns

If you need a reminder on how to set up the environment for this course, see the Environment and Basic Select posts.

As you know, SQL is a language to select data. It is a common situation that only some columns of a table are of interest, not all of them. For example, you want to know the titles of books in the database, and you don't care about publication year or number of pages. Run this query:

Read the whole article

Comments

News: Educational and Non-Commercial Licenses

Recently, we've released Educational and Non-Commercial Licenses for OneWebSQL.

Educational (Academic) License

OneWebSQL's Educational License is designed for students and academic institutions.

Read the whole article

Comments

Find Out What's Happening in Your PostgreSQL Database

So you want to monitor the behavior of your PostgreSQL database. Great! Let's start with a brief overview of how PostgreSQL collects statistics.

PostgreSQL has a set of statistics access functions, as well as a set of predefined statistics views. The views use the predefined statistics functions.

By default only a small number of statistics are collected. The statistics collection is controlled by the following configuration parameters:

Read the whole article

Comments

What's Up, Dear Reader?

I started thinking about this post entry. What subject should I cover? In the previous few posts I've started writing with a season theme: summer, fall or winter. I just realized that we've got this blog for 6 or 7 months up and running. This time I want to start with something different. The question comes to my mind. What's up, dear reader? I know you are there. I know you're reading this. I can't say I can hear your breath, but I can see your browser activity. I've checked a HTTP log file, clever me :)

Read the whole article

Comments