Paul talks with Carol Keeney of BKeeney Software about databases, requirements analysis, agile/scrum and much more.
1 CommentCategory: Database
All posts related to using databases.
Using 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 CommentsXojo 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.
Comments closedHave you ever needed or wanted a populated sample database with several related tables to play around with? Perhaps you are learning about databases and database design or perhaps you want to try out a new tool such as Xojo but want a pre-build database to start with.
Comments closedI recently had someone ask me how to reorder the columns in a SQLite table. As you may be aware, the SQLite ALTER table does not have a lot of functionality compared to other databases and it certainly doesn’t have a way to do this.
Comments closedMaybe you’ve heard the term SQL injection and how it can allow unintended database access. Here’s how a SQL Injection works and what you can do to avoid it.
1 CommentAre you a consultant that uses FileMaker to create solutions for your clients? Do you work in an office and use FileMaker to run your company’s business?
Comments closedEveryone loves SQLite. It is everywhere, it is fast and it is easy to use. Want to know how to make it even faster?
Comments closedXojo Cloud has always taken the headaches out of setting up, securing, maintaining and deploying servers for web apps. Now Xojo Cloud servers are better, stronger and faster- all for the same great price!
Comments closedFormatting SQL for display can sometimes be a pain, particularly for the many different flavors of SQL. One easy way to do the formatting is to use a web service.
Comments closed