Blog about the Xojo programming language and IDE
Based on recent conversations with a couple Xojo users, here are a few quick tips for uploading and working with SQLite and MySQL databases on Xojo Cloud.
If you aren’t already familiar with Xojo Cloud, it’s simple, secure, maintenance-free hosting for your Xojo web apps.
Comments closedThis tutorial will show you how to deploy your SQLite based projects so they behave right on Desktop, Web and iOS, copying the database file to the right place on every target.
Comments closedIn a recent Star Trek Discovery episode, the crew was investigating how a probe (from the future!) was attempting to hack into their systems. This is what was said about it:
It’s very usual to use encrypted SQLite databases in our Xojo projects where we expect to get the maximum read speed from them. But the truth is that encrypting the data in these databases can introduce a penalty in our queries, both from read and writing/updating data to them. How can we improve this? One technique is the creation of a new in-memory based SQLite database, where we will be able to copy the table (or tables) we are interested in getting the maximum speed possible with. Continue reading to see how to do this.
Comments closedIf 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 closedXojo 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 closed
