Skip to content

Month: September 2016

About PostgreSQL Case Sensitivity

I’ve ran into PostgreSQL case sensitivity myself before and I’ve seen it come up on the forums, so I thought it might be a good thing to bring up here.

Sometimes you hear that PostgreSQL is case-insensitive, but it isn’t really. What it actually does is convert your SQL to lowercase by default. So take a look at this SQL:

SELECT FullName FROM Person

This gets converted to:

SELECT fullname FROM person

That is nice if you happen to like to write your queries with mixed casing.

Comments closed

iOS Tutorial: Shorten that URL!

In this Xojo tutorial we will see how simple it is to make an iOS App that shortens an entered URL using the public API of Bit.ly. We will use our own subclass inherited from Xojo.Net.HTTPSocket, and the Declare statement in order to use some functions and methods found on the native Cocoa Touch API. In fact, the use of Declare is mandatory because with the new Xojo Framewok we don’t yet have access to the EncodeURLComponent function available with the old framework. This one is a big help in substituting any ilegal character with his hexadecimal value for the final URL’s composition.

Comments closed

iPad Apps and ITMS-90474 Error

Starting with iOS 9, some iPads now support app multitasking which allows you to use more than one app at a time on the device. These apps can be displayed side-by-side or with an overlay. Your Xojo iOS apps support this feature automatically when all the Supported Orientations for the iPadScreen are turned on for your app.

Comments closed