XenoAtom.Interop.sqlite 1.1.0-alpha.2

XenoAtom.Interop.sqlite

This package provides a low-level and modern .NET P/Invoke wrapper around the SQLite database engine.

♻️ XenoAtom.Interop

This package is part of the XenoAtom.Interop project.

SQLite is a small and fast SQL database engine. For more information, see sqlite website.

💻 Usage

After installing the package, you can access the library through the static class XenoAtom.Interop.sqlite.

For more information, see the official documentation at https://www.sqlite.org/docs.html.

Example of using this library in C#:

using static XenoAtom.Interop.sqlite;

// Open a connection to a database
var ret = sqlite3_open("path/to/database", out var db);
if (ret != SQLITE_OK)
{
    var errmsg = sqlite3_errmsg(db);
    // ...
}

// Do something with the database
// ...

📦 Compatible Native Binaries

This library does not provide C native binaries but only P/Invoke .NET bindings to sqlite 3.45.3-r1.

If the native library is already installed on your system, check the version installed. If you are using this library on Alpine Linux, see the compatible version in the Supported API section below. Other OS might require a different setup.

For convenience, you can install an existing NuGet package (outside of XenoAtom.Interop project) that is providing native binaries. The following packages were tested and are compatible with XenoAtom.Interop.sqlite:

📚 Supported API

This package is based on the following header version:

• sqlite C include headers: sqlite-dev
• Version: 3.45.3-r1
• Distribution: AlpineLinux v3.20

The following API were automatically generated from the C/C++ code:

