René's URL Explorer Experiment


Title: Command Line Shell For SQLite

direct link

Domain: www.sqlite.org

Nonetext/html; charset=UTF-8

Links:

https://www.sqlite.org/index.html
Homehttps://www.sqlite.org/index.html
Menujavascript:void(0)
Abouthttps://www.sqlite.org/about.html
Documentationhttps://www.sqlite.org/docs.html
Downloadhttps://www.sqlite.org/download.html
Licensehttps://www.sqlite.org/copyright.html
Supporthttps://www.sqlite.org/support.html
Purchasehttps://www.sqlite.org/prosupport.html
Searchjavascript:void(0)
Abouthttps://www.sqlite.org/about.html
Documentationhttps://www.sqlite.org/docs.html
Downloadhttps://www.sqlite.org/download.html
Supporthttps://www.sqlite.org/support.html
Purchasehttps://www.sqlite.org/prosupport.html
1. Getting Startedhttps://www.sqlite.org/cli.html#getting_started
1.1. SQLite command-line program versus the SQLite libraryhttps://www.sqlite.org/cli.html#sqlite_command_line_program_versus_the_sqlite_library
1.2. GUI Alternatives To The CLIhttps://www.sqlite.org/cli.html#gui_alternatives_to_the_cli
1.3. Starting the CLIhttps://www.sqlite.org/cli.html#starting_the_cli
1.4. Double-click Startup On Windowshttps://www.sqlite.org/cli.html#double_click_startup_on_windows
1.5. Running The CLI In A Web Browserhttps://www.sqlite.org/cli.html#running_the_cli_in_a_web_browser
2. Special commands (dot-commands)https://www.sqlite.org/cli.html#special_commands_dot_commands_
3. Rules for dot-commands, SQL, and Morehttps://www.sqlite.org/cli.html#rules_for_dot_commands_sql_and_more
3.1. Line Structurehttps://www.sqlite.org/cli.html#line_structure
3.2. Dot-command argumentshttps://www.sqlite.org/cli.html#dot_command_arguments
3.3. Dot-commands are evaluated separatelyhttps://www.sqlite.org/cli.html#dot_commands_are_evaluated_separately
4. Output Formatshttps://www.sqlite.org/cli.html#output_formats
5. Querying the database schemahttps://www.sqlite.org/cli.html#querying_the_database_schema
6. Opening Database Fileshttps://www.sqlite.org/cli.html#opening_database_files
7. Redirecting I/Ohttps://www.sqlite.org/cli.html#redirecting_i_o
7.1. Writing results to a filehttps://www.sqlite.org/cli.html#writing_results_to_a_file
7.2. Reading SQL from a filehttps://www.sqlite.org/cli.html#reading_sql_from_a_file
7.3. File I/O Functionshttps://www.sqlite.org/cli.html#file_i_o_functions
7.4. The edit() SQL functionhttps://www.sqlite.org/cli.html#the_edit_sql_function
7.5. Importing files as CSV or other formatshttps://www.sqlite.org/cli.html#importing_files_as_csv_or_other_formats
7.6. Export to CSVhttps://www.sqlite.org/cli.html#export_to_csv
7.6.1. Export to Excel https://www.sqlite.org/cli.html#_export_to_excel_
7.6.2. Export to TSV (tab separated values)https://www.sqlite.org/cli.html#_export_to_tsv_tab_separated_values_
8. Accessing ZIP Archives As Database Fileshttps://www.sqlite.org/cli.html#accessing_zip_archives_as_database_files
8.1. How ZIP archive access is implementedhttps://www.sqlite.org/cli.html#how_zip_archive_access_is_implemented
9. Converting An Entire Database To A Text Filehttps://www.sqlite.org/cli.html#converting_an_entire_database_to_a_text_file
10. Recover Data From a Corrupted Databasehttps://www.sqlite.org/cli.html#recover_data_from_a_corrupted_database
11. Loading Extensionshttps://www.sqlite.org/cli.html#loading_extensions
12. Cryptographic Hashes Of Database Contenthttps://www.sqlite.org/cli.html#cryptographic_hashes_of_database_content
13. Database Content Self-Testshttps://www.sqlite.org/cli.html#database_content_self_tests
14. SQLite Archive Supporthttps://www.sqlite.org/cli.html#sqlite_archive_support
14.1. SQLite Archive Create Command https://www.sqlite.org/cli.html#_sqlite_archive_create_command_
14.2. SQLite Archive Extract Command https://www.sqlite.org/cli.html#_sqlite_archive_extract_command_
14.3. SQLite Archive List Command https://www.sqlite.org/cli.html#_sqlite_archive_list_command_
14.4. SQLite Archive Insert And Update Commands https://www.sqlite.org/cli.html#_sqlite_archive_insert_and_update_commands_
14.5. SQLite Archive Remove Command https://www.sqlite.org/cli.html#_sqlite_archive_remove_command_
14.6. Operations On ZIP Archives https://www.sqlite.org/cli.html#_operations_on_zip_archives_
14.7. SQL Used To Implement SQLite Archive Operations https://www.sqlite.org/cli.html#_sql_used_to_implement_sqlite_archive_operations_
15. SQL Parametershttps://www.sqlite.org/cli.html#sql_parameters
16. Index Recommendations (SQLite Expert)https://www.sqlite.org/cli.html#index_recommendations_sqlite_expert_
17. Working With Multiple Database Connectionshttps://www.sqlite.org/cli.html#working_with_multiple_database_connections
18. Miscellaneous Extension Featureshttps://www.sqlite.org/cli.html#miscellaneous_extension_features
19. Other Dot Commandshttps://www.sqlite.org/cli.html#other_dot_commands
20. Using sqlite3 in a shell scripthttps://www.sqlite.org/cli.html#using_sqlite3_in_a_shell_script
21. Marking The End Of An SQL Statementhttps://www.sqlite.org/cli.html#marking_the_end_of_an_sql_statement
22. More Details On How To Start The CLIhttps://www.sqlite.org/cli.html#more_details_on_how_to_start_the_cli
22.1. Extra command-line argumentshttps://www.sqlite.org/cli.html#extra_command_line_arguments
22.2. Command-line Optionshttps://www.sqlite.org/cli.html#command_line_options
22.3. The --safe command-line optionhttps://www.sqlite.org/cli.html#the_safe_command_line_option
22.3.1. Bypassing --safe restrictions for specific commandshttps://www.sqlite.org/cli.html#bypassing_safe_restrictions_for_specific_commands
22.4. The --unsafe-testing command-line optionhttps://www.sqlite.org/cli.html#the_unsafe_testing_command_line_option
22.5. The --no-utf8 and --utf8 command-line optionshttps://www.sqlite.org/cli.html#the_no_utf8_and_utf8_command_line_options
23. Compiling the sqlite3 program from sourceshttps://www.sqlite.org/cli.html#compiling_the_sqlite3_program_from_sources
23.1. Do-It-Yourself Builds https://www.sqlite.org/cli.html#_do_it_yourself_builds_
Visual DBhttps://visualdb.com/sqlite
https://visualdb.com/sqlite
ZIP archivehttps://www.sqlite.org/cli.html#zipdb
Emscriptenhttps://en.wikipedia.org/wiki/Emscripten
https://sqlite.org/fiddlehttps://sqlite.org/fiddle
sqlite3_prepare()https://www.sqlite.org/c3ref/prepare.html
sqlite3_exec()https://www.sqlite.org/c3ref/exec.html
.mode commandhttps://www.sqlite.org/climode.html
covered in a separate documenthttps://www.sqlite.org/climode.html
sqlite_schemahttps://www.sqlite.org/schematab.html
attachedhttps://www.sqlite.org/lang_attach.html
attachedhttps://www.sqlite.org/lang_attach.html
sqlite3_txn_state()https://www.sqlite.org/c3ref/txn_state.html
sqlite3_open()https://www.sqlite.org/c3ref/open.html
sqlite3_deserialize()https://www.sqlite.org/c3ref/deserialize.html
appendvfs extensionhttps://sqlite.org/src/file/ext/misc/appendvfs.c
dot-commandshttps://www.sqlite.org/cli.html#dotcmd
application-defined SQL functionshttps://www.sqlite.org/appfunc.html
loadable extensionhttps://www.sqlite.org/loadext.html
ext/misc/fileio.chttps://sqlite.org/src/artifact?ci=trunk&filename=ext/misc/fileio.c
SQLite source code repositorieshttps://www.sqlite.org/download.html#srctree
--rowsep optionhttps://www.sqlite.org/climode.html#opt-rowsep
--colsep optionhttps://www.sqlite.org/climode.html#opt-colsep
.mode commandhttps://www.sqlite.org/climode.html
file I/O functionshttps://www.sqlite.org/cli.html#fileio
Zipfile virtual tablehttps://www.sqlite.org/zipfile.html
in-memory databasehttps://www.sqlite.org/inmemorydb.html
Zipfile virtual tablehttps://www.sqlite.org/zipfile.html
Zipfile virtual tablehttps://www.sqlite.org/zipfile.html
CREATE VIRTUAL TABLEhttps://www.sqlite.org/lang_createvtab.html
application-defined SQL functionshttps://www.sqlite.org/appfunc.html
collating sequenceshttps://www.sqlite.org/datatype3.html#collation
virtual tableshttps://www.sqlite.org/vtab.html
VFSeshttps://www.sqlite.org/vfs.html
Run-Time Loadable Extensionshttps://www.sqlite.org/loadext.html
ext/mischttps://sqlite.org/src/tree?name=ext/misc&ci=trunk
SHA3https://en.wikipedia.org/wiki/SHA-3
VACUUMhttps://www.sqlite.org/lang_vacuum.html
sqlite_schemahttps://www.sqlite.org/schematab.html
LIKEhttps://www.sqlite.org/lang_expr.html#like
LIKEhttps://www.sqlite.org/lang_expr.html#like
extension function "sha3_query()"https://sqlite.org/src/file/ext/misc/shathree.c
PRAGMA integrity_checkhttps://www.sqlite.org/pragma.html#pragma_integrity_check
DELETEhttps://www.sqlite.org/lang_delete.html
SQLite Archive formathttps://www.sqlite.org/sqlar.html
apndvfs VFShttps://sqlite.org/src/file/ext/misc/appendvfs.c
glob(Y,X)https://www.sqlite.org/lang_corefunc.html#glob
zipfilehttps://www.sqlite.org/zipfile.html
loadable extensionshttps://www.sqlite.org/loadext.html
SQLite source treehttps://sqlite.org/src
ext/misc/ subfolderhttps://sqlite.org/src/file/ext/misc
fileio.chttps://sqlite.org/src/file/ext/misc/fileio.c
sqlar.chttps://sqlite.org/src/file/ext/misc/sqlar.c
zipfile.chttps://www.sqlite.org/zipfile.html
appendvfs.chttps://sqlite.org/src/file/ext/misc/appendvfs.c
VFShttps://www.sqlite.org/vfs.html
bound parametershttps://www.sqlite.org/lang_expr.html#varparam
sqlite3_bind_...()https://www.sqlite.org/c3ref/bind_blob.html
command-line shell source codehttps://sqlite.org/src/file/src/shell.c.in
EXPLAIN QUERY PLANhttps://www.sqlite.org/eqp.html
SQLite query plannerhttps://www.sqlite.org/optoverview.html
ANALYZEhttps://www.sqlite.org/lang_analyze.html
SQLite expert extensionhttps://sqlite.org/src/dir?ci=trunk&name=ext/expert
Automatically Load Statically Linked Extensionshttps://www.sqlite.org/c3ref/auto_extension.html
Persistent Loadable Extensionshttps://www.sqlite.org/loadext.html#persist
database connectionshttps://www.sqlite.org/c3ref/sqlite3.html
output modehttps://www.sqlite.org/climode.html
dot-commandshttps://www.sqlite.org/cli.html#dotcmd
.openhttps://www.sqlite.org/cli.html#dotopen
UINT collating sequencehttps://www.sqlite.org/uintcseq.html
decimal extensionhttps://www.sqlite.org/floatingpoint.html#decext
generate_serieshttps://www.sqlite.org/series.html
base64()https://www.sqlite.org/base64.html
base85()https://www.sqlite.org/base85.html
REGEXPhttps://www.sqlite.org/lang_expr.html#regexp
previouslyhttps://www.sqlite.org/cli.html#startup
dot-commandhttps://www.sqlite.org/cli.html#dotcmd
.open commandhttps://www.sqlite.org/cli.html#dotopen
ATTACHhttps://www.sqlite.org/lang_attach.html
.archive commandhttps://www.sqlite.org/cli.html#sqlar
.import commandhttps://www.sqlite.org/cli.html#csv
.load commandhttps://www.sqlite.org/cli.html#dotload
SQLITE_DBCONFIG_DEFENSIVEhttps://www.sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
SQLITE_DBCONFIG_TRUSTED_SCHEMAhttps://www.sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigtrustedschema
tclshhttps://www.tcl.tk/man/tcl8.3/UserCmd/tclsh.htm
zlib compression libraryhttps://zlib.net
.archive commandhttps://www.sqlite.org/cli.html#sqlar
.archive commandhttps://www.sqlite.org/cli.html#sqlar
zlib source codehttps://zlib.net
src/shell.c.inhttps://sqlite.org/src/file/src/shell.c.in
Compilehttps://www.sqlite.org/howtocompile.html
sqlite3 library source codehttps://www.sqlite.org/amalgamation.html
-DSQLITE_THREADSAFE=0https://www.sqlite.org/compile.html#threadsafe
-DSQLITE_ENABLE_EXPLAIN_COMMENTShttps://www.sqlite.org/compile.html#enable_explain_comments
-DSQLITE_HAVE_ZLIBhttps://www.sqlite.org/compile.html#have_zlib
-DSQLITE_INTROSPECTION_PRAGMAShttps://www.sqlite.org/compile.html#introspection_pragmas
-DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTIONhttps://www.sqlite.org/compile.html#enable_unknown_sql_function
-DSQLITE_ENABLE_STMTVTABhttps://www.sqlite.org/compile.html#enable_stmtvtab
-DSQLITE_ENABLE_DBPAGE_VTABhttps://www.sqlite.org/compile.html#enable_dbpage_vtab
-DSQLITE_ENABLE_DBSTAT_VTABhttps://www.sqlite.org/compile.html#enable_dbstat_vtab
-DSQLITE_ENABLE_OFFSET_SQL_FUNChttps://www.sqlite.org/compile.html#enable_offset_sql_func
-DSQLITE_ENABLE_JSON1https://www.sqlite.org/compile.html#enable_json1
-DSQLITE_ENABLE_RTREEhttps://www.sqlite.org/compile.html#enable_rtree
-DSQLITE_ENABLE_FTS4https://www.sqlite.org/compile.html#enable_fts4
-DSQLITE_ENABLE_FTS5https://www.sqlite.org/compile.html#enable_fts5

Viewport: width=device-width, initial-scale=1.0

URLs of crawlers that visited me.