Skip to content

Tag: Tips

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.

Continue reading About PostgreSQL Case Sensitivity

Comments closed

Guest Post: 5 Tips to Control Development Business Chaos

Having problems controlling your projects and clients enough to enjoy your life and have fun developing software? If you can put a few systems in place, you will deliver better customer service, increase your productivity, and communicate better. Here are five tips to help you on your path of reigning in the chaos.

Continue reading Guest Post: 5 Tips to Control Development Business Chaos

Comments closed

Xojo Programming Language: 6 Fascinating Facts

Xojo is similar to VB, Java and C#

The Xojo programming language is fully object-oriented and uses an object model that is quite similar to VB, Java and C#. If you are used those languages at all, you’ll be right at home with Xojo.

Available since 1998, Xojo was one of the first languages to use Automatic Reference Counting (ARC), something that other languages such as Swift and Objective-C now use. Xojo is type-safe and fully object-oriented making it easy to learn and use, but it also has advanced features such as namespaces, extension methods, exception handling, introspection, delegates and more.

Continue reading Xojo Programming Language: 6 Fascinating Facts

Comments closed