• sqlite3.h: sqlite3_aggregate_context, sqlite3_aggregate_count, sqlite3_auto_extension, sqlite3_autovacuum_pages, sqlite3_backup_finish, sqlite3_backup_init, sqlite3_backup_pagecount, sqlite3_backup_remaining, sqlite3_backup_step, sqlite3_bind_blob, sqlite3_bind_blob64, sqlite3_bind_double, sqlite3_bind_int, sqlite3_bind_int64, sqlite3_bind_null, sqlite3_bind_parameter_count, sqlite3_bind_parameter_index, sqlite3_bind_parameter_name, sqlite3_bind_pointer, sqlite3_bind_text, sqlite3_bind_text16, sqlite3_bind_text64, sqlite3_bind_value, sqlite3_bind_zeroblob, sqlite3_bind_zeroblob64, sqlite3_blob_bytes, sqlite3_blob_close, sqlite3_blob_open, sqlite3_blob_read, sqlite3_blob_reopen, sqlite3_blob_write, sqlite3_busy_handler, sqlite3_busy_timeout, sqlite3_cancel_auto_extension, sqlite3_changes, sqlite3_changes64, sqlite3_clear_bindings, sqlite3_close, sqlite3_close_v2, sqlite3_collation_needed, sqlite3_collation_needed16, sqlite3_column_blob, sqlite3_column_bytes, sqlite3_column_bytes16, sqlite3_column_count, sqlite3_column_database_name, sqlite3_column_database_name16, sqlite3_column_decltype, sqlite3_column_decltype16, sqlite3_column_double, sqlite3_column_int, sqlite3_column_int64, sqlite3_column_name, sqlite3_column_name16, sqlite3_column_origin_name, sqlite3_column_origin_name16, sqlite3_column_table_name, sqlite3_column_table_name16, sqlite3_column_text, sqlite3_column_text16, sqlite3_column_type, sqlite3_column_value, sqlite3_commit_hook, sqlite3_compileoption_get, sqlite3_compileoption_used, sqlite3_complete, sqlite3_complete16, sqlite3_config, sqlite3_context_db_handle, sqlite3_create_collation, sqlite3_create_collation16, sqlite3_create_collation_v2, sqlite3_create_filename, sqlite3_create_function, sqlite3_create_function16, sqlite3_create_function_v2, sqlite3_create_module, sqlite3_create_module_v2, sqlite3_create_window_function, sqlite3_data_count, sqlite3_database_file_object, sqlite3_db_cacheflush, sqlite3_db_config, sqlite3_db_filename, sqlite3_db_handle, sqlite3_db_mutex, sqlite3_db_name, sqlite3_db_readonly, sqlite3_db_release_memory, sqlite3_db_status, sqlite3_declare_vtab, sqlite3_deserialize, sqlite3_drop_modules, sqlite3_enable_load_extension, sqlite3_enable_shared_cache, sqlite3_errcode, sqlite3_errmsg, sqlite3_errmsg16, sqlite3_error_offset, sqlite3_errstr, sqlite3_exec, sqlite3_expanded_sql, sqlite3_expired, sqlite3_extended_errcode, sqlite3_extended_result_codes, sqlite3_file_control, sqlite3_filename_database, sqlite3_filename_journal, sqlite3_filename_wal, sqlite3_finalize, sqlite3_free, sqlite3_free_filename, sqlite3_free_table, sqlite3_get_autocommit, sqlite3_get_auxdata, sqlite3_get_clientdata, sqlite3_get_table, sqlite3_global_recover, sqlite3_hard_heap_limit64, sqlite3_initialize, sqlite3_interrupt, sqlite3_is_interrupted, sqlite3_keyword_check, sqlite3_keyword_count, sqlite3_keyword_name, sqlite3_last_insert_rowid, sqlite3_libversion, sqlite3_libversion_number, sqlite3_limit, sqlite3_load_extension, sqlite3_log, sqlite3_malloc, sqlite3_malloc64, sqlite3_memory_alarm, sqlite3_memory_highwater, sqlite3_memory_used, sqlite3_msize, sqlite3_mutex_alloc, sqlite3_mutex_enter, sqlite3_mutex_free, sqlite3_mutex_held, sqlite3_mutex_leave, sqlite3_mutex_notheld, sqlite3_mutex_try, sqlite3_next_stmt, sqlite3_open, sqlite3_open16, sqlite3_open_v2, sqlite3_os_end, sqlite3_os_init, sqlite3_overload_function, sqlite3_prepare, sqlite3_prepare16, sqlite3_prepare16_v2, sqlite3_prepare16_v3, sqlite3_prepare_v2, sqlite3_prepare_v3, sqlite3_profile, sqlite3_progress_handler, sqlite3_randomness, sqlite3_realloc, sqlite3_realloc64, sqlite3_release_memory, sqlite3_reset, sqlite3_reset_auto_extension, sqlite3_result_blob, sqlite3_result_blob64, sqlite3_result_double, sqlite3_result_error, sqlite3_result_error16, sqlite3_result_error_code, sqlite3_result_error_nomem, sqlite3_result_error_toobig, sqlite3_result_int, sqlite3_result_int64, sqlite3_result_null, sqlite3_result_pointer, sqlite3_result_subtype, sqlite3_result_text, sqlite3_result_text16, sqlite3_result_text16be, sqlite3_result_text16le, sqlite3_result_text64, sqlite3_result_value, sqlite3_result_zeroblob, sqlite3_result_zeroblob64, sqlite3_rollback_hook, sqlite3_rtree_geometry_callback, sqlite3_rtree_query_callback, sqlite3_serialize, sqlite3_set_authorizer, sqlite3_set_auxdata, sqlite3_set_clientdata, sqlite3_set_last_insert_rowid, sqlite3_shutdown, sqlite3_sleep, sqlite3_snapshot_cmp, sqlite3_snapshot_free, sqlite3_snapshot_get, sqlite3_snapshot_open, sqlite3_snapshot_recover, sqlite3_soft_heap_limit, sqlite3_soft_heap_limit64, sqlite3_sourceid, sqlite3_sql, sqlite3_status, sqlite3_status64, sqlite3_step, sqlite3_stmt_busy, sqlite3_stmt_explain, sqlite3_stmt_isexplain, sqlite3_stmt_readonly, sqlite3_stmt_scanstatus, sqlite3_stmt_scanstatus_reset, sqlite3_stmt_scanstatus_v2, sqlite3_stmt_status, sqlite3_str_append, sqlite3_str_appendall, sqlite3_str_appendchar, sqlite3_str_errcode, sqlite3_str_finish, sqlite3_str_length, sqlite3_str_new, sqlite3_str_reset, sqlite3_str_value, sqlite3_strglob, sqlite3_stricmp, sqlite3_strlike, sqlite3_strnicmp, sqlite3_system_errno, sqlite3_table_column_metadata, sqlite3_test_control, sqlite3_thread_cleanup, sqlite3_threadsafe, sqlite3_total_changes, sqlite3_total_changes64, sqlite3_trace, sqlite3_trace_v2, sqlite3_transfer_bindings, sqlite3_txn_state, sqlite3_unlock_notify, sqlite3_update_hook, sqlite3_uri_boolean, sqlite3_uri_int64, sqlite3_uri_key, sqlite3_uri_parameter, sqlite3_user_data, sqlite3_value_blob, sqlite3_value_bytes, sqlite3_value_bytes16, sqlite3_value_double, sqlite3_value_dup, sqlite3_value_encoding, sqlite3_value_free, sqlite3_value_frombind, sqlite3_value_int, sqlite3_value_int64, sqlite3_value_nochange, sqlite3_value_numeric_type, sqlite3_value_pointer, sqlite3_value_subtype, sqlite3_value_text, sqlite3_value_text16, sqlite3_value_text16be, sqlite3_value_text16le, sqlite3_value_type, sqlite3_vfs_find, sqlite3_vfs_register, sqlite3_vfs_unregister, sqlite3_vtab_collation, sqlite3_vtab_config, sqlite3_vtab_distinct, sqlite3_vtab_in, sqlite3_vtab_in_first, sqlite3_vtab_in_next, sqlite3_vtab_nochange, sqlite3_vtab_on_conflict, sqlite3_vtab_rhs_value, sqlite3_wal_autocheckpoint, sqlite3_wal_checkpoint, sqlite3_wal_checkpoint_v2, sqlite3_wal_hook, sqlite3_win32_set_directory, sqlite3_win32_set_directory16, sqlite3_win32_set_directory8

🪪 License

This software is released under the BSD-2-Clause license.

🤗 Author

Alexandre Mutel aka xoofx.