SQLite Database

  1. SQLite Extensions and Advanced Capabilities
    1. Full-Text Search
      1. FTS3 Virtual Tables
        1. FTS4 Virtual Tables
          1. FTS5 Virtual Tables
            1. Creating an FTS Index
              1. Performing Full-Text Queries with MATCH
                1. Ranking and Ordering Search Results
                  1. Tokenizers and Customization
                    1. Auxiliary Functions
                      1. Performance Tuning for FTS
                      2. JSON Support
                        1. Storing JSON as TEXT
                          1. JSON Functions
                            1. json Function
                              1. json_extract Function
                                1. json_insert Function
                                  1. json_replace Function
                                    1. json_set Function
                                      1. json_type Function
                                        1. json_array Function
                                          1. json_object Function
                                            1. json_each Function
                                              1. json_tree Function
                                              2. Querying and Manipulating JSON Data
                                                1. JSON Path Expressions
                                                  1. Performance Considerations
                                                  2. R*Tree Module
                                                    1. Purpose and Use Cases
                                                      1. Creating R*Tree Virtual Tables
                                                        1. Geospatial Indexing and Queries
                                                          1. Spatial Query Operations
                                                            1. Performance Optimization
                                                            2. Virtual Tables
                                                              1. Virtual Table Interface
                                                                1. Creating Custom Virtual Tables
                                                                  1. Built-in Virtual Table Modules
                                                                    1. Performance Considerations
                                                                    2. Database Attachment
                                                                      1. The ATTACH DATABASE Command
                                                                        1. Syntax and Usage
                                                                          1. Querying Across Multiple Databases
                                                                            1. Cross-Database Joins
                                                                              1. Detaching Databases
                                                                                1. Security Considerations

                                                                              Previous

                                                                              8. Using SQLite with Programming Languages

                                                                              Go to top

                                                                              Next

                                                                              10. SQLite Internals and Architecture