Paul talks with Carol Keeney of BKeeney Software about databases, requirements analysis, agile/scrum and much more.
1 CommentTag: SQL
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 CommentsMaybe 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 CommentEveryone loves SQLite. It is everywhere, it is fast and it is easy to use. Want to know how to make it even faster?
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 closedOne 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.
Comments closedSQLite has the ability to do full text searching and this feature is available with Xojo. Read on to learn how to best use it!
Comments closedXojo can connect to a wide variety of databases, including: SQLite, PostgreSQL, MySQL, Oracle, Microsoft SQL Server and pretty much anything else using ODBC. A must-read for anyone building their first database application.
Comments closed