# SQLite components

| [tSQLiteClose](https://help.qlik.com/talend/r/en-US/7.3/components/sqlite/tsqliteclose) | Closes a transaction committed in the connected DB. |
| --- | --- |
| [tSQLiteCommit](https://help.qlik.com/talend/r/en-US/7.3/components/sqlite/tsqlitecommit) | Commits in one go, using a unique connection, a global transaction instead of doing<br>that on every row or every batch and thus provides gain in performance. |
| [tSQLiteConnection](https://help.qlik.com/talend/r/en-US/7.3/components/sqlite/tsqliteconnection) | Opens a connection to the database for a current transaction. |
| [tSQLiteInput](https://help.qlik.com/talend/r/en-US/7.3/components/sqlite/tsqliteinput) | Executes a DB query with a defined command which must correspond to the schema<br>definition. It passes on rows to the next component via a Main row link. |
| [tSQLiteOutput](https://help.qlik.com/talend/r/en-US/7.3/components/sqlite/tsqliteoutput) | Executes the action defined on the table and/or on the data contained in the table,<br>based on the flow incoming from the preceding component in the job. |
| [tSQLiteRollback](https://help.qlik.com/talend/r/en-US/7.3/components/sqlite/tsqliterollback) | Cancels the transaction committed in the SQLite database. |
| [tSQLiteRow](https://help.qlik.com/talend/r/en-US/7.3/components/sqlite/tsqliterow) | Executes the defined query onto the specified database and uses the parameters<br>bound with the column. |