SQLite 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 closedCategory: Database
All posts related to using databases.
Xojo Cloud is now available with plans starting at just $49 per month for a fully managed and secure cloud server for running your Xojo web apps. What does this mean for your web apps?
Comments closedI am often asked when it makes sense to use Commit with your database code. The answer is always “it depends”. To go into more detail, let’s talk a bit about transactions.
Comments closedThe SQLite ALTER TABLE command is somewhat limited. For one thing, it cannot be used to rename an existing column on a table. But there is a workaround.
Comments closedXojo ships with 5 database plugins in the Plugins folder. These plugins are what you use to connect to the following database servers and ODBC:
- Microsoft SQL Server
- MySQL
- Oracle
- PostgreSQL
The ODBC database plugin allows you to connect to any database engine that supports ODBC connections.
Comments closed
Your Xojo apps can connect to many different databases, including PostgreSQL, MySQL, Oracle, Microsoft SQL Server and ODBC. Learn more about connecting to different database servers here.
We get all sorts of questions about connecting your apps to specific databases. Recently, a developer asked about connecting his app to the PostgreSQL database using SSL for a secure connection. In Xojo this is simple.
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