Up to date

This page is up to date for Godot 4.3. If you still find outdated information, please open an issue.

SQLiteDatabase

Inherits: Resource < RefCounted < Object

A SQLite database resource. Can be either in-memory or load a database from a file.

Description

A SQLite database resource.

Properties

Dictionary

tables

{}

Methods

SQLiteQuery	create_query(query: String, arguments: Array)
SQLiteQuery	create_table(table_name: String, columns: Array[SQLiteColumnSchema])
SQLiteQuery	delete_rows(table_name: String, condition: String = "")
SQLiteQuery	drop_table(table_name: String)
SQLiteQueryResult	execute_query(query: String, arguments: Array)
Array[SQLiteColumnSchema]	get_columns(table_name: String) const
SQLiteAccess	get_sqlite()
SQLiteQuery	insert_row(table_name: String, value: Dictionary)
SQLiteQuery	insert_rows(table_name: String, values: Array[Dictionary])
SQLiteQuery	select_rows(table_name: String, condition: String = "")
void	set_data(data: PackedByteArray)

---

Property Descriptions

Dictionary tables = {} 🔗

• Dictionary get_tables()

There is currently no description for this property. Please help us by contributing one!

---

Method Descriptions

SQLiteQuery create_query(query: String, arguments: Array) 🔗

Creates a new query object.

---

SQLiteQuery create_table(table_name: String, columns: Array[SQLiteColumnSchema]) 🔗

Creates a new table.

---

SQLiteQuery delete_rows(table_name: String, condition: String = "") 🔗

Deletes rows from a table.

---

SQLiteQuery drop_table(table_name: String) 🔗

Drops a table.

---

SQLiteQueryResult execute_query(query: String, arguments: Array) 🔗

Create and execute a query directly.

---

Array[SQLiteColumnSchema] get_columns(table_name: String) const 🔗

Returns the columns of a table.

---

SQLiteAccess get_sqlite() 🔗

Returns the underlying SQLite object.

---

SQLiteQuery insert_row(table_name: String, value: Dictionary) 🔗

Inserts a row into a table.

---

SQLiteQuery insert_rows(table_name: String, values: Array[Dictionary]) 🔗

Inserts multiple rows into a table.

---

SQLiteQuery select_rows(table_name: String, condition: String = "") 🔗

Selects rows from a table.

---

void set_data(data: PackedByteArray) 🔗

Sets the data of the database.