Skip to content

Category: Database

All posts related to using databases.

Unlock the all in one, low-code, cross-platform solution

Like his father, my teenage son loves video games. The single player games where you take a character through some kind of adventure are the ones I like most. These usually have a fair number of AI-controlled enemies that must be defeated. My son, on the other hand, prefers to play against other human beings. When I asked him why, he said, “The AIs are so predictable.” To prove this to me, he took over when I was having trouble defeating a particularly difficult enemy and quickly dispatched him, narrating his strategy as he went and barely being scratched in the process. My son is an elite player compared to me partially because he puts a lot more time into it than I do but also because he loves video games far more than I do.

Just as people have varying levels of skill and interest in video games, the same is true of app development. There are those that are happy to devote enormous amounts of time to learning everything they possibly can. They don’t care how long it takes. They want to have control over everything and are willing to do whatever is necessary to make that happen. I’m so glad those people exist because there’s a lot of great software that might not otherwise have been created without them. I’m not one of those people. I really want to focus mostly on what makes my application unique, abstracted from the nitty-gritty of app development.

That’s why I have always been attracted to tools like Xojo. I am a citizen developer. Of all the job titles I have had over the years, all of them in tech,  none have ever included words like programmer or engineer. I do some software development but it’s just a part of my job. It’s something I do to help me in my work or to help my co-workers.

Comments closed

Do I need a Xojo Cloud server during development?

If you are just starting the development of your first web app you may be wondering if you need to get a Xojo Cloud server right away. In most cases, the answer is no. You can develop your application on your own computer and sign up for a Xojo Cloud server when you are getting close to deployment and are ready to test in as close to a real world situation as possible.

There are differences of course between how a web app will execute on your computer with a single user (you) versus on a server that is anywhere from hundreds to thousands of miles away with many users connected all at the same time. For the most part, you don’t have to think very much about this but there are areas where you should.

Keep the following 3 things in mind when developing without a cloud server.

Comments closed

A Better Alternative to PHP

Are you tired of the hassles of creating web apps using PHP? Why not develop faster and smarter with Xojo?

Like PHP, Xojo is object-oriented. Unlike PHP, Xojo has a coherent framework design that is easy to work with; plus the Xojo language is simple and focused.

Comments closed

Spotlight: Build Flexible, Powerful and Secure Database Applications

Whether 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 closed

Simple Web Development with Xojo

Do you find it frustrating to create web apps? HTML, CSS, JavaScript, and AJAX can be challenging, and frameworks such as Node, React, Ruby on Rails, ASP.NET, PHP and Java are often overwhelming for those just beginning web development.

There is a simpler solution: Xojo. Using a single programming language and a single IDE, you can go from zero to a working web app in an amazingly short amount of time with Xojo.

Comments closed

Making a Web App: Comparing Xojo and Visual Studio for Mac

In previous articles, I’ve written about how Xojo is often much, much easier to use and more capable than Visual Studio for Mac for creating Mac and cross-platform desktop apps.

Visual Studio can also create web apps and as it would turn out, you may find that Xojo is a better option for web apps.

Technically, Visual Studio for Mac can create ASP.NET Core Web Apps. These type of web apps use the ASP.NET framework, but do not provide a form (layout editor) for your app’s user interface. Instead you’ll have to create everything in code, including mapping UI actions to corresponding code. ASP.NET Core also requires you to use the MVC (model-view-controller) design pattern, which can be a bit daunting for beginners.

Comments closed

SoundEx Algorithm

Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English. It is commonly used with databases to help with searching and is built-in to many database engines such as PostgreSQL and MySQL. SoundEx is not included with SQLite by default and there may be situations when you want to use it when searching.

Comments closed