If you are using SQLite you might be trying to share your database. What are your options when you want to be able to share your database?
Comments closedTag: SQL
Xojo 2018 Release 4 updated SQLite to 3.25. The SQLite 3.25 release had two significant changes: Window Functions and an improved ALTER TABLE command.
Comments closedDo you need to know what version of MySQL you’re using in code? Maybe you need one of the many other configuration parameters that MySQL offers? It’s easy to get this information with some simple code!
Comments closedHere at Xojo, we ❤️ SQLite so much – It’s truly a great database to use for all kinds of apps.
Here are 8 reasons why you should be using SQLite with your apps:
Comments closedWhether you are new to building database applications or you need to expand your toolbox, Xojo is a smart choice. With Xojo you can build real, native apps. And Xojo’s powerful language allows for rapid app development while supporting a wide variety of databases and ODBC, plus it offers flexible form design, database binding, reporting and more.
Comments closedPostgreSQL is an open source object-relational database system that’s had more than 15 years of active development. Here are 7 reasons you should be using PostgreSQL.
Comments closedNoted 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!
Comments closedI’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 closedPaul talks with Carol Keeney of BKeeney Software about databases, requirements analysis, agile/scrum and much more.
1 CommentUsing databases with web apps is not much different than using them with desktop apps, but there are a few things to keep in mind. The most important thing to note is that a web app allows multiple users. This means you’ll want your database connection to be unique for each user that connects to the web app, rather than global to the app itself (as is common in desktop apps). The simplest way to ensure this is to create the connection to your database in the WebSession.Open event handler, saving a reference to the connection as a property that you add to WebSession.
6 Comments