Table of Contents - RDoc Documentation
Pages
-
CHANGELOG
- sqlite3-ruby Changelog
- 2.5.0.rc1 / 2024-12-14
- Ruby
- 2.4.1 / 2024-12-08
- Dependencies
- Fixed
- 2.4.0 / 2024-12-03
- Added
- 2.3.1 / 2024-11-25
- Dependencies
- 2.3.0 / 2024-11-20
- Added
- Fixed
- 2.2.0 / 2024-10-30
- Added
- Improved
- 2.1.1 / 2024-10-22
- Dependencies
- 2.1.0 / 2024-09-24
- Ruby
- Fork safety improvements
- Improved
- Documentation
- 2.0.4 / 2024-08-13
- Dependencies
- 2.0.3 / 2024-07-29
- Improved
- 2.0.2 / 2024-05-23
- Dependencies
- 2.0.1 / 2024-04-20
- Fixed
- 2.0.0 / 2024-04-17
- Ruby
- Packaging
- Dependencies
- Added
- Improved
- Changed
- Removed
- 1.7.3 / 2024-03-15
- Dependencies
- 1.7.2 / 2024-01-30
- Dependencies
- 1.7.1 / 2024-01-24
- Dependencies
- 1.7.0 / 2023-12-27
- Ruby
- Improved
- 1.6.9 / 2023-11-26
- Dependencies
- Added
- 1.6.8 / 2023-11-01
- Dependencies
- Added
- 1.6.7 / 2023-10-10
- Dependencies
- Added
- 1.6.6 / 2023-09-12
- Dependencies
- 1.6.5 / 2023-09-08
- Packaging
- 1.6.4 / 2023-08-26
- Dependencies
- 1.6.3 / 2023-05-16
- Dependencies
- 1.6.2 / 2023-03-27
- Dependencies
- Packaging
- 1.6.1 / 2023-02-22
- Dependencies
- 1.6.0 / 2023-01-13
- Ruby
- Dependencies
- Fixes
- 1.5.4 / 2022-11-18
- Dependencies
- 1.5.3 / 2022-10-11
- Fixed
- 1.5.2 / 2022-10-01
- Packaging
- 1.5.1 / 2022-09-29
- Dependencies
- Security
- 1.5.0 / 2022-09-08
- Packaging
- Faster, more reliable installation
- More consistent developer experience
- Rubies and Platforms
- Added
- Fixed
- 1.4.4 / 2022-06-14
- Fixes
- 1.4.3 / 2022-05-25
- Enhancements
- 1.4.2 / 2019-12-18
- 1.4.1
- 1.4.0
- Enhancements
- Bugfixes
- 1.3.13
- Enhancements
- 1.3.12
- Bugfixes
- 1.3.11 / 2015-10-10
- Enhancements
- Internal
- 1.3.10 / 2014-10-30
- Enhancements
- 1.3.9 / 2014-02-25
- Bugfixes
- 1.3.8 / 2013-08-17
- Enhancements
- Bugfixes
- Internal
- 1.3.7 / 2013-01-11
- Bugfixes
- Internal
- 1.3.6 / 2012-04-16
- Enhancements
- Bugfixes
- Deprecations
- 1.3.5 / 2011-12-03 - ZOMG Holidays are here Edition!
- Enhancements
- Bugfixes
- Internal
- 1.3.4 / 2011-07-25
- Enhancements
- Bugfixes
- 1.3.3 / 2010-01-16
- Bugfixes
- 1.3.2 / 2010-10-30 / RubyConf Uruguay Edition!
- Enhancements
- Bugfixes
- Deprecations
- 1.3.1 / 2010-07-09
- Enhancements
- Bugfixes
- 1.3.0 / 2010-06-06
- Enhancements
- Experimental
- Bugfixes
- 1.3.0.beta.2 / 2010-05-15
- Enhancements
- Bugfixes
- 1.3.0.beta.1 / 2010-05-10
- Enhancements
- Experimental
- Bugfixes
- 1.2.5 / 2009-07-25
- 1.2.4.1 (internal) / 2009-07-05
- 1.2.4 / 2008-08-27
- 1.2.3 / 2008-08-26
- 1.2.2 / 2008-05-31
- CONTRIBUTING
-
FAQ
- How do I do a database query?
- I just want an array of the rows…
- I’d like to use a block to iterate through the rows…
- I need to get the column names as well as the rows…
- I just want the first row of the result set…
- I just want the first value of the first row of the result set…
- How do I prepare a statement for repeated execution?
- How do I use placeholders in an SQL statement?
- How do I discover metadata about a query result?
- I’d like the rows to be indexible by column name.
- How do I insert binary data into the database?
- How do I do a DDL (insert, update, delete) statement?
- How do I execute multiple statements in a single string?
- How do I begin/end a transaction
- How do I discover metadata about a table/index?
- How do I do tweak database settings?
- Gemfile
- Gemfile.lock
-
INSTALLATION
- Installation and Using SQLite3 extensions
- Installation
- Native Gems (recommended)
- Avoiding the precompiled native gem
- Compiling the source gem
- Packaged libsqlite3
- Controlling compilation flags for sqlite
- System libsqlite3
- System libsqlcipher
- Using SQLite3 extensions
- How do I load a sqlite extension?
- How do I use my own sqlite3 shared library?
- LICENSE
- README
- Rakefile
- 2024-09-fork-safety
Classes and Modules
- SQLite3
- SQLite3::AbortException
- SQLite3::AuthorizationException
- SQLite3::Backup
- SQLite3::Blob
- SQLite3::BusyException
- SQLite3::CantOpenException
- SQLite3::Constants
- SQLite3::Constants::ColumnType
- SQLite3::Constants::ErrorCode
- SQLite3::Constants::Open
- SQLite3::Constants::Optimize
- SQLite3::Constants::Status
- SQLite3::Constants::TextRep
- SQLite3::ConstraintException
- SQLite3::CorruptException
- SQLite3::Database
- SQLite3::Database::FunctionProxy
- SQLite3::EmptyException
- SQLite3::Exception
- SQLite3::ForkSafety
- SQLite3::FormatException
- SQLite3::FullException
- SQLite3::IOException
- SQLite3::InternalException
- SQLite3::InterruptException
- SQLite3::LockedException
- SQLite3::MemoryException
- SQLite3::MismatchException
- SQLite3::MisuseException
- SQLite3::NotADatabaseException
- SQLite3::NotFoundException
- SQLite3::PermissionException
- SQLite3::Pragmas
- SQLite3::ProtocolException
- SQLite3::RangeException
- SQLite3::ReadOnlyException
- SQLite3::ResultSet
- SQLite3::SQLException
- SQLite3::SchemaChangedException
- SQLite3::Statement
- SQLite3::TooBigException
- SQLite3::UnsupportedException
- SQLite3::Value
- String
Methods
- ::arity — SQLite3::Database
- ::finalize — SQLite3::Database
- ::name — SQLite3::Database
- ::new — SQLite3::Backup
- ::new — SQLite3::Database
- ::new — SQLite3::Statement
- ::new — SQLite3::Database::FunctionProxy
- ::new — SQLite3::ResultSet
- ::new — SQLite3::Value
- ::open — SQLite3::Database
- ::quote — SQLite3::Database
- ::status — SQLite3
- ::step — SQLite3::Database
- ::suppress_warnings! — SQLite3::ForkSafety
- ::template — SQLite3::Database
- ::threadsafe? — SQLite3
- #[] — SQLite3::Database::FunctionProxy
- #[]= — SQLite3::Database::FunctionProxy
- #active? — SQLite3::Statement
- #application_id — SQLite3::Pragmas
- #application_id= — SQLite3::Pragmas
- #authorizer — SQLite3::Database
- #authorizer= — SQLite3::Database
- #auto_vacuum — SQLite3::Pragmas
- #auto_vacuum= — SQLite3::Pragmas
- #automatic_index — SQLite3::Pragmas
- #automatic_index= — SQLite3::Pragmas
- #bind_param — SQLite3::Statement
- #bind_parameter_count — SQLite3::Statement
- #bind_params — SQLite3::Statement
- #busy_handler — SQLite3::Database
- #busy_handler_timeout= — SQLite3::Database
- #busy_timeout — SQLite3::Database
- #busy_timeout — SQLite3::Pragmas
- #busy_timeout= — SQLite3::Database
- #busy_timeout= — SQLite3::Pragmas
- #cache_size — SQLite3::Pragmas
- #cache_size= — SQLite3::Pragmas
- #cache_spill — SQLite3::Pragmas
- #cache_spill= — SQLite3::Pragmas
- #case_sensitive_like= — SQLite3::Pragmas
- #cell_size_check — SQLite3::Pragmas
- #cell_size_check= — SQLite3::Pragmas
- #changes — SQLite3::Database
- #checkpoint_fullfsync — SQLite3::Pragmas
- #checkpoint_fullfsync= — SQLite3::Pragmas
- #clear_bindings! — SQLite3::Statement
- #close — SQLite3::Database
- #close — SQLite3::Statement
- #close — SQLite3::ResultSet
- #closed? — SQLite3::Database
- #closed? — SQLite3::Statement
- #closed? — SQLite3::ResultSet
- #collation — SQLite3::Database
- #collation_list — SQLite3::Pragmas
- #column_count — SQLite3::Statement
- #column_decltype — SQLite3::Statement
- #column_name — SQLite3::Statement
- #columns — SQLite3::Statement
- #columns — SQLite3::ResultSet
- #commit — SQLite3::Database
- #compile_options — SQLite3::Pragmas
- #complete? — SQLite3::Database
- #count_changes — SQLite3::Pragmas
- #count_changes= — SQLite3::Pragmas
- #create_aggregate — SQLite3::Database
- #create_aggregate_handler — SQLite3::Database
- #create_function — SQLite3::Database
- #data_version — SQLite3::Pragmas
- #database_list — SQLite3::Pragmas
- #database_name — SQLite3::Statement
- #default_cache_size — SQLite3::Pragmas
- #default_cache_size= — SQLite3::Pragmas
- #default_synchronous — SQLite3::Pragmas
- #default_synchronous= — SQLite3::Pragmas
- #default_temp_store — SQLite3::Pragmas
- #default_temp_store= — SQLite3::Pragmas
- #defer_foreign_keys — SQLite3::Pragmas
- #defer_foreign_keys= — SQLite3::Pragmas
- #define_aggregator — SQLite3::Database
- #define_function — SQLite3::Database
- #define_function_with_flags — SQLite3::Database
- #done? — SQLite3::Statement
- #each — SQLite3::Statement
- #each — SQLite3::ResultSet
- #each_hash — SQLite3::ResultSet
- #enable_load_extension — SQLite3::Database
- #encoding — SQLite3::Database
- #encoding — SQLite3::Pragmas
- #encoding= — SQLite3::Pragmas
- #eof? — SQLite3::ResultSet
- #errcode — SQLite3::Database
- #errmsg — SQLite3::Database
- #execute — SQLite3::Database
- #execute — SQLite3::Statement
- #execute! — SQLite3::Statement
- #execute2 — SQLite3::Database
- #execute_batch — SQLite3::Database
- #execute_batch2 — SQLite3::Database
- #expanded_sql — SQLite3::Statement
- #extended_result_codes= — SQLite3::Database
- #filename — SQLite3::Database
- #finalize — SQLite3::Database
- #finish — SQLite3::Backup
- #foreign_key_check — SQLite3::Pragmas
- #foreign_key_list — SQLite3::Pragmas
- #foreign_keys — SQLite3::Pragmas
- #foreign_keys= — SQLite3::Pragmas
- #freelist_count — SQLite3::Pragmas
- #full_column_names — SQLite3::Pragmas
- #full_column_names= — SQLite3::Pragmas
- #fullfsync — SQLite3::Pragmas
- #fullfsync= — SQLite3::Pragmas
- #get_boolean_pragma — SQLite3::Pragmas
- #get_enum_pragma — SQLite3::Pragmas
- #get_first_row — SQLite3::Database
- #get_first_value — SQLite3::Database
- #get_int_pragma — SQLite3::Pragmas
- #get_query_pragma — SQLite3::Pragmas
- #ignore_check_constraints= — SQLite3::Pragmas
- #incremental_vacuum — SQLite3::Pragmas
- #index_info — SQLite3::Pragmas
- #index_list — SQLite3::Pragmas
- #index_xinfo — SQLite3::Pragmas
- #integrity_check — SQLite3::Pragmas
- #interrupt — SQLite3::Database
- #journal_mode — SQLite3::Pragmas
- #journal_mode= — SQLite3::Pragmas
- #journal_size_limit — SQLite3::Pragmas
- #journal_size_limit= — SQLite3::Pragmas
- #last_insert_row_id — SQLite3::Database
- #legacy_file_format — SQLite3::Pragmas
- #legacy_file_format= — SQLite3::Pragmas
- #length — SQLite3::Value
- #load_extension — SQLite3::Database
- #locking_mode — SQLite3::Pragmas
- #locking_mode= — SQLite3::Pragmas
- #max_page_count — SQLite3::Pragmas
- #max_page_count= — SQLite3::Pragmas
- #memused — SQLite3::Statement
- #message — SQLite3::Exception
- #mmap_size — SQLite3::Pragmas
- #mmap_size= — SQLite3::Pragmas
- #next — SQLite3::ResultSet
- #next_hash — SQLite3::ResultSet
- #null? — SQLite3::Value
- #optimize — SQLite3::Pragmas
- #page_count — SQLite3::Pragmas
- #page_size — SQLite3::Pragmas
- #page_size= — SQLite3::Pragmas
- #pagecount — SQLite3::Backup
- #parser_trace= — SQLite3::Pragmas
- #prepare — SQLite3::Database
- #query — SQLite3::Database
- #query_only — SQLite3::Pragmas
- #query_only= — SQLite3::Pragmas
- #quick_check — SQLite3::Pragmas
- #read_uncommitted — SQLite3::Pragmas
- #read_uncommitted= — SQLite3::Pragmas
- #readonly? — SQLite3::Database
- #recursive_triggers — SQLite3::Pragmas
- #recursive_triggers= — SQLite3::Pragmas
- #remaining — SQLite3::Backup
- #reset — SQLite3::ResultSet
- #reset! — SQLite3::Statement
- #reverse_unordered_selects — SQLite3::Pragmas
- #reverse_unordered_selects= — SQLite3::Pragmas
- #rollback — SQLite3::Database
- #schema_cookie — SQLite3::Pragmas
- #schema_cookie= — SQLite3::Pragmas
- #schema_version — SQLite3::Pragmas
- #schema_version= — SQLite3::Pragmas
- #secure_delete — SQLite3::Pragmas
- #secure_delete= — SQLite3::Pragmas
- #set_boolean_pragma — SQLite3::Pragmas
- #set_enum_pragma — SQLite3::Pragmas
- #set_int_pragma — SQLite3::Pragmas
- #short_column_names — SQLite3::Pragmas
- #short_column_names= — SQLite3::Pragmas
- #shrink_memory — SQLite3::Pragmas
- #soft_heap_limit — SQLite3::Pragmas
- #soft_heap_limit= — SQLite3::Pragmas
- #sql — SQLite3::Statement
- #stat — SQLite3::Statement
- #statement_timeout= — SQLite3::Database
- #stats — SQLite3::Pragmas
- #step — SQLite3::Backup
- #step — SQLite3::Database
- #step — SQLite3::Statement
- #synchronous — SQLite3::Pragmas
- #synchronous= — SQLite3::Pragmas
- #table_info — SQLite3::Pragmas
- #temp_store — SQLite3::Pragmas
- #temp_store= — SQLite3::Pragmas
- #threads — SQLite3::Pragmas
- #threads= — SQLite3::Pragmas
- #to_blob — String
- #to_blob — SQLite3::Value
- #to_f — SQLite3::Value
- #to_i — SQLite3::Value
- #to_int64 — SQLite3::Value
- #to_s — SQLite3::Value
- #total_changes — SQLite3::Database
- #trace — SQLite3::Database
- #transaction — SQLite3::Database
- #transaction_active? — SQLite3::Database
- #type — SQLite3::Value
- #types — SQLite3::Statement
- #types — SQLite3::ResultSet
- #user_cookie — SQLite3::Pragmas
- #user_cookie= — SQLite3::Pragmas
- #user_version — SQLite3::Pragmas
- #user_version= — SQLite3::Pragmas
- #vdbe_addoptrace= — SQLite3::Pragmas
- #vdbe_debug= — SQLite3::Pragmas
- #vdbe_listing= — SQLite3::Pragmas
- #vdbe_trace — SQLite3::Pragmas
- #vdbe_trace= — SQLite3::Pragmas
- #wal_autocheckpoint — SQLite3::Pragmas
- #wal_autocheckpoint= — SQLite3::Pragmas
- #wal_checkpoint — SQLite3::Pragmas
- #wal_checkpoint= — SQLite3::Pragmas
- #writable_schema= — SQLite3::Pragmas