Skip to content

Tag: PostgreSQL

Appreciating SQL

Noted recently at the SQLizer blog, the SQL language was first created 43 years ago. And what is remarkable about that is that SQL is still used today. According to the Stack Overflow 2017 developer survey it is the #2 programming language. Not many languages remain in use for such a long period of time. Although we’re happy to also note that Xojo celebrated our 20th anniversary in 2016!

Continue reading Appreciating SQL

Comments closed

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

Xojo Cloud Databases: Add, Connect & Manage

One of the most popular Xojo Cloud feature requests was to add database support. On Tuesday Feb 10th, we added MySQL and Postgres databases for Xojo Cloud. In addition to having a database server right on your Xojo Cloud server, we have also enabled the creation of SSH Tunnels so you can connect directly to the databases using a 3rd party management tool.

Continue reading Xojo Cloud Databases: Add, Connect & Manage

Comments closed