GDNative wrapper for SQLite (Godot 4.x+)
NOTE: This is the latest release for Godot 4.X. The latest 3.X release for this plugin can be found here.
Download the demo-project and/or the necessary binaries below.
Godot v4.2.1-stable SQLite v3.45.1
gdsqlite.gdextension
-file.open_db()
-method by returning an error if a database connection is already open.extensions_support
in Godot v4.2.1 is still very unstable and largely dependent on the Web browser that is used. For example the build of the exported demo-project crashes on Firefox, while it works most of the times on Vivaldi.default
-field in the private validate_table_dict()
-method. The method now correctly compares the type of the default
-field with the supplied string in the data_type
-field of the table_dictionary
-variable.backup_to()
- and import_from()
-methods to natively create database backups as discussed here. This can be used, for example, to easily implement a saving/loading mechanism in your project.NOTE: This is the latest release for Godot 4.X. The latest 3.X release for this plugin can be found here.
Download the demo-project and/or the necessary binaries below.
Godot v4.1-stable SQLite v3.40.1
NOTE: This is the latest release for Godot 4.X. The latest 3.X release for this plugin can be found here.
Download the demo-project and/or the necessary binaries below.
Godot v4.0.3-stable SQLite v3.40.1
create_table()
-method which should result in better error reporting.gdsqlite.gdextension
-file, but this doesn't seem to be sufficient to make the Android export functional.NOTE: This is the latest release for Godot 4.X. The latest 3.X release for this plugin can be found here.
Download the demo-project and/or the necessary binaries below.
Godot v4.0.0-stable SQLite v3.40.1
verbose_mode
-property in favor of the much more versatile verbosity_level
-property.Download the demo-project and/or the necessary binaries below.
Godot v4.0.0-rc5 SQLite v3.40.1
verbose_mode
-property in favor of the much more versatile verbosity_level
-property.Download the demo-project and/or the necessary binaries below.
Godot v3.5.1
gdsqlite.gdns
file directly, is still available for anyone that doesn't require easy access to any documentation. A huge thanks goes out to both @engineer-pearl and @leprasmurf for implementing this feature (https://github.com/2shady4u/godot-sqlite/pull/97).Download the demo-project and/or the necessary binaries below.
Godot v3.5.1
path
-property to file::memory:?cache=shared
. A huge thanks goes out to @cridenour for implementing this feature (#91).alloc_c_string()
-method now gets properly freed by calling the api->godot_free()
-method.Download the demo-project and/or the necessary binaries below.
Godot v3.4.4
query_result_by_reference
-property which allows the user to get the query's result by reference. This variable is especially handy for experienced users who are handling queries that return large quantities of data that are both unnecessary and too time-consuming to duplicate.UNIQUE
keyword in the create_table()
-method.Download the demo-project and/or the necessary binaries below.
Godot v3.4.4
last_insert_rowid
can now be manually set by the user.query()
and query_with_bindings()
can now successfully execute multiple statements at once, see #58.verbosity_level
-variable which replaces the, now deprecated, verbose_mode
-variable. This variable can be used to control the plugin's degree of console logging to a much finer extent than was previously possible. (As requested in #73)query_result
-variable is now duplicated by default. This avoids a common situation where beginning users get into issues where they are overwriting their previous query's result by executing further queries that depend on the previous result.get_autocommit()
-method used to get the database's autocommit mode. The database's autocommit mode is non-zero whenever there's a transaction in progress and can thus be used to determine if there's any dangling active transactions in the database.Download the demo-project and/or the necessary binaries below.
Godot v3.4.2
default_extension
which enables the user to define his/her own database extension; see the relevant sections in the documentation.addons/godot-sqlite/bin/ios/
-folder and added them as dependencies for the iOS binaries.