Skip to content

Month: September 2016

About PostgreSQL Case Sensitivity

About PostgreSQL Case Sensitivity

Published September 28, 2016 by Paul Lefebvre

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.

Continue readingAbout PostgreSQL Case Sensitivity
Comments closed
iOS Tutorial: Shorten that URL!

iOS Tutorial: Shorten that URL!

Published September 20, 2016 by Javier Menendez

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.

Continue readingiOS Tutorial: Shorten that URL!
Comments closed

iPad Apps and ITMS-90474 Error

Published September 6, 2016 by Paul Lefebvre

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.

Continue readingiPad Apps and ITMS-90474 Error
Comments closed