Xojo Documentation Xojo Documentation

These questions are related to working with SQLite.

Where can I find more information about SQLite in the docs?

First, be sure to check out the SQLite category: Category:SQLite.

The User Guide has several SQLite topics:

• UserGuide:SQLite Database
• UserGuide:SQLite Column Renaming and Deleting
• UserGuide:SQLite Full Text Searching
• UserGuide:SQLite Write-Ahead Logging

You may also find general database topics helpful:

• Category:User_Guide_Framework_Databases

Do you have any videos about SQLite?

Yes, these videos are available:

• Using SQLite
• About SQLite
• Advanced SQLite
• Connecting to Databases

How do I use Full Text Searching?

Full Text Searching gives you a way to quickly search for text in a table. The UserGuide:SQLite Full Text Searching topic describes how you can use this feature.

You can also refer to these example projects:

• Examples/Database/SQLite/FTSExample
• Examples/Database/SQLite/FTS5Example

When should I use Write-Ahead Logging?

The UserGuide:SQLite Write-Ahead Logging topic talks about write-ahead logging and when it makes sense to use it.

How can I rename columns in a SQLite table?

SQLite has a limited ALTER TABLE command that does not directly allow you to rename a table column. You can workaround that by creating a new table and copying your data to it as described in the Renaming Columns topic.

The ability to rename columns was added to SQLite 3.25 which is available starting with Xojo 2018 Release 4.